mysql thread and tomcat thread should be the same for a better perfoming?

Question

my tomcat instance on ubuntu server running with mysql and only the application has access to mysql (only the service-user tomcat). I have small experience level with optimizing with mysql and tomcat. For a good perfomance should the maxthread value tomcat the same like mysql ?

For any help, im grateful

kind regards

blackbeard

Rick James · Answer 1 · 2020-01-31T21:36:52.280

0

Are you referring to max_connections in MySQL? What are the values now? If you have more than, say, 20, active threads running, you need to worry about optimizing the queries.

It is not critical that the settings be the same, or even similar. Performance issues stem from slow queries, bursts of queries, etc. Do you have any symptoms of "bad performance"?

edited Jan 31 '20 at 21:36

answered Jan 31 '20 at 19:41

Rick James

2,463
1
6
13

the max connections default value of my mysql community edition is 151. If im running htop i see 30 pid for my mysql istance. – beard black Jan 31 '20 at 21:15
@beardblack Please post your HTOP report so we can see your HTOP output page 1. – Wilson Hauck Mar 07 '20 at 22:41

mysql thread and tomcat thread should be the same for a better perfoming?

1 Answers1