MySQL Forums
Forum List  »  Performance

thread_cache_size: Need suggestion on this paramateer
Posted by: Gnanasekar A.
Date: December 26, 2015 10:49AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
thread_cache_size: Need suggestion on this paramateer
1445
December 26, 2015 10:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.