Hotness

Nick Lamb -

Hotness is a tool to find the 'hot' containers involved in writes and reads for a given cluster. To run, simply copy it to /clustrix/ on one of the nodes and execute the script with:

clx_node$ ./hotness

This script will output the most used containers and what tables they hold data for. This can be used to find imbalances that could be impacting cluster performance.

Example Output:


Overall hot writes (1950131):
3: sbtest.k 469605 (24%)
2: sbtest.\_\_idx\_sbtest\_\_PRIMARY 440979 (22%)
2: sbtest.k 440606 (22%)
3: sbtest.\_\_idx\_sbtest\_\_PRIMARY 300478 (15%)
1: sbtest.k 148129 (7%)
1: sbtest.\_\_idx\_sbtest\_\_PRIMARY 140502 (7%)
3: statd\_current.\_\_idx\_statd\_current\_\_PRIMARY 4916 (0%)
1: statd\_current.\_\_idx\_statd\_current\_\_PRIMARY 3336 (0%)
2: statd\_current.\_\_idx\_statd\_current\_\_PRIMARY 1580 (0%)
3: alerts\_parameters.\_alerts\_parameters\_ind\_0 0 (0%)
3: USER\_SPHINX\_UPDATE.idx\_processed\_location\_chunkid\_userid 0 (0%)
1: statd\_metadata.\_\_idx\_statd\_metadata\_\_PRIMARY 0 (0%)
2: USER\_SPHINX\_UPDATE.idx\_processed\_location\_chunkid\_userid 0 (0%)
1: rebalancer\_activity\_log.\_rebalancer\_activity\_log\_ind\_1 0 (0%)
2: alerts\_parameters.\_alerts\_parameters\_ind\_0 0 (0%)
3: mysql\_slave\_log\_updates.\_mysql\_slave\_log\_updates\_ind\_0 0 (0%)
3: network\_interfaces.\_\_base\_network\_interfaces 0 (0%)
1: protection\_log.\_protection\_log\_ind\_1 0 (0%)
3: bar.\_\_base\_bar 0 (0%)
2: mysql\_slave\_log\_updates.\_mysql\_slave\_log\_updates\_ind\_0 0 (0%)

Overall hot reads (38898587):
1: ALL 31%
2: ALL 0%
3: ALL 68%
3: sbtest.\_\_idx\_sbtest\_\_PRIMARY 26542546 (68%)
1: sbtest.\_\_idx\_sbtest\_\_PRIMARY 12350927 (31%)
1: statd\_current.\_\_idx\_statd\_current\_\_PRIMARY 1672 (0%)
3: statd\_metadata.\_\_idx\_statd\_metadata\_\_PRIMARY 874 (0%)
1: statd\_metadata.\_\_idx\_statd\_metadata\_\_PRIMARY 798 (0%)
2: statd\_metadata.\_\_idx\_statd\_metadata\_\_PRIMARY 792 (0%)
2: statd\_current.\_\_idx\_statd\_current\_\_PRIMARY 792 (0%)
1: protection\_log.\_protection\_log\_ind\_1 180 (0%)
3: statd\_history.timestamp 2 (0%)
2: statd\_history.timestamp 2 (0%)
1: statd\_history.timestamp 2 (0%)
3: alerts\_parameters.\_alerts\_parameters\_ind\_0 0 (0%)
3: USER\_SPHINX\_UPDATE.idx\_processed\_location\_chunkid\_userid 0 (0%)
2: USER\_SPHINX\_UPDATE.idx\_processed\_location\_chunkid\_userid 0 (0%)
1: rebalancer\_activity\_log.\_rebalancer\_activity\_log\_ind\_1 0 (0%)
2: alerts\_parameters.\_alerts\_parameters\_ind\_0 0 (0%)
3: mysql\_slave\_log\_updates.\_mysql\_slave\_log\_updates\_ind\_0 0 (0%)
3: network\_interfaces.\_\_base\_network\_interfaces 0 (0%)
3: bar.\_\_base\_bar 0 (0%)
2: mysql\_slave\_log\_updates.\_mysql\_slave\_log\_updates\_ind\_0 0 (0%)
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk