…MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB but, depending on your database…InnoDB, determines the recovery time. Does PBXT support clustered indexes? No, currently it does not. This is…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…people throw at databases Many people assume their application is difficult or somehow different, and…If these are not the same size, as often happens, I’ll explain that the minimum of the two is used to determine…MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe the client is doing…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…determine which MySQL High-Availability solution is best? What is really tricky with MySQL is…if you are concerned about loss of data, you are most likely using the InnoDB storage engine, since MyISAM is…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…MySQL version installed already, but if it’s not any of… and the patch is. First you should determine how your current… same set of storage engines or default paths): (garfield:~/work) % env …storage engines used (InnoDB will take significantly longer to close than MyISAM), database configuration, …
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
… browser every 10 secs or so. We cache …The question really is how do you determine the memory consumption…X mb. If the answer to ‘b’ is 2mb …databases‘, ’93′ ‘Com_show_errors’, ’0′ ‘Com_show_fields’, ’4260′ ‘Com_show_grants’, ’0′ ‘Com_show_innodb…32M # Only for MyISAM which isnt used. sort_buffer_size=…
