MySQL Forums :: InnoDB :: large volume inserts/selects
Re: large volume inserts/selects
Posted by: James Day ()
Date: January 22, 2005 11:57PM
It's not large by some definitions but Wikipedia sees around 200 million selects and 2.1 million inserts/updates per day, using InnoDB for most of them. Total database size is around 180GB. Dual Opterons with six drive RAID 10 sets, 4 or 8GB of RAM and a master with a couple of slaves are sufficient for that. Add in another couple of slaves for fulltext search through about 6GB of text and related queries. Depends very heavily on the exact nature of the queries and most are fairly simple.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| large volume inserts/selects | 3472 | Michael Kirby | 01/11/2005 08:58AM |
| Re: large volume inserts/selects | 2160 | Heikki Tuuri | 01/12/2005 05:18PM |
| Re: large volume inserts/selects | 2203 | James Day | 01/22/2005 11:57PM |
| Re: large volume inserts/selects | 2161 | Heikki Tuuri | 01/26/2005 05:37PM |
| Re: large volume inserts/selects | 1844 | James Day | 01/27/2005 07:51AM |
| Re: large volume inserts/selects | 2655 | Heikki Tuuri | 01/31/2005 11:30AM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.