Hi, If the index file is just 1k (the same size as an EMPTY table!), it sounds like you don't have any indexes. The 8.6MB table is probably at least a few thousand rows, right? Well, if all your queries are scanning the whole table, that would cause a few Table_locks_waited! :-)
In order to help you add indexes, we will need the output of SHOW CREATE TABLE your_table; for your table(s). Also need examples of queries that you're running. Matt ----- Original Message ----- From: "James Kelty" Sent: Tuesday, September 02, 2003 2:23 PM Subject: Re: Many Read and Writes... > Ahhh! Ok, yeah the index file was 1.0k and the data file was 8.6M. > > -James > > > On Tue, 2003-09-02 at 12:17, Jeremy Zawodny wrote: > > On Tue, Sep 02, 2003 at 11:23:57AM -0700, James Kelty wrote: > > > Whoa, ok. Sorry. I didn't read the questions about the data and index > > > files. I'm, uh, not exactly sure how to tell that, can you give me a > > > hint there as well? *look sheepishly around*... > > > > Sure. > > > > First you need to figure out where MySQL is storing your data files. > > You can find the value of "datadir" in the output of SHOW VARIABLES. > > > > In that directory, you'll see a sub-directory for each database. And > > each MyIAM table is composed of three files: > > > > table.MYI - indexes > > table.MYD - data > > table.frm - table definition > > > > Find out how large your various indexs are by doing something like: > > > > du -sk *.MYI > > > > Jeremy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
