Consider the join_buffer_size parameter in MySQL Server.
Which two statements are true about the join buffer?
A. The value should be increased if the client performs several SELECT operations.
B. The join buffer is set per connection.
C. The join buffer is used to process sorts when complex joins are being performed.
D. The value should be increased from the default if the query joins large rows without using an index.
E. The join buffer is global and can be changed only by restarting the server.
Answer: BD

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL