Hi Jeremy,
Thankx for the solution......but can you please tell me how to increase the key buffer fo mysql ?? Its urgent...we are facing a lot of problems. Thankx once again for the solution. > 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) -- Visit http://www.brandemataram.com Login To The Future -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
