May 19, 2013

What I’m looking forward to at Percona Live (MySQL Users Conference)

April 4, 2013 By 1 Comment

This is my 10th year attending and speaking at the MySQL Users Conference (as the Percona Live MySQL Conference and Expo was originally called back in 2003), and for me it does not get tiring. So what is there in this conference for me as an attendee, speaker and businessman? Learning. First and foremost the conference [...]

Filed Under: MySQL, Percona Live Tagged With: , , , ,

InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

This is part 2 in a 3 part series. In part 1, we took a quick look at some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here, we are going to run some queries and compare the result sets. Our hope is that the one of two things [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

MySQL 5.5 and MySQL 5.6 default variable values differences

February 21, 2013 By 8 Comments

As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes to default variable values. To do that I’ve loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query:

Lets go over to see what are the most important changes [...]

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Sell-an-Elephant-to-your-Boss-HOWTO

August 28, 2012 By 3 Comments

Spoiler alert: If your boss does not need an elephant, he is definitely NOT going to buy one from you. If he will, he will regret it and eventually you will too. I must appologize to the reader who was expecting to find an advice on selling useless goods to his boss. While I do [...]

Filed Under: Insight for DBAs, Insight for Developers Tagged With: ,

Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks

August 17, 2012 By 17 Comments

Percona XtraDB Cluster (PXC) and the technology it uses (Galera) is an exciting alternative to traditional MySQL replication.  For those who don’t know, it gives you: Fully Synchronous replication with a write latency increase equivalent to a ping RTT to the furthest node Automatic cluster synchronization, both incremental and full restores The ability to read [...]

Filed Under: MySQL, XtraDB Cluster

An update on Percona Live MySQL Conference & Expo 2012

November 30, 2011 By 2 Comments

We announced a while back that we were going to continue the traditional MySQL conference in Santa Clara, because O’Reilly wasn’t doing it anymore. But we haven’t given an update in a while. Here’s the current status: We created a conference committee. We created a conference website that allows people to create an account and [...]

Filed Under: Events and Announcements, MySQL

What’s a good buffer pool read/write ratio?

May 31, 2011 By 6 Comments

At Percona Live last week, someone showed me a graph from their Cacti monitoring system, using the templates that I wrote. It was the buffer pool pages read, written, and created. He asked me if the graph was okay. Shouldn’t there be a lot more pages read than written, he asked? It’s a great question. [...]

Filed Under: MySQL

Getting History of Table Sizes in MySQL

December 8, 2010 By 13 Comments

One data point which is very helpful but surprisingly few people have is the history of the table sizes. Projection of data growth is very important component for capacity planning and simply watching the growth of space used on partition is not very helpful. Now as MySQL 5.0+ has information schema collecting and keeping this [...]

Filed Under: Insight for DBAs, MySQL Tagged With:

New Forum Categories: Help Wanted, For Hire

October 20, 2010 By 1 Comment

I’ve just added two categories to our forum, so you can post your job listings if you’re looking for someone to help you, and you can post your qualifications if you are available for hire.

Filed Under: Events and Announcements Tagged With:

How to know if you’re updating Slave you should not ?

April 11, 2010 By 8 Comments

When replication runs out of sync first question you often ask is if someone could be writing to the slave. Of course there is read_only setting which is good to set in the slave but it is not set always and also users with SUPER privilege bypass it. Looking into binary log is obvious choice [...]

Filed Under: Insight for DBAs, MySQL Tagged With:
« Older Posts