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 -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 32 days, processed 1,375,019,175 queries (496/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]