mysql high usage


Well-known member

i have average of 500 users per day login
and i always have this hangup problem.

Resource: Process Time
Exceeded: 2094 > 1800 (seconds)
Executable: /usr/bin/php
Command Line: /usr/bin/php /home/XXXX/public_html/index.
PID: 21496 (Parent PID:21433)
Killed: No

The tech said:
I apologize for the delay. It seems that MySQL was causing very high I/O wait times on the server bringing it to a crawl. Restarting the MySQL server has fix this. Please let me know if you have any further questions or concerns.

is there a way how to fix this?

Last edited:


Well-known member
Are you an a shared server or on a VPS or dedicated server?
Is you Mysql configuration file optimized for Innodb?


Well-known member
im on vps
Name Intel(R) Xeon(R) CPU X3430 @ 2.40GHz
Speed 2393.982 MHz
Cache 8192 KB
RAM 4gb

does innodb better over myisam ?
Last edited:


Well-known member
Xenforo uses mainly Innodb tables and if your VPS is a standard install without any optimization you will experience heavy performance problems.

Take a look at your /etc/my.cnf file and look for an entry "innodb_buffer_pool_size=2G". If there is no such entry or if it has a very low value correct it to
innodb_flush_method = O_DIRECT
innodb_buffer_pool_size = 2G