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, 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.
Saturday, January 9, 2010
Check out a php tool that shows mysql queries on web interface. Its shows index usage,query cache hit rate,slow queries,table scans,tables lock waits, etc… in a beautiful way on the browser. It also provides online demo. Best part is its freeware. Please follow link to get more details on it and check for yourself.
Monday, December 21, 2009
Some of the MySQl Best Practices Optimize Your Queries For the Query Cache EXPLAIN Your SELECT Queries LIMIT 1 When Getting a Unique Row Index the Search Fields Index and Use Same Column Types for Join Do Not ORDER BY RAND() Avoid SELECT Almost Always Have an id Field Use ENUM over VARCHAR Get Suggestions [...]
Friday, November 27, 2009
I was searching over past many days to get some tool which can push Awstats data file in to MySql database so that it can be customized to generate reports the way I wanted. I came across a tool that really does that with quite ease. You may have to customize the script so that [...]
Monday, November 16, 2009
Mysql monitoring is an important task and can help to determine the performance of the database server. We provide below link to some of the great tools that can help all to achive a logging mechanism which can be used to track the performance of mysql server as well as some useful tools for mysql. [...]
© 2010 Solution Expert Online Blogs. Powered by Wordpress.
Wednesday, June 2, 2010
0 Comments