…=0 while [ "$NUMROW" -gt "$COUNT" ] do UUID=`uuidgen` mysql test -e “insert into sorttest value (‘$UUID’);” let “…_size by steps of 32 KB and I recorded the time required to perform 12 queries like ‘select … required and then, the time for the queries loses all dependency over the sort buffer size. I …
Post: MySQL should have dynamic durability settings
April 8, 2008 By 4 Comments
…durability requirements you set it to 1 and log records are pushed directly to the disk on transaction commit…For some of updates you really would hate to lose them, though they may be rare. For example … for each transaction separately in session context. What MySQL Could do to take it further is to …
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… (no thinking time, no keying time), it uses MySQL C API and the server side prepared statement. …bigger value makes the more effort not to stock records to the insert buffer. (Though, the more IO … of “Ibuf: size” (like > 1000) may tend to losing the performance. If you have powerful IO system, …
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…Innodb updates buffer pool pages in memory and records page operations in the transaction (redo) log. …log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence …the log. We cannot overwrite that without potentially losing data on a crash, so Innodb does …
