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.