Re: Big MyISAM table with 3500 insertions per second behaviour

[Edwin DeSouza]

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