… DDL and several other InnoDB and query optimizer improvements. However, I plan to focus on a series of posts on the… almost unnoticed by most (not all) DBAs. Duplicate Index Detection I commented about this on my last webinar, but did not… time to analyze it in-depth. If you try to do something like this in MySQL 5.5, you will succeed…
Comment: How number of columns affects performance ?
May 25, 2013 By 12 Comments
Peter, Do you think it would it be more efficient to have … of data in the multiple column scenario and 16 if I had to add a data type column. We are probably…
Comment: Be careful when joining on CONCAT
May 24, 2013 By 16 Comments
… world, only unexperienced person might think that’s not necessary. I need to calculate IBAN from bank number+acc.number+sufix… can only be separate). And cast or convert isn’t doing proper job with a number with 23 digits.
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
I recently had to do some customer work involving the McAfee MySQL Audit Plugin and … exposed by a consistent API. If you also need to do this, the details are clearly explained here. The plugin writes… for which you do not want events written to the log. Just for reference, these are the lines I had to add…
Comment: What Are Full, Incremental, and Differential Backups?
May 22, 2013 By 9 Comments
… weeks. Can you give an example in a table? I am doing a project with Open university, and would appreciate your help…
Comment: How to calculate a good InnoDB log file size
May 22, 2013 By 38 Comments
… i ran this test several times over the course of ten minutes yesterday, maybe there is some cleanup thread that can do…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… describes very nicely how to switch to GTID-based replication, I won’t repeat it. Basically the steps are: Make the… items in the documentation are not so clear. For instance: Do we really need to restart all the servers at the… started: 2013-05-17 13:21:26 3130 [ERROR] Slave I/O: The slave IO thread stops because the master has…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 20, 2013 By 10 Comments
@Jervin can you take a look at that thread – any idea of what’s going on? is there any more debug i can do? thanks
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 20, 2013 By 13 Comments
… this plays out. I think it will work. Sure, the landscape will be littered with carcasses of those who did not make…
Comment: Is Synchronous Replication right for your app?
May 20, 2013 By 18 Comments
… applies to any multi-writer system. second comment, first paragraph — I‘d argue this is a problem in conventional replication (or… chunked into smaller transactions via pt-archiver and similar tools. I do believe that’s the “right” solution. second comment, second paragraph…
