Search found 47 matches

by debfawn
Tue Jul 30, 2013 4:14 pm
Forum: New to Vertica Database Administration
Topic: admintools has random letters all over the screen
Replies: 1
Views: 19429

admintools has random letters all over the screen

Hi,

When I launch admintools in a putty session, there are a bunch of random letters displayed all over the screen (see attachment). Is this normal?
admintools_weirdness.png
admintools_weirdness.png (8.9 KiB) Viewed 19429 times
by debfawn
Wed Jul 17, 2013 12:08 pm
Forum: Vertica Installation
Topic: NTP service not synchronized on the hosts
Replies: 3
Views: 9043

Re: NTP service not synchronized on the hosts

Thanks, BoMBaY!

But if I run the chkconfig on each of my node hosts, it seems that the ntpd service is on:

Code: Select all

[root@ ~]# chkconfig --list ntpd
ntpd            0:off   1:off   2:on    3:on    4:on    5:on    6:off
[root@ ~]# runlevel
N 5
by debfawn
Wed Jul 17, 2013 4:12 am
Forum: Vertica Installation
Topic: NTP service not synchronized on the hosts
Replies: 3
Views: 9043

NTP service not synchronized on the hosts

Hi guys, When installing Vertica as part of the output I see the message: NTP service not synchronized on the hosts: ['ZZZ.ZZZ.ZZZ.ZZ1', 'ZZZ.ZZZ.ZZZ.ZZ2', 'ZZZ.ZZZ.ZZZ.ZZ3'] Check your NTP configuration for valid NTP servers. Vertica recommends that you keep the system clock synchronized using How ...
by debfawn
Thu Jul 11, 2013 12:50 pm
Forum: New to Vertica Database Development
Topic: NOLOCK option in Vertica
Replies: 2
Views: 22088

Re: NOLOCK option in Vertica

Thank you, nnani!

So I'll just remove all the NOLOCK commands from my scripts.

Cool.
by debfawn
Wed Jul 10, 2013 2:25 pm
Forum: New to Vertica Database Development
Topic: NOLOCK option in Vertica
Replies: 2
Views: 22088

NOLOCK option in Vertica

Hey guys,

I have a bunch of queries I need to convert from SQL Server. The queries have a NOLOCK option on each table which is supposed to improve concurrency on a busy system...

Can I do this in Vertica? Is it necessary?

Thank you,
Deb
by debfawn
Sun Jun 30, 2013 12:08 am
Forum: New to Vertica Database Administration
Topic: CPU frequency scaling
Replies: 3
Views: 9467

Re: CPU frequency scaling

Thanks for the reply guys! I see how to make the change now. I do have one more question though. Do you think this setting matters for a cluster made up of virtual machines?
by debfawn
Fri Jun 28, 2013 1:56 pm
Forum: New to Vertica Database Administration
Topic: CPU frequency scaling
Replies: 3
Views: 9467

CPU frequency scaling

Howdy, I am trying to add a node to my Vertica cluster. I noticed in the output of the upgrade_vertica script has the following statements: CPU frequency scaling is enabled. This may adversely affect the performance of your database. Vertica recommends that cpu frequency scaling be turned off or set...

Go to advanced search