MySQL S-L-O-W when handling my 19 million row table
Posted on 2002-07-22
I am using MySQL 4.0.1-alpha on a i686 machine with RedHat 7.2. I'm afraid I don't have the exact machine specs available to me, but it's fast -- trust me! (SELECT BENCHMARK(1000000,1+1) = 0.1 seconds)
I've got a large 19 million items table, with 9 indices, and I need to run fairly complex queries (e.g.: one select from 2 tables, with a WHERE clause and an ORDER clause, etc...).
Currently, this is taking a HUGE amount of time (600 seconds), even though I've installed the fairly optimized my-huge.cnf configuration file. The longest step seems to be "copy to tmp table", which I presume is the SELECT portion.
Any help on speeding this query up would be highly appreciated.