… done using this script: The benchmark run with following simple shell script: [root@DB10 ~]# for i in 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql…to drop performance 20 times. Innodb in single tablespace mode showed following results…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
…. (Alexey Kopytov) Bug #688211 – Using the –password option with innobackupex to specify MySQL passwords containing special shell characters (such as “&”) did not … the CMake scripts actually expect. (Alexey Kopytov) Bug #713799 – Dropping a table during a backup process could result in assertion …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… command line (shell) on the server and go to the directory …mysql-5.0.51a) % patch -p1 < ../patch-mysql-5.0.51a-msl.diff patching file include/my_time.h patching file scripts…to set this to “full_scanâ€, while in order to get only those which use on-disk temporary storage for intermediate results…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… MySQL server running Percona XtraDB for a gaming workload (mostly inserts to the “moves” table), I used strace to…with a little more shell scripting, but the output from this was enough for me to massage into a decent format with another step or two! Here is the final result: …
