XAMPP MySQL fails to start: ‘InnoDB’ ENGINE failed
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
Home »
Database
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… Read More »Get all databases size of an instance/server in MB or GB (Human readable format)
MySQL wait_timeout and sleep connections.
For cases where an application fails to close a connection it is no longer using,… Read More »MySQL wait_timeout and sleep connections.
Auto start MySQL on Mac startup
If enabling “Automatically Start MySQL Server on Startup” does not work then doing below process… Read More »Auto start MySQL on Mac startup
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)