Thanks guys for the responses. Hmmm? Well, I suppose my problem
could be somewhere else. But I am still a little unsure about
something. First, here is more background....

- MySQL has exclusive use of the server (ie the J2EE app is not on it)
- the server has 8GB of RAM
- my-large.cnf is in /etc

>>Rob:
>>Does this mean I have 549 live open connections via my connector/j
>>driver from my app?

>Gordon
>No, 549 connections since startup. This is not inconsistent with a
>maximum of 10 simultaneous connections.

That confuses me though. Because I have another MySQL install that I
look after, and it shows Opens:0, yet I know that machine is active.
May we compare my two machines?:
------------------------------
MACHINE 1
(involved in the problem I am asking about, MySQL has whole server,
8GB RAM)
Threads: 5 Questions: 12940 Slow queries: 0 Opens: 191 Flush
tables: 1 Open tables: 64 Queries per second avg: 0.246

MACHINE 2
(runs fine, MySQL has the whole server, 4GB RAM)
Threads: 2 Questions: 79842768 Slow queries: 0 Opens: 0 Flush
tables: 1 Open tables: 64 Queries per second avg: 1.558
-----------------------------

Two quick notes.....these 2 databases serve different data (they are
used by the same apps). And, MACHINE 1 was just restarted and has
only about an hour of very low use on it (but the office if filling in
now, it will rise). If Opens: 549 (from my previous posting) is the
connections since startup, why does MACHINE 2 have Opens: 0 ? I know
that database is consistently used, and runs nicely.

Also, I would estimate that I would reach 549 connections in....man,
about 5 minutes in the middle of the day. So that fact, plus MACHINE
2 having Opens: 0 is confusing me?

I see my server variable of table_cache is 64, so the fact both server
have reached Open Tables: 64 is not a surpirse. Is "Opens:" really
the number of database connections since uptime? If yes, what would
cause MACHINE 1 to be so low, and MACHINE 2 to be 0?

Rob