If you are truly getting 10k queries per second, that would imply to me a roughly
comparable number of webserver connections (maybe within a factor of 2). If this is
the case, I'd be amazed that it would work at all when hosted on a single box with
"only" 256M of ram. I believe your problem is with the overall architecture of your
system, not mysql specifically. I think that the first thing I would do is either add
ram or move mysql to a dedicated server to try and distribute the load.
Then I would consult some apache (I'm assuming thats what your running) performance
and tuning guides.
Also, I would examine the ratio of insert/updates to selects along with your use of
indexing.
Regards,
Gary "SuperID" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 12:08 PM
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