JZTXT

mysql 常用命令

发布时间 2023-07-26 14:12:18作者: chenzechao
-- 查看多个参数
SHOW VARIABLES where  Variable_name in('max_connections','version','slow_query_log','log_output');

-- 查看多个状态
show global status where Variable_name in('Memory_used','uptime','max_connections','Threads_connected','Bytes_received','Bytes_sent','Com_rollback','Com_commit','innodb_buffer_pool_reads','innodb_buffer_pool_read_requests','innodb_buffer_pool_pages_free','innodb_buffer_pool_pages_total','innodb_buffer_pool_pages_dirty','innodb_data_written','innodb_data_read','innodb_buffer_pool_write_requests');