…’ve seen performance issues with large query_cache_size also sort_buffer_size and read_buffer_size may not give you better performance if… test on CentOS 5.3, Xeon E5405, 16GB RAM and EXT3 file system on the SATA hard drive. MySQL 5.0… in Performance focused MySQL 5.4. As we can see large table_cache (or table_open_cache_ values indeed can cause significant performance problems…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…database directory to get more efficient backup. EXT3 file system works OK in most cases…READ-COMMITED isolation mode – if it does – set it to be default as transaction-isolation=READ-COMMITTED. This option has some performance… on hardware without battery backed up cache with no OS changes and have …
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… a filesystem allows when it comes to competing reads/writes. I believe that ext3 is taking an exclusive rwlock on each write… so) all of the indirect address blocks are cached and ext3 resumes the “raw” performance. But once the snapshot is created it plummets…. Bigger write ratio has even a more drastic effect on ext3 + snapshot performance. “randomio” might not be a good representation of what…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…ran tests for MyISAM and Innodb tables on ext3 filesystem. Here is what I found: The … I used default MySQL settings for MyISAM (table_cache=64) and set innodb_buffer_pool_size=8G…significant overhead for insert with many tables. The read performance, which is the main measurement for this benchmark…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-query-demo-data-flatfiles 30GB ext3 EBS This is an ext3 volume which contains the flat… or database About the cluster For best performance, there should be an even data distribution…cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ…
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
… would be that performances wouldn’t improve much after a certain size is reached). Domas, does this differs from ext3‘s data… intensives, reads, and cpu bound moments, not just huge sustained writes) would give controller better chances to reorder properly before cache being… perceived performances may be more reflected by per-request time to completion (so, latency). I mean workloads including possibles concurrents reads and…
Comment: Slow DROP TABLE
June 17, 2009 By 21 Comments
… tmpfs, and using a disk store like ext3: 1) Our database is typically 100% cached (both data and indexes), 16 – 20 GB… is not an issues since all reads are cached and the few writes we have are not performance critical. I’m just wondering… need on disk, since our ram is mostly dedicated to caching the db / indexes). I’d go spelunking, but have no…
Comment: Linux schedulers in tpcc like benchmark
October 27, 2009 By 19 Comments
…Cached, Adaptive Read-ahead. Kernel 2.6.31.5 (Arch Linux). Very short recap with some numbers (40 simultaneous seq reads): XFS+noop: 140MB/s EXT3+noop: 133MB/s EXT4+noop: … this setup: – XFS beats EXT*, with EXT4 performing badly and also being unstable – cfq vs…
