Percona's MySQL & InnoDB performance and scalability blog
… distinct values (e.g status, gender, group_id with only 10 groups per 10M records), then you don’t want to use… “Highly selective columns only” section for examples where it doesn’t work well for us too.
… wrappers/scripts around this to make life easier, however, wouldn’t it be nice if this was built into the system… hostname – should be known in advance (the node itself needn’t be up), which may not be feasible in a cloud… (Note, the wsrep_sst_xtrabackup in 5.5.30 can’t do those except parallel, the one in 5.5.31…
… owe it to the MySQL community to share them. Don’t worry about being fancy. Some of the most popular talks…
… use of subqueries/multiple joins vs. multiple queries (e.g. temp tables)? For performance, it’s hard… to store an interim result set, and then use that to ultimately produce the result you want, that’… against the temp table fail. Q: Why doesn’t the query optimizer take care the execution decisions? …
… optimizations for this (like larger btrfs metadata block size etc.). b) For #a, it would be nice if btrfs (from 3…? btrfs supports LZO etc. too I believe. e) Another latest entrant to filesystem is Tux3 which is showing impressive results in performance.
… bad changed page data. Bug fixed #1108613. Percona Server wouldn’t start if the XtraDB changed page tracking was enabled and… server starting if the innodb_data_home_dir variable didn’t have the path separator at the end. Bug fixed #1181887…_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which…
… WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name… schema migration (to new schema name) using –include=”^orig[.]“ (i.e. functional partitioning) Combine with –replicate-rewrite-db Daily backups from production to staging with different db names (i.e. orig_prod restored to orig_staging) I’m sure there…
The unstable result problem I met (e.g. 32G BP was faster than 50GB BP even I … O_DIRECT when I tested) might not be from PCI-e flash card (cached etc..). But it might be from LinkBench…
…’t try more than 2; the additional work that the kernel has to do in reordering TCP packets can actually result in… binary log filters are executed on the intermediate server, thus resulting in less binary log data being sent down to the…: Oracle RAC is a “shared everything” system; there really isn’t anything quite like that in the MySQL world, except maybe…
… KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_B` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `parent_id…, PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`), CONSTRAINT `child_B_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`parent_id… the time spent maintaining SchemaSpy to his wife 
Finally don’t forget to automate SchemaSpy via crontab once you’re done…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.