At Facebook, we have upgraded most of MySQL database tiers
to 5.6, except very few tiers that have a special requirement --
very fast single threaded replication speed.
As Oli mentioned, single threaded performance is
worse in 5.6. The regression is actually not visible in most
cases. For remote clients, the performance regression is almost
negligible because network latency is longer than 5.1->5.6
overhead. If clients are running locally but MySQL server is disk
i/o bound, the overhead is negligible too because disk i/o
latency is much longer than 5.1->5.6 overhead.
But the regression is obvious when clients run locally and
queries are CPU bound. The most well known local client program
for MySQL is SQL Thread (Replication Thread). Yes, 5.6 has a
slower replication performance problem, if SQL thread is …
On Tuesday 17th December, we’ll be presenting a webinar on the
latest developments for MySQL Fabric (a framework for managing
pools of MySQL server – together with 2 applications: automated
sharding and High Availablity). As always, the webinar is free
and you should register here.
This is your opportunity to hear the details directly from the engineering team and put your questions to them.
This session will present MySQL Fabric and help you understand how you will be able to leverage it to address your scaling needs:
- Architecture for performance of a sharded deployment
- Management of MySQL server farms via MySQL Fabric
- MySQL Fabric as a tool for …
In the MySQL team @ Oracle, we’ve been discussing changing the default values for MySQL replication so that they are safer to use.
Specifically:
| Setting | Current Value | Proposed New Value |
| sync_binlog | 0 | 1 |
| master-info-repository | FILE | TABLE |
| … |
In my last post, a tale of two MySQL upgrades, a few folks asked if I would outline the process we used to upgrade, and what kind of downtime we had.
Well, the processes were different for each upgrade, so I will tackle them in separate blog posts. The first step was to upgrade all our MySQL 5.1 machines to MariaDB 5.5. As mentioned in the previous post, MariaDBs superior performance for subqueries is why we switched and we switched back to MySQL for 5.6 to take full advantage of the performance_schema.
It is not difficult to blog about our procedure, as we have documentation on each process. My first tip would be to do that in your own environment. This also enables other folks to help, even if they are sysadmins and not normally DBAs. You may notice the steps contain items that might be obvious to someone who has done maintenance before we try to …
[Read more]If the performance of your MySQL servers is important to you, performance tuning is key.
In the 4-day MySQL Performance Tuning course, you learn to analyze and optimize the performance of the MySQL Database, using the tools necessary for monitoring, evaluating and tuning.
You can take this course as a:
- Training-on-Demand event: Start training within 24 hours of registration and take this training at your own pace.
- Live-Virtual event: Attend a live event from your own desk - no travel required. You can choose from a selection of events already on the schedule.
- In-Class event: Travel to an education center to take this training. Below is a selection of the events already on the schedule. …
I clicked around for a few moments but didn’t immediately see a license mentioned for the MariaDB knowledgebase. As far as I know, the MySQL documentation is not licensed in a way that would allow copying or derivative works, but at least some of the MariaDB Knowledge Base seems to be pretty similar to the corresponding MySQL documentation. See for example LOAD DATA LOCAL INFILE: MariaDB, MySQL.
Oracle’s MySQL documentation has a licensing notice that states:
You may create a printed copy of this documentation solely for your own personal use. Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. You shall not publish or …
[Read more]I clicked around for a few moments but didn’t immediately see a license mentioned for the MariaDB knowledgebase. As far as I know, the MySQL documentation is not licensed in a way that would allow copying or derivative works, but at least some of the MariaDB Knowledge Base seems to be pretty similar to the corresponding MySQL documentation. See for example LOAD DATA LOCAL INFILE: MariaDB, MySQL. Oracle’s MySQL documentation has a licensing notice that states:
Dear MySQL users,
MySQL Connector/Net 6.8.2, a new version of the all-managed .NET driver for MySQL has been released. This is a RC release for 6.8.x and it's not recommended for production environments.
It is appropriate for use with MySQL server versions 5.0-5.6
It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)
The 6.8.2 version of MySQL Connector/Net has support for Entity Framework 6.0
The release is available to download at http://dev.mysql.com/downloads/connector/net/#downloads
…
[Read more]Taxonomy upgrade extras: mysqlperformancePerformance Tuningqueryquery tuningtuningMySQL single query performance - the truth!
As suggested by morgo I did a little test for the same query and the same data-set mentioned in Impact of column types on MySQL JOIN performance but looking into an other dimension: the time (aka MySQL versions).
…[Read more]