… that the single-node configuration used 16 threads (8 cores on a single socket x 2 threads per socket), while the second one…(*) from sbtest$i WHERE k like ‘%0%’ SysBench-0.5/lua: POINT_SELECT QPS test sysbench –num-threads=<1..1024> –test=oltp.lua….sock –oltp-point-selects=9 –oltp-simple-ranges=0 –oltp-sum-ranges=0 –oltp-order-ranges=0 –oltp-distinct-ranges=0 –oltp-skip-trx=on…
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 21 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: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
…2 97% 0.0 2.0 8% 0 36.0 9.3 0.2 0% 0.2 4.2 6.0 109.3 0.3 93% 0.0 0.2 15% 0 12.0 8.7 0.1 0% 0.1 4.2 6.0 101.3 0…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1359714063/*!*/; ALTER TABLE test add column id_2 int(11) default 0 after id /*!*/; # at 658 #130201 11:21:39 server id 1 end_log_pos 726 Query thread… is_null=0 */ ### SET ### @1=2 /* INT meta=0 nullable=0 is_null=0 */ ### @2=0 /* INT meta=0 nullable=1 is_null=0 */ ### @3=’hop’ /* STRING(9) meta=65033…
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: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… | +—-+—————+——–+ | 2 | percona1 | lefred | | 3 | percona2 | kenny | | 5 | percona1 | liz | | 9 | percona1 | ewen | | 10 | percona2 | jay | +—-+—————+——–+ 5 rows in set (0….():34 120723 23:45:30 [Note] WSREP: applier thread exiting (code:7) 120723 23:45:30 [ERROR] …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 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…
