… used: Locate an existing snapshot that contains the schema you are interested in (/tmp/snapshot/2013-06-03_11-30/orig) Get…’ AND ENGINE=’InnoDB‘; EOF For full disclosure, here are the versions I was using on my test VM: Percona Server 5.5.30 Xtrabackup…
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 used O_DIRECT when I… it might be from LinkBench. The LinkBench (at least I used at the time) seems strongly depend on GC of java…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… likely not hitting a bottleneck caused by compression. If I use SSD for L2ARC, I’ll need to do the same… for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…old data if you don’t need to?). I get up to speed a lot faster and can …case here is the properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=… NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `id` int…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…’re talking about using a temporary table to store an interim result set, and then use that to ultimately produce the result you want… you have irregular distribution of matching rows that you’ll get skewed results. For instance, if there’s a gap of id…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and… We get no warnings and no errors in 5.6, as the indexes are different. But as you may know, we can use…
Comment: ZFS on Linux and MySQL
May 28, 2013 By 17 Comments
Yes, since XFS uses transactional model, metadata checksums may be sufficient. With full data … sets of checksums – one that of InnoDB and other of XFS itself. In case of InnoDB, the block size – 16k – is much…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors of suboptimal. On Wednesday, June 5, at…technologies available today (largely grouped into those which use traditional MySQL replication, those which use some other MySQL-level replication, and those…
Comment: ZFS on Linux and MySQL
May 27, 2013 By 17 Comments
… to have metadata checksums. d) What compression algo does ZfsOnLinux use? Is gzip-1 by default? btrfs supports LZO etc. too… latest entrant to filesystem is Tux3 which is showing impressive results in performance.
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.5.31-30.3[/caption] Percona is glad to announce the… could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed the RPM packaging regression that…
