(Justin Swanhart) MySQL always tries to make toast of my good ideas. This is the only time is succeeds in making toast (see bug #2).

(Todd Farmer) A while back, I wrote a blog post explaining how PERFORMANCE_SCHEMA improvements in MySQL Server 5.7 provides new visibility into the SSL/TLS status of each running client configuration.

(Frederic Descamps) In this post, the first one of a Maxscale series, I describe how to use MariaDB’s MaxScale and MySQL-utilities with MySQL Asynchronous replication.

(Rik Prohaska) The “mysql_real_connect” function is used by MySQL clients, including multi-threaded clients, to connect to a MySQL server. The “mysql_real_connect” function is allowed to be run by concurrent threads without application level serialization.

(Justin Swanhart) There is often a need to run queries in the background in MySQL. This generally is accomplished using a message queue (like gearman), or by using extensions to a client (PHP has such extensions) or by using MariaDB’s native async query interface (C client only I think).

(Frederic Descamps) MySQL connection using SSLIn this blog post, we’ll discuss how we can determine if a MySQL connection is using SSL.

(Manyi Lu) At a recent optimizer webinar, I talked about MySQL introducing a new style for hints, and that MySQL 5.7 also added support for more hints, see Sergey Glukhov’s blog.

(Joao Osorio) On an earlier post I wrote about real time query monitoring on MySQL with a third party tool and without one. The script is useful as it works with MySQL 5.5 and later.

(Marcelo Altmann) If you use a storage engine that supports transactions, you probably have faced or heard of deadlock’s.

(Peter Sylvester and Valerie Parham-Thompson) Introduced in version 10.1.3 (and with substantial changes in 10.1.4), the MariaDB data encryption at rest feature allows for transparent encryption at the tablespace level for various storage engines, including InnoDB and Aria.