mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
32 lines
763 B
Text
32 lines
763 B
Text
#
|
|
# MDEV-34125: ANALYZE FORMAT=JSON: r_engine_stats.pages_read_time_ms has wrong scale
|
|
#
|
|
create table t1 (
|
|
a varchar(255),
|
|
b varchar(255),
|
|
c varchar(255),
|
|
d varchar(255),
|
|
primary key(a,b,c,d)
|
|
) engine=innodb character set latin1;
|
|
SET unique_checks=0, foreign_key_checks= 0;
|
|
begin;
|
|
insert into t1 select
|
|
repeat(uuid(), 7),
|
|
repeat(uuid(), 7),
|
|
repeat(uuid(), 7),
|
|
repeat(uuid(), 7)
|
|
from seq_1_to_16384;
|
|
commit;
|
|
SET GLOBAL innodb_fast_shutdown=0;
|
|
# restart
|
|
set log_slow_verbosity='engine';
|
|
set long_query_time=0.0;
|
|
set @js='$analyze_output';
|
|
set @pages_read_time_ms=
|
|
(select json_value(@js,'$.query_block.nested_loop[0].table.r_engine_stats.pages_read_time_ms'));
|
|
|
|
|
|
OK: pages_read_time is same in slow log and ANALYZE
|
|
|
|
set long_query_time=default;
|
|
drop table t1;
|