0

What will happen if a low value was assigned in my.cnf to any of the per-thread buffers, when it fills?

I'm thinking of possible scenarios:

  1. MySQL will gracefully call realloc for additional block with the same size.
  2. A buffer overflow, causing thread to terminate
  3. Unexpected behaviour, like incorrect sort (if sort-buffer-size is filled during the process)
Improve this question
2
  • read buffer is preemptive, so if it is filled already, new data replace the old one. If your dataset is too big to fit into buffer, no buffering occurs. Commented Jun 12, 2015 at 13:47
  • please answer as your comment and I will accept your answer. Commented Sep 16, 2015 at 19:06

0

Reset to default

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.