Percona's MySQL & InnoDB performance and scalability blog
… 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.
… of PXC, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production…
we use sphinx to our website where we have about 1200 tables each with hundreds of thousands of records, for we use…
… 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…
@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.
… this. Please see “Highly selective columns only” section for examples where it doesn’t work well for us too.
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.
…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…
… 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…
… 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 …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.