On Fri, Mar 09, 2001 at 02:05:42PM +0200, Richard Ellerbrock wrote:
> Add another index on your timestamp column. Also, I think timestamp is a reserved
>word. Maybe you should rename the column to something else.
...
> PRIMARY KEY (timestamp,hostname,interfacename)
> ) TYPE=MyISAM PACK_KEYS=1;
Hello
My selects still last several hours. Can anybody give me a hint which
parameters to tune when the main selects look like the following one on a
1.5GB big table with aprox 1 million affected rows?
join_buffer_size| 131072
key_buffer_size | 67104768
max_heap_table_size