Documentation Home
MySQL Internals Manual
Download this Manual
EPUB - 0.8Mb


MySQL Internals Manual  /  ...  /  Stability Checks for Random Timing Problems

25.6.1 Stability Checks for Random Timing Problems

  • Recommended Several test runs (<number>), use an memory based (extreme fast) filesystem if available

./mysql-test-run.pl --mem .... --repeat=<number> <your test> 
  • Several test runs, use a "slow" disk based filesystem

rmdir var # "var" must not be a symlink pointing into a RAM based filesystem
./mysql-test-run.pl .... --repeat=<number> <your test>
  • Recommended Generate parallel load on the CPUs and/or the disk where MTR2 reads and writes data (in most cases directory "var"). Examples:

  • all OS: Compile a MySQL version from source

  • Unix derivates (OpenSolaris,Linux,OSX,...): tar -chvf - <some path> > /dev/null

  • Unix derivates: root: dd if=<area of disk containing the "var" directory> of=/dev/null

  • Windows: Defragmentation

rmdir var # "var" must not be a symlink pointing into a RAM based filesystem
./mysql-test-run.pl .... --repeat=<number> <your test>

  • all OS:

./mysql-test-run.pl .... --repeat=<number> --parallel=8 <your test> 

User Comments
Sign Up Login You must be logged in to post a comment.