You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The host_summary_by_stages and user_summary_by_stageswait_sum and wait_avg columns were renamed to total_latency and avg_latency respectively, for consistency.
The host_summary_by_file_io_type and user_summary_by_file_io_typelatencycolumn was renamed tototal_latency`, for consistency.
Improvements
Made the truncation length for the format_statement view configurable
This includes adding a new persistent sys_config table to store the new variable - statement_truncate_len - see the README for usage
Added total_latency to the schema_tables_with_full_table_scans view, and added an x$ counterpart
Added innodb_buffer_free to the schema_table_statistics_with_buffer view, to summarize how much free space is allocated per table in the buffer pool
The schema_unused_indexes view now ignores indexes named PRIMARY (primary keys)
Added rows_affected and rows_affected_avg stats to the statement_analysis views
The statements_with_full_table_scans view now ignores any SQL that starts with SHOW
Added a script, generate_sql_file.sh, that can be used to generate a single SQL file, also allowing substitution of the MySQL user to use, and/or whether the SET sql_log_bin ... statements should be omitted.
** This is useful for those using RDS, where the root@localhost user is not accessible, and sql_log_bin is disabled (Issue #5)
Added a set of memory_by_thread_by_current_bytes views, that summarize memory usage per thread with MySQL 5.7's memory instrumentation
Improved each of the host specific views to return aggregate values for background threads, instead of ignoring them, in the same way as the user summary views
Bug Fixes
Added the missing memory_by_host view for MySQL 5.7
Added missing space for hour notation within the format_time function
Fixed views affected by MySQL 5.7 ONLY_FULL_GROUP_BY and functional dependency changes