mysql getinstance,获取实例某类Sql详情GetInstanceTypeRtAndCountPerfData

{

"Code": 200,

"Message": "successful",

"Success": true,

"Data": {

"sqlTemplate": "SELECT ?",

"hashCode": "095F2345F262D090A83FF1AC64CA8C76",

"sqlSample": {

"obregion": null,

"realServerIp": null,

"requestTime": 1447949115072252,

"sqlId": 10167779173,

"sql": "select /*+client(obdatasource) client_version(1.2.1) mysql_driver(5.1)*/ 'client_version'",

"instanceName": "ocpwebTest_99",

"rtTime": 84,

"affectedRow": 1,

"status": 0,

"client": "10.244.4.1:30363",

"requestType": 3,

"params": ""

},

"perfData": [

{

"timeStamp": 1447982700000,

"requestCount": 449,

"avgRt": 0.088

},

{

"timeStamp": 1447983000000,

"requestCount": 985,

"avgRt": 0.665

},

{

"timeStamp": 1447983300000,

"requestCount": 5,

"avgRt": 37.698

},

{

"timeStamp": 1447983600000,

"requestCount": 4,

"avgRt": 0.102

},

{

"timeStamp": 1447983900000,

"requestCount": 1,

"avgRt": 0.087

},

{

"timeStamp": 1447984200000,

"requestCount": 2,

"avgRt": 17.879

},

{

"timeStamp": 1447984500000,

"requestCount": 1,

"avgRt": 0.108

},

{

"timeStamp": 1447984800000,

"requestCount": 3,

"avgRt": 33.224

},

{

"timeStamp": 1447985100000,

"requestCount": 120,

"avgRt": 29.033

},

{

"timeStamp": 1447985700000,

"requestCount": 17,

"avgRt": 42.835

},

{

"timeStamp": 1447986000000,

"requestCount": 1,

"avgRt": 0.085

},

{

"timeStamp": 1447986300000,

"requestCount": 7,

"avgRt": 44.965

},

{

"timeStamp": 1447986900000,

"requestCount": 31,

"avgRt": 59.957

},

{

"timeStamp": 1447987200000,

"requestCount": 9,

"avgRt": 59.747

},

{

"timeStamp": 1447987800000,

"requestCount": 2,

"avgRt": 63.439

},

{

"timeStamp": 1447988100000,

"requestCount": 3,

"avgRt": 60.155

},

{

"timeStamp": 1447988400000,

"requestCount": 117,

"avgRt": 40.074

},

{

"timeStamp": 1447989000000,

"requestCount": 4,

"avgRt": 33.96

},

{

"timeStamp": 1447989300000,

"requestCount": 3,

"avgRt": 32.054

},

{

"timeStamp": 1447989600000,

"requestCount": 20,

"avgRt": 6.25

},

{

"timeStamp": 1447989900000,

"requestCount": 3,

"avgRt": 0.098

},

{

"timeStamp": 1447990500000,

"requestCount": 2,

"avgRt": 59.283

},

{

"timeStamp": 1447990800000,

"requestCount": 77,

"avgRt": 49.668

},

{

"timeStamp": 1447991100000,

"requestCount": 6,

"avgRt": 56.012

},

{

"timeStamp": 1447991400000,

"requestCount": 2,

"avgRt": 0.083

},

{

"timeStamp": 1447992000000,

"requestCount": 3,

"avgRt": 44.746

},

{

"timeStamp": 1447992300000,

"requestCount": 75127,

"avgRt": 2.424

},

{

"timeStamp": 1447992900000,

"requestCount": 2,

"avgRt": 54.218

},

{

"timeStamp": 1447993500000,

"requestCount": 9,

"avgRt": 0.102

},

{

"timeStamp": 1447993800000,

"requestCount": 130110,

"avgRt": 1.778

},

{

"timeStamp": 1447994100000,

"requestCount": 91145,

"avgRt": 1.707

},

{

"timeStamp": 1447994400000,

"requestCount": 126887,

"avgRt": 3.694

},

{

"timeStamp": 1447994700000,

"requestCount": 4,

"avgRt": 58.052

},

{

"timeStamp": 1447995000000,

"requestCount": 65,

"avgRt": 5.498

},

{

"timeStamp": 1447995900000,

"requestCount": 26936,

"avgRt": 0.727

},

{

"timeStamp": 1447996500000,

"requestCount": 1,

"avgRt": 52.98

},

{

"timeStamp": 1447996800000,

"requestCount": 3,

"avgRt": 34.773

},

{

"timeStamp": 1447998600000,

"requestCount": 13,

"avgRt": 0.65

},

{

"timeStamp": 1447998900000,

"requestCount": 42,

"avgRt": 32.116

},

{

"timeStamp": 1447999200000,

"requestCount": 9,

"avgRt": 10.512

},

{

"timeStamp": 1447999500000,

"requestCount": 6,

"avgRt": 44.495

},

{

"timeStamp": 1447999800000,

"requestCount": 6,

"avgRt": 45.795

},

{

"timeStamp": 1448000400000,

"requestCount": 2,

"avgRt": 46.513

},

{

"timeStamp": 1448000700000,

"requestCount": 1,

"avgRt": 0.097

},

{

"timeStamp": 1448001000000,

"requestCount": 6,

"avgRt": 0.102

},

{

"timeStamp": 1448001900000,

"requestCount": 1,

"avgRt": 0.108

},

{

"timeStamp": 1448004000000,

"requestCount": 3,

"avgRt": 0.101

},

{

"timeStamp": 1448004300000,

"requestCount": 2,

"avgRt": 0.096

},

{

"timeStamp": 1448004600000,

"requestCount": 2,

"avgRt": 0.15

},

{

"timeStamp": 1448005200000,

"requestCount": 3,

"avgRt": 35.597

},

{

"timeStamp": 1448005800000,

"requestCount": 1,

"avgRt": 40.641

},

{

"timeStamp": 1448006400000,

"requestCount": 5,

"avgRt": 7.051

},

{

"timeStamp": 1448007300000,

"requestCount": 272,

"avgRt": 24.573

},

{

"timeStamp": 1448007600000,

"requestCount": 1,

"avgRt": 110.516

},

{

"timeStamp": 1448008200000,

"requestCount": 1,

"avgRt": 122.203

},

{

"timeStamp": 1448009100000,

"requestCount": 8,

"avgRt": 2.2

},

{

"timeStamp": 1448009400000,

"requestCount": 1,

"avgRt": 0.102

},

{

"timeStamp": 1448009700000,

"requestCount": 238,

"avgRt": 13.62

},

{

"timeStamp": 1448010000000,

"requestCount": 10,

"avgRt": 0.239

},

{

"timeStamp": 1448010300000,

"requestCount": 4,

"avgRt": 0.133

},

{

"timeStamp": 1448010600000,

"requestCount": 2,

"avgRt": 0.085

},

{

"timeStamp": 1448010900000,

"requestCount": 20,

"avgRt": 98.059

},

{

"timeStamp": 1448011500000,

"requestCount": 16,

"avgRt": 129.885

},

{

"timeStamp": 1448011800000,

"requestCount": 12,

"avgRt": 149.95

},

{

"timeStamp": 1448012100000,

"requestCount": 2,

"avgRt": 74.29

}

]

}

}