Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have an application that has few concurrent connections but does a lot of uncacheable fulltext searches sorting, limit with offset, etc. I have an xlarge instance with innodb buffer pool size @ 75% of available memory, tmp table size is set at 64M. temp table status shows lots of in memory and in disk temp table creation. client vars are:

sort_buffer_size 2M read_buffer_size 2M read_rnd_... 4M

I am thinking of bumping up the temp table size and other sort related vars by scaling down the innodb buffer pool. Does that even make sense? By the way we are not using provisioned iops either.

share|improve this question
    
Does your max_heap_table_size match your configured tmp_table_size? MySQL will use the lesser of the two. –  Derek Downey Apr 18 '13 at 12:21
    
yes it is. thanks, Derek. –  JShean Apr 18 '13 at 12:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.