Hi,I have a web application. It is a java-jsp-tomcat-mysql. It is working, but
sometimes, it is slow. For each data update statement, it is not slow: the next
jsp page shows promptly. But the next page does not see updated data. I wait a
coupe seconds, refresh the page, the updated date shows. Each connection is
from tomcat.DataSource, so I believe each jsp page may use a different database
connection. So, mysql inside is slow. Anything I can do?
I checked server cpu and memory. Cpu is 20%, memory is lower than 50%.
Everything is running on one server machine, one tomcat, one mysql, runs on
Ubuntu: 4.15.0-54-generic, Tomcat/9.0.16, mysql: 8.0.21.
Any information would be appreciated. Thanks in advance.
