Apart from "my.cnf" MySQL also provide you with my-huge.cnf, my-large.cnf, my-medium.cnf and my-small.cnf.
Files whih are used for diferrent sizes of datadases. Check them out it can help. if you find the conf you r looking for in one of the cnf file you just have to rename it to my.cnf. Vinay Jeremy Zawodny wrote: > 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] -- http://www.uptoten.com - The fun place to learn on-line UpToTen Kids : 600 educational games and activities. UpToTen Parents : Practical ideas and advice. UpToTen Toyshop : Great gifts to give. Great gifts to receive. http://toyshop.uptoten.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]