The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Is modifying vconsole's report definition queries supported

Running vertica-console-9.2.0-0.x86_64.

The Vertica Hardware Guide (https://www.vertica.com/kb/GenericHWGuide/Content/Hardware/GenericHWGuide.htm)
specifies:

Selecting a Network Adapter
To support the maximum performance MPP cluster operations, Vertica nodes should include at least two 10-gigabit Ethernet ports, bonded together for performance and redundancy.

However the bundled queries in Vertica Management Console that poll the dc_network_info_by_minute view only return data for interfaces matching the following constraint:

WHERE (interface_id like 'eth%' or interface_id like 'em%' or interface_id like 'p%p%' )

If a bonded NIC is used the network interface should have the ID bond0, bond1, etc...

modifying this condition in the report definitions seems to work:
$ find /opt/vconsole/reports/ -name *.xml -exec grep -l -i interface_id {} \;
/opt/vconsole/reports/network-usage-percluster.xml
/opt/vconsole/reports/bottlenecks-pernode.xml
/opt/vconsole/reports/queries_8.xml
/opt/vconsole/reports/queries.xml
/opt/vconsole/reports/network-usage-pernode.xml

ie. change this condition to
WHERE (interface_id like 'eth%' or interface_id like 'em%' or interface_id like 'p%p%' or interface_id like 'bond%')

Is this modification supported?
Will this modification be bundled in future releases of vconsole?

Tagged:

Answers

  • Bryan_HBryan_H Employee

    Hi, I think that would be redundant as the bondX adapter statistics should be the sum of the ethX adapter statistics. It's kept separate to help identify cases where the physical adapters might be unbalanced - I've seen cases where channel 0 of a bonded adapter was carrying ~80% of the traffic - though I did have to dig into ifconfig, dc_network_stats, etc. to find that.

  • Hi Bryan,
    In the specific case I'm looking at there is no data stored in the internal view for the em* devices but when I manually run the query with the modified condition above I get credible figures.

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.