Tag Info

New answers tagged

0

From RDS Console > Parameter Groups > Edit Parameters, You can change the value of the max_connections parameter to a custom value.


1

I think your understanding of query queues is a little off. A queue is like a thread in Java. A query arrives and is designated to the "less loaded" queue, and it waits for its turn to be resolved. The decision of where to put a query is independent of how busy a queue is; queries are allocated based on the rules you've set up: ...


0

The trick was in increasing the amount of RAM on the RSD. Oracle simply doesn't initialize well on db.t1.micro with 0.613GB RAM. However, once Oracle gets initialized on a bigger machine (I tested db.m3.medium), it is possible to switch the instance to db.t1.micro and run Oracle with only 0.613GB RAM. Thank you all for your support.


3

You probably don't want to hear this, but the best option to speed up SELECT DISTINCT is to avoid DISTINCT to begin with. In many cases (not all!) it can be avoided with better database-design or better queries. Sometimes, GROUP BY is faster, because it takes a different code path. In your particular case, it doesn't seem like you can get rid of DISTINCT. ...


0

Run this query to show if/when your tables were last vacuumed. select * from pg_stat_all_tables; A table won't be vacuumed until the insert/update/delete threshold is reached, which is 20%. You can tweak the setting in RDS by creating a new DB Parameter Group and change the setting you want.


0

Are you able to run this command from a client that has the AWS tools configured ? (you could launch an EC2 instance with an Amazon AMI Linux image which is already configured to run this command if not) rds-describe-db-instances --headers This should return info to verify the port number and hostname as per here


0

I don't know if that applies to Amazon RDS, but a possible reason for getting an empty list of queries with pgtop is when using a version older than 3.7.0 (released in August 2013) against a 9.2 or newer PostgreSQL instance. I just noticed this with the ptop 3.6.2 package that currently ships with Ubuntu 12.04 LTS. I guess this may be also not fixed in ...


0

i think you are facing spinlock contention. you can verify this using "perf" (in case s_lock shows up on top my guess is right). in general try the following: echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled echo never > /sys/kernel/mm/redhat_transparent_hugepage/defrag we also got the impression here at cybertec that more recent ...


3

A pg_dump output with the -Fc (custom) is not a SQL script, it's a compressed archive that only pg_restore is able to handle. You may either pass the dump file to pg_restore and pipe its output to psql (often done that way and close to what you tried): pg_restore /home/jboss/proc_dump_jan15.dump | psql --host=blahrds [other options]... ...or use the ...


1

The Amazon RDS is marketed as [...] managing time-consuming database management tasks, freeing you up to focus on your applications and business. From one point of view, this is true, it relieves you from a lot of maintenance. On the other hand, it means less flexibility, in our case the lack of access to the filesystem. The PostgreSQL ...


0

SHOW GLOBAL STATUS; Then compute these (whether using MyISAM or InnoDB): Qcache_lowmem_prunes / Uptime -- How often the QC is being pruned -- More than 15/sec says there is a lot of overhead in having the QC on. Qcache_not_cached / Uptime -- Cache attempts failed (per second). >40 is probably bad. Qcache_not_cached / (Qcache_hits + Com_select + ...



Top 50 recent answers are included