Search found 29 matches
- Fri May 20, 2016 8:28 am
- Forum: Vertica Database Administration
- Topic: Memory usage
- Replies: 5
- Views: 14994
Memory usage
Hi, We have a web-app platform that uses Vertica server. Our machines are on cloud, from AWS. Vertica cluster has 3 nodes, m3.2xlarge, 8 vCPU, 30 GB memory. SIze of the db files - 25 GB. The database contains around 10 tables, maximum 15.000.000 records/table, 1000 columns/table. The tables have onl...
- Fri May 20, 2016 7:33 am
- Forum: Vertica Database Administration
- Topic: Recommended AWS Instance Type for Vertica???
- Replies: 5
- Views: 12411
Re: Recommended AWS Instance Type for Vertica???
Hi,
We have 2 clusters (3 nodes) on AWS.
They are working well.
Veronica
We have 2 clusters (3 nodes) on AWS.
They are working well.
Veronica
- Thu May 19, 2016 1:43 pm
- Forum: Vertica Management Console
- Topic: mc-activity-query monitoring-running queries-memory column
- Replies: 6
- Views: 29004
Re: mc-activity-query monitoring-running queries-memory column
Using the following select : select --i.node_name,i.session_id,i.transaction_id,i.statement_id,i.request_id, i.time,i.request, r.memory_acquired_mb, r.request_duration_ms , r.success, a.request_type, a.pool_name, a.memory_inuse_kb/1024 memory_inuse_mb, a.acquisition_timestamp, a.release_timestamp, e...
- Thu May 19, 2016 1:35 pm
- Forum: Vertica Management Console
- Topic: mc-activity-query monitoring-running queries-memory column
- Replies: 6
- Views: 29004
Re: mc-activity-query monitoring-running queries-memory column
Vertica Analytic Database v7.1.1-0
- Thu May 19, 2016 1:22 pm
- Forum: Vertica Management Console
- Topic: mc-activity-query monitoring-running queries-memory column
- Replies: 6
- Views: 29004
Re: mc-activity-query monitoring-running queries-memory column
On mc-activity-resource pool monitoring-query details by pools in xxxx_pool, I see for each query , one row for each node. For the queries that are running, I have 3 rows (=3nodes) , with the same transaction_id, column 'Execution ended'= 'Currently running' , column 'memory usage'=2,5G. Also, for o...
- Thu May 19, 2016 11:30 am
- Forum: Vertica Management Console
- Topic: mc-activity-query monitoring-running queries-memory column
- Replies: 6
- Views: 29004
mc-activity-query monitoring-running queries-memory column
Hi, I have the following situation: - resource pool configured to use max 25 G memory create resource pool xxxx_pool memorysize '30%' maxmemorysize '95%' priority 100 runtimepriority MEDIUM runtimeprioritythreshold 30 queuetimeout 120 runtimecap '10 seconds' cascade to general - 6 SELECTs running, t...
- Tue May 17, 2016 1:19 pm
- Forum: Vertica Database Administration
- Topic: Vertica Nodes Randomly Fail
- Replies: 23
- Views: 117286
Re: Vertica Nodes Randomly Fail
solved
The Vertica server is installed on Amazon EC2. There was an issue related to the instance/machine : "The instance is running on degraded hardware"
The Vertica server is installed on Amazon EC2. There was an issue related to the instance/machine : "The instance is running on degraded hardware"