Performance Issue at Vertica

Would like to hear any feedback regarding performance issue that I'm noticing on my DB. I don't have any such activity going on at my Vertica DB but even then I see lot's of Network & IO Usages. Specially on IO, I see lots of write operations happening and I don't know what is causing that as there is no as such Data Loading/Projection Creation going on? Moreover, when I tried validating, I see lots of query requests but all those seem to be system level query but not some application level query. I had confronted similar issue sometime earlier because of which I ran into "out of memory error" while connecting via Application and I'd to restart my DB. Does anyone have any idea on what's going on here and if there is anything I could look upon specifically? Also, just querying even a single system table is taking noticeable seconds which I believe should not have happened. Any suggestions would be kindly appreciated. Should you require any further details, please revert back. Thanks, Asim

Comments

  • Hi Amelia, did anyone happen to diagnose it further? Would be great if I can get some insights as I don't feel restarting the DB frequently. BTW, I see some Critical & Warning events under MONITORING_EVENTS but I'm not sure if these issues are correlated. And my DB is on AWS.
  • Abhishek_RanaAbhishek_Rana Vertica Employee Employee
    This looks to me a problem with your environment or resource pool settings.

     How many nodes are on your database? 

    Can you send me the output of below commands:
    select * from nodes;
    select * from host_resources;
    select * from resource_pools;
    select * from resource_pool_status;
    select * from dc_resource_acquisitions;  
    select * from MONITORING_EVENTS;
    select * from network_interfaces; 

    Reasons can also be other, so for detailed analysis we might need diagnostics from your side - when you face performance issues. But first send me the information from above tables ,so that I get some picture of your environment.

    So I recommend to send us diagnostics too to dig further in this issue.

    Regards'

    Abhishek
  • Abhishek_RanaAbhishek_Rana Vertica Employee Employee
    How many nodes are on your database? 
    Can you send me the output of below commands:
    select * from nodes;
    select * from host_resources;
    select * from resource_pools;
    select * from resource_pool_status;
    select * from dc_resource_acquisitions;  
    select * from MONITORING_EVENTS;
    select * from network_interfaces; 

    Reasons can also be other, so for detailed analysis we might need diagnostics from your side - when you face performance issues. But first send me the information from above tables ,so that I get some picture of your environment.

    So I recommend to send us diagnostics too to dig further in this issue.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file