tag:blogger.com,1999:blog-4210944690127207162024-09-04T16:22:40.048-07:00jayaramhttp://www.blogger.com/profile/02952748219396821771noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-421094469012720716.post-66960690882409894422012-09-07T03:34:00.001-07:002012-09-07T03:34:02.498-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> http://www.mysqlperformanceblog.com/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/</div> jayaramhttp://www.blogger.com/profile/02952748219396821771noreply@blogger.com0tag:blogger.com,1999:blog-421094469012720716.post-7469617121108469672012-03-14T11:06:00.003-07:002012-03-14T11:39:32.092-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> Changing innodb_log_file_size of MySQL-Server.<br /> <br /> Steps to change&nbsp;&nbsp;innodb_log_file_size&nbsp;without effecting of existing innodb tables's data.<br /> 1. Check&nbsp;<span style="text-align: -webkit-auto;">innodb_fast_shutdown value in server variables. It is global variable. Before changing innodb_log_file_size, You have to set&nbsp;</span><span style="text-align: -webkit-auto;">innodb_fast_shutdown = 0 or OFF.</span><br /> <span style="text-align: -webkit-auto;">2. Stop MySQL server.</span><br /> <span style="text-align: -webkit-auto;">3. Delete innodb log files.</span><br /> <span style="text-align: -webkit-auto;">4. Start MySQL server.</span><br /> <span style="text-align: -webkit-auto;"><br /></span><br /> <span style="text-align: -webkit-auto;">Setting of&nbsp;</span><span style="text-align: -webkit-auto;">innodb_fast_shutdown=0 takes little time, to purge all data.</span></div>jayaramhttp://www.blogger.com/profile/02952748219396821771noreply@blogger.com0tag:blogger.com,1999:blog-421094469012720716.post-74288907757557867222012-01-11T23:34:00.000-08:002012-01-12T06:13:37.802-08:00<div dir="ltr" style="text-align: left;" trbidi="on"> 1. We have to check RAM and ,&nbsp;&nbsp;You can set .._buffer_pool_size up to 50 - 80 %&nbsp;&nbsp;of RAM but beware of setting memory usage too high<br /> <br /></div>jayaramhttp://www.blogger.com/profile/02952748219396821771noreply@blogger.com1