Hi all, I'm doing another bout of MySQL server tuning as the load on my server has nearly doubled due to recent projects, so I'm trying to squeeze some more performance out of it. Again, I'm looking at thread_cache_size, which I currently have set to 16. The manual says that "by examining the difference between Connections and Threads_created you can see how efficient the current thread cache is for you". I looked at the variables, and at that particular moment, they were at 777744 and 67343 respectively. This works out that a new thread is being created roughly every 12 connections. This sounds bad to me, but is it really? I suppose the ideal figure would be zero new threads having to be created ever, as all new connections would use cached threads. So, I have a couple of questions that someone might be able to answer: * What is the definition of an efficient thread cache? * Should I be aiming to get my new threads per connections figure as low as possible? * What effect on memory usage would having a larger thread cache make? This is all on a RedHat Linux 6.2 server with 512Mb RAM and MySQL 3.23.32. Regards, ------------------------------------------------ Basil Hussain ([EMAIL PROTECTED]) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
