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 -- James Kelty E-Commerce / Financial Systems Administrator Portland State University 503.725.9152 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
