Re: How many records can a single MySql Table Hold.
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]
Re: How many records can a single MySql Table Hold.
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]
How many records can a single MySql Table Hold.
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, Rupak Banerjee. -- 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]
Re: How many records can a single MySql Table Hold.
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 poor, comparing to other tables in the same database. Can somebody help me out. Thanks, Rupak Banerjee. read about query optimization and table indexes. use EXPLAIN SELECT .. to see what happends with your query. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How many records can a single MySql Table Hold.
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 records. Is there any remedy for this problem. I have been working with MySQL tables up to 16 million records, and the INSERTS was lightning fast (Making SELECTS was another history, but raw INSERTS worked fine). So I think your problem relates more to index structure, make sure you don't have more indexes than really needed. You can test with a temporal table without any keys (not even primary) and adding indexes until you get the behaviour described so that you can locate which is the problem. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How many records can a single MySql Table Hold.
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 particular table has only 150,000 records. Is there any remedy for this problem. You can have up to 4 billion rows in one MyISAM table. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How many records can a single MySql Table Hold.
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]
AutoReply: Re: How many records can a single MySql Table Hold.
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.
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. Thanks and regards, Rupak Banerjee. -- 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]