by Morgan Tocker | Mar 18, 2011 | Insight for DBAs, MySQL
(This is a cross post from percona.tv – the home of percona material in video form.)Last month I gave a presentation at the PHP UK Conference on the InnoDB storage engine. I was a last minute speaker, and I want to thank them for the time-slot and... by Morgan Tocker | Feb 14, 2011 | MySQL, Percona Events
Percona Live is in only two days away – and we’ve managed to completely sell out (something I predicted earlier). Before I go into details, I want to thank three sponsors who have been absolutely awesome:Clustrix is providing an open bar all... by Morgan Tocker | Feb 2, 2011 | MySQL, Percona Events
We’re down to less than 25 tickets remaining for Percona Live. If you are planning on attending, it might be a good idea to purchase your ticket(s) as soon as possible – we are expecting to sell out. by Morgan Tocker | Jan 28, 2011 | MySQL, Percona Events
We’re excited to announce that as well as Percona Live – we will also be holding an evening of Ignite talks on February 16th. For those not familiar the format, you should check out the Best of Ignite from the MySQL conference last year, as well as... by Morgan Tocker | Jan 25, 2011 | MySQL, Percona Events
Today we are announcing Venu Anuganti as a guest speaker to Percona Live: San Francisco. Venu works as a Data architect, evaluating and implementing high performance SQL/NoSQL data store solutions for large scale OLTP and OLAP infrastructure; and previously worked as... by Morgan Tocker | Jan 12, 2011 | MySQL, Percona Events
Mark Callaghan has graciously accepted to be the closing keynote speaker for Percona Live: San Francisco!Mark is best known for his work behind MySQL @ Facebook, where he and his team maintain one of the largest MySQL installations around. They also... by Morgan Tocker | Jan 5, 2011 | MySQL, Percona Events
Today we’re announcing Percona Live – a one day event to be held at the Bently Reserve on February 16th in San Francisco. Live is our way of showcasing some of the awesome work that has been going into MySQL recently – and the theme of... by Morgan Tocker | Dec 25, 2010 | Insight for DBAs, MySQL
Inspired by Baron’s earlier post, here is one I hear quite frequently – “If you enable innodb_file_per_table, each table is it’s own .ibd file. You can then relocate the heavy hit tables to a different location and create symlinks... by Morgan Tocker | Dec 13, 2010 | MySQL, Percona Events
For those that missed it – last week we added training in Frankfurt and London to our website. This includes our new Operations Training announced in September.(While in Europe, we’d love to speak at your meetup group on Percona Server and/or... by Morgan Tocker | Dec 9, 2010 | MySQL, Percona Events
We’ve just published the recordings for our webinars; Migrating MyISAM to InnoDB and Introduction to Percona Server, XtraDB and Xtrabackup. To listen, click on (Watch: Recorded Webinar) on each of these links.We’re planning for future webinars... by Morgan Tocker | Nov 26, 2010 | MySQL, Percona Events
We’ve had such a large number of signups to our Migrating MyISAM to InnoDB webinar, that we decided to hold one more before the year is out: December, 8th 9AM PST: Introduction to Percona Server, XtraDB and Xtrabackup. As the title suggests: this presentation is... 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. ... by Morgan Tocker | Oct 26, 2010 | Benchmarks, Insight for Developers, MySQL
A couple of weeks ago I blogged about Sharing an auto_increment value across multiple MySQL tables. In the comments, a few people wrote in to suggest alternative ways of implementing this. I just got around to benchmarking those alternatives today across... by Morgan Tocker | Oct 6, 2010 | MySQL, Percona Events
My colleague Aleksandr Kuzminsky will be speaking at WebConf Riga 2010 next month on XtraBackup: Hot Backups and More and Recovery of Lost or Corrupted InnoDB Tables.WebConf is the first big conference of its kind in the Baltic states (Estonia, Latvia, Lithuania) and... by Morgan Tocker | Oct 4, 2010 | Benchmarks, Insight for Developers, MySQL
The title is SEO bait – you can’t do it. We’ve seen a few recurring patterns trying to achieve similar – and I thought I would share with you my favorite two:Option #1: Use a table to insert into, and grab the insert_id: CREATE TABLE option1... by Morgan Tocker | Sep 20, 2010 | Insight for Developers, MySQL
I occasionally get in to light arguments healthy discussions with students about whether or not to use Foreign Key constraints on InnoDB tables. My standard response has always been: “it depends on how much of a tradeoff you are willing to make for... by Morgan Tocker | Aug 19, 2010 | MySQL, Percona Events
Four Perconians (perconites?) will be at OpenSQL Camp in Sankt Augustin, Germany this weekend presenting talks on: Recovery of Lost or Corrupted InnoDB Tables Keep your MySQL backend online no matter what XtraDB — InnoDB on steroids Xtrabackup for MySQLIf you... by Morgan Tocker | Aug 18, 2010 | MySQL, Percona Events
We’re opening up registration for our new training courses today. In short: we are moving from two days to a new four-day format. The new additions are created by: Splitting our current InnoDB day in half. We now have one day for DBAs,... by Morgan Tocker | Aug 10, 2010 | Insight for Developers, MySQL
If you read Percona’s whitepaper on Goal-Driven Performance Optimization, you will notice that we define performance using the combination of three separate terms. You really want to read the paper, but let me summarize it here: Response Time – This is the... by Morgan Tocker | Jul 24, 2010 | Insight for Developers, MySQL
I recently had a run-in with a very popular PHP ecommerce package which makes me want to voice a recurring mistake I see in how many web applications are architected.What is that mistake?The ecommerce package I was working with depended on caching. Out of...