Documentation Home
MySQL Internals Manual


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

26.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
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.