MySQL Troubleshooting
1. Not able to start the database.
-MySQL configuration file /etc/my.cnf is present and have all valid configuration.
-System has enough free resources to cater MySQL.
-Filesystems are not in READ ONLY mode.
-Check and fix the errors reported in /var/log/mysqld.log
2. MySQL is running, But users are unable to connect remotely.
-Verify you are connected to correct port of the database.
-Check firewall status on MySQL connectivity.
-Verify you are using correct user/password.
3. Users are unable to create new connections after a certain limit.
-Verify you are not hitting "max_connections limits" if yes, you need to increase it as per requirement.
show status like '%onn%';
show variables like "max_connections";
set global max_connections = 200;
No comments:
Post a Comment