Author - Sveta Smirnova

MySQL is crashing: a support engineer’s point of view

In MySQL QA Episode #12, “MySQL is Crashing, now what?,” Roel demonstrated how to collect crash-related information that will help Percona discover what the issue is that you are experiencing, and fix it.
As a Support Engineer I (Sveta) am very happy to see this post – but as a person who better understands writing than recording – […]

Read more

Why base64-output=DECODE-ROWS does not print row events in MySQL binary logs

MySQL binary logs

Lately, I saw many cases when users specified the option
–base64-output=DECODE-ROWS  to print out a statement representation of row events in MySQL binary logs just to get nothing. Reason for this is obvious: option
–base64-output=DECODE-ROWS  does not convert row events into its string representation, this is the job of the option
— verbose. But […]

Read more

Playing with Percona XtraDB Cluster in Docker

Like any good, thus lazy, engineer I don’t like to start things manually. Creating directories, configuration files, specify paths, ports via command line is too boring. I wrote already how I survive in case when I need to start MySQL server (MySQL Sandbox which can be used for the same purpose.
But what to do […]

Read more

Optimizer hints in MySQL 5.7.7 – The missed manual

In version MySQL 5.7.7 Oracle presented a new promising feature: optimizer hints. However it did not publish any documentation about the hints. The only note which I found in the user manual about the hints is:

It is now possible to provide hints to the optimizer by including /*+ … */ comments following the SELECT, […]

Read more