…: ext4, mounted with nobarrier. The results for random write case (8 async IO threads): In general it shows stable throughput topping…/sec, but every 20 min, there is small drop to 87 MiB/sec, which I guess is related to internal garbage… getting to the peak throughput at 8 threads. And response time: For 8 threads, we may expect 0.62ms response time. In general…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
…. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18… 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97… 99 100 done. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825 InnoDB: is in the future! Current…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… 1694.0 77.1 | 378.8 0.1 0.1 2.9 0.1 1678.6 | 1341.6 0.1 74.4 1584.6 87.0 | 337.0 0.1 0.1 1.1 0.0 1670….8 0.1 73.3 1559.8 85.1 | 341.1 0.1 0.1 0.7 0.0 1693.7 | 1357.2 0.1 73.6 1480.5 87.1 | 336.5 0.1 0…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… 4381.82 13.22 8.03 1.02 0.94 0.93 102.13 dm-0 0.00 0.00 1091.53 0.62 8760.33 4….27 4.87 247.70 0.27 0.52 0.52 27.22 dm-0 0.00 0.00 542.60 0.61 130724.54 4.87 65362.27 2.43 240.66 0.28 0…
Post: Too many connections? No problem!
March 23, 2010 By 28 Comments
… ever happen to you in production? [percona@sandbox msb_5_0_87]$ ./use ERROR 1040 (00000): Too many connections Just happened to… the application? Here’s the trick: [percona@sandbox msb_5_0_87]$ gdb -p $(cat data/mysql_sandbox5087.pid) \ -ex “set max…_5_0_87]$ ./use Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.0.87…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
…: 0 1 0 24132256 73252 8248788 0 0 259 590 1271 531 0 0 92 8 0 0 1 0 24135976 73284 8244964 0 0 413 938 1427 761 0 0 87 12 0 0 1 0 24139572 73308 8241300 0 0 399 905 1412 736 0 0 87 12 0 0 1 0…
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
…0 | 5 | 242 | 0 | 3 | 0 | 8 | 7 | unknown | | | | | 7 | 0 | 6 | 3006 | 0 | 0 | 0 | 9 | 6 | unknown | | | | | 8 | 0 | 45 | 0 | 0 | 0 | 0 | 10 | 2 | undo_log | | | | | 9 | 0 | 50 | 0 | 0 | 0 | 0… | 15054 | 0 | 0 | 51 | 17855 | index | PRIMARY | art | author87 | | 87 | 1 | 3340 | 286 | 15082 | 0 | 0 | …
Comment: Returning to InnoDB scalability
August 4, 2006 By 42 Comments
…0 | 0 | 0 | 0 | 0 | | &(table->autoinc_mutex) | dict0mem.c | 8 | 0 | 0 | 0 | 0 | 0 | | &(table->autoinc_mutex) | dict0mem.c | 178 | 0 | 0 | 0 | 0 | 0 | | &(table->autoinc_mutex) | dict0mem.c | 174 | 0 | 0 | 0 | 0 | 0…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… Factor Type Type Detail ========= ======== ================= ============= ============= =========== DIMM_A1 4096 MB 1333 MHz (0.8 ns) DIMM {OUT OF SPEC} Other … # Disk Schedulers And Queue…. That said, benchmark was running on a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data…_prg {925} dm-0 462.1 34.1 7.7 0% 3.8 8.2 12.1 87.0 0.5 0% 0.0 0.7 93% 0 While number of operations…
Post: Which adaptive should we use?
September 15, 2009 By 14 Comments
… modified age %/max behavior 0 ~ 50% nothing 50% ~ 75% constant flushing (weak) 75% ~ 87.5% constant flushing (strong) 87.5% ~ (flushing storm) < adaptive... method)> oldest modified age %/max behavior 0 ~ 50% nothing 50% ~ 87.5% estimate flushing as bellow * 87.5% ~ (flushing storm) * estimate blocks to… innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_flush_method = O_DIRECT innodb_thread_concurrency = 0 innodb_ibuf_active_contract…
