[Maria-discuss] thread_cache_size and buffer pool
Hi all Would someone kindly explain (or document) how @@thread_cache_size affects the pool-of-threads? Do values > 0 make sense? Regards Federico
I already asked the exact same question some times ago and it shouldnt have any impact to change the value when the threadpool is used. Le 03/12/2014 02:56, Federico Razzoli a écrit :
Hi all
Would someone kindly explain (or document) how @@thread_cache_size affects the pool-of-threads? Do values > 0 make sense?
Hi Federico. It is documented, in the threadpool document https://mariadb.com/kb/en/mariadb/documentation/optimization-and-tuning/buff... 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Sorry, I missed that part, as well as previous Jean's question. Thank you Federico -------------------------------------------- Mer 3/12/14, vvaintroub@gmail.com <vvaintroub@gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] thread_cache_size and buffer pool A: "Federico Razzoli" <federico_raz@yahoo.it>, "Maria Discuss" <maria-discuss@lists.launchpad.net> 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/buff... 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (3)
-
Federico Razzoli -
Jean Weisbuch -
vvaintroub＠gmail.com