mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
c2b6916393
* it isn't "pfs" function, don't call it Item_func_pfs, don't use item_pfsfunc.* * tests don't depend on performance schema, put in the main suite * inherit from Item_str_ascii_func * use connection collation, not utf8mb3_general_ci * set result length in fix_length_and_dec * do not set maybe_null * use my_snprintf() where possible * don't set m_value.ptr on every invocation * update sys schema to use the format_pico_time() * len must be size_t (compilation error on Windows) * the correct function name for double->double is fabs() * drop volatile hack
52 lines
2 KiB
Text
52 lines
2 KiB
Text
DESC sys.statement_analysis;
|
|
Field Type Null Key Default Extra
|
|
query longtext YES NULL
|
|
db varchar(64) YES NULL
|
|
full_scan varchar(1) NO
|
|
exec_count bigint(20) unsigned NO NULL
|
|
err_count bigint(20) unsigned NO NULL
|
|
warn_count bigint(20) unsigned NO NULL
|
|
total_latency varchar(12) YES NULL
|
|
max_latency varchar(12) YES NULL
|
|
avg_latency varchar(12) YES NULL
|
|
lock_latency varchar(12) YES NULL
|
|
rows_sent bigint(20) unsigned NO NULL
|
|
rows_sent_avg decimal(21,0) NO 0
|
|
rows_examined bigint(20) unsigned NO NULL
|
|
rows_examined_avg decimal(21,0) NO 0
|
|
rows_affected bigint(20) unsigned NO NULL
|
|
rows_affected_avg decimal(21,0) NO 0
|
|
tmp_tables bigint(20) unsigned NO NULL
|
|
tmp_disk_tables bigint(20) unsigned NO NULL
|
|
rows_sorted bigint(20) unsigned NO NULL
|
|
sort_merge_passes bigint(20) unsigned NO NULL
|
|
digest varchar(32) YES NULL
|
|
first_seen timestamp NO 0000-00-00 00:00:00
|
|
last_seen timestamp NO 0000-00-00 00:00:00
|
|
SELECT * FROM sys.statement_analysis;
|
|
DESC sys.x$statement_analysis;
|
|
Field Type Null Key Default Extra
|
|
query longtext YES NULL
|
|
db varchar(64) YES NULL
|
|
full_scan varchar(1) NO
|
|
exec_count bigint(20) unsigned NO NULL
|
|
err_count bigint(20) unsigned NO NULL
|
|
warn_count bigint(20) unsigned NO NULL
|
|
total_latency bigint(20) unsigned NO NULL
|
|
max_latency bigint(20) unsigned NO NULL
|
|
avg_latency bigint(20) unsigned NO NULL
|
|
lock_latency bigint(20) unsigned NO NULL
|
|
rows_sent bigint(20) unsigned NO NULL
|
|
rows_sent_avg decimal(21,0) NO 0
|
|
rows_examined bigint(20) unsigned NO NULL
|
|
rows_examined_avg decimal(21,0) NO 0
|
|
rows_affected bigint(20) unsigned NO NULL
|
|
rows_affected_avg decimal(21,0) NO 0
|
|
tmp_tables bigint(20) unsigned NO NULL
|
|
tmp_disk_tables bigint(20) unsigned NO NULL
|
|
rows_sorted bigint(20) unsigned NO NULL
|
|
sort_merge_passes bigint(20) unsigned NO NULL
|
|
digest varchar(32) YES NULL
|
|
first_seen timestamp NO 0000-00-00 00:00:00
|
|
last_seen timestamp NO 0000-00-00 00:00:00
|
|
SELECT * FROM sys.x$statement_analysis;
|