Kouhei Sutou
null+****@clear*****
Mon Feb 8 14:56:03 JST 2016
Kouhei Sutou 2016-02-08 14:56:03 +0900 (Mon, 08 Feb 2016) New Revision: afefd32bef61b3c13caab13cfb03d045e15c5006 https://github.com/groonga/wikipedia-search/commit/afefd32bef61b3c13caab13cfb03d045e15c5006 Message: Ignore OR in InnoDB Modified files: benchmark/centos7/mysql.sh Modified: benchmark/centos7/mysql.sh (+2 -1) =================================================================== --- benchmark/centos7/mysql.sh 2016-02-08 14:35:56 +0900 (3549cfc) +++ benchmark/centos7/mysql.sh 2016-02-08 14:56:03 +0900 (c4e5eda) @@ -205,7 +205,8 @@ benchmark_search_innodb() 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)" + query=$(echo ${search_word} | sed -e "s/ OR / /g") + 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}" -------------- next part -------------- HTML����������������������������...Download