searchindex in phpMyAdmin
 

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?

You need it for searching. Reduce its size by either increasing the min word length or turning off the search engine altogether.

Or install the MYSQL 4 search hack. :) It's brilliant.

But requires MySQL 4 :p ;)

Well this is the current stable release now isn't it so why should that be a problem?

- miSt

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