Category Archives: mysql

How Much Network Traffic Does A MySQL Query Consume

Have you ever wondered how much network traffic was caused by a query with a  specific data set? In this post, I would like to share some research I did for stress testing network. During the whole test, I used mysqlslap to simulate a … Continue reading

Posted in mysql | Tagged , , | Comments Off

Learn About MySQL 5.6 at the Percona Live MySQL Conference

5.6 has redefined MySQL performance and usability. Some great talks at the Percona Live MySQL Conference and Expo will provide insight into the new features and benefits of this major release. The conference is April 22-25, 2013 at the Santa … Continue reading

Posted in mysql | Leave a comment

OurSQL Episode 133: MySQL on Auto-Tune

This week, we talk about variables with changed default values in MySQL 5.6. Ear Candy is the pt-config-diff tool and At the Movies is Tim Callaghan of Tokutek talking about Fractal Trees. Changed Defaults in MySQL 5.6 Percona’s article about … Continue reading

Posted in mysql | Leave a comment

MySQL 5.6 is out, so what is next?

MySQL 5.6 is out now and that is good news. I have already been using pre-GA versions on some production servers with good success and now that the few wrinkles I have seen have been ironed out, I am sure … Continue reading

Posted in mysql | Leave a comment

Gearing up for the Percona Live: MySQL Conference & Expo!

Join the SkySQL and MariaDB Crews in Santa Clara and Save on Registration Percona Live: MySQL Conference and Expo 2013 starts in just 3 weeks, and it’s the premiere event for MySQL users, open-source enthusiasts, and the technology movers ‘n … Continue reading

Posted in mysql | Leave a comment

Percona Live 2013 schedule & events summary

Here’s the (hopefully) complete list of events throughout and following the upcoming Percona Live MySQL Conference & Expo, 2013. The schedule is quite packed! Make sure to take a deep breath beforehand: Monday, April 22 09:30 – 16:30: Tutorials 16:30 … Continue reading

Posted in mysql | Leave a comment

Making use of PHP mysqlnd statistics

One of the great things of mysqlnd as a base library for PHP’s MySQL support are the collected statistics. mysqlnd collects about 160 different statistical values about all the things going on. When having such an amount of raw data … Continue reading

Posted in mysql | Leave a comment

MySQL and the forks in the road

There’s a lot of activity in the MySQL ecosystem currently. I’ve written an article for The H which takes a look at MySQL and the various forks and spinoffs to give an overview of where MySQL’s community and close competition is … Continue reading

Posted in mysql | Leave a comment

MongoDB Transactions? Yes

People claim that MongoDB is not transactional. It actually is, and that’s a good thing. In MongoDB 2.2, individual operations are Atomic. By having per database locks control reads and writes to collections, write operations on collections are Consistent and … Continue reading

Posted in mysql | Leave a comment

Wide Selection of MySQL DBA Training Events

MySQL for Database Administrators is the foundation of the authentic MySQL Curriculum. By taking this live 5-day instructor-led course, you find out how MySQL enhancements increase performance, scalability, reliability and manageability of your Web, Cloud and embedded application requirements. You will learn to: Setup … Continue reading

Posted in mysql | Leave a comment