… meaning using a single set of datafiles that support multiple copies of the source database. Would be interested if someone wanted… supports multiple consumers and appears that each has an exclusive copy of that source data. (see http://www.dbms2.com/2013…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer improvements. However, I plan to focus on… are engine-dependent, like redundant suffixes for secondary keys in InnoDB. As some of this redundancies could be necessary, depending on…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
Does this version of xtrabackup backup of used pages only? We use xtrabackup_55 version 2.1.3 and basically copies entire database to another folder, and us later we run tar+gzip to save space.
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… -f /etc/cluster/cluster.conf Configuration validates We can now copy the configuration file on all nodes: [root@percona1 ~]# scp /etc…
Comment: ZFS on Linux and MySQL
May 28, 2013 By 17 Comments
… before. @Nils, In a way that is true. Imagine running InnoDB over XFS, you will end with two sets of checksums – one that of InnoDB and other of XFS itself. In case of InnoDB, the block size – 16k – is much…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage… a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed the RPM packaging regression that was…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
@JDempster: I could give the SSD to xfs also with Flashcache and the like. Don’t forget all these jbods have a raid controller write cache in front of them. I also did the Innodb tuning. @Nils: no fuse, direct kernel support. Look here: http://zfsonlinux.org/
Comment: How to calculate a good InnoDB log file size
May 22, 2013 By 38 Comments
…* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql -BNe’show engine innodb status\G’ | grep sequence && ls -l…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 22, 2013 By 32 Comments
Does Percona have improvements to keep the InnoDB insert buffer from getting full (as in do background reads for ibuf merges when it is getting full)? That is the key to sustaining good throughput for InnoDB on iibench.
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 22, 2013 By 32 Comments
Hi Vadim, I can confirm the steady downfall of InnoDB throughput down to ~1500 insert/sec (and counting) while TokuDB …
