Igor-Lopes/mysql-util.md

## mysql-util.md

      
    Raw
  

              mysql-util.md
            
          
    MySQL conf file location:

/etc/my.cnf
Change Max connections parameters:

max_connections = 500
Print on terminal value of max_connections:

echo "show variables like 'max_connections';" | mysql -u root -p
SQL query lists database name and sizes

SELECT table_schema "DB Name", sum(data_length + index_length)/ 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;