Re: How many records can a single MySql Table Hold.

2003-08-26 Thread Vinay
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

Re: How many records can a single MySql Table Hold.

2003-08-25 Thread Rupak Banerjee
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

How many records can a single MySql Table Hold.

2003-08-25 Thread Rupak Banerjee
Hi, I have a mysql database running on Mysql version 3.23.53 on a Red Hat Linux 7.2. In the database there is a single table with over 150,000 records. Unfortunately, the performance of that table is very poor, comparing to other tables in the same database. Can somebody help me out. Thanks,

Re: How many records can a single MySql Table Hold.

2003-08-25 Thread Antony Dovgal
On Mon, 25 Aug 2003 10:05:32 +0530 (IST) Rupak Banerjee [EMAIL PROTECTED] wrote: Hi, I have a mysql database running on Mysql version 3.23.53 on a Red Hat Linux 7.2. In the database there is a single table with over 150,000 records. Unfortunately, the performance of that table is very

Re: How many records can a single MySql Table Hold.

2003-08-22 Thread Jose Miguel PĂ©rez
Hi Rupak! 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

Re: How many records can a single MySql Table Hold.

2003-08-22 Thread Egor Egorov
Rupak Banerjee [EMAIL PROTECTED] 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

Re: How many records can a single MySql Table Hold.

2003-08-22 Thread Jeremy Zawodny
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

AutoReply: Re: How many records can a single MySql Table Hold.

2003-08-22 Thread educredit
Thank you for the Email. I will contact you within 24 hours. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How many records can a single MySql Table Hold.

2003-08-21 Thread Rupak Banerjee
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