MySQL show status command details

Time:2021-9-27

Show status server status item introduction

Status name Scope explicate
Aborted_clients Global The number of connections interrupted because the client terminated because the client did not close the connection properly
Aborted_connects Global The number of failed connections attempting to connect to the MySQL server
Compression Session Only compression protocol is enabled between client and server
Created_tmp_disk_tables Both The number of temporary tables automatically created on the hard disk when the server executes statements
Created_tmp_files Global Mysqld number of temporary files that have been created
Flush_commands Global The number of flush statements executed
Handler_rollback Both Number of internal rollback statements
Innodb_buffer_pool_pages_dirty Global Current dirty pages
Innodb_buffer_pool_pages_data Global Number of pages containing data (dirty or clean)
Innodb_buffer_pool_pages_flushed Global Number of buffer pool pages required to be emptied
Innodb_buffer_pool_pages_free Global Number of empty pages
Innodb_buffer_pool_pages_total Global Total buffer pool size (pages)
Innodb_buffer_pool_write_requests Global Number of writes to InnoDB buffer pool
Innodb_data_fsyncs Global Fsync() operand
Innodb_data_pending_fsyncs Global The number of fsync() operations currently pending
Innodb_data_pending_writes Global Current number of pending writes
Innodb_data_pending_reads Global Current pending readings
Innodb_data_reads Global Total number of data reads
Innodb_data_writes Global Total number of data writes
Innodb_log_write_requests Global Number of log write requests
Innodb_os_log_written Global Number of bytes written to the log file
Innodb_row_lock_current_waits Global Number of rows currently waiting to be locked
Innodb_row_lock_time Global Total time spent locking rows, in MS
Innodb_rows_deleted Global Number of rows deleted from InnoDB table
Innodb_rows_inserted Global Number of rows inserted into InnoDB table
Innodb_rows_updated Global Number of rows updated in InnoDB table
Max_used_connections Global The maximum number of simultaneous connections that have been used since the server was started
Qcache_hits Global The number of times the query cache was accessed
Slave_heartbeat_period Global Heartbeat interval for replication
Slave_received_heartbeats Global Heartbeat from server

This work adoptsCC agreement, reprint must indicate the author and the link to this article

Flying Elephant

Recommended Today

The selector returned by ngrx store createselector performs one-step debugging of fetching logic

Test source code: import { Component } from ‘@angular/core’; import { createSelector } from ‘@ngrx/store’; export interface State { counter1: number; counter2: number; } export const selectCounter1 = (state: State) => state.counter1; export const selectCounter2 = (state: State) => state.counter2; export const selectTotal = createSelector( selectCounter1, selectCounter2, (counter1, counter2) => counter1 + counter2 ); // […]