[RESOLVED] Need help with optimizing table

[palpie]

I have a a guestbook in a MySQL table. I now has 76373 posts and is starting to get pretty slow.

CREATE TABLE guestbook (
username varchar(50) NOT NULL default '',
from varchar(50) NOT NULL default '',
message text NOT NULL,
when datetime NOT NULL default '0000-00-00 00:00:00',
ip varchar(15) NOT NULL default '',
id bigint(20) unsigned NOT NULL auto_increment,
UNIQUE KEY id (id),
KEY username (username),
FULLTEXT KEY message (message),
KEY from (from)
) TYPE=MyISAM;

username is whos guestbook it is.
from is who the guestbook post is from.
The rest I don't think need any explanation.

What I need now is to make this table work a little faster with SELECT and preferably also with DELETE.

[zhabala]

So, please tell us, how the indexes are setup ? Do you have some ?

Zdenek

[ultraslacker]

btw, 'from' is a bad idea for a column name, as it is a reserved word

ditto for 'when'

[ultraslacker]

Prefix your query with EXPLAIN, ie EXPLAIN SELECT username, message, ... to see a rudimentary query plan. This output will let you know where you need to index.