… ZFS metadata caching to make ZFS fast. NexentaStor recommends minimum 1-2GB ram for every 1TB raw storage. So in essence…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… the IDs for movies are distributed uniformly over the range 1..MAX(id)? Yes, there’s a risk if you have…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…`; # ######################################################################## # Summary of indexes # ######################################################################## # Size Duplicate Indexes 5 # Total Duplicate Indexes 1 # Total Indexes 3 Additionally, pt-duplicate-key-checker will detect…
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.
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… (think of replication 10 years ago or partioning in 5.1 for instance).
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
On Scenario #1, replace “change master to master_port=10001;” with “change master to master_port=10002;”
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
since I upgrade percona xtrabackup to 2.1.3. My node is crashed and I have this error …
Comment: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
pacemaker has been a real pain in the butt to work with on 6.4.
Comment: MySQL alternative Percona Server 5.1.68 -14.6 now available
May 28, 2013 By 3 Comments
Fran, The 5.1 files had been indeed removed (accidentaly) in a recent operation. They’ve been restored now. Thanks!
Comment: ZFS on Linux and MySQL
May 28, 2013 By 17 Comments
… full data checksum. d) I compared lzjb (default), lz4, gzip-1 and gzip-6. I may have found the main performance…
