does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?
Comment: Percona Server 5.6.11-60.3 first Release Candidate now available
June 18, 2013 By 3 Comments
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
Comment: Sample datasets for benchmarking and testing
June 17, 2013 By 18 Comments
the links here are useful and informative…
Comment: How to change innodb_log_file_size safely
June 13, 2013 By 17 Comments
@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
…tables (such as MYISAM) with innodb tables within the same transaction. The same issue can arise if slave host is using different storage engine for the respective table…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…the InnoDB storage engine. In my testing I discovered that innodb_old_blocks_time had an effect on performance of the…the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… index ‘col2_2′ defined on the table ‘test.test’. This …for filtering by just the first one. Why can’t MySQL enforce this kind of constraints? For many reasons: the…engine-dependent, like redundant suffixes for secondary keys in InnoDB. As some of this redundancies could be necessary, depending on the…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…for two of everything. Q: Is it possible to replicate only some tables from…the same machine if you use the BLACKHOLE storage engine) in between the actual master and the slaves at the bottom of the replication topology. On the… something like that? I can’t imagine the performance being all that …
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_B` ( `id` int…the child tables they reference it as parent_id — this might make sense to Developers but it doesn‘t…great way for a high level overview of the table sizes and an easy way to use the …
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…table could vanish if the slave restarts and then subsequent queries against the temp table fail. Q: Why doesn‘t the query optimizer take care the…t clear, because I didn’t present the details of all the tables and columns. It turned out this solution was 150x faster for…
