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

This article mainly introduces "how to solve the error problems caused by orztop in Mysql tools". In the daily operation, I believe many people have doubts about how to solve the error problems caused by orztop in Mysql tools. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts about "how to solve the error problems caused by orztop in Mysql tools". Next, please follow the editor to study!

Mysqltools-orztop

The information printed on the screen also includes the database's insert/update/delete/select per second, logical read, hit rate, current active thread, and so on. You can roughly see the current pressure of the database.

When there is a performance bottleneck in your instance, you might as well use this tool to take a look, grab the slow sql that is currently running, and then analyze the sql

Execute the orztop script:

. / orztop-hull 127.0.0.1-Please 3306-u=root-pendant 123456-tasking 1

H represents the host address (the RDS user changes to the connection address of the instance: hzn02.rds.aliyuncs.com)

P stands for port (RDS user transposition instance connection port: 3306)

U represents the running user

P stands for password

T stands for time refresh interval

Error:

DBD::mysql::st execute failed: Unknown column 'Com_select' in' where clause' at. / orztop line 703.

Code

Show global status where Variable_name in ("Com_select", "Com_insert", "Com_update", "Com_delete", "Innodb_buffer_pool_read_requests", "Innodb_buffer_pool_reads", "Threads_running")

The modifications are as follows:

"show global status where Variable_name in ('Com_select','Com_insert','Com_update','Com_delete','Innodb_buffer_pool_read_requests','Innodb_buffer_pool_reads','Threads_running')"

At this point, the study on "how to solve the error problems caused by orztop in Mysql tools" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.