How to display the size of all MySQL tables using the command line
Background Issue the following command if you want to see in Megabytes the size of all MySQL tables from the command line: SELECT table_name AS
Background Issue the following command if you want to see in Megabytes the size of all MySQL tables from the command line: SELECT table_name AS
Background Under certain circumstances you might want to trash all the databases you have on a server. This article explains how to do it. Please
Background Having a broken MySQL / MariaDB database is no fun. Broken tables can also lead to half complete backups really compounding the situation and
Background If you have a server with sufficient RAM but you are running out of MySQL connections, you might want to look at two easy
Whilst trying to install or use PHPMyAdmin, you might encounter the following errors: mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] mysqli_real_connect():
Symptoms You’re looking at a database table in PHPStorm but all the records are not showing. The only clue you have is the words 930.44
Port Number The port number for MySQL is TCP port 3306. See where it’s listening How can you see if it’s listening on more than
Backing Up To backup a MySQL database from the command line, use the mysqldump command and pip the output to a file. For example: mysqldump
Background You have some sticky queries but you can’t see what’s happening. On certain website actions pages are just slow and you fully suspect the
You might encounter a situation (e.g. on AWS) where you have a new CentOS 7 server, but an old version of MariaDB 5.5 on the