thread_cache_size: Need suggestion on this paramateer

[Gnanasekar A.]

Hi,

mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.1.73 |
+-----------+

mysql> SHOW GLOBAL STATUS LIKE 'max_used_connections';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Max_used_connections | 27169 |
+----------------------+-------+
1 row in set (0.00 sec)

mysql> SHOW GLOBAL STATUS LIKE 'Threads_created';
+-----------------+---------+
| Variable_name | Value |
+-----------------+---------+
| Threads_created | 2328847 |
+-----------------+---------+
1 row in set (0.01 sec)

mysql> SHOW GLOBAL STATUS LIKE 'connections';
+---------------+---------+
| Variable_name | Value |
+---------------+---------+
| Connections | 2328864 |
+---------------+---------+
1 row in set (0.00 sec)

2328847/2328864=0.9999927003036674

As the value is close to 1, few blogs suggests value of thread_cache_size to set to max_used_connections.

In this scenario, max_used_connections is 27169.

Question:
+ Can I go ahead and set the value of thread_cache_size to 27169 ?
+ Is there any limit for this parameter which shouldn't be exceeded ?
+ Please suggest me if any thing else to be considered before we set?

Thanks in advance.

With Regards,
Gnana