Shulou(Shulou.com)05/31 Report--

This article mainly introduces the Percona server mysql index monitoring example analysis, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor with you to understand.

User Statistics

On variable: off by default, it creates several HASH tables in memory

Set global userstat=on

Set global thread_statistics=on

Check the index usage: you can determine whether the index is used or not

Select * from t where c1, and c2, and c5, order by c2, c3

SELECT * FROM INFORMATION_SCHEMA.INDEX_STATISTICS WHERE TABLE_NAME='t' and table_schema='test'

+-+

| | TABLE_SCHEMA | TABLE_NAME | INDEX_NAME | ROWS_READ | |

+-+

| | test | t | idx_t_c1 | 18 | |

+-+

ROWS_READ: the number of rows accessed from the index, which is a cumulative value

Show client connection details

SELECT * FROM INFORMATION_SCHEMA.CLIENT_STATISTICS\ G

Thank you for reading this article carefully. I hope the article "sample Analysis of Percona server mysql Index Monitoring" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.