Tips:
1. FORMAT: shell>sh load_data.sh sf 0.2
2. 功能主要包括生成用户指定sf值的数据量，导入数据进数据库表中，显示表状态，并计算表空间和索引空间大小

PATH_DATA=/home/tracylling/tpch/dbgen
DATABASE=tpch

TABLES=”lineitem”
export LANG=zh_CN.utf8

echo $1 = $2

cd $PATH_DATA
./dbgen -v -T L -s $2

echo “Load table lineitem”
mysql -uroot -pll -S /var/run/mysqld/mysqld.sock -D $DATABASE -e “TRUNCATE TABLE $TABLES”

echo `date`
mysql -uroot -pll -S /var/run/mysqld/mysqld.sock -D $DATABASE -e “LOAD DATA LOCAL INFILE ‘$PATH_DATA/$TABLES.tbl’ INTO TABLE $TABLES FIELDS TERMINATED BY ‘|'”

mysql -uroot -pll -S /var/run/mysqld/mysqld.sock -D $DATABASE -e “SHOW TABLE STATUS\G”

mysql -uroot -pll -S /var/run/mysqld/mysqld.sock -D information_schema -e ”
SELECT CONCAT(table_schema,’.’,table_name) AS ‘Table Name’,
CONCAT(ROUND(table_rows/1000000,2),’M’) AS ‘Number of Rows’,
CONCAT(ROUND(data_length/(1024*1024),2),’MB’) AS ‘Data Size’,
CONCAT(ROUND(index_length/(1024*1024),2),’MB’) AS ‘Index Size’ ,
CONCAT(ROUND((data_length+index_length)/(1024*1024),2),’MB’) AS’Total’FROM information_schema.TABLES WHERE table_schema LIKE ‘$DATABASE'”