…response times even for small amount of threads. For 8 threads the 95% response time is 0.69ms. Now let me get … percentiles. So there is no grow in throughput after 2 threads, and the result averages at 300 MiB/sec. I … be giving a webinary “MySQL and SSD” on May-9. It will be the same as my talk on …
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… XtraBackup 2.0! We call this version 1.9.1 as we are using the 1.9.x version numbers for betas of 2.0 to clearly differentiate beta releases from the final 2.0 release. We do…=4 –compress –compress-threads=2‘ will create 4 IO threads that will read the data and pipe it to 2 compression threads. New streaming format…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… better suited to more environments. The 2.0.0 release contains no changes from the last beta (1.9.2), only the version number has…, compression was only possible with streaming backups + external (usually single-threaded) compression utilities, which also had a number of other limitations…:30 – 16:20 @ Ballroom F You can download Percona XtraBackup 2.0.0 from our downloads site or install it using our YUM…
Comment: InnoDB thread concurrency
March 19, 2012 By 4 Comments
…thread 0 (thread id: 18578) state: waiting for completed aio requests (insert buffer thread) I/O thread 1 (thread id: 18579) state: waiting for completed aio requests (log thread) I/O thread 2 (thread…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
…-back cache in the controller in RAID1+0 configuration. First the raw numbers – 100 threads, 20% writes, 4K iosize. Iops reported are… 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.9 | 1334.9 0.1 75.0…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Delayed_errors’, ‘0‘ ‘Delayed_insert_threads‘, ‘0‘ ‘Delayed_writes’, ‘0‘ ‘Flush_commands’, ’5′ ‘Handler_commit’, ’19092941′ ‘Handler_delete’, ‘0‘ ‘Handler_discover’, ‘0‘ ‘Handler…, 2 running, 0 zombie, 0 stopped CPU states: cpu user nice system irq softirq iowait idle total 15.0% 0.0% 9.5% 0.0% 0….
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…] @ localhost [] # Thread_id: 1 Schema: test Last_errno: 0 Killed: 0 # Query_time: 0.117904 Lock_time: 0.002886 …0 816.04 0 # IO r ops 6 0 2 0.00 0 0.05 0 # IO r wait 64ms 0 26ms 13us 0 530us 0 # pages distin 28.96k 0…07 124.25 # Rows affecte 0 0 0 0 0 0 0 0 # Rows read 8 9.01k 0 216 61.90 202.40…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… # Report grouped by Thread_id # ######################################################################## # Item 1: 3.41 QPS, 0.97x …0.08 0.99 0.27 0 # Rows examine 1 4.97M 0 445.49k 9.80k 5.73k 49.33k 0 # Rows affecte 0 2 0 1 0.00 0 0.06 0…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…; asc a ;; *** (2) TRANSACTION: TRANSACTION 0 42313620, ACTIVE 24 sec, process no 10099, OS thread id 4078512 starting index read, thread declared inside InnoDB… thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2… 37491 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 57973114, created 251137, written 10761167 9.79 reads/s…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…_size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 200 port… ~9’600 iops (~150MB/s) at 1 thread, 14500 iops (~230MB/s) at 4 threads and ~16300 iops (~250MB/s) at 8 threads. Neither…_prg {540} dm-0 447.1 34.0 7.4 0% 2.4 5.4 23.4 49.6 0.6 0% 0.0 0.6 85% 0 Misaligned: #ts…
