Details
-
Bug
-
Resolution: Fixed
-
Critical
-
4.0.0
-
Security Level: Public
-
None
-
400-2093
linux
10 buckets ..
-
Untriaged
-
Unknown
Description
1. create tpcc workload, consider say bucket ORDERS which has 2 indexes
- primary index
- index on OL_O_ID_D_ID_W_ID
2. Start tpcc-select only workload, which issues number of selects agains the bucket, the queries use either primary or the non-primary index.
The index stats show no activity on following fields
- items scanned
- bytes returned
- requests/sec
- average scan latency
logs
https://s3.amazonaws.com/cb-customers/g/1/collectinfo-2015-05-12T154215-ns_1%4010.6.2.164.zip
https://s3.amazonaws.com/cb-customers/g/1/collectinfo-2015-05-12T154215-ns_1%4010.6.2.167.zip
https://s3.amazonaws.com/cb-customers/g/1/collectinfo-2015-05-12T154215-ns_1%4010.6.2.168.zip
https://s3.amazonaws.com/cb-customers/g/1/collectinfo-2015-05-12T154215-ns_1%4010.6.2.194.zip
https://s3.amazonaws.com/cb-customers/g/1/collectinfo-2015-05-12T154215-ns_1%4010.6.2.195.zip