Kouhei Sutou
null+****@clear*****
Mon Feb 8 19:39:03 JST 2016
Kouhei Sutou 2016-02-08 19:39:03 +0900 (Mon, 08 Feb 2016) New Revision: 5be3d84d1077973a2270d623ad2773fdae3d0397 https://github.com/groonga/wikipedia-search/commit/5be3d84d1077973a2270d623ad2773fdae3d0397 Message: Set charset Modified files: benchmark/centos7/mysql.sh Modified: benchmark/centos7/mysql.sh (+4 -2) =================================================================== --- benchmark/centos7/mysql.sh 2016-02-08 19:24:28 +0900 (d945c00) +++ benchmark/centos7/mysql.sh 2016-02-08 19:39:03 +0900 (18545c9) @@ -193,7 +193,8 @@ benchmark_search_mroonga() for i in $(seq ${n_search_tries}); do where="MATCH(title, text) AGAINST('*D+ ${search_word}' IN BOOLEAN MODE)" echo "Mroonga: search: ${where}: ${i}:" - time run mysql -u root ${mroonga_db} \ + time run mysql --default-character-set=utf8mb4 \ + -u root ${mroonga_db} \ -e "SELECT SQL_NO_CACHE COUNT(*) FROM wikipedia WHERE ${where}" done done @@ -208,7 +209,8 @@ benchmark_search_innodb() query=$(echo ${search_word} | sed -e "s/ OR / /g") where="MATCH(title, text) AGAINST('${query}' IN BOOLEAN MODE)" echo "InnoDB: search: ${where}: ${i}:" - time mysql -u root ${innodb_db} \ + time mysql --default-character-set=utf8mb4 \ + -u root ${innodb_db} \ -e "SELECT SQL_NO_CACHE COUNT(*) FROM wikipedia WHERE ${where}" done done -------------- next part -------------- HTML����������������������������...Download