by Vadim Tkachenko | Mar 13, 2009 | Percona Software
We are coming with next version of xtrabackup – online backup solution for MySQL 5.0 / 5.1 and InnoDB standard version, plugin modification and XtraDB. We still consider it as alpha version, though it shows perfect stable results in our tests. Let me address two...
by Morgan Tocker | Mar 10, 2009 | Percona Events
Percona presented two talks at PHP Quebec last week – one on A Tour of MySQL High Availability, and another on Performance Tuning MySQL. There was a great reaction to showcasing some of the quick-wins that can be found by using the Percona patches....
by Peter Zaitsev | Mar 9, 2009 | Hardware and Storage
One question which comes up very often is when one should use SAN with MySQL, which is especially popular among people got used to Oracle or other Enterprise database systems which are quite commonly deployed on SAN. My question in such case is always what exactly are...
by Baron Schwartz | Mar 9, 2009 | Percona Events
Even though we haven’t yet gotten a schedule online, we’re still accepting proposals for the Percona Performance Conference. As a teaser, let me just share one accepted proposal with you: Cary Millsap. If you are even vaguely involved with Oracle, you...
by Vadim Tkachenko | Mar 9, 2009 | Percona Software
We had too many requests for deb builds of Percona releases so I could not ignore that and added scripts to build binaries on our Ubuntu 8.10 box. It’s going to be only 64bit releases (32bit is dead, isn’t it?), and I tested binaries on Debian Lenny system...
by Baron Schwartz | Mar 5, 2009 | Insight for Developers
If you were interviewing to work at Percona, and I asked you “what does Using filesort mean in EXPLAIN,” what would you say? I have asked this question in a bunch of interviews so far, with smart people, and not one person has gotten it right. So I...
by Vadim Tkachenko | Mar 5, 2009 | Percona Software
After some sprint coding and testing I am more than happy to declare Xtrabackup getting into alpha stage. And alpha means more that we have some dirty hacks in code / not fully scripted builds / not fully tested all MySQL versions, but backups work just fine! I am...
by Vadim Tkachenko | Mar 4, 2009 | Percona Software
Running MySQL slave is quite common and regular task which we do every day, taking backups from slave is often recommended solution. However the current state of MySQL replication makes restoring slave a bit tricky (if possible at all). The main problem is that InnoDB...
by Vadim Tkachenko | Mar 2, 2009 | Hardware and Storage
We finally managed to get Intel X25-E SSD drive into our lab. I attached it to our Dell PowerEdge R900. The story making it running is worth separate mentioning – along with Intel X25-E I got HighPoint 2300 controller and CentOS 5.2 just could not start with two...
by Evgeniy Stepchenko | Mar 2, 2009 | Percona Software
Today we announce release 1.0.2-3 of our XtraDB storage engine. Here is a list of enhancements: Move to MySQL 5.1.31 Scalability fix — ability to use several rollback segments Increasing the number of rseg may be helpful for CPU scale of write-intentional workloads....
by Peter Zaitsev | Mar 2, 2009 | Insight for Developers
There are few terms you need to have a good understanding if you’re working with high volume systems. I commonly see these mixed and people not understanding the difference between them. Performance – The performance comes down to performing up to users...
by Peter Zaitsev | Mar 1, 2009 | Insight for DBAs
When I visit customers quite often they tell me about number of creative techniques they heard on the conferences, read on the blogs, forums and Internet articles and they ask me if they should use them. My advice is frequently – do not. It is fun to be creative...
by Vadim Tkachenko | Feb 24, 2009 | Percona Software
For long time as main backup solution for MySQL on Linux we have been using LVM snapshots. Performance concerns from performance critical envinronment caused us to do LVM performance research which showed horrible results forcing us to look at more performing...
by Baron Schwartz | Feb 13, 2009 | Percona Events
Percona is hiring. We’ve added several experts recently and we’re growing at a fast but sustainable pace. The demand for our services is strong, and we have openings for more experts in the next couple of months. Let me explain a little about what...
by Baron Schwartz | Feb 12, 2009 | Insight for DBAs
I vaguely recall a couple of blog posts recently asking something like “what’s the formula to compute mysqld’s worst-case maximum memory usage?” Various formulas are in wide use, but none of them is fully correct. Here’s why: you...
by Vadim Tkachenko | Feb 11, 2009 | Percona Software
One of InnoDB’s features is that memory allocated for internal tables definitions is not limited and may grow indefinitely. You may not notice it if you have an usual application with say 100-1000 tables. But for hosting providers and for user oriented...
by Aleksandr Kuzminsky | Feb 10, 2009 | Benchmarks
Introduction When people think about Percona’s microslow patch immediately a question arises how much logging impacts on performance. When we do performance audit often we log every query to find not only slow queries. A query may take less than a second to execute,...
by Peter Zaitsev | Feb 7, 2009 | Insight for DBAs
Here is nice gotcha which I’ve seen many times and which can cause just a minefield for many reasons. Lets say you had a system storing articles and you use article_id as unsigned int. As the time goes and you see you may get over 4 billions of articles you...
by Peter Zaitsev | Feb 5, 2009 | Benchmarks, Hardware and Storage
In many cases I speculate how things should work based on what they do and in number of cases this lead me forming too good impression about technology and when running in completely unanticipated bug or performance bottleneck. This is exactly the case with LVM Number...
by Baron Schwartz | Feb 5, 2009 | Percona Events
All of us here at Percona warmly invite you to Percona Performance Conference 2009 on April 22 and 23, 2009 in the Hyatt Regency in Santa Clara, California. The theme for the conference is Performance Is Everything. This conference is about application performance...
