Re: How Huge of your mySQL database or table in your former Instance
On Sun, Dec 16, 2001 at 09:49:29AM -0600, Philip Molter wrote: > On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote: > : On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote: > : > > : > So, could you give me some advice that if it is feasible ? Or show > : > me your successful cases of using mySQL which is supporting very > : > large DB or tables with details ? > : > : How about a table with 260 million rows? We've got one that is very, > : very quick for indexed selects. > > How quick is it for inserts? And what table type? Sorry for the insanely late reply. I had to vanish for a while. It is a MyISAM table and we can run a few hundred inserts/second on it--(probably a lot more, but I can't easily test that right now. Hope that helps. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 5 days, processed 123,265,106 queries (246/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How Huge of your mySQL database or table in your former Instance
On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote: : On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote: : > : > So, could you give me some advice that if it is feasible ? Or show : > me your successful cases of using mySQL which is supporting very : > large DB or tables with details ? : : How about a table with 260 million rows? We've got one that is very, : very quick for indexed selects. How quick is it for inserts? And what table type? * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How Huge of your mySQL database or table in your former Instance
On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote: > > So, could you give me some advice that if it is feasible ? Or show > me your successful cases of using mySQL which is supporting very > large DB or tables with details ? How about a table with 260 million rows? We've got one that is very, very quick for indexed selects. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 16 days, processed 373,938,737 queries (254/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How Huge of your mySQL database or table in your former Instance
Thanks very much Paul, Could you like to tell me what time spent in your querying ten thousands of records from tables one time? In my test, when I query 10,000 records from a table which contains 17 millions records total, it will cost less than 1 second of querying INDEX, or cost more than 30 seconds of querying normal COLUMNs. I want to know query speed in larger table. Regards Ares - Original Message - From: <[EMAIL PROTECTED]> To: "Ares Liu" <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 1:28 PM Subject: Re: How Huge of your mySQL database or table in your former Instance > > Now I want to design a database which contains more than 10G data to use. I > > think the largest table in my db will contains more than 30 million records > > and the amount of this kind of table will be up to 7 or 10. In my instance > > there won't be so many clients connecting. normally, there are less than 20 > > clients concurrent querying. My hardware is dual PIII 933, 512M I plan to > > upgrade to 1G RAM, three SCSI 18G HD, one of them is dedicated to mySQL DB. > > platform RH 7.2 with XFS. > > > > So, could you give me some advice that if it is feasible ? Or show me your > > successful cases of using mySQL which is supporting very large DB or tables > > with details ? > > I've just restructured a database which has 8 identical tables whose size > varies by the hour. They often have 30-35 million rows each. In addition, > there are two new tables per day, and the system has been running for over > a year now. > > The database server is a dual PIII-1000 with 1 Gb of RAM, 18 Gb Ultra-wide > SCSI disk for the system, and a RAID array with 14 * 73 Gb IBM 10,000 rpm > Ultra-wide SCSI discs. > > The system sings. It's easy to hit disk limits with a large database, hence > the RAID array above. It has 8-10 other machines on a 100 MHz ethernet lan > which fire selects at the database server, and two which issue inserts into > the 8 tables mentioned above. > > Hope this helps a little. > > Regards, > > Paul Wilson > iiNet Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How Huge of your mySQL database or table in your former Instance
All, Now I want to design a database which contains more than 10G data to use. I think the largest table in my db will contains more than 30 million records and the amount of this kind of table will be up to 7 or 10. In my instance there won't be so many clients connecting. normally, there are less than 20 clients concurrent querying. My hardware is dual PIII 933, 512M I plan to upgrade to 1G RAM, three SCSI 18G HD, one of them is dedicated to mySQL DB. platform RH 7.2 with XFS. So, could you give me some advice that if it is feasible ? Or show me your successful cases of using mySQL which is supporting very large DB or tables with details ? Thanks a lot! Ares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php