MySQL performance bottleneck for data warehousing

Without the tools of hash joins and parallel, MYSQL is destined not to be a suitable data warehousing tool.

Whether it is MyISAM or InnoDB, when dealing with a complex SQL query, it is not possible to perform multi-core CPU performance.

Only one CPU is running at full load.

So for an analytic database, MySQL multicore is actually a huge waste.

But after the selection of the scheme, can only do more optimization.

For example: Split SQL manually and merge result sets.

MY.CNF configuration optimizations, increased temporal tablespace and key_buffer_size, and more.

Even kettle, DATASTAGE, can not do distributed computing like Hadoop when dealing with massive amounts of data.

Hey, if let me choose, or on the PG library forget it.

MySQL performance bottleneck for data warehousing