… 10 groups per 10M records), then you don’t want to use this. Please see “Highly selective columns only” section for…
Comment: Sphinx search performance optimization: attribute-based filters
June 13, 2013 By 11 Comments
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb…storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
… on the nodes and encounter replication errors, which you have to deal with. Even later, when asynchronous or single-threaded replication… gain a lot from write set replication. If the application gets really popular, sooner or later you have to think about write…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…to replicate only some tables from master to slave, and if so, how? A: Yes. There are a few of ways to…to set up a relay master (it can be on the same machine if you use the BLACKHOLE storage engine…to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… prior to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain you how to fix your cluster in case it breaks after a distribution upgrade that implies an update of pacemaker from 1.1.7 to… the cluster in maintenance mode before the update, see bellow how to perform this action [root@percona1 percona]# yum update -y [root…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and … Updates involving non-transactional storage engines – It is not possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… writing a SQL query optimizer and see how easy it is? ;-) Generative grammars like SQL …finite amount of engineer-years spent developing and testing the query optimizer. The developers have to make … order from what you specify in the query? The tuple comparison you’re referring to is this…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables…, I allocated mirror pairs using drives from different controllers. That way, if a controller dies, the storage will still be working. Also…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…, easier comparison, and allow remote users to compare on a live system without needed to grant access to another “backup” server. As noted… `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF mysql -N -B <<'EOF' > import…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… easy move for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took a look at OmniOS but frankly it was the first time I read something about it. How different is it from Solaris in term of porting? @kyle: Yes, that…
