mysql high usage

[swatme]

hi

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.
php
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?

thanks

 

[Walter]

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

 

[swatme]

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 ?

 

[Walter]

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