Nov 7, 2023 · Databases

When Does MySQL Use Internal Temporary Tables? Analysis of UNION, GROUP BY and Other Scenarios

This article explains the circumstances under which MySQL creates internal temporary tables, illustrating the behavior with UNION, UNION ALL, GROUP BY, various hints, and additional query patterns, and provides practical examples and execution plans to help developers understand and optimise their queries.

GROUP BYMySQLSQL Hint

0 likes · 13 min read

When Does MySQL Use Internal Temporary Tables? Analysis of UNION, GROUP BY and Other Scenarios

Java High-Performance Architecture

Aug 5, 2015 · Databases

When to Use MySQL Query Cache: Hints, Best Practices, and Pitfalls

This article explains how MySQL's Query Cache invalidation works, which tables are suitable for caching, how to control caching with the SQL_NO_CACHE and SQL_CACHE hints, and how to handle large result sets using the query_cache_limit setting.

MySQLQuery CacheSQL Hint

0 likes · 3 min read

When to Use MySQL Query Cache: Hints, Best Practices, and Pitfalls