MyQCache - free command-line utility to help coders grok the query cache
am 27.04.2006 23:46:09 von jonathan.lampeMyQCache is a free command-line application that replays a MySQL=AE database=
=20
query log and gathers information about MySQL cache usage and execution=20
time. MyQCache helps identify specific queries in your code that:
* ...would benefit from the "SQL_NO_CACHE" SELECT option.
* ...are possible candidates for software caching.
* ...are wasting large amounts of your database's time.
* ...are actually using the query cache well.
Long story short, you use MyQCache like this:
* Record a MySQL log full of activity from your application
* Replay the MySQL log through MyQCache.exe
* MyQCache.exe will display cache usage and execution statistics
More information and download here:
http://people.stdnet.com/jonathan/default.php?schr101=3DSoft ware_MyQCache.ph=
p
Regards,
- Jonathan Lampe
- jonathan.lampe@tds.net
******************* PLEASE NOTE *******************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org