You can use Statpack to generate stats of mysql show global status and store in file for later analysis. Its a python script that collects performance snapshot of mysql server. You will need to install mysql-python module to get this script working. Please follow link to know more about it.
Thursday, July 1, 2010
Monitor Mysql server statistics using mysql-monitoring. Its a perl script that queries mysql server for statistics every 60 secs. Licensed under GPL v3. Once rrd files have been generated, you can use ddraw tool to generate graphs out of it. Please follow link to get to know more about it. Ddraw a tool to generate [...]
Wednesday, June 2, 2010
Cool piece of work for graphing mysql performance using mycheckpoint. Tried it and its really good as its database driven, you can customize and generate your own kind of report. It also has features of alerting system. Try it, its really good and displays lot of stuffs on browser as well as text.
Tuesday, June 1, 2010
Want to monitor, process logs and many other, try this link which has many other tools on its site. Tried it and found really good to process the logs and can help in automating many mysql activity stuffs.
Friday, May 28, 2010
I was trying to install zabbix monitoring tool and was getting libcurl library not found error. I checked all the way and found curl and libcurl installed. Finally ,found the library that was missing was not libcurl but libidn-devel library which provides -lcurl option to zabbix for installation. Sharing this as it might help many. [...]
Tuesday, May 18, 2010
Want to monitor traffic based on per hosts or IP passing through linux gateway, try IPAudit. Fantastic tool provides complete activity details on your traffic passing through interface. Displays traffic details on web based interface, that’s the one I liked the most. Please follow link to get more details on it.
Friday, March 19, 2010
Want to know what all commands or processes run on server, with every detail out of it. Use can use psacct software provided with OS. Provides lots of information on what all commands have been run on server at what time and from which terminal. It also tracks commands run by users.
Saturday, February 13, 2010
Mysql status update is a script which provides status update by email or SMS whenever mysql is restarted, huge fluctuation in numbers difference about queries and slow queries. Thought of sharing. Please follow link to get more details on it.
Wednesday, February 10, 2010
Found a great and fantastic tool which monitors full processlist of mysql query running on server. No logs required to get the details. You can use it to log to any way you want it and can see what all queries have been executed on server for fine tuning your application. Written is perl, Its [...]
Tuesday, February 9, 2010
Cool piece of perl script that monitors usage/resource consumption of Mysql on Linux machine.Written in perl and can be modified to get details of almost any running program.Liked a lot as it helps me to get resource consumption of many programs. Please follow link to get more detail on it.
© 2010 Solution Expert Online Blogs. Powered by Wordpress.
Tuesday, July 6, 2010
0 Comments