SQL Performance (MOSC)

MOSC Banner

Caching of Prepared Statements and Stored Programs v have_query_cache

Hi all, First time posting here. We are upgrading our database from MySQL 5.7 to 8.0.28 commercial. The caching of queries option 'have_query_cache' (https://dev.mysql.com/blog-archive/mysql-8-0-retiring-support-for-the-query-cache/) has been removed from version 8 as it was seen as a band aid for poor performance and was not scalable. The version 8 documentation does state that it will cache stored procedures within a session (https://dev.mysql.com/doc/refman/8.0/en/statement-caching.html) so I'm just curious to know what the difference is between the removed caching option and the caching within a session, and will we see performance degradation in our current queries.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center