current position:Home>What database server performance analysis methods and commands does MySQL have?

What database server performance analysis methods and commands does MySQL have?

2022-02-04 16:46:29 Alibaba cloud Q & A

MYSQL What are the methods and commands for database server performance analysis ?




Take the answer 1:

Show status, Some variable values worth monitoring :

Bytes_received and Bytes_sent Traffic to and from the server .

Com_* The command the server is executing .

Created_* Temporary tables and files created during the query execution period .

Handler_* Storage engine operation .

Select_* Different types of join execution plans .


copyright notice
author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/02/202202041646278649.html

Random recommended