by Morgan Tocker | Jul 13, 2009 | Cloud
The question “what problems will I have when migrating to the cloud” gets asked often enough. If by cloud you mean Amazon EC2, then from a technical perspective there isn’t much that changes. The biggest thing that changes is just how you pay your...
by Vadim Tkachenko | Jul 7, 2009 | Percona Software
Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see: http://bugs.mysql.com/bug.php?id=29847 http://dammit.lt/2008/10/26/innodb-crash-recovery/ This is problem when your InnoDB crashes, it may takes long time to start. Also it...
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 Baron Schwartz | Jul 7, 2009 | Percona Events
This is just a public service announcement (reminder?) that LenZ and Giuseppe are planning OpenSQL Camp 2009, this time in Europe, which is great. It’ll be part of FrOSCon. I wish I could say that I’ll attend, but due to various unpredictabilities in my...
by Michael.Bender | Jul 6, 2009 | MySQL
On April 9-10 the National Science Foundation hosted the Workshop on the Science of Power Management (SciPM 2009), where I gave an invited talk. Here I give a brief summary of my talk along with a pointer to the slides. The talk describes how MySQL with TokuDB can...
by Peter Zaitsev | Jul 6, 2009 | Insight for Developers
One of the most typical reasons for performance and scalability problems I encounter is simply failing to do the math. And these are typically bad one because it often leads to implementing architectures which are not up for job they are intended to solve. Let me...
by Peter Zaitsev | Jul 5, 2009 | Percona Events
As the part of FbFund educational seminars I will give a talk on MySQL Scalability for Facebook Application Developers. We have been working with number of top FaceBook applications and these are really fun to work with due to their commonly agile development...
by Peter Zaitsev | Jul 2, 2009 | Percona Events
At Percona we provide services both Onsite – visiting the customers and Remote – logging in to their systems or communicating via email,phone,instant messaging. We believe both approaches have their benefits and drawbacks and mixing them right way allows...
by Peter Zaitsev | Jul 2, 2009 | Percona Events
The Scaling with Flash webinar I’ve mentioned earlier was a success and we got the recording available. It contains Percona presentation, presentation of Schooner appliances and Q&A session. Enjoy.
by Baron Schwartz | Jul 1, 2009 | Insight for DBAs
For the last couple of months, we’ve been quietly developing a MySQL protocol parser for Maatkit. It isn’t an implementation of the protocol: it’s an observer of the protocol. This lets us gather queries from servers that don’t have a slow...
by Aleksandr Kuzminsky | Jul 1, 2009 | Percona Software
Dear community, The release 0.8 of the opensource backup tool for InnoDB and XtraDB is available for download. Key features: New mode of innobackupex –stream=tar4ibd; new command tar4ibd based on libtar-1.2.11 Experimental option –export is added (see...
by Vadim Tkachenko | Jun 29, 2009 | Insight for DBAs
As you see MySQL is doing great in InnoDB performance improvements, so we decided to concentrate more on additional InnoDB features, which will make difference. Beside ideas I put before https://www.percona.com/blog/2009/03/30/my-hot-list-for-next-innodb-features/...
by Ryan Lowe | Jun 26, 2009 | Insight for DBAs
With the growing adoption of Google’s User Statistics Patch**, the need for supporting scripts has become clear. To that end, we’ve created check-unused-keys, a Perl script to provide a nicer interface than directly querying the INFORMATION_SCHEMA...
by kuszmaul | Jun 24, 2009 | MySQL
Summary: An alternate approach, offered in response to our original post, provides excellent improvements for smaller databases, but clustered indexes offer better performance as database size increases. (This posting is by Dave.) Jay Pipes suggested an alternate...
by Zardosht.Kasheff | Jun 23, 2009 | MySQL
A couple of weeks ago, Baron Schwartz wrote an interesting post describing a rule of thumb he sometimes uses to choose the order of columns in an index. In a nutshell, he recommends putting highly selective columns first. This is a very good rule of thumb. I would...
by Peter Zaitsev | Jun 21, 2009 | Percona Events
I have not got a chance to have a standard session on Velocity Conference this year, However I’m hosting the BOF. Bring your flash, IO Performance, and general performance stories and questions if you have any. I also plan to attend the conference afternoon on...
by Peter Zaitsev | Jun 19, 2009 | Percona Events
I will co-present in webinar on Performance Challenges and Solutions for IO Bound Workloads in MySQL. My part of the presentation will be speaking about why switching from CPU bound workload to IO bound is such an important event, how to prepare to it as well as how...
by Ryan Lowe | Jun 18, 2009 | Percona Events
Today marks the official launch of Percona.tv. We’ll be uploading technical screencasts, conference video, and anything else cool we can think up. If you’ve got ideas or requests, let us know and we’ll do our best to accommodate!
by Maciej Dobrzanski | Jun 16, 2009 | Insight for DBAs
It is a known fact that ext3 is not the most efficient file system out there and for example file removals can be painfully slow and cause a lot of random I/O. However, as it turns out, it can sometimes have a much more severe impact on the MySQL performance that it...
by Vadim Tkachenko | Jun 15, 2009 | Benchmarks, Hardware and Storage
With new updates of FusionIO drivers I was able to test it on our Dell R900 with Ubuntu 8.10 without pain of compiling drives myself and downgrading to older kernel, so I was decided to test it in strict_sync mode. As I understand FusionIO in default mode, like Intel...
