… performance penalities associated with CoW. Now, they have their own optimizations for this (like larger btrfs metadata block size etc.). b… 3.9) and zfsonlinux (latest) are benchmarked. c) Regarding integrity, XFS from 3.10 is going to have metadata checksums. d…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… a gazillion FAQs and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options. I wanted… (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00051fe9 Device Boot Start… not start on a RAID stripe boundary. Create the Filesystem XFS requires a little massaging (or a lot). For a standard…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… it with basics of Hardware OS And Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well for wide range of applications, though the optimal settings of course depend on the workload. Hardware If you… if you’re running in particular roadblocks with it try XFS. You can use noatime and nodiratime options if you’re…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
….088 TB 1 (1-0-0) 2 2-2 64 Optimal WT, RA PhysiclDev Type State Errors Vendor Model Size ========== ==== ======= ====== ======= ============ =========== Hard… minimize the effects of misalignment. File system of choice was XFS. Barriers and physical disk cache was disabled. The tool I… written before this was set may still be unaligned, though xfs defragmentation may be able to fix that (not verified). 6…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…=0 optimizer_switch=’index_condition_pushdown=on’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_cost_based=off’ read_rnd_buffer_size=32M optimizer_switch… query_cache_type=0 optimizer_switch=’index_condition_pushdown=on’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_sort_keys=on’ optimizer_switch=’mrr_cost… disks are 5.4K RPM disks. The filesystem used is XFS, and the OS installed is Centos 6.2 Table Structure…
Post: Slow DROP TABLE
June 16, 2009 By 21 Comments
… ENGINE=…; DROP TABLE large_table; TRUNCATE TABLE large_table; OPTIMIZE TABLE large_table; DROP TABLE large_table; Unfortunately as it… out each of the administrative commands like ALTER TABLE or OPTIMIZE TABLE one way or another uses LOCK_open mutex when… only alternative seems to be changing the file system. To XFS for example, which handles file removals much more efficiently: EXT3…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…/downloads/valgrind-3.8.1.tar.bz2 # Or newer tar -xf valgrind-3.8.1.tar.bz2 cd valgrind-3.8… (downloaded ‘GA’ [generally available] packages may contain optimized or stripped binaries, which are optimized for speed rather than debugging). If the binaries…
Comment: White Paper: "Scaling MySQL Deployments Efficiently" from Percona and Virident
February 10, 2011 By 2 Comments
… to optimize a server when you cut the number of services on it. E.G a better filesysystem for mysql (XFS) compared…
Post: Working with many files and file system fragmentation
March 18, 2008 By 11 Comments
Working on performance optimization project (not directly MySQL related) we did a test – creating … see how other filesystems deal with this problem, for example XFS with delayed allocation may be doing better job. I also…
