Re: What constitutes a large table?
MySQL 4.1.13
Linux 2.4.31
Apache 1.3.33
CREATE TABLE `am_log` (\n `id` int(10) NOT NULL auto_increment,\n `level` tinyint(2) NOT NULL default '0',\n `updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,\n `entered` timestamp NOT NULL default '0000-00-00 00:00:00',\n `message` text,\n PRIMARY KEY (`id`),\n KEY `entered` (`entered`),\n FULLTEXT KEY `message` (`message`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1
I am recording an autoincremented key, a flag, a couple of dates, and a block of text with an average length of 130 characters (although the mean length is probably 20 characters and it never exceeds 1,000 characters).
I already mentioned the operations. Generally, I add sequential records. Occasionally, I delete a block of them. Otherwise, it is just SELECT operations.