diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2023-03-27 18:50:49 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2023-03-27 21:27:27 +0200 |
| commit | c2b69163934016afa4bb3b274cddaacec92fcb61 (patch) | |
| tree | e626bb791fdfb7438e1bdd340da47970926c95b9 /scripts/sys_schema/views/p_s/host_summary.sql | |
| parent | d9808f79de992964ed802d27984c9031d72e7b9a (diff) | |
| download | mariadb-git-c2b69163934016afa4bb3b274cddaacec92fcb61.tar.gz | |
MDEV-19629 post-merge fixesbb-11.0-serg
* 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
Diffstat (limited to 'scripts/sys_schema/views/p_s/host_summary.sql')
| -rw-r--r-- | scripts/sys_schema/views/p_s/host_summary.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/scripts/sys_schema/views/p_s/host_summary.sql b/scripts/sys_schema/views/p_s/host_summary.sql index 080100a4241..99ed0942a9c 100644 --- a/scripts/sys_schema/views/p_s/host_summary.sql +++ b/scripts/sys_schema/views/p_s/host_summary.sql @@ -46,11 +46,11 @@ VIEW host_summary ( ) AS SELECT IF(accounts.host IS NULL, 'background', accounts.host) AS host, SUM(stmt.total) AS statements, - sys.format_time(SUM(stmt.total_latency)) AS statement_latency, - sys.format_time(IFNULL(SUM(stmt.total_latency) / NULLIF(SUM(stmt.total), 0), 0)) AS statement_avg_latency, + format_pico_time(SUM(stmt.total_latency)) AS statement_latency, + format_pico_time(IFNULL(SUM(stmt.total_latency) / NULLIF(SUM(stmt.total), 0), 0)) AS statement_avg_latency, SUM(stmt.full_scans) AS table_scans, SUM(io.ios) AS file_ios, - sys.format_time(SUM(io.io_latency)) AS file_io_latency, + format_pico_time(SUM(io.io_latency)) AS file_io_latency, SUM(accounts.current_connections) AS current_connections, SUM(accounts.total_connections) AS total_connections, COUNT(DISTINCT accounts.user) AS unique_users |