DB層レポート5章

Size: px

Start display at page:

Download "DB層レポート5章"

せせらほがり
4 years ago
Views:

1 1 OSDL DBT-1 PostgreSQL(ODBC) Linux MIRACLE LINUX V3.0 Asianux Inside )DBT-1 sshgccsysstatlibstdc PostrgreSQL autoconf DBT-1 1 DB (/etc/security/limis.conf) /etc/security/limits.conf nofile 2 MIRACLE LINUX hard

2 1.2.1 PostgreSQL PostgreSQL PostgreSQL beta beta1 tarball 1-2

3 PostgreSQL DBT-1 PostgreSQL(ODBC)UnixODBC Linux ODBC ODBC PostgreSQL ODBC ODBC UnixODBC psqlodbc DBT-1 PostgreSQL(ODBC)postgreSQL ODBC unixodbc psqlodbc unixodbc psqlodbc PostgreSQL Gborg 1-3

4 DBT1 c ODBC PostgreSQL pgsql odbc.ini DBT postgresql PostgreSQL ID=pgsql,=pgsql pgsql sudo root DBT-1 sudo /etc/sudoers root visudo PostgreSQL (1) PostgreSQL(ODBC) 1-4

5 pgsql ~/.bashrc export LD_LIBRARY_PATH=/usr/local/lib:/usr/local/pgsql/lib 1-5

6 1.3.2 DBT PostgreSQL(ODBC) (1) DBT-1 pgsql DBT-1 ( IPA ) (2) DBT-1 DBT-1 (3) DBT-1 1-6

7 1.4 DBT MIRACLE LINUX CD DBT (Text ) PostgreSQL -d (SAPDB PGSQL) -i -u -p -T i -- item c -- customer a -- author d -- address 1-7

8 o -- order p /tmp /tmp 3.5GB PostgreSQL(ODBC) PostgreSQL DBT1 1-8

9 DBT-1 ~/dbt1-v2.1/scripts/stats/dbt1.config MaxDB,MySQL dbt1.config [database] #hostname instance username password localhost:dbt1:dbt:dbt [cache] #hostname port dbconnections items appcache_executable_directory localhost:9999:5:10000:/home/dbt/dbt1-v2.1/cache [appserver] #hostname appserver localhost #port appserver 9992 #dbconnection RDBMS 20 #transaction_queue_szie dbdriver 1000 #transaction_array_szie 1000 #items #appserver executable directory appserver /home/dbt/dbt1-v2.1/appserver [dbdriver] #hostname dbdriver localhost #items #customers

10 #eu #eu/min 100 #mean think_time 7.2 #run_duration in seconds 4100 () #dbdriver executable directory dbdriver 1-10

11 () ":" (1) PostgreSQL PostgreSQL PostgreSQL pgsql DB #eu #transaction_queue_szie #transaction_array_szie # eu OSDL-J 1-11

12 DBT-1 DB appcache run_dbt1.sh (/home/dbt/u200 /home/pgsql/u200) BT BT PostgreSQL PostgreSQL(ODBC) 1-12

13 sar A run.sar.data 10 I/O iostat d io.txt 10 top d 120 b top.txt 120 I/O I/O select * from pg_stat_activity db_activity*.out *: select * from pg_stat_database where db_load*.out datname= DBT ; select relid, indexrelid, relname, index_info*.out indexrelname idx_blks_read, idx_blks_hit from pg_statio_user_indexes *: *: select * from pg_stat_user_indexes; indexes_scan*.out *: select relname,pid, mode, granted from lockstats*.out pg_locks, pg_class where relfilenode = *: I/O relation select relid, relname, table_info*.out heap_blks_read,heap_blks_hit,idx_blks_read, idx_blks_hit from pg_statio_user_tables; *: select * from pg_stat_user_tables; table_scan*.out *: select * from pg_locks where transaction is tran_lock*.out not NULL; *: DBT-1 BT mix.log DBT-1 BT/s OSDL DBT-1 dbdriver appserver (msec)bt 1-13

untitled

untitled HP OpenSource MySQL Server 5.0 Red Hat Enterprise Linux 4 ver 1.5 MySQL Red Hat Enterprise Linux 4 Super Smack Super Smac MySQL Super Smack RHEL4 1 2 MySQL SuperSmack SuperSmack 3 SuperSmack MySQL 4 MySQL