Skip to main content

Vertica super slow, should I restart it?

  • July 27, 2016
  • 2 replies
  • 21 views
David_P_1
Forum|alt.badge.img+2

Vertica 7.1

 

I added a new column to a table.  Ran database designer with comprehensive design.  After a few minutes system stated database designer failed for unknown reasons.  

 

Waited for an hour but server top shows 22 load.  Normally load is around 1.

 

Screen Shot 2016-07-27 at 11.11.02 AM.png

 

 

No queries are running:

 

Screen Shot 2016-07-27 at 11.15.15 AM.png

 

 

System is now so slow it is unusable.  Should I use adminTools to restart Vertica?

    2 replies

    Sam37
    Forum|alt.badge.img+1
    • Sam37
    • Participating Frequently
    • July 28, 2016

    Can you check to see what is going on in Vertica.log?

     

    thanks

     

    Adrian_Oprea_1
    Forum|alt.badge.img+1
    • Adrian_Oprea_1
    • Participating Frequently
    • August 1, 2016

     See if you have internal session running. Best way is to install Vertica Management Console so you can track the IO/CPU and cross refrerence with internal and user query usage.

     

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement