by Michael.Bender | Aug 7, 2012 | MySQL
A few weeks ago Bradley Kuszmaul and I attended the Dagstuhl Seminar on Database Workload Management. The Dagstuhl computer science research center is (remotely) located in the countryside in Saarland, Germany. The actual building is an 18th Century Manor House, first...
by Peter Zaitsev | Aug 7, 2012 | MySQL, Percona Events
I’m hosting MySQL Indexes: Best Practices Webinar next week, Wednesday August 15. In which I will talk about how MySQL indexes are structured and how they can be used, as well as go over the best practices in selecting correct indexes for your database...
by Miguel Angel Nieto | Aug 6, 2012 | MySQL
The use of tmpfs/ramfs as /tmp partition is a common trick to improve the performance of on-disk temporary tables. Servers usually have less RAM than disk space so those kind of partitions are very limited in size and there are some cases were we can run out of space....
by Frederic Descamps | Aug 2, 2012 | MySQL, Percona Software
Some people want to use a backup to prepare a new Percona XtraDB Cluster node. They want this to avoid State Snapshot Transfer that could slow down the donor (depending of the SST method you are using, the donor can be blocked. I will cover this in a future blog...
by Tim.Callaghan | Aug 1, 2012 | MySQL
Benchmarking is a tricky thing, especially when it comes to compression. Some data compresses quite well while other data does not compress at all. Storing jpeg images in a BLOB column produces 0% compression, but storing the string “AAAAAAAAAAAAAAAAAAAA” in a...
by Peter Zaitsev | Jul 31, 2012 | Insight for DBAs, MySQL
Innodb uses row level locks right ? So if you see locked tables reported in SHOW ENGINE INNODB STATUS you might be confused and rightfully so as Innodb table locking is a bit more complicated than traditional MyISAM table locks. Let me start with some examples. First...
by David Hildebrandt | Jul 30, 2012 | Insight for Developers, MySQL, Percona Events
Today, Percona announces that Live Virtual Training is now an option for busy professionals. We set out to develop a training solution that balances the time to deliver the content with the amount of time an attendee can participate in a live virtual training (LVT)...
by Peter Zaitsev | Jul 30, 2012 | MySQL, Percona Events
If you’re looking for best prices for Percona Live NY 2012, taking place Oct 1,2 in New York do not delay and book now. Super Saver discounts ends tomorrow, which can save you hundreds of dollars off conference prices list prices. These are the best prices you...
by Bill Karwin | Jul 26, 2012 | Insight for Developers, MySQL
I presented a webinar today about SQL Injection, to try to clear up some of the misconceptions that many other blogs and articles have about this security risk. You can register for the webinar even now that I’ve presented it, and you’ll be emailed a link...
by Frederic Descamps | Jul 25, 2012 | MySQL, Percona Software
During the design period of a new cluster, it is always advised to have at least 3 nodes (this is the case with PXC but it’s also the same with PRM). But why and what are the risks ? The goal of having more than 2 nodes, in fact an odd number is recommended in...
by Tim.Callaghan | Jul 24, 2012 | MySQL
I’ll be presenting TokuDB at the Emerging Business Technology Meetup in Boston this Thursday night at 6pm at 290 Congress St (near South Station). The meeting topic is “NewSQL: SQL Technologies Keeping NoSQL Promises” and also includes presentations...
by Miguel Angel Nieto | Jul 24, 2012 | MySQL
One month ago I wrote about how a big read_buffer_size could break the replication. The bug is not solved but now there is an official workaround to ease this problem using a new configuration variable: slave_max_allowed_packet This new variable will be available in...
by Zardosht.Kasheff | Jul 23, 2012 | MySQL
Three rules on making indexes around queries to provide good performance Application performance often depends on how fast a query can respond and query performance almost always depends on good indexing. So one of the quickest and least expensive ways to increase...
by Hrvoje Matijakovic | Jul 21, 2012 | MySQL
Percona is glad to announce the release of Percona Server 5.5.25a-27.1 on July 21st, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.25a, including all the bug fixes in it, Percona Server 5.5.25a-27.1 is now the...
by Bill Karwin | Jul 18, 2012 | Insight for Developers, Percona Events
The threat of SQL injection has appeared prominently in the news recently: An SQL injection vulnerability resulted in an urgent June bugfix release of Ruby on Rails 3.x. Make sure you upgrade if you use Rails 3.0, 3.1, or 3.2! Also you should disable mass...
by Tim.Callaghan | Jul 18, 2012 | MySQL
TokuDB v6.1 is now generally available and can be downloaded here. New features include: Added support for MariaDB 5.5 (5.5.25) The TokuDB storage engine is now available with all the additional functionality of MariaDB 5.5. Added HCAD support to our MySQL 5.5 version...
by Rich.Prohaska | Jul 16, 2012 | MySQL
We found a simple XA transaction that crashes MySQL 5.5 replication. This simple transaction inserts a row into an InnoDB table and a TokuDB table. The bug was caused by a flaw in the logging code exposed by the transaction’s use of two XA storage engines (TokuDB and...
by Michael.Bender | Jul 12, 2012 | MySQL
I attended the NSF Workshop on Research Directions in the Principles of Parallel Computation in Pittsburgh on 6/27/12. The workshop brought together researchers from academia and industry to explore visions for the future of parallel computing. I was one of 17 invited...
by Peter Zaitsev | Jul 11, 2012 | MySQL, Percona Events
Yes, We will be at OSCON next week. I will be talking about Optimizing MySQL Configuration and host a BOF on MySQL Sharding Replication and Clustering if you’re interested in any of these technologies please come by and share your story. I would love to see both...
by Stewart Smith | Jul 10, 2012 | Percona Software
I’m glad to announce the third Percona Playback release – another alpha release of a new software package designed to replay database server load. The first two versions were released in April, just in time for my talk at the Percona Live MySQL Conference...
