On Wed, Sep 25, 2002 at 08:42:05AM -0300, Dyego Souza do Carmo wrote:
The variables record_buffer,join_buffer and sort_buffer are alocated
every user connect ?
No, their are allocated on an as-needed basis for each thread. If a
thread doesn't need to join anything, there will be no join
The variables record_buffer,join_buffer and sort_buffer are alocated
every user connect ?
ex:
join_buffer=6M
record_buffer=7M
sort_buffer=9M
max_connection=200
in final case the mysql stored in memory is:
(6+7+9)*200 = 1813MB
???
or the variables in this case is to global