1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148
|
#!/bin/sh
#
# Execute some simple basic test on MyISAM libary to check if things
# works at all.
valgrind="valgrind --alignment=8 --leak-check=yes"
silent="-s"
if test -f mi_test1$MACH ; then suffix=$MACH else suffix=""; fi
mi_test1$suffix $silent
myisamchk$suffix -se test1
mi_test1$suffix $silent -N -S
myisamchk$suffix -se test1
mi_test1$suffix $silent -P --checksum
myisamchk$suffix -se test1
mi_test1$suffix $silent -P -N -S
myisamchk$suffix -se test1
mi_test1$suffix $silent -B -N -R2
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -k 480 --unique
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -N -S -R1
myisamchk$suffix -sm test1
mi_test1$suffix $silent -p -S
myisamchk$suffix -sm test1
mi_test1$suffix $silent -p -S -N --unique
myisamchk$suffix -sm test1
mi_test1$suffix $silent -p -S -N --key_length=127 --checksum
myisamchk$suffix -sm test1
mi_test1$suffix $silent -p -S -N --key_length=128
myisamchk$suffix -sm test1
mi_test1$suffix $silent -p -S --key_length=480
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -B
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -B --key_length=64 --unique
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -B -k 480 --checksum
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -B -k 480 -N --unique --checksum
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -m
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -m -P --unique --checksum
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -m -P --key_length=480 --key_cache
myisamchk$suffix -sm test1
mi_test1$suffix $silent -m -p
myisamchk$suffix -sm test1
mi_test1$suffix $silent -w -S --unique
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -w --key_length=64 --checksum
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -w -N --key_length=480
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -w -S --key_length=480 --checksum
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -b -N
myisamchk$suffix -sm test1
mi_test1$suffix $silent -a -b --key_length=480
myisamchk$suffix -sm test1
mi_test1$suffix $silent -p -B --key_length=480
myisamchk$suffix -sm test1
mi_test1$suffix $silent --checksum
myisamchk$suffix -se test1
myisamchk$suffix -rs test1
myisamchk$suffix -se test1
myisamchk$suffix -rqs test1
myisamchk$suffix -se test1
myisamchk$suffix -rs --correct-checksum test1
myisamchk$suffix -se test1
myisamchk$suffix -rqs --correct-checksum test1
myisamchk$suffix -se test1
myisamchk$suffix -ros --correct-checksum test1
myisamchk$suffix -se test1
myisamchk$suffix -rqos --correct-checksum test1
myisamchk$suffix -se test1
# check of myisampack / myisamchk
myisampack$suffix --force -s test1
# Ignore error for index file
myisamchk$suffix -es test1 2>&1 >& /dev/null
myisamchk$suffix -rqs test1
myisamchk$suffix -es test1
myisamchk$suffix -rs test1
myisamchk$suffix -es test1
myisamchk$suffix -rus test1
myisamchk$suffix -es test1
mi_test1$suffix $silent --checksum -S
myisamchk$suffix -se test1
myisamchk$suffix -ros test1
myisamchk$suffix -rqs test1
myisamchk$suffix -se test1
myisampack$suffix --force -s test1
myisamchk$suffix -rqs test1
myisamchk$suffix -es test1
myisamchk$suffix -rus test1
myisamchk$suffix -es test1
mi_test1$suffix $silent --checksum --unique
myisamchk$suffix -se test1
mi_test1$suffix $silent --unique -S
myisamchk$suffix -se test1
mi_test1$suffix $silent --key_multiple -N -S
myisamchk$suffix -sm test1
mi_test1$suffix $silent --key_multiple -a -p --key_length=480
myisamchk$suffix -sm test1
mi_test1$suffix $silent --key_multiple -a -B --key_length=480
myisamchk$suffix -sm test1
mi_test1$suffix $silent --key_multiple -P -S
myisamchk$suffix -sm test1
mi_test2$suffix $silent -L -K -W -P
myisamchk$suffix -sm test2
mi_test2$suffix $silent -L -K -W -P -A
myisamchk$suffix -sm test2
mi_test2$suffix $silent -L -K -W -P -S -R1 -m500
echo "mi_test2$suffix $silent -L -K -R1 -m2000 ; Should give error 135"
myisamchk$suffix -sm test2
mi_test2$suffix $silent -L -K -R1 -m2000
myisamchk$suffix -sm test2
mi_test2$suffix $silent -L -K -P -S -R3 -m50 -b1000000
myisamchk$suffix -sm test2
mi_test2$suffix $silent -L -B
myisamchk$suffix -sm test2
mi_test2$suffix $silent -D -B -c
myisamchk$suffix -sm test2
mi_test2$suffix $silent -m10000 -e8192 -K
myisamchk$suffix -sm test2
mi_test2$suffix $silent -m10000 -e16384 -E16384 -K -L
myisamchk$suffix -sm test2
mi_test2$suffix $silent -L -K -W -P -m50 -l
myisamlog$suffix
mi_test2$suffix $silent -L -K -W -P -m50 -l -b100
myisamlog$suffix
time mi_test2$suffix $silent
time mi_test2$suffix $silent -K -B
time mi_test2$suffix $silent -L -B
time mi_test2$suffix $silent -L -K -B
time mi_test2$suffix $silent -L -K -W -B
time mi_test2$suffix $silent -L -K -W -S -B
time mi_test2$suffix $silent -D -K -W -S -B
|