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

Processor scaling effects

Vertica user to backend HP Automation Insight. Have a 3 blade Vertica cluster that is reporting the following a LOT:

 

2017-01-08 17:40:51.002 SystemMonitor:0x2af7503438f0 <LOG> @v_cbidb_node0001: 00000/4441: Processor 10 current scaling frequency: 1200000 kHz
2017-01-08 17:40:51.002 SystemMonitor:0x2af7503438f0 <LOG> @v_cbidb_node0001: 00000/4441: Processor 11 current scaling frequency: 2401000 kHz

 

I did some preliminary research that indicates that this is the underlying blade varying the speed of the processor to adhere to its power policy, but what's the net effect on Vertica of this continual change in processor frequency?

 

Thanks,

 

--Chris

Comments

  • A Vertica best practice is to disable CPU frequency scaling. I've heard that it can actually have a fairly large performance improvement if it is turned off.

  • Hi You need to disable CPU frequency scaling on every CPU in cluster to get performance otherwise you will always get performance issue for large queries, This is i faced and we rectified it by disabling CPU scaling in every cluster.

  • the increasing frequency of a processor is known as processor scaling in computer architecture. the frequency of a microprocessor can be automatically adjusted is known as dynamic frequency scaling. currently, I have faced a major issue regarding processor scaling which is fixed by my facebook friend.

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.