MySQL Problem series

1. Source code MySQL start and close commands

Start

/data/app/mysql/bin/mysqld_safe &

Shut down

/data/app/mysql/bin/mysqladmin-uroot-p shutdown

2. Change the maximum number of MySQL connections

Go to MySQL install directory open mysql config file my.ini or my.cnf find max_connections=100 Modify for max_connections=1000 service to restart MySQL can

3. View the number of MySQL connections

(Threads is the current number of connections)

Mysqladmin-u root-p Status
Enter Password:
uptime:72562 threads:6 questions:177132 Slow queries:0 opens:62 Flush tables:1 Open tables:55 queries per se Cond avg:2.441

View Connection Details command

mysqladmin-uroot-pts123456 processlist