Home >Database >Mysql Tutorial >如何查看mysql连接相关参数_MySQL
如何查看mysql连接相关参数_MySQL
- WBOYOriginal
- 2016-06-01 13:36:301491browse
bitsCN.com
如何查看mysql连接相关参数
1、查看当前所有连接的详细资料:
./mysqladmin -uadmin -p -h10.140.1.1 processlist
2、只查看当前连接数(Threads就是连接数.):
./mysqladmin -uadmin -p -h10.140.1.1 status
3、如何知道当前MySQL设置的并发连接数是多少（查看max_connections）：
mysql> show variables;
如何更改MySQL最大并发连接数量：在my.cnf中[mysqld]下添加：
“set-variable=max_connections=1000”
之后重启MySQL服务即可.
bitsCN.comStatement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql merge分表操作_MySQLNext article：How to Create/Drop Database, Table_MySQL