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