可以通过查询钻取特性收集关于系统上执行的每个sql语句的统计信息并分析语句历史。
Query drill down allows you to gather statistical information about each SQL statement executed on the system and analyze statement history.
因此,通常情况下,在这些视图上查询统计或者历史记录数据是不可行的。
Thus, queries on these views are usually not feasible to gather statistical or historical data.
mytop 还提供了一个有关关键字缓冲区和查询缓存效率的实时数据和历史数据,以及有关正在运行的查询的统计信息。
mytop also provides real-time and historical data about key-buffer and query-cache efficiency, and statistics about the queries being run.
应用推荐