• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

mysql high usage

swatme

Well-known member
#1
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
 
Last edited:

Walter

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

swatme

Well-known member
#3
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:

Walter

Well-known member
#4
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
Code:
innodb_flush_method = O_DIRECT
innodb_buffer_pool_size = 2G