Luis Manson Posted April 1, 2012 Share Posted April 1, 2012 Im courently looking for optimizations to mysql, im between moving to MariaDB and keep MyISAM or moving to innoDB some tables Right now i have the next tables to InnoDB: gaadmin_login_logs, gaerror_logs, gasearch_keywords, gasearch_visitors gasessions(MEMORY) i wonder if moving the members table would make any difference, or any other table. I dont feel confident on moving the posts table yet Link to comment Share on other sites More sharing options...
yacenty Posted April 2, 2012 Share Posted April 2, 2012 I moved users and gallery images. Performance is visible better. Previously we have had a lot of LOCKS on members and pictures. Now those disapeard. Somebody told me that InnoDB is slower. We have founded some benchmarks showing that read is slower on InnoDB, but when we have a huge ammount of UPDATEs and INSERTs, it's much efficient to have this table as InnoDB, because lock is on certain ROW not on whole TABLE Link to comment Share on other sites More sharing options...
yacenty Posted April 2, 2012 Share Posted April 2, 2012 on the other hand we had moved to the Percona DB - it was a huge performance boost. Admin told me many queries were done 50% faster Link to comment Share on other sites More sharing options...
raindog308 Posted April 2, 2012 Share Posted April 2, 2012 InnoDB excels at high-contention situations. It's slower than myisam for some things, faster for others. Percona originally made their name as a Mysql clone with a better InnoDB. Link to comment Share on other sites More sharing options...
Luis Manson Posted April 2, 2012 Author Share Posted April 2, 2012 I knew about Percona, but since most of my tables still MyISAM I was thinking on MariaDB... yacenty, you just converted the members table and nothinf else, right? Link to comment Share on other sites More sharing options...
yacenty Posted April 2, 2012 Share Posted April 2, 2012 yes, you are right Link to comment Share on other sites More sharing options...
Luis Manson Posted April 2, 2012 Author Share Posted April 2, 2012 thanks, i will give that a try, now i just need to understand if mysqloptimize will be whorst or what :S Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.