MySQL's Tri-party infobright Data Warehouse BrightHouse engine

Infobright is the MySQL three-party dedicated data analysis engine, specifically for more than billion-level data query, and query speed is the MySQL Myisam,innodb 5~60 times, the engine can be said that each field has established a variety of indexes,

https://www.infobright.org/

Installation and use: http://blog.zyan.cc/infobright/

The engine is three-way, there are two versions of the official web, one is the community version of "Free" one is the Enterprise version of "Fee $10000",

The Community edition does not support insert,update,delete for data manipulation and alter-to-structure operations, does not support high concurrency query operations "generally up to 10 concurrent queries", data storage high compression is generally 18:1, can not be connected with engines such as Myisam,innodb query, The data must be written using LOAD mode,

General Way

LOAD DATA INFILE ' filename ' IGNORE into TABLE table_name CHARACTER SET UTF8 fields TERMINATED by ' \ t ' LINES TERMINATED by ' \ n ' (fields)

FileName is the source file to import the data in, and \ t is the spacer between each data, \ n is the delimiter for each data, and fields is the corresponding field list.

Since the engine is basically full-indexed, try not to use variable-length fields such as text that cannot be indexed.

This article is from the "PHP in the Web" blog, so be sure to keep this source http://php2012web.blog.51cto.com/5585213/1580027

MySQL's Tri-party infobright Data Warehouse BrightHouse engine