… Per second averages calculated from the last 44 seconds Make sure data is sampled for at least 20-30 seconds. … at the same time. Also number of pending fsync operations is displayed. For writes Innodb has to…page 0 Pages read 57973114, created 251137, written 10761167 9.79 reads/s, 0.31 creates/s, 6…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…will be consuming all CPU when we’re running 16 seconds per second. Of course no system scale perfectly, so you …use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for your disk IO estimation. When you can divide …0 # pages distin 17.51M 1 44.28k 10.27 9.83 250.90 7.70 # queue wait 0 0 …
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
…Using mmap here and performing a kill -9 seems to preserve the changes in memory…tchdbsetecode(hdb, TCEMMAP, __FILE__, __LINE__, __func__); err = true; } if(fsync(hdb->fd) == -1){ tchdbsetecode(hdb, TCESYNC, __FILE__, __LINE…I had anywhere from 5 seconds of missing data to 60 seconds post crash. This …
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 9 Comments
…async writes, so this will emulate database load, and second, async mode allows to see maximal possible throughput, …file-io-mode=async –file-extra-flags=direct –file-fsync-freq=0 –file-block-size=16384 –report-interval=… giving a webinary “MySQL and SSD” on May-9. It will be the same as my talk …
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 12 Comments
…async writes, so this will emulate database load, and second, async mode allows to see maximal possible throughput, …file-io-mode=async –file-extra-flags=direct –file-fsync-freq=0 –file-block-size=16384 –report-interval=… giving a webinary “MySQL and SSD” on May-9. It will be the same as my talk …
Comment: MySQL Server Variables - SQL layer or Storage Engine specific.
December 1, 2006 By 14 Comments
….txt -p 4721 (4721 is the pid of mysql) % time seconds usecs/call calls errors syscall 84.78 18.000.427….484223 124 3906 pwrite 0.00 0.445093 404 1102 fsync 0.00 0.430290 72 6000 1500 lstat 0.00….000028 14 2 2 rt_sigreturn 0.00 0.000009 9 1 clock_gettime 100.00 21.231.713.014 13399213…
