Hey
I'm working on several scripts which use the Text feature of mysql database. I set the db up as follows:
CREATE TABLE dutylog (
logid int(5) unsigned NOT NULL auto_increment,
name varchar(104) NOT NULL default '',
timesent varchar(64) NOT NULL default '',
message text NOT NULL default '',
PRIMARY KEY (logid)
) TYPE=MyISAM
Now although everything works fine, whenever I delete a row I get an overhead in the database space usage and have to use the optimize database command to free up the overhead. Can anyone tell me what it is i'm doing wrong?
Thanks
Jack
