find out how many open connection in mysql

mysqladmin –user=root –password=mysqlpass processlist -i 1
is a great thing 🙂
shows how many mysql connection/process open in server

specially in python mysql you can get errors like this:
OperationalError: (1040, ‘Too many connections’)
this means you have many connection open and they are not closed.
from above command you can check how many connection are open and even check what python code is causing this by trying different python code while that command is running to see which increases the idle open connection.

Then you can change your python code so it closes the cursor and the connection right after finishing the task in mysql.

Advertisements
About

Work is fun!

Tagged with: , , , , ,
Posted in Linux, mysql, ploneCMS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Disclaimer
All content provided on this "tareqalam.com" blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner of [tareqalam.wordpress.com] will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information.
December 2014
M T W T F S S
« Sep   Jan »
1234567
891011121314
15161718192021
22232425262728
293031  

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 23 other followers

%d bloggers like this: