this post also show’s that the Average Query Execution Time
# Average Query Execution Time for Last 6 hours
select avg(m_query_time_sum/m_query_time_cnt) from metrics where period_start>subtractHours(now(),6);
is wrong too
this post also show’s that the Average Query Execution Time
# Average Query Execution Time for Last 6 hours
select avg(m_query_time_sum/m_query_time_cnt) from metrics where period_start>subtractHours(now(),6);
is wrong too
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2024 Percona LLC. All rights reserved.