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

mysql high usage

Discussion in 'Server Configuration and Hosting' started by swatme, Jul 12, 2013.

  1. swatme

    swatme 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: Jul 12, 2013
  2. Walter

    Walter Well-Known Member

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

    swatme 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: Jul 12, 2013
  4. Walter

    Walter 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

Share This Page