MariaDB-server/mysql-test/include/analyze-format.inc

# Remove non-deterministic parts of ANALYZE FORMAT=JSON output:
# - any timings
# - Buffer sizes (depend on pointer size)
# - r_engine_stats depends on buffer pool state and whether old record versions
#   were purged.

--replace_regex /("(r_[a-z_]*_time(_in_progress)?_ms|r_buffer_size|cost|r_partial_match_buffer_size)": )[^, \n]*/\1"REPLACED"/ /("r_engine_stats":) {[^}]*}/\1 REPLACED/
MDEV-31577: Make ANALYZE FORMAT=JSON print innodb stats ANALYZE FORMAT=JSON output now includes table.r_engine_stats which has the engine statistics. Only non-zero members are printed. Internally: EXPLAIN data structures Explain_table_acccess and Explain_update now have handler* handler_for_stats pointer. It is used to read statistics from handler_for_stats->handler_stats. The following applies only to 10.9+, backport doesn't use it: Explain data structures exist after the tables are closed. We avoid walking invalid pointers using this: - SQL layer calls Explain_query::notify_tables_are_closed() before closing tables. - After that call, printing of JSON output is disabled. Non-JSON output can be printed but we don't access handler_for_stats when doing that. 2023-07-06 10:41:46 +03:00			`# Remove non-deterministic parts of ANALYZE FORMAT=JSON output:`
			`# - any timings`
			`# - Buffer sizes (depend on pointer size)`
			`# - r_engine_stats depends on buffer pool state and whether old record versions`
			`# were purged.`
MDEV-11866: ANALYZE FORMAT=JSON not predicatable for r_total_time_ms/r_buffer_size [0-9][.]?[0-9] wasn't a sufficient regex to cover the %lg used in Json_writer::add_double. Exponent formats where missed. Here we normalize all the replace_regex expressions for ANALYZE FORMAT=JSON into one include file. Signed-off-by: Daniel Black <daniel.black@au.ibm.com> 2017-01-23 13:32:57 +11:00
Merge branch '10.11' into 11.1 2024-08-03 09:32:42 +02:00			`--replace_regex /("(r_[a-z_]_time(_in_progress)?_ms\|r_buffer_size\|cost\|r_partial_match_buffer_size)": )[^, \n]/\1"REPLACED"/ /("r_engine_stats":) {[^}]*}/\1 REPLACED/`