How to allocate more RAM to MariaDB/MySQL on a shared server and increase the connection count
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
Databases
PHPMyAdmin error requested authentication method unknown to the client [caching_sha2_password]
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():
Seeing 930.44 kB (204.8 kB loaded when loading a large database table in PHPStorm
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
What is the listen port network interface for MySQL and how can you change it?
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
How to backup and restore a MySQL database from the command line
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
How to log queries in real time using MariaDB/MySQL
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
How to upgrade for MariaDB 5.5 to 10.1 and then to 10.3
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
MySQL stops working: InnoDB: Fatal error: cannot allocate memory for the buffer pool
Background A MySQL server stop working. You’re confused as this is a new Virtualmin installation and everything went smooth. You start troubleshooting: # service mariadb
Backups Failing: …tables used by Event Scheduler were found damaged at server start (1577)
On your MySQL Server doing backups you get: Backups Failing: Dumping MySQL database database_name …. dump failed! mysqldump: Couldn’t execute ‘show events’: Cannot proceed because
Communication link failure: 1153 Got a packet bigger than ‘max_allowed_packet’ bytes (SQL: update…
Whilst updating a Trix Editor field box with many images, you get the following error: [2019-01-18 10:12:07] local.ERROR: SQLSTATE[08S01]: Communication link failure: 1153 Got a