dbt2-benchmark-tool

dbt2 설치

$ tar zxvf dbt2-0.37.50.10.tar.gz
$ cd dbt2-0.37.50.10
$ mkdir /engn001/masvc01/dbt2
$ ./configure --prefix=/engn001/masvc01/dbt2 --with-mysql-includes=/engn001/masvc01/GAAID/mysql/include/mysql --with-mysql-libs=/engn001/masvc01/GAAID/mysql/lib --with-mysql=/engn001/masvc01/GAAID/mysql
$ make
$ make install
$ vi .bash_profile
export PATH=$PATH:/data001/engn001/masvc01/dbt2/bin 추가

data 생성

mkdir /data001/masvc01/DBT2
datagen -w 20 -d /data001/masvc01/DBT2 --mysql
cd /engn001/masvc01/dbt2-0.37.50.10/scripts/mysql
vi mysql_load_db.sh
..
NEW_ORDER="CREATE TABLE new_order (
  no_o_id int(11) NOT NULL default '0',
  no_d_id int(11) NOT NULL default '0',
  no_w_id int(11) NOT NULL default '0',
  PRIMARY KEY  (no_w_id,no_d_id,no_o_id),
  KEY ix_no_wid_did(no_w_id,no_d_id) <- 추가
)"

..