Thanks for your attention to this problem!
The files are just about 1GB zipped. I'm on a cable modem, so it would take
quite a while to upload these files, but I would be happy to upload them if
helps solve the problem.
Here are the results you requested:
mysql> SELECT COUNT(*) FROM temp_bill_note_search WHERE MATCH notes
AGAINST("traded" IN BOOLEAN MODE);
+----------+
| COUNT(*) |
+----------+
| 55093 |
+----------+
1 row in set (34.02 sec)
mysql> SELECT COUNT(*) FROM temp_bill_note_search WHERE MATCH notes
AGAINST("this" IN BOOLEAN MODE);
+----------+
| COUNT(*) |
+----------+
| 0 | (a very common stop word most likely in >50% of the notes)
+----------+
1 row in set (0.00 sec)
mysql> SELECT COUNT(*) FROM temp_bill_note_search WHERE MATCH notes
AGAINST("bill" IN BOOLEAN MODE);
+----------+
| COUNT(*) |
+----------+
| 7922619 | (another very common word, but in <50% of the notes)
+----------+
1 row in set (9 min 48.39 sec)
By the way, the following count(*) query works WITHOUT crashing the server:
mysql> SELECT COUNT(*) FROM temp_bill_note_search WHERE MATCH notes
AGAINST('"traded this bill"' IN BOOLEAN MODE);
+----------+
| COUNT(*) |
+----------+
| 672 |
+----------+
1 row in set (8 min 6.58 sec)
But when I then go to query the actual records and score, this SQL crashes the
server:
mysql> SELECT denom,series,serial_number,notes,MATCH (notes) AGAINST ('"traded
this bill"') AS score FROM temp_bill_note_search WHERE MATCH (notes) AGAINST
('"traded this bill"' IN BOOLEAN MODE) ;
CRASH:/usr/bin/mysqld_safe: line 1: 7789 Segmentation fault nohup
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/bmw.eskin.com.pid --skip-locking --core-file
>>/var/lib/mysql/logs/error.log 2>&1
But when I leave off the "score" in the SELECT clause, this query works without
crashing the server:
mysql> SELECT denom,series,serial_number FROM temp_bill_note_search WHERE MATCH
(notes) AGAINST ('"traded this bill"' IN BOOLEAN MODE) ;
.... 672 rows returned.... in set (8 min 13.11 sec)
I hope this helps!!
BTW, I'm not getting any core dump files in the data dir or any other basedir.
If there is any more information you need, or would like to log in to the
server yourself to do tests, let me know via email at [EMAIL PROTECTED]
Thanks!
-Hank
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
