Log in

View Full Version : searchindex in phpMyAdmin

Mijae
04-26-2003, 02:33 PM
I currently have 375,464 fields in that table and it uses up 9.0MB, which is 1/4 of my current total.

I wonder what is it usefull for? And why is it so big? Also, how do I clean it up and what would cleaning it do?
filburt1
04-26-2003, 02:39 PM
You need it for searching. Reduce its size by either increasing the min word length or turning off the search engine altogether.
Erwin
04-26-2003, 03:22 PM
Or install the MYSQL 4 search hack. :) It's brilliant.
filburt1
04-26-2003, 03:36 PM
But requires MySQL 4 :p ;)
Dean C
04-26-2003, 05:36 PM
Well this is the current stable release now isn't it so why should that be a problem?

- miSt
Erwin
04-26-2003, 11:29 PM
Today at 03:36 AM filburt1 said this in Post #4 (https://vborg.vbsupport.ru/showthread.php?postid=387459#post387459)
But requires MySQL 4 :p ;)


MySQL 4.1.3 - it supports caching as well - I suggest upgrading to it, as it speeds things up.