sudo ntpdate us.pool.ntp.org
The problem is having wrong mod on the file.
Easily solved by executing –
chmod 400 mykey.pem
Taken from Amazon’s instructions –
Your key file must not be publicly viewable for SSH to work. Use this command if needed: chmod 400 mykey.pem
Amazon has to set the number of connections based on each model’s right to demand a certain amount of memory and connections
MODEL max_connections innodb_buffer_pool_size --------- --------------- ----------------------- t1.micro 34 326107136 ( 311M) m1-small 125 1179648000 ( 1125M, 1.097G) m1-large 623 5882511360 ( 5610M, 5.479G) m1-xlarge 1263 11922309120 (11370M, 11.103G) m2-xlarge 1441 13605273600 (12975M, 12.671G) m2-2xlarge 2900 27367833600 (26100M, 25.488G) m2-4xlarge 5816 54892953600 (52350M, 51.123G)
But if you want you can change the max connection size to custom by
From RDS Console > Parameter Groups > Edit Parameters,
You can change the value of the max_connections parameter to a custom value.
For closing the connections periodically you can setup a cron job some thing like this.
where usename = ‘yourusername’
and current_query = ‘
and query_start < current_timestamp - interval '5 minutes';
EC2 instance-hours are calculated according to the following considerations:
- You are billed for an EC2 instance-hour for each hour or partial hour that your instance is in the running state. Instances that are in any other state (for example, stopped, pending, etc.) are not billed.
- Every partial instance-hour is rounded up and calculated as a full instance-hour.
- Each time your instance enters the running state, a new instance-hour begins.
- Each instance is billed separately; partial instance-hours for multiple instances of the same type are not combined into one instance-hour.
Note: If you purchase an EC2 Reserved Instance, you are billed at the beginning of the month for every hour in the current month, according to the terms of your Reserved Instance contract. For more information, see How do EC2 Reserved Instances work?
Here are a few examples of how these considerations work in practice:
- When you run an instance for 30 minutes and then terminate the instance, you are billed for one instance-hour.
- When you run an instance for 10 minutes, stop the instance, and then start the instance again, you are billed for two instance-hours.
- When you run two EC2 instances of the same type for 30 minutes each, you are billed for two instance-hours.
For pricing information, see Amazon EC2 Pricing.