Showing entries 1 to 2
Displaying posts with tag: optimize mysql (reset)
Oct
02
2009
SHOW ENGINE INNODB STATUS;
Posted by Jayant Kumar on Fri 02 Oct 2009 10:40 UTC
Tags:

Innodb monitors show information about innodb internal status - which could be used for performance tuning. Lets break down the output of show engine innodb status and get a look at what is happening and how it can be improved. Just fire the "Show engine innodb status" command and check the Output.mysql> show engine innodb status\G*************************** 1. row ***************************

Jun
11
2009
optimizing mysql guide
Posted by Jayant Kumar on Thu 11 Jun 2009 04:55 UTC
Tags:

I had written about this but mostly in parts. Here is a step by step guide to optimizing mysql. Following variables should be looked into for optimizing mysql.Memory consumption: Total memory consumption should be less than the available RAM. You should also leave a small amount of memory for the OS. Total memory consumption can be calculated using this formula (for myisam tables):Key_buffer + (

Showing entries 1 to 2