June 19, 2013

Comment: Call for papers: Percona Live London

… a live performance while eating, drinking or simply watching the show, this is the place to begin your search. At TicTune…, search within distance, date, or by type or genre of shows you are interested in.

Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26

… of PXC, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production…

Comment: Sphinx search performance optimization: attribute-based filters

we use sphinx to our website where we have about 1200 tables each with hundreds of thousands of records, for we use…

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… of synchronous replication setup with high-availability guarantees like split-brain immunity. Nobody likes to debug async replication while its broken or…). By using Xtrabackup for SST, you also get its benefits like compression, parallel streaming, encryption, compact backups which can be used…

Comment: How to change innodb_log_file_size safely

@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.

Comment: Sphinx search performance optimization: attribute-based filters

… this. Please see “Highly selective columns only” section for examples where it doesn’t work well for us too.

Comment: How to calculate a good InnoDB log file size

According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.

Post: MySQL Query Patterns, Optimized - Webinar questions followup

…improved.  But there’s a finite amount of engineer-years spent developing and testing the query optimizer….first table in the EXPLAIN seem like it was scanning more rows.  But by avoiding the temporary table, … the query where you were trying to determine the last episode of each TV show. Couldn’t you…

Post: Implementing SchemaSpy in your MySQL environment

… CREATE TABLE `parent` ( `parent_id` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child… the child and parent tables.  Your environment may be like a lot of shops that we see, where the parent table is known as…

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

… Duplicates: 0 Warnings: 0 mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `id` int(11…detect subtle redundancies that are engine-dependent, like redundant suffixes for secondary keys in InnoDB. As some of …