473,326 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Diagnosing ConnectionProblems

Application thread (Java server code) making database queries is
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

My Environment:
MySQL Server: 5.0.22 - CentOS
Connector/J version: mysql-connector-java-3.1.13
JDBC connection parameters:
autoReconnect=false
connectTimeout=5000
socketTimeout=8000
wait_timeout on the server side is default (8 hours)

Thanks in advance.

- M

Jan 30 '07 #1
0 2371

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tim Callaghan | last post by:
We have an inhouse replication process which is causing us headaches when we try to run more than one copy of it against the same target database (we support unlimited remote databases so we may...
2
by: pratchaya | last post by:
This is my sample error in my MySQL Log New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions...
1
by: James Tsao | last post by:
I'm trying to run an external image processing application from a web application. The function below works for a windows application but when i try to call it from a web app, the image processing...
5
by: CB | last post by:
Does anyone know of a resource for diagnosing ASP_0147 errors that appear occasionally in server logs? They hit my server in bunches, on rare occasions, for about an hour at a time. Any advice...
0
by: andy6 via DotNetMonster.com | last post by:
When I run a specific report I intermittently, on different laptops, desktops, etc, get this error: An error has occurred during report processing. Exception of type 'System.OutOfMemoryException'...
0
by: Simon | last post by:
I have a problem with an application which randomly hangs on site. The symptoms are that the user will click a button - which normally would open a new form (which inevitably will create a socket...
18
bartonc
by: bartonc | last post by:
I run my monitor at 1280 X 1024. IE7 has a great look. I can't seem to find anything even close on Firefox. PS The new site icon still hasn't loaded. Any suggestions?
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.