Results 1 to 7 of 7

Thread: Limit issue

  1. #1
    Join Date
    Oct 2012

    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/ --open-files-limit31980 --pid-file/var/lib/mysql/ --socket/var/lib/mysql/mysql.sock

  2. #2
    Join Date
    Mar 2003
    Install mytop so you can monitor which databases are causing this problem.
    Specially 4 You
    JoneSolutions.Com ( Jones.Solutions ) is on the net 24/7 providing stable and reliable web hosting solutions and services since 2001

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

  4. #4
    Join Date
    Oct 2011
    Sofia, Bulgaria

    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
    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
    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 and Data Centers
    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