DB Wiki

User Tools

Site Tools

Trace: • mysqlperformance
mysqlperformance

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
mysqlperformance [2019/08/05 15:52] – [Performance Schema Scripts] z0hpvkmysqlperformance [2019/08/06 10:40] (current) – [Performance Schema Scripts] z0hpvk
Line 22: Line 22:
  where index name is not null and count_star = 0  where index name is not null and count_star = 0
  order by object_schema, object_name;  order by object_schema, object_name;
 +
 +-- Queries not using Indexes
 +SELECT THREAD_ID TID, SUBSTR(SQL_TEXT, 1, 50) SQL_TEXT, ROWS_SENT RS,
 +       ROWS_EXAMINED RE,CREATED_TMP_TABLES,NO_INDEX_USED,NO_GOOD_INDEX_USED
 +  FROM performance_schema.events_statements_history
 + WHERE NO_INDEX_USED=1 OR NO_GOOD_INDEX_USED=1;
 +
 +-- Queries using Full Table Scans
 +SELECT query, db, total_latency, no_index_used_count, rows_sent, rows_examined, last_seen
 +  FROM sys.statements_with_full_table_scans
 + WHERE db not in ('performance_schema','sys')
 +ORDER BY last_seen DESC limit 50;
  
 -- Process List -- Process List
mysqlperformance.1565020349.txt.gz · Last modified: (external edit)