GitHub - ctmnz/selectqkiller: Simple c++ daemon for seek and destroy time consuming MySQL SELECT queries

ctmnz / selectqkiller Public

Notifications You must be signed in to change notification settings
Fork 0
Star 1

Simple c++ daemon for seek and destroy time consuming MySQL SELECT queries

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 6 Commits
.gitignore		.gitignore
Makefile		Makefile
README		README
myslowlogfile.log		myslowlogfile.log
selectqkiller		selectqkiller
selectqkiller.c		selectqkiller.c
selectqkiller.cnf		selectqkiller.cnf

Repository files navigation

SELECTQKILLER
--------------------
Description:

This is a simple program for finding and killing slow mysql select queries produced by your applications.
Once started, it executes constanlty 'show full processlist' and watches for SELECT queries that are slower than defined time 'config_max_query_time' and kills the slow queries. Killed queries are logged in myslowlogfile.log file.

Who needs this?
Someone who manages projects that using Linux MySQL.

Easy to install (from linux console)

#> make


Easy to configure. It uses ini-like configuration file.

#> vim selectqkiller.cnf

----
[Main]
config_max_query_time=20

[Mysql user config]
config_host=localhost
config_user=root
config_pass=
config_db=test
config_logfilepath=/root/selectqkiller
----


Easy to use

#> ./selectqkiller
#>




Easy to remove (from linux console)

#> make clean