Hello,
I saw your message on the list, could you
tell me which scripting language you are
using (php, perl, java ?)
and if you have the time could you show me
your my.cnf and the result of a "show variable"
request ? I am experiencing problem with 100% CPU
load and can't figure what it is ?
Thanks in advance,
Jerome
>>> -----Message d'origine-----
>>> De : Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
>>> Envoye : vendredi 7 septembre 2001 11:05
>>> A : [EMAIL PROTECTED]
>>> Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED]
>>> Objet : Re: A question about load / queries pr second
>>>
>>>
>>> On Fri, Sep 07, 2001 at 09:54:35AM +0100,
>>> [EMAIL PROTECTED] wrote:
>>> >
>>> >
>>> > > About a year ago, I used mysql-super-smack and was able to hit
>>> > > 8,000 per second on our [then new] server. The highest I've
>>> > > recorded on an actual production application was around 5,000.
>>> > > But I don't watch the numbers closely very often...
>>> >
>>> > Just out of curiosity, on what hardware? My needs are much lower
>>> > than this, but my management may get worried about what we might,
>>> > just possibly, need in the future. If I can explain that
>>> MySQL will
>>> > stretch far beyond our conceivable needs, it would help pacify a
>>> > hardware-oritented management who tend to favour software
>>> suppliers
>>> > they hear about on the financial pages (i.e. M$ or Oracle, in this
>>> > case).
>>>
>>> This was Linux 2.2.x on a dual-cpu P3-850 with 1GB of RAM and 5 36GB
>>> SCSI disks.
>>>
>>> Most of the time, our busy hours run around 300-600 queries per
>>> second, with non-peak times being in the 50 queries per second
>>> ball-park.
>>>
>>> But as each month goes by, the numbers keep increasing. Luckily,
>>> we've got a lot of room to grow.
>>>
>>> Jeremy
>>> --
>>> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
>>> Technical Yahoo - Yahoo Finance
>>> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>>>
>>> MySQL 3.23.41-max: up 1 days, processed 20,918,186 queries
>>> (202/sec. avg)
>>>
>>> ------------------------------------------------------------
>>> ---------
>>> 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
>>>
---------------------------------------------------------------------
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
