…? For many reasons: the first one because it would break 99% of all applications out there that use MySQL, for which…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… long) | — buf_LRU_free_block(buf_page_t*, unsigned long) | |–99.94%– buf_LRU_scan_and_free_block(buf_pool_t…_func(rw_lock_t*, unsigned long, char const*, unsigned long) | |–99.14%– buf_LRU_free_block(buf_page_t*, unsigned long…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… –forced-shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB… –forced-shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 11, 2013 By 13 Comments
… may be much better than InnoDB, but I assume for 99% applications/workloads mainline innodb/xtradb with mysql/percona/mariadb server…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
2 Andy. I mean that in most queries (99%) data was only inserted, not updated. I inserted data with mostly unique PK, That is part ON DUPLICATE KEY was not triggered.
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 2, 2013 By 10 Comments
… matter if I set batch size to 100 and lose 99 entries from cache?), etc.
Comment: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
… : 382474358784 (382.47GB) (reads), 33881456360448 (33.88TB) (writes) Remaining Life : 99.60% Garbage Collection Impact : Low Daughter Max Life_Left RAID Status Board ID Capacity (cycles) Groups 0 128 GiB 99.61% 0 2 4 6 GOOD 1 128 GiB… 5 7 GOOD 10 128 GiB 99.61% 0 2 4 6 GOOD 11 128 GiB 99.60% 1 3 5 7…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… sent 7.15M 0 56.36k 4.19 0.99 360.95 0.99 # Rows examine 33.77M 0 2.21M 19.81 0.99 3.53k 0.99 # Rows affecte 0 0 0 0 0 0… 0 507.86k 3.08 1.96 469.31 0.99 # Bytes sent 8.77G 11 55.41M 5.15k 3… 0 # Tmp tbl size 554.04M 0 12.83M 324.99 0 32.65k 0 # Query size 294.90M 14 783… r ops 947.67k 0 70.34k 0.54 0.99 56.64 0 # IO r wait 7127s 0 266s 4ms…
Post: Computing 95 percentile in MySQL
November 28, 2008 By 5 Comments
… performance analyzes you often would want to see 95 percentile, 99 percentile and similar values. The “average” is the evil of…. For larger systems defining (increasing) response times for 99.9 or even 99.99 percentile numbers often make sense. It also often makes… different from average numbers (it is not rare to see 99 percentile to be order of magnitude different from the average…
Post: Performance Optimization and Six Sigma
June 7, 2010 By 6 Comments
… time (probably inherited from these industry standards). Sometimes we use 99% response time as a guidance but this is not even… response time (one request per thousand being slow) and use 99 percentile over 5 minutes to graph response time stability. This… internet applications – A lot of applications like Gmail have 99.9 to 99.99 percent of uptime, and from the user point of…
