Score:0

How to find usage (memory) of databases inside a Google CloudSQL instance?

uy flag

I run multiple databases inside a single CloudSQL instance. My problem is that I cannot get monitoring insights at the individual database level. For example, if I want to know how much memory a particular database is causing, I cannot find that. Google's monitoring for CloudSQL shows the total instance level resource utilisation. Does anyone have any helpful ideas on this?

Thank you.

Score:0
co flag

In terms of the database as mysql: Just write a script to calculate the memory (like the innodb_buffer_pool_size/sort_buffer_size and other buffer parameters) and then calculate the memory with max connections utilization and the number of connections happening at the moment.

In that way we can check the database memory.

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.