MySQL index dumper/loader

The quickest method for storing/loading MySQL data is using "SELECT INTO OUTFILE" and "LOAD DATA INFILE" statements. After an "LOAD DATA INFILE", indexes need to be rebuilded. In MEMORY (HEAP) data storage, indexes use hashed keys, but a computation of a hash value for records is slow. A solution to this issue is to store index structure into file when "SELECT INTO OUTFILE" is called and restore indexes when "LOAD DATA INFILE" is called. Program should be a patch against MySQL source, which: 1. On "SELECT INTO OUTFILE" will find all indexes of all MEMORY storage tables involved in query and saves them to separate or the same file. 2. On "LOAD DATA INFILE" will restore all indexes saved previously. You can assume that only one table will be involved in query and MEMORY storage with HASH keys (not BINARY) will be used for indexes.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

MySQL 5.1

Programación en C Ingeniería MySQL PHP Arquitectura de software Verificación de software

Nº del proyecto: #3211285

Sobre el proyecto