Are you sure about that number? 1,000 queries per second is pretty high.
Assuming that 10k per second is correct, that translates to 36,000,000
queries per hour. That is quite a lot. BTW, what DB were you using before
and was its inability to handle your load a factor in your decision to
switch? Have you tried setting limitations on the number of concurrent
connections and such. Very possibly, your server is being completely
overwhelmed. Also, with that much activity, your database will soon grow
beyond your 10gb disk capacity.
If you could supply a little more information:
1. What web server and version are you using?
2. What threads library and version?
3. What OS and version?
4. What other applications might you have loaded on the system?
5. What version of MySQL are you using?
6. Which type of DB tables are you using? (MySQL supports a number of table
types).
7. Are you using binary distributions or did you compile from the source?
8. If compiled, which compiler and version did you use?
9. Are you using a server-side scripting language and if so what type and
version?
These basic questions need to get answered before moving forward.
Happy hunting....
Dean
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 11:08 AM
To: [EMAIL PROTECTED]
Subject: MYSQL Problem
Hi Everybody,
We have a very popular greetings card site at http://gcards.com
We recently switched to MYSQL as our backend database..
But recently we noticed that MYSQL cannot handle high load under
normal installation. In our system we get more than 10,000
insert/update/delete/select queries per second sometime. And this
creates the problem.
Under this circumstances MYSQL failed to respond or get hanged.
We have to restart MYSQL then.
We are on a dedicated server with 256 MB of RAM and 10 GB disk
space.
We are trying to figure out the problem but if anybody could help
on this that could be gr8. We've a good offer also for this. Whoever
will solve this problem will get the source code of our card program
FREE. Only dedicated and sound developer/engineer are need to be
contacted in the following email address
[EMAIL PROTECTED]
Best Wishes,
The Development Team
http://www.gcards.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
---------------------------------------------------------------------
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
