By my count MySQL 5.7 added over 150 new features, and some of my favourite ones are based on community ideas and contributions:

1. Statement Timeout (contributed by Davi Arnaut)
2. Disabled Storage Engines (suggested by the community)
3. MySQL Command Line client Ctrl+C support fixed (bug reported by the community)
4. Barracuda + Dynamic row format enabled by default (change made to better support WordPress and …

In our previous post, we showed you how to interpret reports generated by pt-query-digest. Today we’d like to cover some of its more advanced features, as it is a pretty extensive tool with lots of functionality. We’ll also show you what information you should be looking for, and how to derive conclusions based on that data. 

This is the eleventh installment in the ‘Become a MySQL DBA’ blog series. Our previous posts in the DBA series include Analyzing SQL Workload with pt-query-digest, Query Tuning Process, …

The Sakila sample database was created almost 10 years ago, as a sample set of data for MySQL courses and examples.

The database was developed by MySQL employees, with substantial contributions form the community.

Recently, the database was updated to use some of the features in MySQL 5.7. As a result, we had two sets of samples, one to use with MySQL 5.0+, and one that only loads with MySQL 5.7.

I filed a feature request, offering a patch to use conditional schema and data changes, which was incorporated very quickly into the official release.

The current release, available within the …

Today, at the Strata Conference in Santa Clara, Calpont Corporation announced that it is changing its name to InfiniDB, Inc., and that it has raised another $7.5M in funding. So “What’s in a name?” you ask?  For InfiniDB, a lot, actually. Since its introduction in 2010, the InfiniDB database has delivered exceptional scaling and speed, […]

All ad earnings on heidisql.com from September 01 up to the rest of the year, namely December 31 2015, will be donated to the refugees help operation Aktion Deutschland hilft!

This way I want to support the huge help operation for the refugees of the Syrian Civil War.

This Log Buffer Edition carries on with the weekly culling of blog posts from Oracle, SQL Server and MySQL.

Oracle:

Most people are now aware that in 12c, a VARCHAR2 has been extended from a maximum size of 4000 to 32767 bytes.

FDMEE is offered as the full-featured successor to Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications (ERP Integrator) and Oracle Hyperion Financial Data Quality Management (FDM).

Cybersecurity is Hot! In fact, so is the weather here in California at this moment.

How do you monitor …

MySQL sys version 1.5.0 has just been released.

It has significant contributions from both external contributors (thank you Daniël and Shlomi) and internal (thank you Jesper and Morgan). Jesper particularly made many significant improvements in this release.

Here’s a full summary of the changes:

Improvements

• The `format_bytes` function now shows no decimal places when outputting a simple bytes value
• The `processlist`/`x$processlist` views where improved, changes include:
  • The `pid` and `program_name` of the connection are shown, if set within the `performance_schema.session_connect_attrs` table (Contributed by Daniël van Eeden)
  • Issue #50 – The current statement progress is reported via …

Sometimes it's useful to have a set of data prepared to be used on a fresh MySQL install for testing purposes. Or you might be preparing some training or workshop and want to prepare examples with fake information. For MySQL there are some choices available:

Employees Sample Database: provides a combination of a large base of data (approximately 160MB) spread over six separate tables and

I don’t understand how this works. Can an EC2 instance manage a MySQL server installation on an RDS instance? RDS don’t even provide an option to stop/start the mysql service. RDS provides a very limited option to manage the MySQL server. Using an EC2 instance is more like tunneling into the RDS.

The home of Eurovision and Euroradio choses Severalnines to tune its MySQL databases

Stockholm, Sweden and anywhere else in the world – Severalnines, the provider of database infrastructure management software, recently announced its latest customer, European Broadcasting Union (EBU), a premium media distributor of live sports, culture, news and entertainment content. The Swedish company won the new deal in the same year as heartthrob compatriot Måns Zelmerlöw’s rendition of “Heroes” won the EBU’s flagship programme, the Eurovision Song Contest, watched by 200 million viewers.

The EBU is the world’s leading alliance of public service media with 73 Members in 56 countries across Europe and beyond. The EBU’s platform provides content creators in the broadcasting industry with high-quality …