While working on something unrelated, I came across the server status flags that are exposed to client connections by the client library. I have never used those flags myself, but as I understand they are meant to provide some context to applications and proxies which would otherwise have to do some fairly expensive things to obtain that information.

What stroke me as odd is that there is no way to see those flags from interactive sessions in the MySQL command-line client. Like applications or proxies, human beings need context, especially when multi-tasking and switching between multiple tabs or windows. That's precisely the reason why the command prompt in the mysql client can be customized via the …

Good news ! The MySQL & Friends Devroom has been accepted for Fosdem’s 2018 edition !

This event is a real success story for the MySQL ecosystem, the content, the speakers and the attendees are growing every year.

Fosden 2018’s edition will take place 3rd & 4th February in Brussels and our MySQL & Friends devroom will run on Sunday 4th. FOSDEM & MySQL is a love story started 18 years ago !

The committee selecting the content for our devroom is not yet created and if you want to be part of this experience, just send me an email (candidate at mysqlandfriends dot eu) before Oct 20th .

If you want to join the Committee you have to align with the following conditions:

– planning to be present at FOSDEM
– having a link with …

I periodically do MySQL Troubleshooting tutorials. Every time I run them I have a dilemma on how to make tutorials more interactive. I tried:

1. Just talk. But troubleshooting is about action, not about sitting and listening 
2. Put tasks on my own website which required a lot of coding, not related to the talk and tasks themselves.
3. Put tasks on VirtualBox image. Many attendees do not want to use flash drive or download big image from Internet.
4. Put tasks into Amazon EC2 instance. This is practically good option, but expensive.
5. Use machines, provided by tutorial organizers (conference or training center). This is, probably, the best option, but few do it.

I did not like any of these options as final solution. That's why for my last two tutorials I tried Stepik platform. This is how " …

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.

This week: a quick roundup of releases, a summary of my thoughts about Percona Live Europe 2017 Dublin, links to look at and upcoming appearances. Oracle OpenWorld happened in San Francisco this past week, and there were lots of MySQL talks there as well (and a good community reception). I have a bit on that as well (from afar).

Look for these updates on Planet MySQL.

Releases

• Red Hat Software Collections 3.0 Beta now has MariaDB 10.2.7, MongoDB …

It was expected for a long time…. here is the fix for bug #199 !!

The bug #199 submitted by PeterZ has been fixed in 8.0. Thank you to Zhang Simon for his contribution that inspired us to implement the fix.

Let’s have a look at the test case described in the bug report, I will reproduce it on MySQL 5.7.19 & MySQL 8.0.3.

The initial steps are exactly the same on both versions:

mysql> create table a(id int unsigned not null primary key auto_increment);
Query OK, 0 rows affected (0.17 sec)

mysql> show create table a\G
*************************** 1. row ***************************
       Table: a
Create Table: CREATE TABLE `a` (
  `id` int(10) unsigned NOT …

We are pleased to announce that MySQL Enterprise Monitor 3.4.4 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.

You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.

Important: MySQL Enterprise Monitor (MEM) 4.0 offers many significant improvements over MEM 3.4 and we highly recommend that you consider upgrading. More information on MEM 4.0 is available here:

• …

The Metrics Monitor of Percona Monitoring and Management 1.3.0 (PMM) provides graph descriptions to display more information about the monitored data without cluttering the interface.

Percona Monitoring and Management 1.3.0 is a free and open-source platform for managing and monitoring MySQL®, MariaDB® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL, MariaDB® and MongoDB servers to ensure that your data works as efficiently as possible.

Each dashboard graph in PMM contains a lot of information. Sometimes, it is not easy to understand what the plotted line represents. The metric labels and the plotted data are limited and have to account for the space they can use in dashboards. It is …

MySQL Cluster Manager 1.4.4 is now available for download from My Oracle Support.

What’s new?
With MCM 1.4.4 we continue to improve on MySQL Cluster Manager, specifically around:

• the collect logs command
• process status reporting
• process command execution in specific scenarios

More details
More details are available in the MCM 1.4.4 Release Notes.…