…rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows parallel processing of individual tables when rebuilding the index. Percona… the backups. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client….
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…, unlike anything you find in standard async MySQL replication. It is my belief that the … taken for applications to avoid using Donor/Desynced nodes, particularly when using a blocking SST method… small fc_limit does however keep the certification index smaller in memory. It keeps the certification …
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… ids(after load of data size of datadir ~10GB). We used this dataset to check server behavior when data fully fits… related to BUG#67808. For MySQL 5.6.11 top mutexes is &buf_pool->mutex,&new_index->lock. I profiled 5.6…_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… explicitly named foreign key constraint which implied an implicit secondary index with the same name. Fixed by detecting such cases and… Kopytov). Percona Server for MySQL was built with YaSSL which could cause some of the programs that use it to crash. Fixed… #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test database when using rpm on server upgrade, even if the…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… in Innodb is a single row (well, the PRIMARY KEY index entry for that row). This means typically on a single… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… tradeoffs. Most of us are used to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… names explain their content. Index id in our example is 1679: mysql> SELECT * FROM SYS_FIELDS WHERE INDEX_ID = 1679; +———-+—–+———-+ | INDEX_ID | POS | COL…/FIL_PAGE_INDEX/<index_id> 4. Load dumps of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…. * A ‘range’ delete would mostly follow above two points. * Secondary indexes are also BTrees, so they need updating (although delayed). Yes… main use case for PARTITIONing. I go into more details (and code) here: http://mysql.rjweb.org/doc.php/partitionmaint The third use case for PARTITIONing involves 2D-like indexing. I have not found a 4th use case…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… which should produce updates in-place (I will use INSERT .. ON DUPLICATE KEY UPDATE statements for that…(60) DEFAULT ” NOT NULL, PRIMARY KEY (id) ) CREATE INDEX k on sbtest$I(k) and tables …myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-…
Comment: Percona MySQL Webinar: Really Large Queries: Advanced Optimization Techniques, Feb. 27
March 25, 2013 By 2 Comments
Peter, Can you have a look at this: http://stackoverflow.com/questions/15619755/why-would-adding-a-duplicate-index-make-mysql-use-the-correct-index-not-the-dup
Comment: Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?
April 10, 2013 By 2 Comments
… our first alpha of Percona XtraBackup for MySQL 2.1″ Is anybody even still using MySQL 2.1? Or do you actually mean “We just released our first alpha of Percona XtraBackup 2.1 for MySQL” which would make more sense. Just thinking about how google is going to index your page. You…
