June 18, 2013

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

June 17, 2013 By Leave a Comment

… 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…

Filed Under: MySQL, Percona XtraDB Cluster, XtraDB Cluster Tagged With: , , , , , , , ,

Comment: Sphinx search performance optimization: attribute-based filters

June 13, 2013 By 11 Comments

… 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.

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Post: Call for papers: Percona Live London

June 14, 2013 By Leave a Comment

… owe it to the MySQL community to share them. Don’t worry about being fancy. Some of the most popular talks…

Filed Under: MySQL, Percona Live Tagged With:

Comment: Sphinx search performance optimization: attribute-based filters

June 12, 2013 By 11 Comments

…, so we applied the technique described here, but the search results have gone from milliseconds to more than 43 seconds

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Post: Percona MySQL University @Portland next Monday!

June 12, 2013 By Leave a Comment

… work with MySQL, then this is an event you can’t afford to miss… :)   So register now! Please also join the…

Filed Under: Events and Announcements, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona MySQL Training, Percona MySQL University, Percona Remote DBA Tagged With: ,

Post: MySQL Query Patterns, Optimized - Webinar questions followup

June 3, 2013 By 2 Comments

… 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? …

Filed Under: Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Comment: ZFS on Linux and MySQL

May 27, 2013 By 17 Comments

… 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.

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

June 10, 2013 By 3 Comments

… 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…

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Post: Migrating between MySQL schemas with Percona Xtrabackup

June 10, 2013 By 2 Comments

… 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…

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Comment: MySQL and Percona Server in LinkBench benchmark

June 9, 2013 By 18 Comments

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…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , , ,
« Older Posts