Common commands for viewing mysql status in CentOS
Recently, mysql on the server has some strange issues. Unfortunately, I am not a professional dba. To learn more about mysql, check the basic mysql status commands first.
Command: show status;
Command: show status like '% variable % ';
Aborted_clients the number of dropped connections because the client does not properly close the connection.
The number of times that the MySQL server failed to connect to Aborted_connects.
The number of times that Connections attempted to connect to the MySQL server.
Created_tmp_tables: Number of implicit temporary tables created when the statement is executed.
The number of Delayed_insert_threads threads that are being inserted to the processor.
Number of rows written by Delayed_writes Using insert delayed.
The number of rows in which Delayed_errors writes data using insert delayed (which may duplicate key values.
The number of times Flush_commands executes the FLUSH command.
Number of rows deleted from a table in the Handler_delete request.
Number of times the Handler_read_first request reads the first row of the table.
Handler_read_key the number requested is based on the key-read row.
The number of times the Handler_read_next request reads a row based on a key.
The number of times the Handler_read_rnd request reads a row based on a fixed position.
The number of times Handler_update requests to update a row in the table.
The number of times a Handler_write request inserts a row into the table.
Number of Key_blocks_used Blocks Used for keyword cache.
Number of Key_read_requests requests that read a key value from the cache.
The number of times that Key_reads reads a key value from the disk physically.
Number of times that Key_write_requests requests write a key block to the cache.
Number of times that Key_writes physically writes a key-Value block to a disk.
The maximum number of connections simultaneously used by Max_used_connections.
Not_flushed_key_blocks has been changed in the key cache but has not been cleared to the disk.
The number of rows that Not_flushed_delayed_rows is waiting to write in the insert delay queue.
Number of open tables in Open_tables.
The number of open files in Open_files.
Number of open streams in Open_streams (mainly used for log recording)
The number of open tables in Opened_tables.
The number of queries sent by Questions to the server.
Slow_queries takes more than long_query_time.
The number of connections currently opened by Threads_connected.
Threads_running: Number of threads not sleeping.
How many seconds does the Uptime server work.