Hi!
On Aug 14, Henry Hank wrote:
>
> Sergei wrote:
>
> >How big is your table?
>
> The MYD file is 2,406,292,556 bytes.
oops :(
I actually thought about asking for a copy of your data - it will
definitely help to fix the bug, but 2GB is big enough to try everything
else first.
But if you don't mind - we can skip to this final resort now :)
> I've started mysqld with:
>
> /usr/bin/mysqld_safe --core-file= --core-file-size=1000000 &
>
> And I've made it crash (as expected), but for the life of me, I can't find the
> core file anywhere to send it to you.
It should usually be in the datadir.
Where pid file and database directories are.
One more question:
What are results from
SELECT COUNT(*) FROM temp_bill_note_search
WHERE MATCH notes AGAINST("traded" IN BOOLEAN MODE);
SELECT COUNT(*) FROM temp_bill_note_search
WHERE MATCH notes AGAINST("this" IN BOOLEAN MODE);
SELECT COUNT(*) FROM temp_bill_note_search
WHERE MATCH notes AGAINST("bill" IN BOOLEAN MODE);
?
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
