(Aaron Brown) Have you ever wanted to get a list of indexes and their columns for all tables in a MySQL database without having to iterate over SHOW INDEXES FROM ‘[table]‘? Here are a couple ways…

(Thomas) Official MySQL documentation provides information that using regular expressions is “powerful way of specifying a pattern for a complex search”. Is it really such a powerful way of filtering and should be used, or is it a solution that should be avoided? As it usually happens in real life,

(Rob Gravelle) If you’re hosting your database(s) on a Windows Operating System, you may want to consider performing batch jobs using PowerShell, rather than DOS or Wsh scripts. It’s an interactive shell and scripting tool from Microsoft that combines the capabilities of the MS-DOS Command Prompt,

(wubayou) Today’s MySQL database tutorial will cover MySQL data and table types. Both of these topics are essential to anyone jumping into the world of the MySQL and give you a nice little foundation to build on as you hone your skills.

(Shinguz) Because we are a bit short off disk space on one of our servers I had the idea to try out the MySQL feature Data Compression for InnoDB. This feature is useful if you have tables with VARCHAR, BLOB or TEXT attributes.

(Rob Gravelle) From performing database backups and restores, rollbacks, sanity checks, and even the occasional report generation, there are a lot of tasks that database administrators (DBAs) have to fulfill on a regular basis.

(Shinguz) Because we are a bit short off disk space on one of our servers I had the idea to try out the MySQL feature Data Compression for InnoDB. This feature is useful if you have tables with VARCHAR, BLOB or TEXT attributes.

(Peter Zaitsev) Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the period for which server has to be made read only is very short, just few seconds, yet the impact of FLUSH TABLES WITH READ LOCK

(Michael McLaughlin) While working through prepared statements in MySQL, there was an interesting regular expression question raised. A student wanted to know how to address the following error message:

(Peter Zaitsev) Many people use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most cases it works, but did you know there are some cases when you can get table entirely missing from the backup if you use this technique?