Mohamed Sadok MOUHA a écrit :
>
> We plan to use MySQL in a database of more than 200 000 client.
> Every client has about 1000 bytes of information (stored in 40 fields).
> The number of simultaneos connections could reach 1000.
> With such environment, what di you requires as OS? Does Linux RH 6.2
> is ok? Does MySQL is also OK? What about the hardware config
> (multiprocessor??, RAM??)?
>
> Does Any one can help me?
>
> Thanxs a lot
>
>
>------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> ---------------------------------------------------------------------
> 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 <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hi Mohamed,
I am currently running MySQL on RH 6.2 servers:
- It seems that due to some glibc limitations (it has been discussed
on this mailing list a few weeks ago), MySQL cannot open more than 1024 file
descriptors. Since each active connection uses one file descriptor for its
socket and one for each table used in query; it is not possible
to have 1000 simultaneous connections. My server crashed very often when
there was more than 400 connections, it is stable now with a maximum of 360.
- Under heavy load, I experienced a lot of index corruptions on a biprocessor
machine. The problem has disappeared after rebooting in single processor mode.
It seems that upgrading to a Linux 2.4 kernel with glibc 2.2 should solve the
problem but I have not tested it yet.
- RAM configuration is crucial for maximum performance. My databases use ~450Mb
(this a little bit more than what you describe,~200 Mb, but you should also add
space for indexes), MySQL is running on dedicated servers and ~ 1Gb of RAM is
used.
Hope this helps
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
