Monthly Archives - June 2009

Few more ideas for InnoDB features

As you see MySQL is doing great in InnoDB performance improvements, so we decided to concentrate more on additional InnoDB features, which will make difference.
Beside ideas I put before (and one of them – moving InnoDB tables between servers are currently under development), we have few mores:
– Stick some InnoDB tables / indexes […]

Read more

Another look at improving TPC-H-like queries – Q17

Summary: An alternate approach, offered in response to our original post, provides excellent improvements for smaller databases, but clustered indexes offer better performance as database size increases. (This posting is by Dave.)

Jay Pipes suggested an alternate approach to improving MySQL performance of Query 17 on a TPC-H-like database.

Add the index (l_partkey, […]

Read more