Tag Info

New answers tagged

0

you need to give it a value if you wish to preserve the binlogs: call mysql.rds_set_configuration('binlog retention hours', 24); will cause the binlogs to be stored for 24hrs, for example.


0

Before deciding on value for max_connections I suggest that you look at WHY it reached the max_connection condition. A bunch of sleeping/idle connection due to loose coding is very common cause. Check if you have proper value for wait_timeout and adjust if this is your symptom. Besides that, I would check for INSERT/UPDATE query that holds table locks for ...


0

I suggest taking a look at processlist while the DB is dumping. There could be locked MyISAM tables causing queue of statements waiting for locks to be released.


0

You can use the below comment to check the connections: SELECT count(*) FROM INFORMATION_SCHEMA.PROCESSLIST; SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST order by DB; For MySql you can have the below value to optimize the performance innodb_log_file_size = 512M max_connections=2000 max_allowed_packet=64M wait_timeout=604800 key_buffer = 384M table_cache ...


0

Many connection options aren't available as command line flags. That's one of them. Use a connection string, e.g.: psql "host=XXXX.rds.XXXX.com sslmode=require sslrootcert=rds-ssl-ca-cert.pem port=XXXX username=XXXXX dbname=XXXX"



Top 50 recent answers are included