Researching a performance issue, we came to a startling discovery:

MySQL 5.7 + binlogs is by default 37-45% slower than MySQL 5.6 + binlogs when otherwise using the default MySQL settings

Test server MySQL versions used:
i7, 8 threads, SSD, Centos 7.2.1511
mysql-5.6.30-linux-glibc2.5-x86_64
mysql-5.7.12-linux-glibc2.5-x86_64

mysqld –options:

--no-defaults --log-bin=mysql-bin --server-id=2

Run details:
Sysbench version 0.5, 4 threads, socket file connection

Sysbench Prepare: 

sysbench --test=/usr/share/doc/sysbench/tests/db/parallel_prepare.lua --oltp-auto-inc=off --mysql-engine-trx=yes --mysql-table-engine=innodb --oltp_table_size=1000000 --oltp_tables_count=1 --mysql-db=test --mysql-user=root --db-driver=mysql --mysql-socket=/path_to_socket_file/your_socket_file.sock …

I’m happy to announce that the third Development Milestone Release (DMR) of MySQL Cluster 7.5 — 7.5.2 — is now available!

Some highlights of this third milestone release of MySQL Cluster 7.5 are:

• This release is based on MySQL 5.7, so users can enjoy many of the great new features available in the latest MySQL Server, along with the many features that Cluster brings, including …

Stephen O'Grady at RedMonk has launched a new Podcast called Hark. In his second episode, he and Agile programming guru Kent Beck have a thoughtful discussion around the ideas in O'Grady's book "The Software Paradox."  Even though software is "eating the world" and become more widespread and strategic, its economic value appears to be declining rapidly. Certainly, we've seen a shift in the …

As some already noticed it, I’ve recently joined the amazing MySQL family in Oracle.

I’m now part to the awesome MySQL Community Team and I will be mostly present in EMEA.

Why did I make such change ? Oracle offered me the opportunity to work in a domain I really like and I was already trying to represent the MySQL Community as much as I could but mostly in using my own free time (twitter, facebook, FOSDEM, …). Now this is my full time job !

Yes, OK, but why Oracle ? To be honest this answer is very easy to reply. Somebody interested in the MySQL Community for the last few years should be blind to not see the amount of work the MySQL engineering team is doing: many improvements and overall, many new features. I won’t be a lie if I say that Oracle’s MySQL is also the most active in innovating MySQL (JSON data type, X plugin, MySQL shell,… )

For all these reasons, I’m very proud to have made the …

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.

I would like to inform community, as an Azerbaijan MySQL User Group leader I have attanded to E-Days-2016 and talked about MySQL, Open Source and the power of “BUG”s
Here are some photos from meetup:

In this blog, we’ll use some test results to look at the rationale for using provisioned IOPS volumes for AWS databases.

One piece of advice you often hear running MySQL, MongoDB or other databases in the AWS EC2 environment is that you should use volumes with provisioned IOPs. This kind of makes sense on the “marketing” level, where provisioned IOPS (io1) volumes are designed for IO-intensive database workloads, while General Purpose (gp2) volumes are not. But if you go to the AWS volume type description, you will find that gp2s are shown to have pretty good IO performance. So where do all these supposed database performance problems for Amazon Elastic Block Store (EBS), with no provisioned IOs, come from?

Here is what I found out running experiments with a beta of …

In this blog, I discuss a MongoDB administration checklist designed to help MySQL DBAs.

If you are MySQL DBA, starting MongoDB administration is not always an easy transition. Although most of the concepts and even implementation are similar, the commands are different. The following table outlines the typical MySQL concepts and DBA tasks (on the left) to corresponding MongoDB ones (on the right). If you happen to be a MongoDB DBA and want to learn MySQL administration, you can use the same table looking from right to left.

I’ve also created a webinar, MongoDB administration for MySQL DBA, that explains the above concepts. You can download the slides to use as a reference.

Don’t forget …

Sometimes we require to get age from birthdate using mysql select query we can do it in programming like phpnet and etc framework but if we can do it using mysql query In bellow example mysql query you can learn how to get age from date field We can get age value from using mysql DATEDIFF S

Sometimes we require to get age from birthdate using mysql select query we can do it in programming like phpnet and etc framework but if we can do it using mysql query In bellow example mysql query you can learn how to get age from date field We can get age value from using mysql DATEDIFF S