Category: MySQL

  • 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 # #…