Kouhei Sutou
null+****@clear*****
Mon Feb 8 14:57:26 JST 2016
Kouhei Sutou 2016-02-08 14:57:26 +0900 (Mon, 08 Feb 2016) New Revision: d4f58dfc9f19c306d8d94495e4ec87cba756d70c https://github.com/groonga/wikipedia-search/commit/d4f58dfc9f19c306d8d94495e4ec87cba756d70c Message: Disable query cache Modified files: benchmark/centos7/mysql.sh Modified: benchmark/centos7/mysql.sh (+2 -2) =================================================================== --- benchmark/centos7/mysql.sh 2016-02-08 14:56:03 +0900 (c4e5eda) +++ benchmark/centos7/mysql.sh 2016-02-08 14:57:26 +0900 (6645fd3) @@ -194,7 +194,7 @@ benchmark_search_mroonga() where="MATCH(title, text) AGAINST('*D+ ${search_word}' IN BOOLEAN MODE)" echo "Mroonga: search: ${where}: ${i}:" time run mysql -u root ${mroonga_db} \ - -e "SELECT COUNT(*) FROM wikipedia WHERE ${where}" + -e "SELECT SQL_NO_CACHE COUNT(*) FROM wikipedia WHERE ${where}" done done } @@ -209,7 +209,7 @@ benchmark_search_innodb() where="MATCH(title, text) AGAINST('${query}' IN BOOLEAN MODE)" echo "InnoDB: search: ${where}: ${i}:" time run mysql -u root ${innodb_db} \ - -e "SELECT COUNT(*) FROM wikipedia WHERE ${where}" + -e "SELECT SQL_NO_CACHE COUNT(*) FROM wikipedia WHERE ${where}" done done } -------------- next part -------------- HTML����������������������������...Download