On 21-Oct-2002 Francesc Guasch wrote:
> Hi.
> I asked this question last week and nobody answered. Please
> someone give me a hint.
>
> I need to buy a new server that must handle 500 concurrent
> connections to a mysql server and I don't know how many RAM
> should have.
>
I've a server that does 200 average up to 600 (max_connections)
Dual Pentium III 850Mhz w/ 1 Gig of memory.
Load is normal at 0.6, and peaks at 4 processes.
> I've been looking to the process list but I'm clueless about
> how much memory is shared. Any advice ?
>
> Here is the output of VMonitor:
>
>## PID UID Size Share VSize Rss TTY St Command
> 1 23902 mysql 21M 2.2M 71M 21M S mysqld
> 2 23904 mysql 21M 2.2M 71M 21M S mysqld
> 3 23905 mysql 21M 2.2M 71M 21M S mysqld
> 4 23906 mysql 21M 2.2M 71M 21M S mysqld
> ....
>
> Does this mean every connection uses 21M of memory,
> 2.2 MB shared with the rest of mysql clients ?
>
No. The base footprint of the daemon is 24-40M. Each additional thread will
eat another 0.5 - 1.5M, depending on configuration.
YMMV.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
