Mysql – best practice or tools for stress test on a Tomcat application server and MySQL

The problem is solved now.

It turned out that our backup program "mysqlhotcopy" was the problem.

The cause is that mysqlhotcopy locks, as I can see it, in one statement all tables of all databases when called without database parameter, respectively all tables of one database when called with database parameter. As our databases can contain some thousands of tables, this turned out to be impossible with our current system configuration.

So I wrote a new mysqlhotcopy-script and the problem has disappeared up to now.

As it is defined in the documentation, the redirect port will come into picture when SSL request will come to the server and since http connector port cannot handle SSL requests it will redirect to the port defined. But their must be another section defined in server.xml file in which the defined redirect port will act as a connector port to handle SSL requests. For example, If you want http requests to be handled by port 80 and https request by port 443 the server.xml will look like this:

<Connector port="80" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="443" />

<Connector port="443" protocol="org.apache.coyote.http11.Http11Protocol" SSLEnabled="true" scheme="https" secure="true" sslProtocol="TLS" keystoreFile="/path/to/kestorefile" keystorePass="my_keystore_password"/>

Keystorefile is the ssl certificate of your website.

If you don't configure the other section with redirect port as a connector port your requests will not be redirected to that port. For example if the website do not support ssl requests and you try to send https request to that website an error like Secure Connection Failed will be shown on the browser.