#!/bin/sh -e

DATABASE="$1";
TABLE="$2";
TOTAL_ROWS="400000000";
TOTAL_VALUES="70000";

MYSQL="mysql -N --show-warnings -n -v -v -v $DATABASE";

$MYSQL << EOF
DROP TABLE IF EXISTS $TABLE;
CREATE TABLE $TABLE (id INT NOT NULL DEFAULT 0) ENGINE=MyISAM;
EOF

namedpipe="/tmp/$TABLE.$$";
[ -p $namedpipe ] && rm $namedpipe;
mkfifo --mode=0666 $namedpipe;
awk -vTOTAL_ROWS=$TOTAL_ROWS -vTOTAL_VALUES=$TOTAL_VALUES 'BEGIN {for (i = 0; i < TOTAL_ROWS; i++) {print int(rand() * TOTAL_VALUES);} }' > $namedpipe & $MYSQL -e "LOAD DATA INFILE '$namedpipe' INTO TABLE $TABLE";
[ -p $namedpipe ] && rm $namedpipe;

$MYSQL << EOF
ALTER TABLE $TABLE ADD INDEX(id);
DESC $TABLE;
SHOW CREATE TABLE $TABLE;
CHECK TABLE $TABLE;
EOF