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 causi
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 the
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 p
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