-
Check MySQL database size
This is an example on how to check mysql database size of cacti database. mysql> show databases; +——————–+ | Database | +——————–+ | information_schema | | cacti | | mysql | | test | +——————–+ 6 rows in set (0.00 sec) The the command below. mysql> SELECT table_schema cacti, sum( data_length + index_length ) /…
-
How to check the max_connections in MySQL database.
rpaco@choi:~$mysql -uroot -h localhost -p Enter Password: mypassword Type the command below. mysql> show variables like ‘max_connections’; +—————–+——-+ | Variable_name | Value | +—————–+——-+ | max_connections | 100 | +—————–+——-+ Set temporary values. This values will be reset when mysql service restart. mysql>set global max_connections = 200; To set it permanently. vi /etc/mysql/my.cnf # #…