MySQL Basic parameter query

[Email protected]~]# mysqladmin-f--socket=/opt/mysql.sock-uroot-p********* status; uptime:1296722 # MySQL run time (s) threads:30 #mysql连接数Questions: 97170647 #客户端请求mysql总的次数Slow queri        es:8787 #慢查询的次数Opens: 3451 #数据库打开表的次数Flush tables:1 #执行flush table number of open tables:2917 #现在打开表的个数Queries per second avg:74.935 #mysql平均每秒请求的个数 [[email protected] ~]#

Work in combat: fault handling: MySQL reported the number of connections over, to solve the idea 1. View the command above the current number of connections 2. Modify the my.cnf max-connection = n parameter (restart effective [mysqld] module) 3. Temporary effect in (mysql> set GLO BAL max_connections=n) (temporary entry into force) 4. All two changes will not be effected directly after the restart.

• 
  

This article is from the "Brick Blog" blog, please be sure to keep this source http://wsxxsl.blog.51cto.com/9085838/1892773

MySQL Basic parameter query