mysql_bench_test1.sh

#!/bin/bash

DB_ROOT_USER=root
DB_ROOT_PASS=root

set -e
set -x

cat - <<EOF > /tmp/db_test0.sql
DROP DATABASE IF EXISTS vim_test0;
CREATE DATABASE vim_test0;
USE vim_test0;

DROP TABLE IF EXISTS testtabint;
CREATE TABLE testtabint (
  id smallint(5) NOT NULL,
  name varchar(10),
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='testing it';

GRANT ALL PRIVILEGES ON vim_test0.* TO 'vim'@'localhost' IDENTIFIED BY 'vimpw';
EOF

cat - <<EOF > /tmp/insert_test0.sql
INSERT INTO testtabint (id, name) VALUES (12, 'ciao');
EOF

cat - <<EOF > /tmp/delete_test0.sql
DELETE FROM testtabint WHERE name = 'ciao';
EOF


mysql -u${DB_ROOT_USER} -p${DB_ROOT_PASS} < /tmp/db_test0.sql

sleep 1

while [ 1 ]; do
        echo "insert"
        time mysql -uvim -pvimpw vim_test0 < /tmp/insert_test0.sql 
        sleep 5
        echo "delete"
        time mysql -uvim -pvimpw vim_test0 < /tmp/delete_test0.sql
        sleep 5
done