Re: Troubleshooting FullText Slowness

2005-05-19 Thread Dan Salzer
Dathan, Thanks for the suggestion - I was under the impression that 4GB is the limit for 32bit machines. The server is running Redhat Enterprise Linux 3.0 ES for EM64T and MySQL has also been compiled for EM64T. I'd already tried running 'table opitmize' and that didn't seem to help, table rep

RE: Troubleshooting FullText Slowness

2005-05-19 Thread Dathan Pattishall
Wow, your going pass the 2 GB barrier on a 32 bit server. I would not do that. Reduce your key buffer to 1700 or you will eventually crash. Then type repair table PC1_Text quick, or ALTER TABLE PC1_TEXT ENGINE=myISAM. This helps with rebuilding full text indexes. DVP Dathan Vance Pattishal