systat -ifstat n

Somebody has started 'systat -ifstat n' command on server and it has been run in background for few weeks. Here is funny graph and you can notice moment when I killed systat and load went down:

Comments

Post a Comment

Popular posts from this blog

'50 State Coins' iPhone application

Image
Category: Reference
Released: Jul 27, 2012
Version: 1.0
Size: 7.9 MB
Language: English
Seller: Ivan Klishch
iTunes link: 50 State Coins

'50 State Coins' is my very first try in iOS applications development.

It's free iPhone app for those who is collecting coins (numismatists). Currently we are supporting 2 collections of coins - '50 State Quarters' collection and 'District of Columbia and United States Territories Quarters'.

Read more

Killing Long-Running MySQL Processes

Killing long running MySQL queries is easy. There is KILL command

where PROCESS_ID is an ID from SHOW PROCESSLIST command. I have created small PHP script to kill all long running processes using RegExp.

You can checkout it from my Github: https://github.com/klivan/MySQL-Process-Killer

Just change $host, $user and $password to access your MySQL server, and add regexp that matches your query.

Change $minExecutionTimeToKill to minimum number of seconds that query should be running before killing.

To run simply execute:

$ php ./kill.php

View on Github
Read more