I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… user experience will suffer. So what you can do to prevent this problem from happening ? The answer is easy. Throttle the…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… to take all the locks required in the beginning to prevent dead locks? So you would get a lock wait instead…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would…
Post: Webinar: MySQL and SSD
May 8, 2012 By Leave a Comment
Just as a reminder – tomorrow, May-9, 2012, at 11am PDT I will be giving a free webinar “MySQL and SSD”. This is the same talk I gave on Percona Live MySQL Conference, so if you were there – you probably will find nothing new. Otherwise, you are welcome to join!
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… have heard that Oracle made the decision not to support MySQL for IBM i any longer. This is certainly understandable. However…. Everything works on Zend DBi just as it works on MySQL, with no need to rewrite applications, management scripts, or anything… own Percona Server variant of the MySQL server. We have a history of improving the MySQL server and finding and solving bugs…
Post: Training in London next week
May 16, 2012 By Leave a Comment
I’m going to deliver MySQL Training next week (May 21-24) in London. This is …. You will also get a signed copy of High Performance MySQL 3rd edition as an attendee.
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
… available here and from the Percona Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
… query with a couple of mins gap on the same mysql prod instance . The first SQL query executed in 0.03… merge executes in 3.8 secs. I dont understand why MySQL uses index merge after a couple of mins when previously… | ProjectTbl2 | const | PRIMARY,namespace_ix | PRIMARY | 4 | const | 1 | Using filesort | | 1 | SIMPLE | LinksTbl2 | index_merge | tstamp,userid,converted_from_id…
Post: Zero-downtime schema changes webinar recording
May 8, 2012 By Leave a Comment
The recording and slides for my webinar on zero-downtime schema changes with MySQL are available now. Don’t miss Vadim’s webinar tomorrow!
