Technolize Your Future

Better Your Future with Tech Knowledge

Category

MySQL

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 list all databases with its size in MB. SELECT table_schema AS “Database name”, SUM(data_length +… Continue Reading →

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 simply due to sleeping idle connections that are not in a transaction and will not be… Continue Reading →

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 below commands. run “sudo vi /Library/LaunchDaemons/com.mysql.mysql.plist” and add below code and save the file. If… Continue Reading →

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 not correctly configured)“ To FIx this run mysqld-debug.exe and then check phpmyadmin. mysqld-debug.exe path in… Continue Reading →

© 2019 Technolize Your Future — Powered by WordPress

Theme by Anders NorenUp ↑