last day (1083 days later) » 

Stack Exchange
Stack Exchange
06:51
1
A: Threads_cached 0 while thread_cache_size > 0

RolandoMySQLDBA When a client disconnects, the client's threads are put in the cache if there are fewer than thread_cache_size threads there. In your case, it would read When a client disconnects, the client's threads are put in the cache if there are fewer than 4 threads there. Also, note the followi...

setevoy
setevoy
Oh, thanks! I think - i read it, but don't understood wthat it exactly means :-) Will test tomorrow.
No... Even if I set thread_cache_size 30 - I have Threads_cached 0 after same mysqlslap test (10 concurrently) :-|
RolandoMySQLDBA
RolandoMySQLDBA
Remember, Normally, this does not provide a notable performance improvement if you have a good thread implementation.
You keep using show status where variable_name like 'Threads%';. That's the same as running show session status where variable_name like 'Threads%';.Try show global status where variable_name like 'Threads%';
Please try this select G.variable_name,G.variable_value GlobalValue,S.variable_value SessionValue from (select * from information_schema.global_status) G inner join (select * from information_schema.session_status) S using (variable_name) where G.variable_name like 'Threads%'; to see if you note any difference.
setevoy
setevoy
Hi. > not provide a notable performance improvement // I'm pretty sure, this will not improve performance on this server :-) 5 databases, 2-15 concurrently connections, but - I just want to find out - why it's not work
thread_cache_size = 20; # service mysql restart; # mysqlslap -v -u root -p --auto-generate-sql --concurrency=10 --number-of-queries=100; MariaDB [rtfm_db1]> show global status where variable_name like 'Threads_cached'; Threads_cached 0;
Hi, @RolandoMySQLDBA; please - ping me, if you'll have few minutes;
stackexchange proposed me move discussion here, instead of posting comments in Q;
I'm sorry to bother you

  last day (1083 days later) »