mysql tuning?

Portal Home > Knowledgebase > Articles Database > mysql tuning?

Posted by akihito, 10-22-2012, 03:21 AM
i ran mysql tuner and it suggest me to increase innodb_buffer_pool_size to 17G but will that affect my system as i only have 8GB of physical memory installed. server spec Last edited by akihito; 10-22-2012 at 03:27 AM.
Posted by Simplex-Ed, 10-22-2012, 12:02 PM
I'd seriously consider lowing your max connections first. 1,000 is VERY high (and if you need 1,000 connections, something is wrong with your application). Do not increase the buffer size.
Posted by akihito, 10-22-2012, 09:45 PM
i've lowered that value to 250, now still monitoring the mysql usage anyway i stucked at this part whereby it ask to adjust the innodb_buffer_pool_size to more than 17G, does it drain more memory if set to more than 17G?
Posted by Server Sentinel, 10-23-2012, 05:28 AM
As a good rule of thumb innodb_buffer_pool_size value should be set to 10% larger than the size of your database… that is assuming you have that much memory available on your server. This tells MySQL how much memory it should use to cache data on your InnoDB tables. This cuts down on disc IO. It can save you alot of lookup time if you are pulling out of the cache as opposed to making another call to the database table. If you only have 8GB of memory on your box, then don’t set it to 8GB. This can cause paging at the OS level which is not good.
Posted by BestServerSupport, 10-23-2012, 09:59 AM
Yes, always set innodb_buffer_pool_size value bit larger than the size of your MySQL database. It will surely improve the performance.