…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
…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
…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!
…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
… 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=…

