On Mon, May 20, 2002 at 04:33:41PM +0200, andy wrote: > Thank you Egor for you reply. > > I did read about indexing text column on the mysql site. So I tryed > to index my column like described. After 1 hour, I had to reboot my > machine because there was no other way.
No other way? You could have killed MySQL. > All the cpu was bussy and it seemed to me to be an endless loop. I doubt that it was endless. > After rebooting I had to repair the file system (suse72) and > tables. There was also a 130 MB tmp file I deleted. > > So what did I do wrong, or does it just take that long? The table > contains about 40 MB of space. How much data are you attempting to index, and how large is your key_buffer? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php