Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have LAMP server having 4 core CPU and 32 GB RAM.We are running a large website on it. I have following issues now in my server.

  1. When I use Mysqlreport tool to monitor the mysql server i am always seeing the connection usage as below. And the users reporting connection issues in the website.

_

Connections _______________________________

Max used 251 of 250 %Max: 100.40 Total 748.71k 3.5/s

But when I use "show process list" command it will output nothing. We are using MyISAM engine for all our DBs.

My Mysql Config File is pasted below:

######################

[mysqld]

max_connections = 250

set-variable=local-infile=0

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

skip-name-resolve

skip-bdb

wait_timeout = 60

thread_cache_size = 100

table_cache = 1024

key_buffer = 384M

log_slow_queries=/mysql-log/mysql-slow.log

query-cache-size=512M

query-cache-type=1

query_cache_limit=20M

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

#

Who is using my Mysql connection pool? How can I find it?

And i have another issue.

  1. Sometimes the Load average goes beyond 4-8 range. See below:

13:40:02 up 2 days, 10:39, 0 users, load average: 5.03, 1.68, 0.93

At that time i can see mysql is the top consumer of the CPU. Is there any optimization needed in mysql Server?

share|improve this question
    
"show process list" command it will output nothing - what's "nothing"? Could you post the exact output? –  syneticon-dj Dec 19 '11 at 10:26
    
Try show processlist instead of show process list –  Cakemox Dec 19 '11 at 12:26
    
Anything showing in netstat, could be that you have open connections that are not being closed by your applications? –  Oneiroi Dec 19 '11 at 12:39
add comment

1 Answer

But when I use "show process list" command it will output nothing

The there's something broken on your system. It should at least show the connection running processlist. It will also show current idle connections.

Max used 251 of 250 %Max: 100.40 Total 748.71k 3.5/s

Sounds like this is reporting max_used_connections which is the high water mark since the server was last restarted - which is not the same as the current number of connections.

Is there any optimization needed in mysql Server?

Impossible to say from the information provided. Although since you've not provided a lot of the relevant information for making such a determination then the answer is probably yes.

Try running mysqltuner.pl against the instance. Also read some of the many answers here on tuning a LAMP instance.

share|improve this answer
    
Thank you all for your valuable replies. It was my interpretation mistake of mysqlreport documentation.Thank you symcbean for pointing out this. S –  ArunS Dec 19 '11 at 13:08
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.