Air traffic ontime test

Air traffic ontime test

The run.atc.ontime.bash script loads air traffic onetime data into a MySQL database, checks the tables for correctness after the load, runs some queries on the data, and compares the result sets to the expected result sets.

The test expects that a mysql build is installed in '/usr/local' and that mysqld is running on unix socket '/tmp/mysql.sock'. There are command line arguments that control

• whether or not the loader is used to load the data (tokudb_prelock_empty),
• whether or not the loader compresses intermediate files (tokudb_load_save_space),
• the compression algorithm used for the table (tokudb_row_format),
• the amount of memory used for the loader (tokudb_loader_memory_size).

See the atc.readme for more details.

Expected results: test passes with reasonable query times.

Future work

• Run the test with various combinations of compression and loader memory.
• Check query times