Check under ulimit to raise the number of file descriptors.
ulimit -n #
Linux has a global limit (4096 in debian' case) which may also be
raised. However, as someone else has recommended, look at shortening
the time you are actually connected. Connect, get data, disconnect,
process data...just a thought.
Check /proc/sys/fs/file-nr
You must be root to chane this.
On Mon, 26 Feb 2001, Joseph Bueno wrote:
Date: Mon, 26 Feb 2001 13:56:52 +0100
From: Joseph Bueno [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Subject: Re: MySQL, Linux and Hardware config
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
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
-
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
