tag:blogger.com,1999:blog-13606853.post2763871863630797085..comments2023-12-28T16:01:32.344+05:30Comments on Whatever....: optimizing mysql guidegamegeekhttp://www.blogger.com/profile/00557771372755358783noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-13606853.post-43212176561097018482009-06-16T06:51:15.026+05:302009-06-16T06:51:15.026+05:30Hey mate,
Go have a look at mysqltuner.com, it is...Hey mate,<br /><br />Go have a look at mysqltuner.com, it is a perl script which does a whole bunch of checks like this.<br /><br />Have FunPaulMhttp://blog.dbadojo.comnoreply@blogger.comtag:blogger.com,1999:blog-13606853.post-72514402934253635272009-06-11T12:27:34.888+05:302009-06-11T12:27:34.888+05:30You mention increasing tmp_table_size. You may ha...You mention increasing tmp_table_size. You may have to increase max_heap_table_size as well, as in-memory temporary tables are limited by both of these variables, honoring whichever is smaller.Anonymousnoreply@blogger.com