MySQL Forums
Forum List  »  MyISAM

more info
Posted by: mARK bLOORE
Date: May 16, 2006 04:29PM

Thanks for the reply. Here is the info that should have been in my first post:

MySQL 5.0.19-standard

Linux kernel 2.6.8-24-default
Athlon 64 2800+
3GB RAM

CREATE TABLE `results0047`
(
`query` int(11) NOT NULL,
`match` int(11) NOT NULL,
`score` float NOT NULL,
KEY `query` (`query`),
KEY `match` (`match`),
KEY `score` (`score`)
)
ENGINE=MyISAM
DEFAULT CHARSET=ascii COLLATE=ascii_bin;

CREATE TABLE `items`
(
`id` int(11) NOT NULL,
`url` text collate ascii_bin NOT NULL,
`state` enum('new', 'working', 'searched', 'loaded', 'updated', 'deleted', 'held', 'done') collate ascii_bin default 'new',
`node` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `state` (`state`),
KEY `node` (`node`),
KEY `url` (`url`(767))
)
ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin;

Options: ReplyQuote


Subject
Views
Written By
Posted
2634
May 10, 2006 04:59PM
more info
1637
May 16, 2006 04:29PM
1631
May 17, 2006 02:51AM
1653
May 17, 2006 03:36PM
1605
May 17, 2006 04:06PM
1579
May 18, 2006 09:01AM
1587
May 18, 2006 11:23AM
1637
May 19, 2006 01:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.