by Baron Schwartz | Dec 7, 2010 | Insight for DBAs, MySQL
I usually tell people to use official MySQL builds from MySQL, or from their operating system distribution if they don’t want to do that. (This assumes that there is no compelling reason to use third-party builds such as Percona’s.) Sometimes, though,...
by Peter Zaitsev | Dec 1, 2010 | MySQL, Percona Events
We had some technical difficulties with Webex today which prevented from all registered attendees to be able to join webinar. I personally would be very upset having booked my time to attend event, pre-registered to ensure there is a space available and when unable to...
by Vadim Tkachenko | Nov 29, 2010 | Hardware and Storage, MySQL
Working with customer, I faced pretty nasty bug, which is actually not rare situation , but in this particular there are some lessons I would like to share. The case is pretty much described in bug 55981, or in pastebin. Everything below is related to...
by Vadim Tkachenko | Nov 29, 2010 | MySQL, Percona Events
Erin and Mike, organizers of SF Meetup generously invited me to talk on coming SF Meetup on Dec-14 about new features in InnoDB in MySQL 5.1 and 5.5 and, what is pay attention to, when you upgrade from MySQL 5.0. Although I personally mostly in 5.1->5.5 upgrade area,...
by Fred Linhoss | Nov 23, 2010 | MySQL, Percona Software
Percona Server version 5.1.52-rel11.6 is now available for download. The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1. Functionality Added or Changed  Percona Server 5.1.52-rel11.6 is now based on...
by Peter Zaitsev | Nov 22, 2010 | MySQL, Percona Events
I do not know if it is because we’re hosting a free webinar on migrating MyISAM to Innodb or some other reason but recently I see a lot of questions about migration from MyISAM to Innodb. Webinar will cover the process in a lot more details though I would like...
by Fred Linhoss | Nov 22, 2010 | MySQL, Percona Software
Percona XtraBackup 1.4 is now available for download. Version 1.4 fixes problems related to incremental backups. If you do incremental backups, it’s strongly recommended that you upgrade to this release. Functionality Added or Changed Incremental backups have...
by Vadim Tkachenko | Nov 19, 2010 | Benchmarks, Insight for DBAs
My post back in April, https://www.percona.com/blog/2010/04/08/fast-ssd-or-more-memory/, caused quite interest, especially on topic SSD vs Memory. That time I used fairy small dataset, so it caused more questions, like, should we have more then 128GB of memory? If we...
by Martin.FarachColton | Nov 17, 2010 | MySQL
Summary B-trees suffer from fragmentation. Fragmentation causes headaches — in query performance and space used. Solutions, like dump and reload or OPTIMIZE TABLE are a pain and not always effective. Fractal trees don’t fragment. So if fragmentation is a...
by Baron Schwartz | Nov 16, 2010 | MySQL, Percona Events
Ewen and I have just published Percona’s latest white paper, Forecasting MySQL Scalability with the Universal Scalability Law. This is essentially a streamlined walk-through of Dr. Neil J. Gunther’s book Guerrilla Capacity Planning, with examples to show...
by Fernando Ipar | Nov 16, 2010 | Percona Events
As part of our growth process and with the introduction of our Support and Maintenance services, we’re looking for a new Support Engineer. You would be a part of a unit that operates 24×7 and be the first line of contact for our customers. Responsibilities...
by Baron Schwartz | Nov 16, 2010 | Hardware and Storage, MySQL
Last night a customer had an emergency in selected machines on a large cluster of quite uniform database servers. Some of the servers were slowing down in a very puzzling way over a short time span (a couple of hours). Queries were taking multiple seconds to execute...
by Justin Swanhart | Nov 15, 2010 | Insight for Developers, MySQL
Preamble: On performance, workload and scalability: MySQL has always been focused on OLTP workloads. In fact, both Percona Server and MySQL 5.5.7rc have numerous performance improvements which benefit workloads that have high concurrency. Typical OLTP workloads...
by Baron Schwartz | Nov 11, 2010 | Insight for DBAs, MySQL
The new release of Maatkit has a useful feature in mk-index-usage to help you determine how indexes are used in more flexible ways. The default report just prints out ALTER statements for removing unused indexes, which is nice, but it’s often helpful to ask more...
by Aurimas Mikalauskas | Nov 9, 2010 | Insight for DBAs, MySQL
Before I start a story about the data recovery case I worked on yesterday, here’s a quick tip – having a database backup does not mean you can restore from it. Always verify your backup can be used to restore the database! If not automatically, do this...
by Baron Schwartz | Nov 8, 2010 | Insight for DBAs, MySQL
Based on discussions with several clients, we are strongly considering implementing a limited form of parallel replication. Single-threaded replication is one of the most severe limitations in the MySQL server. We have a brief outline of the ideas at this wiki...
by Baron Schwartz | Nov 8, 2010 | MySQL, Percona Events
Register now for a free Percona webinar about migrating your MyISAM databases to InnoDB. Save the date: Dec 1, 2010 at 9:00 AM PST (California) time. Update: the date was originally listed as December 2nd, but that was a mistake. It’s December 1st. We know that...
by Morgan Tocker | Nov 8, 2010 | Insight for DBAs, MySQL
I have a 5G mysqldump which takes 30 minutes to restore from backup. That means that when the database reaches 50G, it should take 30×10=5 hours to restore. Right? Wrong. Mysqldump recovery time is not linear. Bigger tables, or tables with more indexes...
by Baron Schwartz | Nov 5, 2010 | MySQL, Percona Events
You probably saw the Twitter storm over Oracle’s pricing changes and InnoDB in the last few days. The fear about Oracle removing InnoDB from the free version of MySQL was baseless — it was just a misunderstanding. Still, in the years since MySQL has been...
by Vadim Tkachenko | Nov 2, 2010 | Benchmarks
We all enjoyed Yoshinori announcement of HandlerSocket, the plugin to MySQL which open NOSQL way to access data stored in InnoDB. The published results are impressive, but I want to understand some, that’s why I run couple more experiments. In blog post...
