Mysql
Articles in this category.
- Back up and restore a MySQL database in a Docker container — Dump and reload a MySQL database running in a Docker container with mysqldump and mysql, and inspect the container network and published ports.
- Calculating the InnoDB buffer pool hit ratio — Calculate the InnoDB buffer pool hit ratio from the status counters, and set the buffer pool size.
- Checking and changing character sets and collations in MySQL — MySQL commands to show the character sets of the server, the session and the databases, and to change the default of a database.
- Finding InnoDB lock waits and the blocking transaction — MySQL query that lists InnoDB transactions waiting for a lock and the transaction blocking them.
- Install MariaDB on AlmaLinux and move the data directory — Install MariaDB with dnf, secure the installation, move datadir to another volume and adjust the server and client options.
- MySQL and MariaDB administration cheat sheet — Common commands to manage the service, configuration, logs, sizes, users and privileges of MySQL or MariaDB.
- MySQL: InnoDB statistics tables not found after an upgrade — Recreate the InnoDB statistics and replication system tables when MySQL reports them as not found after an upgrade.
- MySQL server does not start on CentOS — Diagnostic steps when a MySQL server installed on CentOS does not load its database: services, logs, data directory and error log.
- MySQL: size of each database — List the size of each MySQL database in MB, from information_schema.
- Reset the MySQL root password on CentOS — Reset the MySQL root password by starting the server without its grant tables, then restart it normally.
- Resetting the root password on older MySQL versions — Procedure to reset the MySQL root password on version 5.6 and earlier using --skip-grant-tables, only on a server you administer.