Abstract: Open source database MySQL is more and more widely used by airlines information system. Based on deeply analyzing the characteristic of business data in airlines domain, this paper provides a method of managing airlines fundamental data by means of memory storage engine. This method combines memory-based table with disk-based table, it not only provides good performance, but also solves the problem of memory table’s permanent storage.

Key words: MySQL, Storage engine, Database optimization, Memory table

摘要： 开源数据库MySQL越来越广泛地应用于航空公司的信息系统，在深入分析航空公司应用领域数据特点的基础上，该文提出了用内存存储引擎管理航空公司基础数据的方法。该方法结合内存表和磁盘表两种机制，不但提供快速的性能，而且解决了内存表的永久保存问题。

关键词: MySQL, 存储引擎, 数据库优化, 内存表