Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Gabriel Torres Posted January 6, 2014 Posted January 6, 2014 As we have a high-traffic forums, we are having some performance issues, to the point nobody can enter our forums. Analyzing with SHOW PROCESSLIST, we saw several locked tables, in particular skin_cache, sessions, and members. Converted these three tables to InnoDB. I don't have bad experience with InnoDB in the past, as on vBulletin it actually decreased performance. However, it seems, at least for me, that selectively using InnoDB in a few tables (those listed above) performance really improved and solved our availability issues (at least for now). I'd love to hear from other people who manage high-traffic forums and their experience with performance issues, table locking, and InnoDB usage.
stoo2000 Posted January 6, 2014 Posted January 6, 2014 Sessions would be even quicker if you made it a memory table.
Gabriel Torres Posted January 6, 2014 Author Posted January 6, 2014 Awesome tip, and I've just implemented it. Facing performance issues again, now the table that has locking issues is content_cache_posts, and I'm altering it to InnoDB as well.
stoo2000 Posted January 6, 2014 Posted January 6, 2014 Awesome tip, and I've just implemented it. Facing performance issues again, now the table that has locking issues is content_cache_posts, and I'm altering it to InnoDB as well. Be aware though, MEMORY tables lose their content after a MySQL reboot, so don't many any other tables MEMORY.
Gabriel Torres Posted January 6, 2014 Author Posted January 6, 2014 I know! I set only sessions to be on memory!
Dmacleo Posted January 6, 2014 Posted January 6, 2014 wonder if mariadb or percona would work better for you.
Birched Posted January 6, 2014 Posted January 6, 2014 wonder if mariadb or percona would work better for you. Are these (mariadb and percona) different things? https://mariadb.com/kb/en/about-xtradb/ That's a real question -- in some places they are talked about as if they are different, but on that mariadb page it sounds like mariadb uses percona's innodb engine.
Dmacleo Posted January 6, 2014 Posted January 6, 2014 maria built upon the percona xtradb engine but adds more iirc. iirc persona is closer to the mysql code.
Gabriel Torres Posted January 6, 2014 Author Posted January 6, 2014 Thanks, will take a look into that.
stoo2000 Posted January 6, 2014 Posted January 6, 2014 I know! I set only sessions to be on memory! Just making it clear for anyone else that reads this in the future!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.