wade

Hey guys, sorry to resurrect an old thread but I'm currently helping a guy upgrade his server and speed it up a bit and I must say, switching to InnoDB would be a very wise idea. Not only has the performance improved significantly over the last few years, but most importantly, the native InnoDB driver has support for modifying indexes without locking tables (they're kept separately now). Then there's key compression and so on which all help reduce CPU and query times. Also, I'm seeing several places where the queries could be improved by adding/changing indexes. For example the login table when used in joins I see a lot causes a lot less overhead if you "ADD INDEX accountstatelevel (`account_id`, `state`, `level`), ADD INDEX `level` (`level`)". The global_reg_value table can be sped up a hell of a lot with a few extra indexes also.