john pfeiffer
  • Home
  • Categories
  • Tags
  • Archives

Amazon rds

amazon-rds

Server Instance optimized to run MYSQL only

DB Parameter Groups "configures" each instance

max_connections = {DBInstanceClassMemory/12582880} small instance, then, this value should be 1.7GB or 1825361100 = 145 (matches!)

desc mysql.slow_log; select count() from mysql.slow_log; select * from mysql.slow_log where query_time > '00:00:05' limit 1; select count() from mysql.slow_log where query_time > '00:00:05';

NOTE: mytop (mysql top program for linux) is quite useful for also debugging...


  • « Vmware esxi iscsi openfiler continued
  • Amazon mysql to rds migration »

Published

Apr 20, 2011

Category

virtualization

~64 words

Tags

  • amazon 17
  • rds 4
  • virtualization 87