Re: MySQL 5.5.8 - Configuration Settings Suggestions

[Aftab Khan]

Samir, I asked for EXPLAIN outputs for modified and the original sub-queries.


>Frequent Temporary table creation should create load on the server. Is it correct?

Temporary table that use memory storage engines are efficient, here we are trying to improve your query performance as a whole

>I have set sort_buffer_size=32 M with read_buffer_size and read_rnd_buffer_size as you have suggested.

I would say buffer sizes are still high but anyway lets focus on queries that are slow