in google cloudsql cannot monitor ram, , far can tell, cannot monitor disk/cache usage.
so when decide increase ram? when users complain it's slow? slow queries counter increases? number of aborted connections? follow guts?
thanks
use query in mysql instance:
show global status 'innodb_buffer_pool_pages_%'; then @ "innodb_buffer_pool_pages_free" , "innodb_buffer_pool_pages_total" variable see how many pages free compare how many pages allocated instance. each page 16kb.
Comments
Post a Comment