New answers tagged amazon-rds
From RDS Console > Parameter Groups > Edit Parameters, You can change the value of the max_connections parameter to a custom value.
Found the answer. I need to specify the port number when making the connection, per this article: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToInstance.html
It appears that things have changed since the accepted answer. After seeing this thread I ran a test on a db.m3.medium RDS MySQL instance with max_connection manually set to 2000 using DB Parameter Groups. I was able to create 2000 connections and only then got the expected error of Too Many Connections.
Sending data The thread is reading and processing rows for a SELECT statement, and sending data to the client. Because operations occurring during this this state tend to perform large amounts of disk access (reads), it is often the longest-running state over the lifetime of a given query. ...
You should use profiling. set profiling=1; Then do your queries in the same session. Then look for profiles: show profiles; And display them: show profile for query X;, where X - is a number of profile. mysql> show profile for query 2; +--------------------------------+----------+ | Status | Duration | ...
setup a local nameserver (eg dnsmasq) and insert the CNAME records you need into that. dnsmasq.conf: cname=alias,horrible-long-hostname.example.com resolv.conf: nameserver 127.0.0.1
If all you are trying to do is simplify ssh'ing to that system, you can use an ssh config file. Create and edit ~/.ssh/config to contain: Host db: Hostname my-db.ooxxooxxooxxoo.ap-northeast-1.rds.amazonaws.com After that, a simple "ssh db" will lookup what's specified in your .ssh/config file and connect you.
Top 50 recent answers are included