Access internal variables when performance_schema is disabled
Hi folks,
by default the performance_schema¹ is disabled, so that information like e.g. "sum_connect_erros" in performance_schema.host_cache² cannot be queried.
Is there a way to obtain this information from cache even if the performance_schema is disabled?
Because, internally, MariaDB respects settings like e.g. max_connect_errors³ and stuff like that even when the performance_schema is disabled.
Cheers Johannes
¹ https://mariadb.com/kb/en/performance-schema-overview/ ² https://mariadb.com/kb/en/performance-schema-host_cache-table/ ³ https://mariadb.com/kb/en/server-system-variables/#max_connect_errors
Answer Answered by Ian Gilfillan in this comment.
Generally no, the performance impact of the performance schema is because things are being recorded and stored, and this is not done if disabled. Things may be stored elsewhere, such as a status variable, in which case you can view it there, for example Connection_errors_accept.
