Performance Degradation: Introduction to Variable ConnectCheckIntervalDelay And Correlation to HeartbeatIntervalDbDb

(Doc ID 1980863.1)

Last updated on OCTOBER 31, 2016

Applies to:

MySQL Cluster - Version 7.1 and later
Information in this document applies to any platform.

Goal

Test case:

  1. Initial condition: a small amount of traffic running (i.e. less that 20x the normal traffic requests)
  2. Reboot half of the data nodes in order to stop half of the Cluster 

During the reboot, the process handling the traffic (and performing cluster request) have some difficulties to retrieve data. 

In the core stack file retrieved, it appears that most of the thread are blocked in pthread_cond_timedwait in ndb API. 

How to explain this performance degradation?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms