Introduction

The purpose of this test is to benchmark MySQL 5.6 performance on hardware with Haswell CPUs, SSDs and PCIe Flash storage devices.

Background

Software

• SysBench OLTP workload installed on the database machine
  
• MySQL 5.6.24 distribution from Percona
  
• jemalloc used for MySQL Server and Sysbench test client
  
• Charts are plotted using MySQL Performance Analyzer

Method

• Data and software on server was wiped out post every test run.
  
• Predefined number of tables - 16 or 64
  
• Predefined size of rows - 20M per table
  

Tests
Read Only
Read Write
Concurrencies vary from 1 to 512 with incremental increase
EXT4 vs XFS

…

You´re Invited to MySQL Community Reception at Oracle OpenWorld. You do not need to be an attendee of Oracle Open World. We want everyone who can make it to our celebration to attend!

Join the MySQL Team on Tuesday, October 27th, to celebrate the MySQL community. it starts at 7 PM at Jillian’s at Metreon, 175 4th Street, San Francisco, CA 94103. This is very near to Moscone Center and there is parking nearby.

OpenWorld attendees, members of local MySQL user groups, MySQL users in the Bay Area – you’re all invited to Oracle’s MySQL Community Reception.

Mingle with your peers, meet the MySQL engineers, and run into old friends from around the community. We are looking forward to see you there. This will be a special celebration and we want you there!!!

REGISTER NOW.
We are looking forward to see you …

I may only admit that #PerconaLive Conference becomes only better and better year to year. And I'm happy to be there and have an occasion to tell you all the latest news about MySQL 5.7 Performance as it for today..

And of course, if we're speaking about benchmarks, I'll not speak only about MySQL 5.7, I'll not miss either Percona Server 5.6 and MariaDB 10.1 ;-) -- hope to publish all these results later, over a time.. I've realized that I'm blogging less this year -- most of the time is going today to dig the performance problems we're hitting and looking for real solutions for them. Hope to get both fixed soon ;-) While during the conference, please, don't hesitate to ask questions and report your problems -- many persons from #MySQLTeam will be there, so be sure you'll be listened! And if you will don't miss their talks as well - this way you'll don't miss them for sure ;-)

Well, time to leave a sunny Paris..
…

MySQL Utilities 1.5 (1.5.6 GA, published on Friday, 18 Sep 2015)

Since there are a couple of changes in the shows where you can find MySQL team, find below the updated information (updates to blog published in July 2015 & on September 23) about shows where you can find either MySQL Community Team directly or MySQL team experts. New shows are marked with NEW! updates are appropriately marked in green. See the list below:

• October 2015: 
  • NEW! Ohio LinuxFest 2015, Columbus, Ohio, US (October 2-3, 2015) 
    • Find our talk given by David Stokes, the MySQL Community Manager on “ MySQL’s NoSQL” scheduled for October 3rd, 2015 @15:00-16:00 …

mycli is a new command line interface tool for MySQL. It features syntax highlighting and auto-completion of commands plus the ability edit commands with Emacs or VI.

So who could benefit from mycli? If you need prompting to complete commands, fat finger as you type, or just want to add some color highlights as you work with your MySQL server then try mycli.

You can even save save favorite queries. So if you have Python on your system and are looking for a new command line tool please take a look at mycli.

We are more than happy to announce that MySQL Community Team attends one of the biggest events focused (not only) to web professionals, WebExpo 2015!!! This is the first time MySQL attends this conference even when it's 8th edition of WebExpo in Czech!

The event will be hold this weekend, Sep 19-20, 2015 in Prague, Czech Republic. For the MySQL Community team there will be Morgan Tocker & Lenka Kasparova attending and staffing the MySQL booth. 

Do not miss Morgan's talk on "MySQL 5.7 + JSON" scheduled for Sunday, Sep 20, 2015 @ 12:00-12:40 in Divadlo ABC. 

Check the program at conference webpage & come to talk to us! 

Wednesday, September 16, 2015 12 PM EST / 4 PM GMT

Are you a Linux Admin who ‘also has’ MySQL DBA responsibilities but no DBA training? Do you wonder why databases are the problem children of all the software services you are responsible for? Then this webinar is for you. You’ll learn all about:

• Why databases do not play well with others
• How (and how often) you should be doing backups
• How MySQL use authentication is ‘too permissive’
• Which configuration hints keep the server happy
• Other best practices to keep your MySQL instances happy and shiny for years to come

Join us for this exciting live webinar on what you should know about the proper care and feeding of MySQL databases, with Dave Stokes, MySQL Community Manager at Oracle, and Janis Griffin, Database Performance Evangelist at SolarWinds. …

We are happy to announce another MySQL User Group meeting hold in Korea:

• Date: September 22, 2015
• Time: 19-21:00
• Place: Oracle Korea Office
• Proposed agenda: 
  • MySQL JSON - Youngha Kim, TimeGate (MUG member)
  • MySQL Updates - Sumi Riu, Oracle MySQL Sales Consultant

Everybody around is more than welcome at this free local MUG event. Please find more information & registration at MUG Korea FB. 

The latest version of MySQL Sakila SWAG is being beta tested this week at the Pacific Northwest PHP Conference.

Plush Sakila on left, Stress Relief Sakila on righ

The plush toy version of Sakila is very popular but the MySQL Community Team is exploring an alternative stress relief version.

Why a new Sakila when the old one is so popular? We on the MySQL Community Team are always looking for ways to extend and enhance our outreach. Plush toys often encounter a harsh environment such a drool from small children or pets, tearing from rough handling, and finally they get dirty from repeated handling. The new Sakilas have a plastic coating proven to be largely drool resistant and washable. Both are about the same size and weight (important when you bring a hundred to a show and have to carry them around!) and have …