… also use CPU bound workload in this case (no disk IO) to see how efficient storage engines are in terms of CPU usage. In… model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz stepping : 6 cpu MHz : 1995.004 cache size : 4096 KB 16GB of RAM… –falcon_max_record_memory=2GB –falcon_page_cache_size=1500M –max-connections=1500 –table-cache=512 –net_read_timeout=30 –net_write…
Post: Just do the math!
July 6, 2009 By 4 Comments
…file fragmentation, on other hand there is also caching which may be taking place. Depends on …be slowed down 100-1000 then going from CPU bound to IO bound workload. You can get approximate numbers … reports. Finally let me talk about modeling vs benchmarking for capacity planning. I’m sure …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
….000 Models | 24xIntel(R) Xeon(R) CPU X5650 @ 2.67GHz Caches | 24×12288 KB # Memory ##################################################### Total | … an IO bound read-write oltp benchmark in autocommit mode. File IO benchmark For…was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This …
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… main topic of the article lets comment on IO vs Disk question. If you look at Disk Based …are treated as IOs – it can be “logical” if they are cached or “phyiscal” if they require actual IO done … IO and as not as I typically use these terms. For me IO is IO bound workload – disks are moving and CPU…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com…CPU bound workload in this case (no disk IO) to see how efficient storage engines are in terms of CPU…cpu family : 15 model : 6 model name : Intel(R) Xeon(TM) CPU 3.20GHz stepping : 8 cpu MHz : 3192.222 cache…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…server the difference for most enterprises vs most of web applications in …- Sharding and Caching. Indeed Memcache is the most known caching technologies today,…IO and so consolidate system suffering from IO bound workloads. There is KickFire appliance around the corner which more focuses on CPU bound…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…to reduce number of TLB cache misses. huge pages along however do not stop IO pressure and OS may swap…3x performance boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of the …the official InnoDB, though. PZ: If your load is CPU bound and you’re scaling out you can get better…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…and risks . First lets talk about optimizing application vs getting better hardware. With application optimization … CPU bound query takes 30 seconds you unlikely will be able to solve the problem by CPU …caching to upload it or to get some higher end box with few cores 16-32G of RAMs and good IO…
Post: How simple answer are you looking for ?
April 11, 2007 By 5 Comments
… of variables add in – covering indexes, skewed distribution vs lookup frequency, IO bound or CPU bound workload which may be far too complicated. It is… Compared to Your Database Size Should you Have” , “What Key Cache Hit Ratio is Good One” This often gives me head…
