Problems with MySQL table optimisation
Example: mysql> optimize table wp_actionscheduler_actions; +——————————————-+———-+———-+——————————————————————-+ | Table
Databases
Massive amounts of disk space consumed by MySQL and Mariadb binlog files
Background You might find on a MySQL 8.x or MariaDB 10.4 server that suddenly disk space just evaporates. After using ncdu you see the problem
How to use ‘SHOW PROCESSLIST’ and ‘SHOW FULL PROCESSLUIST’ using MySQL on the command line
To see what’s happening on a busy MySQL server, use this: mysql -uroot -e “show full processlist” If you want to do this continuously, try
What defines small medium large and huge on a Virtualmin MySQL installation?
Background When installing Virtualmin, the system will prompt for small, medium, large and huge. The question is how are these parameters defined? By examining the
MySQL Invalid default value for XXX datetime based field
Working servers suddenly start giving the error below when restoring a MySQL database that contains datetime fields with 0000-00-00 defaults: user@server:/tmp# mysql -uuser -ppassword database_name
Beginning MongoDB
MongoDB is a weird little database but seems really popular and works nicely with low overhead Javascript applications. This article highlights a few key pointers
Whilst restoring a MariaDB Backup from one Virtualmin server to another, MySQL create and grant errors
Background On a legacy server with an older version of MariaDB, restoring to a newer Virtualmin server that run MySQL 8 might be problematic. The
How to handle [ERROR] mysqldump: Couldn’t execute ‘show create table `wp_options`’: Table ‘./site_wordpress/wp_options’ is marked as crashed and should be repaired (145)
When performing certain MySQL backup operations you might end up with the following message: [ERROR] mysqldump: Couldn’t execute ‘show create table `wp_options`’: Table ‘./site_wordpress/wp_options’ is
After Ubuntu 18.04 to 20.04 upgrade, MySQL stops working with “Server upgrade in progress”
Background After upgrading from Ubuntu 18.04 to Ubuntu 20.04, MySQL isn’t working and systemctl status mysql.service show there are problems. You see this line lurking
How to test connectivity to a Microsoft SQL database using the Linux command line
Here are some useful commands when working with Microsoft SQL and Linux, specifically pertaining to the `sqlcmd` mssql-cli utility. Update 16 July 2021 It appears