On Fri, Aug 22, 2003 at 10:55:49AM +0530, Rupak Banerjee wrote:
> Hi,
>
>   We are using MySql version 3.27.53 on a Red Hat Linux platform version
> 7.2. For the past couple of months we are noticing that the performance
> of the server has gone down very badly. Every, single insertion is
> taking a hell lot of time.The particular table has only 150,000 records.
>  Is there any remedy for this problem.

Perhpas you need a larger key buffer because your indexes are too
large to fit in memory?

Jeremy
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.13: up 20 days, processed 1,000,169,580 queries (554/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to