← Back to team overview

maria-discuss team mailing list archive

Re: thread_cache_size and buffer pool

 

Sorry, I missed that part, as well as previous Jean's question.

Thank you
Federico


--------------------------------------------
Mer 3/12/14, vvaintroub@xxxxxxxxx <vvaintroub@xxxxxxxxx> ha scritto:

 Oggetto: Re: [Maria-discuss] thread_cache_size and buffer pool
 A: "Federico Razzoli" <federico_raz@xxxxxxxx>, "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Data: Mercoledì 3 dicembre 2014, 03:49
 
 #yiv9108949832
 #yiv9108949832 --
 html {
 }
 #yiv9108949832 #yiv9108949832 #yiv9108949832
 --
 p.yiv9108949832MsoListParagraph, #yiv9108949832
 li.yiv9108949832MsoListParagraph, #yiv9108949832
 div.yiv9108949832MsoListParagraph {
 margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;}
 #yiv9108949832 p.yiv9108949832MsoNormal, #yiv9108949832
 li.yiv9108949832MsoNormal, #yiv9108949832
 div.yiv9108949832MsoNormal {
 margin:0in;margin-bottom:.0001pt;}
 #yiv9108949832 p.yiv9108949832MsoListParagraphCxSpFirst,
 #yiv9108949832 li.yiv9108949832MsoListParagraphCxSpFirst,
 #yiv9108949832 div.yiv9108949832MsoListParagraphCxSpFirst, 
 #yiv9108949832 p.yiv9108949832MsoListParagraphCxSpMiddle,
 #yiv9108949832 li.yiv9108949832MsoListParagraphCxSpMiddle,
 #yiv9108949832 div.yiv9108949832MsoListParagraphCxSpMiddle, 
 #yiv9108949832 p.yiv9108949832MsoListParagraphCxSpLast,
 #yiv9108949832 li.yiv9108949832MsoListParagraphCxSpLast,
 #yiv9108949832 div.yiv9108949832MsoListParagraphCxSpLast {
 margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;line-height:115%;}
 #yiv9108949832 
 
 Hi Federico.It is documented, in the
 threadpool document https://mariadb.com/kb/en/mariadb/documentation/optimization-and-tuning/buffers-caches-and-threads/thread-pool/threadpool-in-55/It
 says ​following, towards the end of the ​doc,
 in “Notes” The thread_cache_size system
 variable is not used when the thread pool is used and
 the Threads_cached status
 variable will have a value of 0.
 
 From: Federico
 Razzoli
 Sent: ‎Tuesday‎,
 ‎December‎ ‎2‎, ‎2014 ‎5‎:‎56‎ ‎PM
 To: Maria
 Discuss
 Hi all
 
 Would someone kindly explain
 (or document) how @@thread_cache_size affects the
 pool-of-threads? Do values > 0 make sense?
 
 Regards
 Federico
 
 _______________________________________________
 Mailing list:
 https://launchpad.net/~maria-discuss
 Post
 to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
 Unsubscribe :
 https://launchpad.net/~maria-discuss
 More
 help   : https://help.launchpad.net/ListHelp
 
 
 
 



References