Crash Posted May 27, 2016 Report Posted May 27, 2016 (edited) Hi. Revive Adserver slows down database. I see many queries "INSERT INTO rv_data_bkt_m" is status "Waiting for table level lock ". I think the problem is MyISAM . Can I change tables types to InnoDB on the live server? Edited May 27, 2016 by Erik Geurts Corrected product name spelling Quote
Ian Posted May 27, 2016 Report Posted May 27, 2016 Could it be that your mysql tables are crashed ? Quote
Snoork Hosting Posted May 27, 2016 Report Posted May 27, 2016 I would recommend using InnoDB, as it will greatly improve the performance of your MySQL queries. Yes, you can change your database tables from MyISAM to InnoDB fairly easy. Please check hhttps://mariadb.com/kb/en/mariadb/converting-tables-from-myisam-to-innodb/ You may also want to consider using disk cache or Memcache to improve SQL queries. Quote
Erik Geurts Posted May 27, 2016 Report Posted May 27, 2016 (edited) I don't agree. In many experiments we've done, MyISAM turned out to be more efficient than InnoDB. I understand about table locking vs row locking, but the test results proved that MyISAM holds its own rather well. Edited May 27, 2016 by Erik Geurts typo Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.