Modifying the default options for the docker (podman) MySQL server is essential. The default MySQL options are too conservative and even for simple (automation?) tests…
Tag: MySQL
docker mysql – Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root!
Pulling the official MySQL image from the docker registry https://hub.docker.com/r/mysql/mysql-server to start a MySQL instance with your configuration file (and MySQL binary files). Adding the…
MariaDB/MySQL replication error – Error during XID COMMIT: failed to update GTID state in mysql.gtid_slave_pos
When in aggressive parallel mode MariaDB/MySQL replication could fail with: This table is used for tracking the replication process and you might probably just do:…
The impact of enabling MySQL sync_binlog – really high disk IO
If you enable this feature in your MySQL you could increase your disk IO time and write by 8-10x times. Generally, this feature could save…
Upgrade MySQL 5.6 to 5.7 what problems to expect with old my.cnf configuration file
Finally, we do not have any more MySQL 5.6 servers. We upgraded our last part of the system with MySQL 5.6 to 5.7. In our…
mysql – Error ‘Your password does not satisfy the current policy requirements’ or zero length mysql password
We got this error when granting permissions for one of our new slave server (it could be for an ordinary MySQL server, too): It appeared…
mysql – Error ‘Column count of mysql.user is wrong. Expected 45, found 43. The table is probably corrupted’ on query.
If you upgraded your MySQL server (from 5.6 to 5.7 or above) or imported a MySQL dump SQL file from older version than your current…
Replication hangs with Relay_Master_Log_File mysql-bin.999999 -wrong variables in mariadb (MySQL) show slave status
Several days after another .999999 hang out – mariadb (MySQL) stopped flushing relay-bin log after mysqld-relay-bin.999999, the monitoring of one of the slaves got critical…
mysql slave requested master to start replication from position greater than the file size
If you happen to reset your master mysql server without shutting down the mysql process (probably because of your super collocation cut the power!!!) you…
Review of netdata graphs – nginx, php-fpm, mysql, memcached, redis, mail (postfix)
Here we show what to expect from the netdata graphics when using it in a web server. So we included here only the specific graphs…