MySQL Forums
Forum List  »  Optimizer & Parser

Re: Big MyISAM table with 3500 insertions per second behaviour
Posted by: Edwin DeSouza
Date: February 22, 2006 01:39PM

You may want to see this case study:

The Reagan Test Site Operations Coordination Center (ROCC) manages the data flow from multiple sensors, processes the acquired data, and provides operator displays to track and predict the path of space objects.

Another challenge is effectively processing data streams that come from multiple sensors. Features that are not typical of the traditional database management system, such as almost real-time response, high input data rates, specific structure of incoming data, etc., validate the need for a sensor database.

In addition to these often contradictory requirements, the data collection process is very intensive. Lost data due to database failure is inexcusable. Reliability is paramount in the selection of a storage system, narrowing the choice to a relational database such as MySQL. In addition, the design must take every precaution to prevent the database to became a single point of failure for the whole system.

http://conferences.oreillynet.com/presentations/mysql05/nikom_jacob.pdf
http://www.mysql.com/why-mysql/case-studies/mysql-rocc-casestudy.pdf

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Big MyISAM table with 3500 insertions per second behaviour
2144
February 22, 2006 01:39PM


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.