mysql 配置
最大连接数
show variables like ‘max_connections’
服务器响应最大连接数值
show global status like ‘Max_used_connections’;
查询 正在执行的事务:
SELECT * FROM information_schema.INNODB_TRX
查看正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
查看等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
查看等待时间
show global variables like ‘wait_timeout’;
查看连接
show status like ‘Threads%’;
Variable_name Value
Threads_cached 0 ##mysql管理的线程池中还有多少可以被复用的资源
Threads_connected 152 ##打开的连接数
Threads_created 550 ##表示创建过的线程数,如果发现Threads_created值过大的话,表明MySQL服务器一直在创建线程,这也是比较 耗资源,可以适当增加配置文件中thread_cache_size值,查询服务器
Threads_running 1 ##激活的连接数,这个数值一般远低于connected数值,准确的来说,Threads_running是代表当前并发数
show global variables like ‘wait_timeout’;
修改测试数据库
show variables like ‘max_connections’;
show global status like ‘Max_used_connections’;
set global max_connections=1000;
SELECT * FROM information_schema.INNODB_TRX;
show global variables like ‘wait_timeout’;
show status like ‘Threads%’;
show global status like’thread_cache_size’;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
show global variables like ‘thread_cache_size’;
set global thread_cache_size = 300;
不定期更新电脑里的文档~。