Results 1 to 7 of 7

Thread: Limit issue

  1. #1
    Join Date
    Oct 2012
    Posts
    31

    Limit issue

    can any one tell me please what is this issue? and what is its solution?, I fund in log and its consuming server CPU load more than 15%

    ============
    /usr/sbin/mysqld --basedir/usr --datadir/var/lib/mysql --plugin-dir/usr/lib64/mysql/plugin --usermysql --log-error/var/lib/mysql/server.domain.com.err --open-files-limit31980 --pid-file/var/lib/mysql/server.domain.com.pid --socket/var/lib/mysql/mysql.sock
    ===========

  2. #2
    Join Date
    Mar 2003
    Location
    /root
    Posts
    23,990
    Install mytop so you can monitor which databases are causing this problem.

    Specially 4 U
    Reseller Hosting: Boost Your Websites | Fully Managed KVM VPS: 3.20 - 5.00 Ghz, Pure Dedicated Power
    JoneSolutions.Com is on the net 24/7 providing stable and reliable web hosting solutions, server management and services since 2001
    Debian|Ubuntu|cPanel|DirectAdmin|Enhance|Webuzo|Acronis|Estela|BitNinja|Nginx

  3. #3
    Join Date
    Oct 2012
    Posts
    31
    Is it free link?

  4. #4
    Join Date
    Oct 2011
    Location
    Sofia, Bulgaria
    Posts
    12
    http://jeremy.zawodny.com/mysql/mytop/

    And if you are using Percona MySQL or MariaDB, you can check the information in the _STATISTICS tables in the information_schema.

  5. #5
    Most probably you have lots of open connection or some large dbs which are consuming more CPU. As suggested, install mytop to monitor the running mysql process via SSH.
    || Web Hosting Blog - Web Hosting security & latest web hosting industry Announcements
    || Web Hosting Discussion - A Web Hosting community

  6. #6
    Join Date
    Oct 2012
    Posts
    31
    I have installed now i can see some connections sleep so what i need to do to save from sleep connections and stop them

  7. #7
    Join Date
    May 2013
    Location
    India
    Posts
    747
    15% of single CPU? That can be quite normal for MySQL process.

Similar Threads

  1. What is providers limit to help heat issue?
    By edmar in forum Colocation, Data Centers, IP Space and Networks
    Replies: 11
    Last Post: 04-30-2011, 08:00 AM
  2. IPTables - Rule Limit / Max Out Limit
    By TomBoy123 in forum Hosting Security and Technology
    Replies: 2
    Last Post: 07-05-2009, 11:12 AM
  3. file limit & http tranfer limit
    By variable in forum Hosting Security and Technology
    Replies: 1
    Last Post: 01-22-2006, 09:05 PM
  4. .htaccess limit - how to limit access to only certain hostnames?
    By mrzippy in forum Programming Discussion
    Replies: 2
    Last Post: 07-15-2003, 01:01 PM
  5. Apache File Descriptor Limit Issue
    By Dathorn-Andrew in forum Hosting Security and Technology
    Replies: 12
    Last Post: 03-10-2003, 07:27 PM

Posting Permissions

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