Re:Managing big tables

2003-07-15 Thread Alexander Schulz
Thanks for your efforts, and in rudys last mail he confirms what i have feared, the io-overhead for reading the extremely longer rows most probably causes these longer query-times. I think we will have to redesign our table-structure, because we're already working on a (hardware-)raid, so the my

Managing big tables

2003-07-15 Thread Alexander Schulz
Hello, i've got a little problem, we're using mysql with two big tables (one has 90 Mio. Rows (60 Gb on HD), the other contains nearly 200.000.000 (130 Gb on HD). Now we want to delete some rows from these tables to free diskspace. It seems that MySQL frees the harddisk-space which was used by th