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.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.