|
Dave:
The other issue that I was concerned about was the
garbage collection. The JVM is currently runing with a 768M heap. I had seen
some tech notes on GC that can cause 100% cpu usage. I tried using the low pulse
collector, but that didn't seem to help.
To further elaborate on Kevin's
information:
We have two twin systems:
1x Opteron 246 2 GHz
2GB RAM
Windows 2003 Server x64
Jrun of course is running in 32bit mode. It is also
running as a local user for interaction with our SMB file server.
We have the latest version of SeeFusion on both
systems. What I have observed is that the query times to the database are less
than a second ( Fractions of ). Where we run into problems is CF rendering the
results. We start seeing 6+ second times after the query has
executed.
I have also been running a tool on our DB server
called mytop..basically identical to the top command on Linux / UNIX systems. It
allows for per-thread montitoring of incoming queries.
The types of queries are on average very short..but
there are times when very large reports on data are ran. We also use a mixture
of MyISIAM and InnoDB tables. The rows in the InnoDB tables are very long. I'm
wondering if this can be part of the issue too?
Thanks agian!
----- Original Message -----
Sent: Wednesday, October 25, 2006 1:08
PM
Subject: Re: [DFW CFUG] not the first
time you've heard from me
Kevin, I felt the same way on my first pass of SeeFusion.
However, we enlisted their (Webapper) consulting services and after seeing how
they used the tool, its value became apparent *very* fast. With
SeeFusion you can watch the threads come and go, and find long running or
hanging requests. They also have a wrapper that you can put around your
jdbc:// path in your DSNs that will log the database interaction and you can
monitor all the way down to specific lines of code and queries that are
breaking your stuff. Believe me, I understand your plight. We had
an application tailspin on us like this and the Webapper guys helped us nail
it. I don't know what your budget is like but if you can afford to
contract them in on the troubleshooting, I can almost guarantee you will feel
it was money well spent.
~Dave
On 10/25/06, Kevin
<[EMAIL PROTECTED]>
wrote:
I am so tired of trying to find out the answer to these problems that I'm
about to look for a job flipping burgers.
We continue to have 100% JRUN issues on our servers.
We have windows 2003 64x servers – plenty of ram, etc.
We have a Linux box running mySQL 5 – plenty of ram, etc.
Our systems are all production systems. Everything is built on the
fly. Therefore I KNOW that there are some code issues and db
issues. I can't even begin to correct these issues because the servers
keep maxing out the JRUN and crashing.
Can anyone help? See fusion sux for some reason and has been no
help. Are there any tools out there that we can use to monitor traffic
and requests by cf and mySQL to help us identify where the problems are?
Thank you for any help you can provide.
kevin
_______________________________________________
Reply
to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List
Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG
Sponsors:
www.HostMySite.com
www.teksystems.com/
--
~Dave Shuck
[EMAIL PROTECTED]
www.daveshuck.com
Where's your
Spot?
www.instantspot.com
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG
Sponsors:
www.HostMySite.com
www.teksystems.com/
| 