Vbulletin 4.2.4 site getting hammered on CPU. Looks like MYSql. Advice?

[Wayne Luke]

Do as the error says and increase that log file size or store your customavatars in the filesystem under Avatars -> User Picture Storage Type.

[Chris Tretta]

I am running into issues. Any guidance? This is only on a couple of large - image based tables.

[Wayne Luke]

Since you're using MySQL 5.6.X, you can convert every table to INNODB.

[Chris Tretta]

I found this list of tables to update to InnoDB. Are there any others you recommend?

• alter table attachment engine=InnoDB;
• alter table datastore engine=InnoDB;
• alter table deletionlog engine=InnoDB;
• alter table forum engine=InnoDB;
• alter table pm engine=InnoDB;
• alter table pmreceipt engine=InnoDB;
• alter table pmtext engine=InnoDB;
• alter table post engine=InnoDB;
• alter table postparsed engine=InnoDB;
• alter table searchcore engine=InnoDB;
• alter table searchgroup engine=InnoDB;
• alter table searchlog engine=InnoDB;
• alter table sigparsed engine=InnoDB;
• alter table subscribethread engine=InnoDB;
• alter table thread engine=InnoDB;
• alter table threadviews engine=InnoDB;
• alter table user engine=InnoDB;
• alter table usertextfield engine=InnoDB;

Thanks
Chris

[Chris Tretta]

My tables are MyISAM. server is 5.6.35. I will move forward with your suggestions

[Paul M]

Without proper analysis, and access to your systems, no one can help you other than just guesswork.

[Wayne Luke]

Are you using MyISAM tables still? If so, convert your tables to INNODB. Upgrade your MySQL to 5.7 as well.

[woodmj]

There's a mod over at vbulletin.org that may help there. [DBTech] vB Optimise v2 (vB4).

[Chris Tretta]

My VB site is getting hammered by high CPU utilization, and I was looking for some ideas. Here is what is in my system process manager:

68.36

5.58

/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.XXXXXXX.com.err --open-files-limit=10000 --pid-file=/var/lib/mysql/mysqld.pid

My research hasn't turned up anything useful. Does anyone have experience with this type of an issue?
Thanks
Chris