MySQL Users Conference 2006 “MySQL is at the heart of revolutionary changes in computer history.“—Tim O'Reilly
 Co-presented by O'Reilly Media, Inc. and MySQL AB
 Conference Coverage

Session

Measuring MySQL Server Performance for the Sensor Data Stream Processing

Jacob Nikom, Technical Staff Member, MIT Lincoln Laboratory

Track: Performance Tuning and Benchmarks, Cluster, Replication, and Scale-out
Date: Thursday, April 27
Time: 11:20am - 12:05pm
Location: Ballroom D

The RTS Operations Coordination Center (ROCC) manages the streams of data from multiple sensors, processes the acquired data, and provides operator displays to track and predict the path of space objects. To perform these tasks ROCC needs to implement real-time data storage and distribution functionality.

Real-time storage of high rate data streams coming from multiple ROCC sensors is a major database management system (DBMS) challenge. The DBMS cannot lose any information, but at the same time it cannot be a bottleneck for the whole system. This ability can be evaluated by measuring the database server throughput.

Throughput benchmark was implemented more than two years ago to compare MySQL server performance on different operating systems and hardware. We will discuss the benchmark and the results which show excellent throughput performance of the MySQL server.

The real-time data distribution solution comes from the possibility to create a DBMS-based messaging system with very low latencies. Such a concept could bring together data processing and distribution, unify API to access the latest and oldest information, and centralize data management. The DBMS needs to provide a very fast response to data requests while allowing message filtering on the server side. This ability could be evaluated by measuring the delay between storage and retrieval times or latency performance.

Recently, the latency benchmark was implemented to evaluate MySQL server performance in a real-time messaging system with many writing and reading clients. We will discuss the benchmark design, execution, and the results which indicate good responsiveness of the MySQL server.



Diamond Sponsor

Business Objects
Hewlett Packard

Platinum Sponsors

Four J's Development Tools, Inc
GoldenGate Software, Inc.

Gold Sponsors

Actuate Corporation
Cleversafe
Continuent
Data Direct Technologies
Dell Inc.
Dolphin Interconnect Solutions
Embarcadero Technologies
EMC Centera
IBM
JasperSoft
Lumen Software
Novell, Inc.
Pentaho
Rackspace Managed Hosting
Red Hat
Solid
SugarCRM
Sun Microsystems
The SCO Group
Unisys
Zmanda, Inc.

Media Sponsors

Conference Guru
Database Trends and Applications
DevtownStation News
IPTV Industry
Linux Journal
LinuxQuestions.org
MacMinute
Methods and Tools newsletter
Mixi.jp
Queue
SDForum
Sys Admin magazine
The ServerSide
The Women's Technology Cluster
VoIP-News
Web Host Industry Review
WiMAX Industry
WITI

In-Kind Sponsors

Griffin Technology
RoundaboutFive.com
SkinIT

Sponsor Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact us at

Download the MySQL Users Conference Sponsor/Exhibitor Prospectus

Conference News

To stay abreast of conference news and to receive email notification when registration opens, please sign up here.

Press and Media

For media-related inquiries, contact Suzanne Axtell at

Copyright MySQL AB and O'Reilly Media, Inc.
MySQL O'Reilly