Re: Help! How to handle Massive index file???

2004-02-24 Thread Eric B.
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 '', >

Re: Help! How to handle Massive index file???

2004-02-23 Thread Sasha Pachev
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 NUL

Re: Help! How to handle Massive index file???

2004-02-20 Thread Eric B.
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 '', `

Re: Help! How to handle Massive index file???

2004-02-20 Thread Chris Nolan
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" <[EMA

Re: Help! How to handle Massive index file???

2004-02-20 Thread 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 b

Re: Help! How to handle Massive index file???

2004-02-20 Thread Chris Nolan
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. wr

Help! How to handle Massive index file???

2004-02-20 Thread Eric B.
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