Explicitly setting thread_cache_size=-1 (autosizing) doesn't work
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned |
Bug Description
Server version: 5.6.29-76.2 Percona Server (GPL), Release 76.2, Revision ddf26fe on Debian Wheezy from Percona repository
I've set "thread-
However when set to "-1":
mysql> SHOW VARIABLES LIKE "thread_
+------
| Variable_name | Value |
+------
| thread_cache_size | 0 |
+------
1 row in set (0.00 sec)
When I manually set a positive value (thread-
mysql> SHOW VARIABLES LIKE "thread_
+------
| Variable_name | Value |
+------
| thread_cache_size | 7 |
+------
1 row in set (0.00 sec)
When I remove the declaration from my.cnf so that MySQL's default will be used and set max_connections=800 (to test the formula '8 + (max_connections / 100)') everything works, too:
mysql> SHOW VARIABLES LIKE "thread_
+------
| Variable_name | Value |
+------
| thread_cache_size | 16 |
+------
1 row in set (0.00 sec)
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-3408