Results 1 to 10 of 10
  1. #1
    Join Date
    Oct 2004
    Posts
    61

    the system load increasing suddenly

    the system load increase suddenly,the maximum is 98.67,but it will decrease later.I think that must mysql problem.how to check with it?

  2. #2
    Join Date
    Jan 2005
    Location
    Hong Kong
    Posts
    47
    login into the system,
    use command "top", and press "P" (big letter P) to see which process use the most CPU usage.
    and then you try to troubleshoot it.

  3. #3
    Also try pressing "M" while running "top", it sort processes by memory usage.

    Most high load problems are caused by over usage of memory, when swap memory has to be used.
    LiteSpeed Web Acceleration Platform by http://www.litespeedtech.com
    Apache drop-in replacement. Triple server capacity with 10X performance increases.
    Ultimate web serving platform for WordPress, Magento and other web applications.
    Turbo charging all WordPress sites hosted on your server with a single click!

  4. #4
    Join Date
    Apr 2003
    Location
    NC
    Posts
    3,080
    Another thing is run ps -aux and look at what is running a lot of things. If the server is really busy there will probably be tens of mysql/httpd processes while if it is something else you may have a rogue process.
    John W, CISSP, C|EH
    MS Information Security and Assurance
    ITEagleEye.com - Server Administration and Security
    Yawig.com - Managed VPS and Dedicated Servers with VIP Service

  5. #5
    are you using cpanel?

    if so there was a problem causing high server loads from /scripts/convertemails.

  6. #6
    Join Date
    Oct 2004
    Posts
    61
    I am using directadmin.But How to check the Mysql?I suspect it is cause by mysql

  7. #7
    Join Date
    Sep 2002
    Location
    Top Secret
    Posts
    11,686
    I am using directadmin.
    Smart choice

    How to check the Mysql?I suspect it is cause by mysql
    mysqladmin processlist will show you everything using sql at the current time.
    In addition, mysqladmin status will show the status of mysql (ie: current slow connections, etc), which will be helpful in determining what part of the problem is
    WHMCS Guru - WHMCS addons, management, support and more.
    WHMCS Notifications Extended - Add slack, hipchat, SMS, pushover to WHMCS !!
    Always looking for Linux, WHMCS, Support Desk work. PM for details

  8. #8
    Join Date
    Oct 2004
    Posts
    61
    Originally posted by linux-tech
    Smart choice



    mysqladmin processlist will show you everything using sql at the current time.
    In addition, mysqladmin status will show the status of mysql (ie: current slow connections, etc), which will be helpful in determining what part of the problem is
    Do you Mean PHPMYADMIN?

  9. #9
    Join Date
    Jul 2002
    Location
    Alberta, Canada
    Posts
    348
    there is an option in phpMyAdmin as well (runtime status) that shows the status, and the processes area shows you whats actually running. the mysqladmin tool he as refering to is the commandline tool on the server.

    Another tool that can be useful, especially if the system is going so slow you can't access phpmyadmin is a script called mytop... its basically a clone of top, but it shows the mysql process information. This should help you isolate the cause of the load along with the other steps.
    AC Host Canada Affordable Canadian Web Hosting Solutions
    Shared Hosting | Email Hosting | DNS Hosting | Custom Plans Available
    Website: www.achost.ca email: [email protected]

  10. #10
    Join Date
    May 2005
    Posts
    61
    Right use mytop to see the mysqlusage or check it 'show processlist' command after entering msyql

    ]$ mysql
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql> show processlist;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •