If the value of Piped sorts ratio is low, you should consider increasing the sort heap threshold (sheapthres) for better sort performance.
如果管道排序率的值很低，您就应该考虑增加排序堆阈值(sheapthres)以获得更高的排序性能。
2
If the value of Post threshold sorts ratio is high, you should either increase the sort heap threshold (sheapthres), or adjust applications to use fewer or smaller sorts via SQL query changes.
For example, you can define a threshold alert to be triggered if your Buffer Pool Hit ratio drops to below 60% for a warning level or 55% for a problem level.
例如，您可以定义当Buffer Pool Hit ratio下降到低于60%时触发一个警告级阈值提醒，或者低于55%时触发一个问题级阈值提醒。