Summary
We have learned what condition pushdown is and how it can be used to optimize Information Schema plugins that need a lot of processing time per row. We have also looked into some real world examples of Information Schema plugins that access internal MySQL data structures and expose them to the user.
This chapter concludes the subject of Information Schema plugins. In the next chapter we will start looking at full-text parsers.