Some times MySQL fails to start/restart with an error like “Plugin ‘InnoDB’ registration as a… Read More »XAMPP MySQL fails to start: ‘InnoDB’ ENGINE failed
To List all databases with its size in MB or GB, below command can be… Read More »Get all databases size of an instance/server in MB or GB (Human readable format)
For cases where an application fails to close a connection it is no longer using,… Read More »MySQL wait_timeout and sleep connections.
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… Read More »Fix Mysql error – 2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)