Results 1 to 7 of 7
Thread: Limit issue
-
11-11-2013, 08:44 AM #1Junior Guru Wannabe
- 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
===========
-
11-11-2013, 09:05 AM #2The Linux Specialist
- 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
-
11-11-2013, 10:17 AM #3Junior Guru Wannabe
- Join Date
- Oct 2012
- Posts
- 31
Is it free link?
-
11-12-2013, 07:36 PM #4Newbie
- 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.
-
11-13-2013, 12:51 AM #5Web Hosting Master
- Join Date
- Jan 2008
- Posts
- 1,204
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
-
11-17-2013, 08:15 AM #6Junior Guru Wannabe
- 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
-
11-17-2013, 09:20 AM #7Temporarily Suspended
- Join Date
- May 2013
- Location
- India
- Posts
- 747
15% of single CPU? That can be quite normal for MySQL process.
Similar Threads
-
What is providers limit to help heat issue?
By edmar in forum Colocation, Data Centers, IP Space and NetworksReplies: 11Last Post: 04-30-2011, 08:00 AM -
IPTables - Rule Limit / Max Out Limit
By TomBoy123 in forum Hosting Security and TechnologyReplies: 2Last Post: 07-05-2009, 11:12 AM -
file limit & http tranfer limit
By variable in forum Hosting Security and TechnologyReplies: 1Last Post: 01-22-2006, 09:05 PM -
.htaccess limit - how to limit access to only certain hostnames?
By mrzippy in forum Programming DiscussionReplies: 2Last Post: 07-15-2003, 01:01 PM -
Apache File Descriptor Limit Issue
By Dathorn-Andrew in forum Hosting Security and TechnologyReplies: 12Last Post: 03-10-2003, 07:27 PM