#!/bin/bash

killall mysqld 
sleep 15
killall -9 mysqld 
sleep 5

./mysqld --defaults-file=~/my1.cnf &

sleep 20

mysql -uroot -A sbtest << EOF

# warm up
select count(*) from (SELECT c from sbtest1 where id between 499160 and 499170) z;

### 1
set @start=(select VARIABLE_VALUE from information_schema.SESSION_STATUS
where variable_name like 'Innodb_buffer_pool_read_requests');

SELECT c from sbtest1 where id between 499160 and 499170;

select ((select VARIABLE_VALUE from information_schema.SESSION_STATUS where
variable_name like 'Innodb_buffer_pool_read_requests') - @start ) as incr, 'OUT';

### 2
set @start=(select VARIABLE_VALUE from information_schema.SESSION_STATUS
where variable_name like 'Innodb_buffer_pool_read_requests');

SELECT c from sbtest1 where id between 499160 and 499170;

select ((select VARIABLE_VALUE from information_schema.SESSION_STATUS where
variable_name like 'Innodb_buffer_pool_read_requests') - @start ) as incr, 'OUT';

### 3
set @start=(select VARIABLE_VALUE from information_schema.SESSION_STATUS
where variable_name like 'Innodb_buffer_pool_read_requests');

SELECT c from sbtest1 where id between 499160 and 499170;

select ((select VARIABLE_VALUE from information_schema.SESSION_STATUS where
variable_name like 'Innodb_buffer_pool_read_requests') - @start ) as incr, 'OUT';

### 4
set @start=(select variable_value from information_schema.session_status
where variable_name like 'innodb_buffer_pool_read_requests');

select c from sbtest1 where id between 499160 and 499170;

select ((select variable_value from information_schema.session_status where
variable_name like 'innodb_buffer_pool_read_requests') - @start ) as incr, 'OUT';

### 5
set @start=(select VARIABLE_VALUE from information_schema.SESSION_STATUS
where variable_name like 'Innodb_buffer_pool_read_requests');

SELECT c from sbtest1 where id between 499160 and 499170;

select ((select VARIABLE_VALUE from information_schema.SESSION_STATUS where
variable_name like 'Innodb_buffer_pool_read_requests') - @start ) as incr, 'OUT';

EOF