I had a typo I was trying to use myisamchk -r not -f to fix it which did
not fix it.
myisamchk -o seems to fix the problem.
The real question is why am i getting this when creating index(s).
Although I'm using the Alpha version, I don't get a warm fuzzy
Any responses on what could be
How do you make something like this fault tolerant?
The answer is probably what I suspect, 2 of every thing.
How does the aggregator handle this or are these machines in a cluster?
We are thinking of how to rebuild our fulltext search. Currently it is
in MS SQL 7.0 - MySQL 4.0 seems to blow
I'm able to index 600,000 records in about 5 to 6 minutes on a dual PII
450
running Win2K and MySQL 4.0.0a
Similar stucture
ID
Title
Description
Indexing Title and Description.
On Wed, 2002-01-09 at 20:26, Jon Shoberg wrote:
I have a simple table with A LOT of data, 2.1M rows. this is
I've been looking hard at the FULLTEXT features of MySQL 4.0.1 on Linux
and 4.0.0a on Win32 and comparing it to MS SQL 2000 / and MS SQL 7.0 as
well as MySQL 3.XX.XX (latest stable release).
MySQL 4 on Win2K (dual 550 1gig memory) can crawl 90MB of data in about
5 minutes . MS SQL 7 and 2000 on