Do you have a question? Post it now! No Registration Necessary. Now with pictures!
January 30, 2007, 1:20 am
rate this thread
blocked on the query execution to return and the db connection does
not timeout. It happens during load test after about three days of
constantly making same type of application requests.
One article that I came across about diagnosing connection problems is
[dev.mysql.com]. Based on this I am setting log_warnings=2 in my
current test. But I am not sure if this is going to help because it
appears that only aborted connections will be logged. So I am looking
for suggestions on how to go about diagnosing this problem.
Other commands that I am using to determine the server status is: get
innodb status and get process list
MySQL Server: 5.0.22 - CentOS
Connector/J version: mysql-connector-java-3.1.13
JDBC connection parameters:
wait_timeout on the server side is default (8 hours)
Thanks in advance.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum