Environment:
I'm setting up a database server on a Dell Poweredge 2650, dual 1.8GHZ pentium
with 1GB of memory and RAID5 drives. I've installed RedHat 9, and updated the
kernel to 2.4.20-19.9smp. I've installed the RPM binary distribution of MySQL
4.0.14 right from the MySQL website. The only thi
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_
Here is the resolved stack trace when the FULLTEXT query crahses my server:
0x807474f handle_segfault + 423
0x82a0ad8 pthread_sighandler + 184
0x82ca717 memcpy + 39
0x82891c3 tree_insert + 483
0x827b037 walk_and_match + 231
0x8289956 tree_walk_left_root_right + 78
0x828992c tree_walk_left_root_ri
Oops.. here's the correct command I used to start mysql:
/usr/bin/mysqld_safe --core-file --core-file-size=100 &
It was not started with "--core-file=" as mentioned in my previous note. Sorry.
-Hank
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use w
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:
+---+-
Hi!
On Aug 13, Henry Hank wrote:
> Environment:
> I'm setting up a database server on a Dell Poweredge 2650, dual 1.8GHZ pentium
> with 1GB of memory and RAID5 drives. I've installed RedHat 9, and updated the
> kernel to 2.4.20-19.9smp. I've installed the RPM binary distribution of MySQL
> 4.0.1
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 do
