P
P
Pu4u2015-10-30 18:05:19
MySQL
Pu4u, 2015-10-30 18:05:19

Why is MySQL threads_per_sec set to 0?

I ran tuning-primer.sh for the first time - he advised me to enable threads. I turned them on in the settings, a few days passed, as a result it writes:

WORKER THREADS
   Current thread_cache_size = 4
   Current threads_cached = 3
   Current threads_per_sec = 0
   Historic threads_per_sec = 0

Why threads_per_sec = 0? Where can I read about it, do I need to change something?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
P
Pu4u, 2015-11-09
@Pu4u

threads_per_sec = 0 because new threads are not created, but taken from the cache.
Here you can read about threads: mysqltips.blogspot.com.by/2007/03/mysql-threads-tu...

P
Puma Thailand, 2015-10-31
@opium

well, open the script and see what it is

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question