by Morgan Tocker | Sep 24, 2009 | MySQL, Percona Events
This is a quick announcement to say that I’ll be speaking at HighLoad++ this year (October 12-14 in Moscow). I’ll be presenting on a few topics: MySQL Performance Tuning (Conference Session) Quick Wins with Third Party Patches for MySQL (Conference...
by Morgan Tocker | Sep 10, 2009 | Percona Events
Today’s the day I fly to Los Angeles to teach a private training class, en route to Santa Clara/San Francisco for our public training workshops next week. Our Montreal practice teach at Station-C went great – it was an opportunity to do a road test and...
by Morgan Tocker | Aug 13, 2009 | Percona Software
Note: This post is part 2 of 4 on building our training workshop. Last week I talked about why you don’t want to shard. This week I’m following up with the top 10 enhancements that XtraDB has over the built-in InnoDB included in MySQL 5.0 and 5.1. ...
by Morgan Tocker | Aug 4, 2009 | Percona Events
Today, we are announcing that we’re ready to offer training for InnoDB and XtraDB in Santa Clara and San Francisco. The course was developed by Morgan Tocker with input from all our team – and covers a lot of the performance problems we run through in...
by Morgan Tocker | Jul 21, 2009 | Insight for DBAs
We’ve written about replication slaves lagging behind masters before, but one of the other side effects of the binary log being serialized, is that it also limits the effectiveness of using it for incremental backup. Let me make up some numbers for the...
by Vadim Tkachenko | Jul 14, 2009 | Benchmarks
There was small delay in our releases, part of this time we worked on features I mentioned before: – Moving InnoDB tables between servers – Improve InnoDB recovery time and rest time we played with performance trying to align XtraDB performance with MySQL...
by Morgan Tocker | Jul 7, 2009 | Insight for DBAs
It seems pretty common to find customers install DRBD for the wrong reasons. There are many pros/cons to compare DRBD to replication, but I’ve managed to cut down my spiel I give to customers to these two points: DRBD’s aim (assuming replication mode C) is...
by Alexey Kovyrin | Apr 23, 2008 | Benchmarks, Insight for DBAs
In one of his recent posts Vadim already gave some information about possible benefits from using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could be useful for large warehousing tasks. One...
by Peter Zaitsev | Feb 4, 2008 | Insight for DBAs
Finding the largest tables on a MySQL instance is a no brainer in MySQL 5.0+ thanks to Information Schema, but I still wanted to post a little query I use for the purpose so I can easily find it later. Plus it is quite handy in a way it presents information: SELECT...
by Alexey Kovyrin | Jan 24, 2008 | Benchmarks
Really often in customers’ application we can see a huge tables with varchar/char fields, with small sets of possible values. These are “state”, “gender”, “status”, “weapon_type”, etc, etc. Frequently we suggest to...
by Peter Zaitsev | Jun 15, 2007 | Hardware and Storage
In the previous post I mentioned not all architectures and solutions work for Commodity People, and people seems to agree with me. Number of vendors would claim they are in Commodity Software or Hardware business but few would probably mention they are doing it for...
by Peter Zaitsev | Jul 31, 2006 | Insight for DBAs, MySQL
I’m leaving MySQL starting 1st of August. This is surely not news for my collegues and friends who knew this is comming. We’re starting our own company which will provide MySQL Consulting services. We’ll focus on MySQL Performance Optimization but...
by Peter Zaitsev | Jun 9, 2006 | Insight for DBAs, MySQL
If you’ve been reading enough database-related forums, mailing lists, or blogs you have probably heard complains about MySQL being unable to handle more than 1,000,000 (or select any other number) rows by some of the users. On the other hand, it is well known...
by Peter Zaitsev | Jun 8, 2006 | Benchmarks
AnandTech published Intel Woodcrest preview benchmarks which have some numbers for MySQL as well. From these numbers performance looks great and it looks like finally Intel has something to respond to AMD Opterons on Server market. Now competition heats up and...
by Peter Zaitsev | May 29, 2006 | Insight for DBAs
MySQL INSERT ON DUPLICATE KEY UPDATE is very powerful but often forgotten MySQL feature. It was introduced in MySQL 4.1 but I still constantly see people unaware of it. Myself I like this feature big deal because it is designed in truly MySQL style – very...
by Peter Zaitsev | May 17, 2006 | Insight for DBAs
Every so often people ask me the question how should they estimate memory consumption by MySQL Server in given configuration. What is the formula they could use. The reasons to worry about memory usage are quite understandable. If you configure MySQL Server so it uses...
by Peter Zaitsev | May 16, 2006 | Insight for DBAs
I’ve now added one more presentation to MySQL Performance Presentations page. This presentation is from MySQL Users Conference 2006 which was presented by Vadim but which we prepared together. Hope you enjoy it. Get it here
by Peter Zaitsev | May 13, 2006 | Insight for DBAs
MyISAM storage engine has key compression which makes its indexes much smaller, allowing better fit in caches and so improving performance dramatically. Actually packed indexes not a bit longer rows is frequent reason of MyISAM performing better than Innodb. In this...
by Peter Zaitsev | May 11, 2006 | Insight for DBAs
Thinking more about the problems I wrote about yesterday I had a question why so ugly workaround and guesses or manual configuration is needed ? The answer seems to be Operation Interfaces just do not provide IO interface which is good enough. The big missing piece is...
