关于论坛的搜索
Posted 06月 30, 2009 
Comments(0)
Comments(0) 无论怎么折腾都有16000000万记录因此考虑分表：
- mysql> select count(*) from phpbb_search_wordmatch;
- +----------+
- | count(*) |
- +----------+
- | 16744176 |
- +----------+
- 1 row in set (1 min 2.28 sec)
- mysql> alter table phpbb_search_wordmatch partition by hash(word_id) partitions 10;
- Query OK, 17365216 rows affected (4 min 42.93 sec)
- Records: 17365216 Duplicates: 0 Warnings: 0
- 结果如下：
- -rw-rw---- 1 mysql mysql 8646 2009-06-30 18:40 phpbb_search_wordmatch.frm
- -rw-rw---- 1 mysql mysql 60 2009-06-30 18:40 phpbb_search_wordmatch.par
- -rw-rw---- 1 mysql mysql 13909000 2009-06-30 18:44 phpbb_search_wordmatch#P#p0.MYD
- -rw-rw---- 1 mysql mysql 60443648 2009-06-30 18:44 phpbb_search_wordmatch#P#p0.MYI
- -rw-rw---- 1 mysql mysql 14121616 2009-06-30 18:44 phpbb_search_wordmatch#P#p1.MYD
- -rw-rw---- 1 mysql mysql 61297664 2009-06-30 18:44 phpbb_search_wordmatch#P#p1.MYI
- -rw-rw---- 1 mysql mysql 16088664 2009-06-30 18:44 phpbb_search_wordmatch#P#p2.MYD
- -rw-rw---- 1 mysql mysql 69895168 2009-06-30 18:44 phpbb_search_wordmatch#P#p2.MYI
- -rw-rw---- 1 mysql mysql 16587448 2009-06-30 18:44 phpbb_search_wordmatch#P#p3.MYD
- -rw-rw---- 1 mysql mysql 72056832 2009-06-30 18:44 phpbb_search_wordmatch#P#p3.MYI
- -rw-rw---- 1 mysql mysql 14599216 2009-06-30 18:44 phpbb_search_wordmatch#P#p4.MYD
- -rw-rw---- 1 mysql mysql 63369216 2009-06-30 18:44 phpbb_search_wordmatch#P#p4.MYI
- -rw-rw---- 1 mysql mysql 13551656 2009-06-30 18:44 phpbb_search_wordmatch#P#p5.MYD
- -rw-rw---- 1 mysql mysql 58858496 2009-06-30 18:44 phpbb_search_wordmatch#P#p5.MYI
- -rw-rw---- 1 mysql mysql 11380344 2009-06-30 18:44 phpbb_search_wordmatch#P#p6.MYD
- -rw-rw---- 1 mysql mysql 49286144 2009-06-30 18:44 phpbb_search_wordmatch#P#p6.MYI
- -rw-rw---- 1 mysql mysql 14271256 2009-06-30 18:44 phpbb_search_wordmatch#P#p7.MYD
- -rw-rw---- 1 mysql mysql 61964288 2009-06-30 18:44 phpbb_search_wordmatch#P#p7.MYI
- -rw-rw---- 1 mysql mysql 12611296 2009-06-30 18:44 phpbb_search_wordmatch#P#p8.MYD
- -rw-rw---- 1 mysql mysql 54674432 2009-06-30 18:44 phpbb_search_wordmatch#P#p8.MYI
- -rw-rw---- 1 mysql mysql 11801832 2009-06-30 18:44 phpbb_search_wordmatch#P#p9.MYD
- -rw-rw---- 1 mysql mysql 51184640 2009-06-30 18:44 phpbb_search_wordmatch#P#p9.MYI
先看看效果如何。