Some times MySQL fails to start/restart with an error like “Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed” The simple solution to fix is to…
Get all databases size of an instance/server in MB or GB (Human readable format)
To List all databases with its size in MB or GB, below command can be used to get the information. Below is the command to…
MySQL wait_timeout and sleep connections.
For cases where an application fails to close a connection it is no longer using, a low wait_timeout value can help to avoid hitting max_connections…
Auto start MySQL on Mac startup
If enabling “Automatically Start MySQL Server on Startup” does not work then doing below process will fix it. Open terminal/command line interface (CLI) and run…
Fix Mysql error – 2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)
Sometimes opening phpMyAdmin can give below error due to incorrect setting done somehow. “2002 – The server is not responding (or the local MySQL server’s socket is…