Sergei wrote:

>How big is your table?

The MYD file is  2,406,292,556 bytes.
The MYI file is  1,381,827,584 bytes.
There are 21,402,554 records in the database.

This table is static (no writers) and ONLY used for fulltext searching on the
"notes" field.

Here is the structure:
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| denom         | varchar(4)   | YES  |     | NULL    |       |
| series        | varchar(5)   | YES  |     | NULL    |       |
| serial_number | varchar(11)  | YES  |     | NULL    |       |
| notes         | varchar(255) | YES  | MUL | NULL    |       |
+---------------+--------------+------+-----+---------+-------+


>Could you please run mysqld with --core-file to get a core dump and
>upload it to ftp://support.mysql.com/pub/mysql/secret/ ?

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.  Nowhere in the documentation does it
specify where to find the file or what it's name is.  And I've looked all over
for it in obvious places and names, but I can't find it.  If someone will tell
me where to find it, I'll gladly send it along. 

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]

Reply via email to