Thanks Sasha. It helped trim down my table a bit
Eric
Sasha Pachev [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Eric B. wrote:
Sure! Here it is:
CREATE TABLE `index2` (
`id` varchar(50) NOT NULL default '',
`recordid` varchar(20) NOT NULL default '',
`transid`
Eric B. wrote:
Sure! Here it is:
CREATE TABLE `index2` (
`id` varchar(50) NOT NULL default '',
`recordid` varchar(20) NOT NULL default '',
`transid` varchar(20) NOT NULL default '',
`formid` varchar(20) NOT NULL default '',
`groupid` varchar(20) NOT NULL default '',
`clientid` varchar(20) NOT
Help!
Okay - so I've been working around on my indexing of a table. My table is
currently over 5M rows (close to 500Mb) and growing at a quick rate. In
order to handle different types of queries, I am forced to create multiple
indexes for the table. But by doing so, I end up with an MYI index
Hmm...if there's lots of thrashing, it might be to do with
fragmentation. Have you tried running OPTIMIZE TABLE on the table in
question?
Does anyone on the list have anything to say about putting the MYD and
MYI files on seperate disks or using RAID MyISAM tables??
Regards,
Chris
Eric B.
Sorry - forgot to mention it. I've already tried both an OPTIMIZE TABLE and
ANALYZE TABLE to try to improve performance, but with no result.
Any other ideas?
Thanks,
Eric
Chris Nolan [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hmm...if there's lots of thrashing, it might be to
Can you send us the CREATE TABLE statement for this troublesome table?
Regards,
Chris
Eric B. wrote:
Sorry - forgot to mention it. I've already tried both an OPTIMIZE TABLE and
ANALYZE TABLE to try to improve performance, but with no result.
Any other ideas?
Thanks,
Eric
Chris Nolan [EMAIL
Sure! Here it is:
CREATE TABLE `index2` (
`id` varchar(50) NOT NULL default '',
`recordid` varchar(20) NOT NULL default '',
`transid` varchar(20) NOT NULL default '',
`formid` varchar(20) NOT NULL default '',
`groupid` varchar(20) NOT NULL default '',
`clientid` varchar(20) NOT NULL default '',