… data will compress much more. That gives us much more disk space than we expected so even more snapshots! Integrity With ZFS each record on disk has a checksum. If a cosmic ray flip a bit… from the other drive in the mirror. Better availability and disk usage On purpose, I allocated mirror pairs using drives from…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… don’t like DRBD with virtual machines. First is the disk IO performance hit that comes with DRBD. When you run a virtual machine, in most cases your virtual disk is basically nothing more than a file on the host…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… is huge, it eventually starts creating a temp table on disk. Now during those 300 second, other ‘innocuous’ queries which perform…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… quickly and reliably Uninterrupted transaction processing during backups Savings on disk space and network bandwidth Automatic backup verification Higher uptime due…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… I need to start writing massive amounts of data to disk. I could go out and buy a bunch of SSDs… that while SSDs are a lot faster than regular spinning disk, a PCIe flash card is still massively faster than an… or HDD RAID), I can write data out to spinning disk at a nice sustainable rate. @Mark- I don’t know…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… = 128 M Of 21559 temp tables, 44% were created on disk Perhaps you should increase your tmp_table_size and/or max_heap_table_size to reduce the number of disk-based temporary tables Note! BLOB and TEXT columns are not… raising these values might not impact your ratio of on disk temp tables.
Comment: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…Mark– The backing disk on this server is an 8-disk RAID 10 of fairly standard SAS drives. Your proposed test …
Comment: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… data in flash and much more data on disk. Where/what are the disks in this benchmark? The benchmark database is small…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… to persist after a crash, it has to get to disk. This has no effect on standard MySQL replication from this… data as well, though not by ensuring it goes to disk (though you can do that). We protect the data by…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… like: pt-stalk, vmstat, top, iostat, etc all saving to disk with the current time stamp in front of each line… size limit is 5GB. So, about 28GB was written to disk in a short while. Here’s the vmstat output during…
