Kouhei Sutou
null+****@clear*****
Mon Feb 8 14:35:56 JST 2016
Kouhei Sutou 2016-02-08 14:35:56 +0900 (Mon, 08 Feb 2016) New Revision: fcfd30c6dc3afd5c38b18aa063ecebb68d0c1e95 https://github.com/groonga/wikipedia-search/commit/fcfd30c6dc3afd5c38b18aa063ecebb68d0c1e95 Message: Restart daemon before each benchmark Modified files: benchmark/centos7/mysql.sh benchmark/centos7/postgresql.sh Modified: benchmark/centos7/mysql.sh (+12 -0) =================================================================== --- benchmark/centos7/mysql.sh 2016-02-07 20:55:25 +0900 (cfa2af5) +++ benchmark/centos7/mysql.sh 2016-02-08 14:35:56 +0900 (3549cfc) @@ -111,6 +111,8 @@ setup_benchmark_db() load_data_mroonga() { + run sudo -H systemctl restart mysqld + echo "Mroonga: data: load:" run mysql -u root ${mroonga_db} < \ "${config_dir}/schema.mroonga.sql" @@ -123,6 +125,8 @@ load_data_mroonga() load_data_innodb() { + run sudo -H systemctl restart mysqld + echo "InnoDB: data: load:" run mysql -u root ${innodb_db} < \ "${config_dir}/schema.innodb.sql" @@ -141,6 +145,8 @@ load_data() benchmark_create_index_mroonga() { + run sudo -H systemctl restart mysqld + for i in $(seq ${n_create_index_tries}); do echo "Mroonga: create index: ${i}:" mysql -u root ${mroonga_db} \ @@ -157,6 +163,8 @@ benchmark_create_index_mroonga() benchmark_create_index_innodb() { + run sudo -H systemctl restart mysqld + for i in $(seq ${n_create_index_tries}); do echo "InnoDB: create index: ${i}:" mysql -u root ${innodb_db} \ @@ -179,6 +187,8 @@ benchmark_create_index() benchmark_search_mroonga() { + run sudo -H systemctl restart mysqld + cat "${benchmark_dir}/search-words.list" | while read search_word; do for i in $(seq ${n_search_tries}); do where="MATCH(title, text) AGAINST('*D+ ${search_word}' IN BOOLEAN MODE)" @@ -191,6 +201,8 @@ benchmark_search_mroonga() benchmark_search_innodb() { + run sudo -H systemctl restart mysqld + cat "${benchmark_dir}/search-words.list" | while read search_word; do for i in $(seq ${n_search_tries}); do where="MATCH(title, text) AGAINST('${search_word}' IN BOOLEAN MODE)" Modified: benchmark/centos7/postgresql.sh (+8 -0) =================================================================== --- benchmark/centos7/postgresql.sh 2016-02-07 20:55:25 +0900 (fab42d5) +++ benchmark/centos7/postgresql.sh 2016-02-08 14:35:56 +0900 (f4cabb8) @@ -134,6 +134,8 @@ database_oid() load_data_pgroonga() { + run sudo -H systemctl restart postgresql-9.5 + echo "PGroonga: data: load:" run sudo -u postgres -H psql -d ${pgroonga_db} < \ "${config_dir}/schema.postgresql.sql" @@ -146,6 +148,8 @@ load_data_pgroonga() load_data_pg_bigm() { + run sudo -H systemctl restart postgresql-9.5 + echo "pg_bigm: data: load:" run sudo -u postgres -H psql -d ${pg_bigm_db} < \ "${config_dir}/schema.postgresql.sql" @@ -211,6 +215,8 @@ benchmark_create_index() benchmark_search_pgroonga() { + run sudo -H systemctl restart postgresql-9.5 + work_mem_size='10MB' work_mem="SET work_mem = '${work_mem_size}';" cat "${benchmark_dir}/search-words.list" | while read search_word; do @@ -225,6 +231,8 @@ benchmark_search_pgroonga() benchmark_search_pg_bigm() { + run sudo -H systemctl restart postgresql-9.5 + work_mem_size='10MB' work_mem="SET work_mem = '${work_mem_size}';" cat "${benchmark_dir}/search-words.list" | while read search_word; do -------------- next part -------------- HTML����������������������������...Download