… transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned … That rarely happens in real life. There are no systems that…of day/week/month/year though). And what is important for an end…). We vary working threads from 1 to 128. There are results…fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;…
Post: MySQL End Of Life (EOL) Policy
August 22, 2008 By 6 Comments
… MySQL Community users this means only releases within Active Life Cycle will be made. For example MySQL 4.1 had end of its Active Lifecycle in the end of 2006. and indeed Latest MySQL 4.1 available for…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…too many tools out there that can make your life easy. However, there is one such tool, pt-… wp_pp_hits # 10 0x88BA308B9C0EB583 0.0905 1.1% 4 0.0226 1.00 0.01 SELECT poller_item # 11 …execution plan used by MySQL. The end result might be that you end up limiting the number of results returned by …
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…of all caches compared to MySQL Server, by measuring just the time it takes cache to return the data. In the real life…home test box (2Ghz AMD Sempron CPU) using MySQL 4.1 and PHP 5.0. For memcached access …should note MySQL is rather fast selecting from the table as well – on this pretty low end …
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
…/4 – mke2fs -b 4096 -E stride=16,stripe-width=80 /dev/ice (some older versions of… total 2339840000 sectors Units = sectors of 1 * 512 = 512 bytes … Device Boot Start End Blocks Id System /dev/sda1…may be interesting to see what are real life effects of misalignment, my benchmark results are in the …
Comment: FlashCache: tpcc workload with FusionIO card as cache
June 8, 2010 By 20 Comments
…MySQL systems. They tried several configurations (usually 4 drives, they tried hardware RAID, software RAID, RAID 1…drivers, we do constant monitoring of estimated remaining life (based on number of writes to each cell), free… and we still saved money in the end, not to mention the power, rack space, …
