MySQL command line utilities have an interesting property – if you only use the prefix of the option or command it will go over the list of available command and if there is only one command with matching prefix it will execute it with no warnings or any kind, otherwise it will report the error. [...]
Percona team at MySQL Connect today
September 29, 2012 By 1 Comment
Attending MySQL Connect ? Do not miss our talks! Peter Zaitsev is doing “Optimizing MySQL Configuration” talk at 2:30 PM in Golden Gate 4 room Vadim Tkachenko is talking about “MySQL and Solid-State Drives: Usage and Tuning” at 4:00 PM in the same room. See you around !
Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
Just yesterday I wrote about math of automatic failover today I’ll share my thoughts about what makes MySQL failover different from many other components and why asynchronous nature of standard replication solution is causing problems with it. Lets first think about properties of simple components we fail over – web servers, application servers etc. We [...]
Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6
August 30, 2012 By 2 Comments
I got the message in the morning today about the bug being fixed in MySQL 5.6.6…. which I reported in Early 2006 (while still being with MySQL) and running MySQL 4.1 I honestly thought this issue was fixed long ago as it was indeed pretty annoying. I must say I’m very impressed with Oracle team [...]
Percona’s “Developer Training for MySQL” is now available via Live Virtual Training
July 30, 2012 By Leave a Comment
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) session. The goal was to ensure there was still time [...]
SQL Injection Questions Followup
July 26, 2012 By 2 Comments
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 to the recording, which will be available soon. During [...]
Percona Server 5.5.25-27.0 release delayed
June 28, 2012 By 2 Comments
Due to a bug in upstream MySQL ( http://bugs.mysql.com/bug.php?id=65745 ), we’ve decided to delay the release of the next Percona Server release until it is resolved. We had originally expected to release Percona Server 5.5.25-27.0 today and instead I’m informing you that we are not. Quoting Hartmut, who reported the bug: An UPDATE that should only modify [...]
ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
Today I was looking at the ALTER TABLE performance with fast index creation and without it with different buffer pool sizes. Results are pretty interesting. I used modified Sysbench table for these tests because original table as initially created only has index on column K which initially contains only zeros, which means index is very [...]
Using innodb_sys_tables and innodb_sys_indexes
June 15, 2012 By Leave a Comment
I was playing with Percona Server today and found fast_index_creation does not work quite exactly like described in the manual. The point I’m looking to make though it would be very hard to catch this problem without additional information_schema tables we added in Percona Server. I was doing simple ALTER TABLE such as: “alter table [...]
Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
Thanks to all who attended my webinar today. The session was recorded and will be available to watch for free soon here. There were a lot of great questions asked during the session, so I’d like to take this opportunity to try to answer a few of them: Q: Is there an easy way to [...]
