Okay just checking a few basic things, have you indexed your table properly?
There is a manual section about performance, also make sure to play around
with the mysql configuration file (global one in /etc/my.cnf)
>From: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: MYSQL Problem
>Date: Mon, 16 Apr 2001 21:37:47 +0530
>MIME-Version: 1.0
>Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id
>MHotMailBCA465A9002A40043165C03AC5A20D8C0; Mon Apr 16 09:15:38 2001
>Received: (qmail 1297 invoked by uid 7797); 16 Apr 2001 16:05:38 -0000
>Received: (qmail 1280 invoked from network); 16 Apr 2001 16:05:31 -0000
>From mysql-return-71620-acojocaru Mon Apr 16 09:17:04 2001
>Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
>(http://www.ezmlm.org)
>List-ID: <mysql.mysql.com>
>Precedence: bulk
>List-Help: <mailto:[EMAIL PROTECTED]>
>List-Unsubscribe:
><mailto:[EMAIL PROTECTED]>
>List-Post: <mailto:[EMAIL PROTECTED]>
>List-Subscribe: <mailto:[EMAIL PROTECTED]>
>Delivered-To: mailing list [EMAIL PROTECTED]
>Message-Id: <[EMAIL PROTECTED]>
>Priority: normal
>X-mailer: Pegasus Mail for Win32 (v3.11)
>
>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
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
