Question on connections to mysql. Hit too many connections recently

Is this an accurate command to check mysql connections? So there is still a conneciton pool? This was 2 years ago, so how about now?

mysql -u cattle -p -e ‘SHOW STATUS WHERE variable_name LIKE “Threads_%” OR variable_name = “Connections”’
Enter password:
±------------------±------+
| Variable_name | Value |
±------------------±------+
| Connections | 107 |

Seems like a lot considering recommended is > 150. I set mine to 500.

What about the scenerio where i run multiple rancher server containers for HA mode? Does that mean I should triple the expected connections?

Thanks

Yes, 150 per server container.

1 Like

great, thanks vincent