1

I have a problem with some performance_schema tables (*_by_host_* and *_by_account_*) taking up too much RAM. It is caused by clients connecting from a /19 subnet (8190 unique addresses). The connections aren't long-lasting: clients connect, perform a task and quit. Which settings can I tweak to limit the memory usage and what are the downsides of each limit?

The DB is on AWS RDS and I would like to keep Performance Insights with as much data as possible.

Improve this question

1 Answer 1

Reset to default
0

Shrink innodb_buffer_pool_size to provide some spare RAM.

There may ways to expand or shrink the limits inside P_S -- but this might not let you monitor all 8K addresses.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.