Hello Terje,
Friday, September 07, 2001, 12:11:30 PM, you wrote:
TK> I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00
TK> (hppa2.0w),
TK> Apache/1.3.20.
TK> The load are rather high, and "Queries per second avg: 94.859"
TK> This is an local B2B installation som we are really not getting any traffic
TK> between 4PM and 7AM
TK> We have peeks where there is more than 1000 Queries per second.
TK> Does anyone have any experience with a higher number of queries pr second
TK> than this ?
There can be lot of queries such as 'SELECT 1' which won't actually
make high CPU load on server and there can be few queries with several
joins without using keys which can almost kill the server. It depends.
I have server which handles about 300-400 queries per second and
serves for ~30 websites.
TK> Regards
TK> Terje K
TK> ---------------------------------------------------------------------
TK> Before posting, please check:
TK> http://www.mysql.com/manual.php (the manual)
TK> http://lists.mysql.com/ (the list archive)
TK> To request this thread, e-mail <[EMAIL PROTECTED]>
TK> To unsubscribe, e-mail <[EMAIL PROTECTED]>
TK> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Best regards,
Vinche mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
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