myisamchk and large files?

2002-08-18 Thread David Miller
Hello all; Is myisamchk known to have problems in tables with lots of rows? I've a table with a simple, single, 32 bit integer as a key. I have about 200 million rows in it. I can run myisamchk -o -e names three times in a row and receive this message each time: Duplicate key 1 for record at

Re: SIGPROF problem in FreeBSD 4.6 (REPOST)

2002-08-09 Thread David Miller
On Sun, 4 Aug 2002, Jeremy Zawodny wrote: Hi Jeremy; I didn't think my server would be doing any name resolution, particularly while replace()ing millions of rows in a table. That said, --skip-name-resolve *seems* to have helped. It's definately still failing, and the ktrace is the same, so it

Re: large_files_support

2001-07-27 Thread David Miller
On Wed, 25 Jul 2001, David Miller wrote: I know it's bad form to followup ones own message, but enough digging turned up an answer that someone else may find useful. > Hi All:) > > I'm running mysql-3.23.30-gamma on FreeBSD 4.3-stable and running into a > problem with max

large_files_support

2001-07-25 Thread David Miller
Hi All:) I'm running mysql-3.23.30-gamma on FreeBSD 4.3-stable and running into a problem with max file sizes. I've got a table, names, which is taking 4294967288 bytes. I notice this is 8 bytes less than 2^32, so I assume there's a 32 bit pointer issue within mysql somewhere. large_files_supp