Breaking News
Loading...
13/12/2013

ps_helper: useful for everyday DBA/Developer

ps_helper is a collection of views and procedures against the performance_schema database within MySQL, that can be used to generate extra summary data, or are generally useful for everyday DBA/Developer/operations use cases.
http://www.markleith.co.uk/ps_helper/

To refer how to use them, see the following link:

http://www.markleith.co.uk/ps_helper/#statement_analysis

For example:

View: statements_with_full_table_scans

select * from statements_with_full_table_scans limit 5;
SELECT * FROM schema_tables_with_full_table_scans LIMIT 10;
SELECT * FROM schema_unused_indexes;
SELECT * FROM schema_table_statistics LIMIT 10;
SELECT * FROM statements_with_runtimes_in_95th_percentile WHERE QUERY NOT LIKE 'show%';


0 comments:

Post a Comment

 
Toggle Footer