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. …

[…] https://winashwin.wordpress.com/2012/08/28/mysql-search/ […]

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 …

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

…

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).

This week we discuss test data sets. Ear Candy is errata from Episode 165 on Galera Cluster, and At the Movies is "Runaway Complexity in Big Data"

Test Data Sets
Episode 81, where we talked about different benchmark tools
Sysbench - general version
Percona's sysbench tests

Factors: # tables, concurrency, data set size

Episode 143, where we did an ear candy featuring Morgan Tocker's article on estimating MySQL's working set with INFORMATION_SCHEMA

…

In todays computing environments, the use of cloud based technologies--both public and private--along with various popular devops automation tools, are essential to effective and efficient IT operations.

MySQL Enterprise Monitor (MEM) 3 integrates very well into these modern operations environments. To demonstrate that point, I've created two short video demos that walk you through some helpful examples.

The first one walks through how you can monitor MySQL instances in the public cloud, using Amazon RDS as an example provider:


The second one walks through some examples of how you can integrate MEM 3 with your private cloud and devops automation tools:


You can find additional video demos, and more information about MEM 3  …

We're very pleased to announce that MySQL Connect will next year take place from Monday September 29 to Thursday October 2, 2014, in San Francisco. And there will be a welcome reception on Sunday September 28 evening.

During the past 2 years we’ve run MySQL Connect during the weekend prior to Oracle OpenWorld, and we repeatedly got feedback that avoiding the weekend would be better. Well, this is now done! MySQL Connect will be fully aligned with Oracle OpenWorld. This will also enable us to have more room to schedule sessions across the 4 days and to be better integrated within Oracle OpenWorld overall, which was also part of the feedback we’ve got.

We will provide more details down the road but wanted to make sure you could save the dates and make your plans accordingly.

The Call for Papers will likely open in March, so start thinking about your topics now in order to submit them swiftly when it …

Recently I was working with a customer where we noticed that Seconds_Behind_Master fluctuating from an expected value of 0 seconds behind to a fairly high six figure value.  The servers were configured in a master-master relationship and used 5 figure server_id values, and we had just migrated this cluster from one data centre to another by re-pointing masters.  Seeing large fluctuations in Seconds_Behind_Master can often be explained by long running queries being processed by the SQL_THREAD, however SHOW PROCESSLIST indicated that there were no long running replication events, and we had no other indication that the server was lagging  due to resource constraints — CPU, disk, and memory were under-utilized.

We then moved our investigation to manual review of the binary log where events appeared normal (5 digit server_id values) until every once in a while we would see a rash of server_id 21 events.. Wait, what?  I …