This article is continuing the MySQL 5.7 Performance story, started from 1.6M QPS on MySQL 5.7 details post , then 1M QPS on mixed OLTP_RO with MySQL 5.7 article, and detailed story about why the Point-Selects performance is so critical (and why the 1M result published by MariaDB is not fair)..

The current story will be about Connect/sec (connect/disconnect) performance improvement in MySQL 5.7 - such kind of metric is very critical for any application which cannot use persistent connections all the …

Thanks to everyone who joined us for our recent live webinar on performing live database upgrades for MySQL Replication & Galera, led by Krzysztof Książek. The replay and slides to the webinar are now available to watch and read online via the links below.

During this live webinar, Krzysztof covered one of the most basic, but essential tasks of the DBA: minor and major database upgrades in production environments.

Watch the replay

Become a MySQL DBA: performing live database upgrades - webinar replay from Severalnines AB  

Read the slides

…

For a long time we’ve been dissatisfied with the fact that we had two separate tools to do the same thing: Top Processes and Top Queries rank processes and queries respectively by a metric of your choice. For example you may rank queries by frequency, or rank databases by total execution time. There’s a lot of shared functionality and at the same time there’s so much more we could do with the metrics we’re capturing from your systems.

Today we are releasing a new tool called Profiler to replace Top Queries and Top Processes, so now we have one tool to do the job of two. Simplifying is always a good thing.

If you are wondering what the Profiler can rank, you’ll be glad to see that not only we still rank Users, Databases, Hosts, Queries, Verbs, Tags and Processes, but we also added Tables, Network Sockets, MySQL Commands and MySQL Processlist Queries. And many more are coming soon of …

Support for storing and querying JSON within SQL is progressing for the ANSI/ISO SQL Standard, and for MySQL 5.7. I'll look at what's new, and do some comparisons.

The big picture

The standard document says

The SQL/JSON path language is a query language used by certain SQL operators (JSON_VALUE, JSON_QUERY, JSON_TABLE, and JSON_EXISTS, collectively known as the SQL/JSON query operators) to query JSON text.The SQL/JSON path language is not, strictly speaking, SQL, though it is embedded in these operators within SQL. Lexically and syntactically, the SQL/JSON path language adopts many features of ECMAScript, though it is neither a subset nor a superset of ECMAScript.The semantics of the SQL/JSON path language are primarily SQL semantics.

Here is a chart that shows the JSON-related data types and functions in the standard, and whether a particular DBMS has something with the same name and a similar functionality. …

In my last post playing with MySQL fabric here and here I used MySQL fabric version 1.4.1 and MySQL 5.6, i must say lot's of things have happened over the last 20 months! MySQL have released several new versions of MySQL Fabric and also a new version of the server with MySQL 5.7.

Current GA version of MySQL Fabric is 1.5.6 and there is also a MySQL Fabric 1.6.2 beta, both versions can be downloaded from here.
As I said earlier, lots of new things have happened, looks like focus has been on making it easier to work with MySQL Fabric but also making output from fabric commands much easier to understand. With latest version 1.6.2 (not …

I got some more questions on the new JSON data type and functions during our TechTours. And I like to summarize the answers in this blogpost.
Memory consumption The binary format of the JSON data type should consume more memory. But how much? I did a little test by comparing a freshly loaded 25,000 row dataset stored as JSON and stored as TEXT. Seven top level attributes per JSON document. Average JSON_DEPTH is 5.9 . Let's see:

mysql> DESC data_as_text;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | NO   | PRI | NULL    |       |
| doc   | text    | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> SELECT COUNT(*),AVG(JSON_LENGTH(doc)) FROM data_as_text;
+----------+-----------------------+ …

A gratitude list is one of my favorite ways to influence my mood. Here’s a gratitude list on Thanksgiving Day 2015 (United States) to express some of the reasons we are so fortunate at VividCortex to have great customers, employees, investors, advisors, friends, vendors, community, and more. This list will omit lots of things and people equally worthy of inclusion, but that’s the point–a gratitude list only makes you aware of how much larger than 26 the list really is.

Amazon Web Services, without whom VividCortex would have been much harder to get off the ground.

Bugsnag, which helps us diagnose many confusing problems our customers experience but we can’t reproduce.

Customers. All of them.

Dyn. A special customer who took a chance on us before we were a “safe” service to risk trying.

Employees, past, present, …

Landing on an enterprise with ongoing projects mean that servers are often handed to IT staff without complete knowledge of  what's inside. I've built a simple script, scraping from here and there, to gather a summary of relevant information. Once you've gained remote access to the MySQL instance, you can execute the queries to identify the following information regarding the target database

Introduction
In my last blog post, Internet of Things, Messaging and MySQL, I have showed how to start your own Internet of Things with Particle Photon board. That implementation is great, but requires constant internet (wi-fi) access as the Particle Photon board does not have any local storage. If you do not have a reliable network access (i.e. in some remote places) or need something really small to store your data you can now use Intel Edison. I’ve even install MySQL on Edison, which makes it the smallest (in size) MySQL server in the world! Other options include:

• Raspberry Pi (my colleague Roel installed …

Swedish database technology ensures intergalactic research data protected “to infinity and beyond” for scientists

Stockholm, Sweden and anywhere else in the world - Severalnines, the provider of database infrastructure management software, today announced its latest customer, the European Gravitational Observatory (EGO). Severalnines’ ClusterControl platform is used to manage and monitor the operations of some of EGO’s open source databases and help scientists to track, analyse and share data gathered from research on gravitational waves.  

EGO is one of the world’s leading research structures devoted to the study of gravitational waves. EGO hosts the Virgo experiment, a project involving about 300 scientists spread across 19 laboratories in France, Italy, Poland, the …