Not able to connect to MemSQL 6.7 with MySQL J Connector 8.0.16


Getting error - Caused by: java.sql.SQLException: Unknown system variable ‘performance_schema’

Ran query SHOW VARIABLES; on my memsql instance and I do not see system variable ‘performance_schema’. But seems like MySQL JDBC Connector 8.0.16 expects it.

It works fine with MySQL JDBC connector 5.1.47 but its too old and I want to upgrade driver. Any suggestions?


Hello Vitthalkumar,

I would suggest using MySQL JDBC Connector 8.0.13 and make appropriate changes on settings file, it should resolve the problem.
Please find the link to download the same: