'Unknown system variable ‘query_cache_size’ on amazon rds mysql 8
I have been using MySQL connector jar version 5.1.44. I have been trying to connect amazon rds MySQL 8 through JDBC connection from a local machine but I'm getting an Unknown system variable ‘query_cache_size’. Can anyone help with it?
Solution 1:[1]
I was also looking for a way to enable query_cache in an RDS MySQL 8 instance.
AWS removed this option in MySQL 8, because it was "so problematic".
Source: AWS Database Blog - Best practices for configuring parameters for Amazon RDS for MySQL
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Guillaume |