Enhanced Query Analyzer Plugin for MySQL on Rails
Install it in vendor/plugins:
<braid add / git clone / git submodule> \ git://github.com/smtlaissezfaire/enhanced_query_analyzer.git \ vendor/plugins/enhanced_query_analyzer Add the model and migration: ./script/generate enhanced_query_analyzer Migrate: rake db:migrate
All select queries will be logged to the query_logs table. You now have the ability to store historical data of all of your database access. You can turn off all query logging by putting the following in environment.rb: EnhancedQueryAnalyzer.logging = false You can also add the ability to dynamically run and log the explain of each query: EnhancedQueryAnalyzer.explain_logging = true
Running Unit Tests
You'll need rspec and mysql. The database must be named 'query_analyzer_test'
Written by Scott Taylor <email@example.com>. Sponsored by Eastmedia (http://eastmedia.com/).
Dual licensed under the MIT & GPL licenses.