A POC module demonstrating how to use Drupal APIs to implement advanced MySQL optimizations - View it on GitHub