See, everyone seems to have good experience with MySQL except for me ;) I've
worked with multiple companies that use it under the covers yet can't seem
to get it to perform worth crap under even medium loads. I know of two
companies at least that have invested small fortunes into MySQL tuning and
configuration only to give up in the end and switch to Oracle.
In regards to monitoring and tuning, that really seems to be a black art.
MINA does support JMX for monitoring but with only 10k connections though, I
really wouldn't worry too much about it. That load isn't very much and MINA
will handle it easily. Better to focus on coding the app as cleanly as
possible initially and testing it heavily to make certain you know how it
performs. I think your real performance problem on the Java side will be
Hibernate (assuming you are going to be calling it 1000 times per second).
Mike
----- Original Message -----
From: "Vinod Panicker" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, July 13, 2007 1:47 AM
Subject: Re: MINA Performance and Scalability
On 7/13/07, Ahmed Al-Obaidy <[EMAIL PROTECTED]> wrote:
Thank you Michael,
1. So you think MINA is able to support 10K session?
2. Do u recommend PostgreSQL or even MaxDB to replace MySQL?
3. where can I find articles about monitoring and tuning my server?
We've seen over 50k sessions per machine using mina during load and
even 200k without any load. It all depends on your OS.
I've seen over 20k queries per second on MySQL (with tables having
millions of records) and found it to be fantastic in terms of
performance. It all depends on how you structure your data and tune
the server.
For best performance, use a server JVM with Epoll enabled. The 1.6
JRE has it by default and 1.5_0.11+ JRE's have support for it via a
JVM option.
Regards,
Vinod.
