1# This is the template definition file. To use it, see pmp-cacti-template. 2# 3# This program is copyright (c) 2007 Baron Schwartz. Feedback and improvements 4# are welcome. 5# 6# THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED 7# WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF 8# MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE. 9# 10# This program is free software; you can redistribute it and/or modify it under 11# the terms of the GNU General Public License as published by the Free Software 12# Foundation, version 2. 13# 14# You should have received a copy of the GNU General Public License along with 15# this program; if not, write to the Free Software Foundation, Inc., 59 Temple 16# Place, Suite 330, Boston, MA 02111-1307 USA. 17 18# Autobuild: ss_get_mysql_stats.php 19 20{ 21 name => 'MySQL Server', 22 hash => 'hash_02_VER_5144c02c3ca3bb2bfef6030202387bfb', 23 version => { 24 version => '$VERSION$', 25 hash => 'hash_06_VER_f5ce191065d85a186cf31723fdea28c8', 26 }, 27 checksum => 'hash_06_VER_3297f1ca480049ff1a8277b24d21a965', 28 graphs => [ 29 { base_value => '1000', 30 dt => { 31 Key_read_requests => { 32 data_source_type_id => '3', 33 hash => 'hash_08_VER_2ad63dc56ece95c5bbee1e717af5960a', 34 }, 35 Key_reads => { 36 data_source_type_id => '3', 37 hash => 'hash_08_VER_53766c926ecef120788000e396454317', 38 }, 39 Key_write_requests => { 40 data_source_type_id => '3', 41 hash => 'hash_08_VER_f6bce0b23cdca99098537a39c338646a', 42 }, 43 Key_writes => { 44 data_source_type_id => '3', 45 hash => 'hash_08_VER_4826d560467cc077c1512122b3ada014', 46 }, 47 hash => 'hash_01_VER_1bc64a50becd57f2ded2d3310ea2425b', 48 input => 'Get MySQL Stats', 49 }, 50 hash => 'hash_00_VER_897a6779370783904f450f893291c399', 51 items => [ 52 { color => '157419', 53 hashes => [ 54 'hash_10_VER_25851df84aba0c8f18aae7936d630db5', 55 'hash_10_VER_8e5265c3da767760caa7e68726f68d5d', 56 'hash_10_VER_7f8add14ebe32b40f5a45e4661707766', 57 'hash_10_VER_e6d2c41f406b387ac18d7aaabce9a0fd', 58 ], 59 item => 'Key_read_requests', 60 task => 'hash_09_VER_f484b257047b3ab261580da8ddcaf8fd', 61 type => 'AREA', 62 }, 63 { color => 'AFECED', 64 hashes => [ 65 'hash_10_VER_8623ea9e977a28a10e5618289250d6fc', 66 'hash_10_VER_0298b69cadac59e5be27664b9846a72c', 67 'hash_10_VER_bc6b44d4a3b36a49d059cf13e39ffea0', 68 'hash_10_VER_475c0599aec3c9be5c6830cf662d6970', 69 ], 70 item => 'Key_reads', 71 task => 'hash_09_VER_2cfc324a82b8c918e1fd67612774bab6', 72 type => 'LINE1', 73 }, 74 { color => '862F2F', 75 hashes => [ 76 'hash_10_VER_b890bc8caca92cb55365c7a7bb8215ce', 77 'hash_10_VER_97a01afff58e9b63e20f5021674f3ddc', 78 'hash_10_VER_7b57079bab2309705c50b77788cd22b3', 79 'hash_10_VER_9655b367665592f7628edce0af27649f', 80 ], 81 item => 'Key_write_requests', 82 task => 'hash_09_VER_2019cf675a9165f434d82cbc32ecacba', 83 type => 'AREA', 84 cdef => 'Negate', 85 }, 86 { color => 'F51D30', 87 hashes => [ 88 'hash_10_VER_ad38ba5c5c6b758e6b3e66934b5dfd72', 89 'hash_10_VER_fccd86f534b2baba5dfb7d540b48d7f3', 90 'hash_10_VER_33bc51a9be430c978f4837ee14323fcb', 91 'hash_10_VER_edf87fc329169b9e3cc307fb930dda2d', 92 ], 93 item => 'Key_writes', 94 task => 'hash_09_VER_53c3d65940830e321c55810fc85169b3', 95 type => 'LINE1', 96 cdef => 'Negate', 97 }, 98 ], 99 name => 'MyISAM Indexes', 100 }, 101 { name => 'MyISAM Key Cache', 102 base_value => '1024', 103 hash => 'hash_00_VER_f6c4f6f4c4a76edb463f6e3600edb82b', 104 dt => { 105 hash => 'hash_01_VER_3256f03758d0648ae9f065ab8b5d3237', 106 key_buffer_size => { 107 data_source_type_id => '1', 108 hash => 'hash_08_VER_42a9eb2a6b1bb632a44c60fac641d4e4', 109 }, 110 Key_buf_bytes_used => { 111 data_source_type_id => '1', 112 hash => 'hash_08_VER_6498085e973fdd43ec0469f3c65028e2', 113 }, 114 Key_buf_bytes_unflushed => { 115 data_source_type_id => '1', 116 hash => 'hash_08_VER_c5e4184415b8963e9122da6cf5e324f1', 117 }, 118 input => 'Get MySQL Stats', 119 }, 120 items => [ 121 { item => 'key_buffer_size', 122 color => '99B898', 123 type => 'AREA', 124 hashes => [ 125 'hash_10_VER_b774f2cbe2a18c5a7f719644e9e81c3c', 126 'hash_10_VER_d4d65fa946724517422bce99218bbd0b', 127 'hash_10_VER_e06b0f6d9ec3852448579121b60a8536', 128 'hash_10_VER_e84d0e54291b37e944053db7c3b6dfe5', 129 ], 130 task => 'hash_09_VER_c3c2cd1be90160a7fb27cd2e1504bd2c', 131 }, 132 { item => 'Key_buf_bytes_used', 133 color => '2A363B', 134 type => 'AREA', 135 hashes => [ 136 'hash_10_VER_cdc83efde5a1466be2a602dbf1d9d740', 137 'hash_10_VER_81913784ebc3cfea4ef3c69a09aaab97', 138 'hash_10_VER_12ba3137e6c13e1eab927505d09980ff', 139 'hash_10_VER_de8f79462ef857108626de2dde31ac21', 140 ], 141 task => 'hash_09_VER_e7e8e7a409927662ab71e8293f4e22cf', 142 }, 143 { item => 'Key_buf_bytes_unflushed', 144 color => 'FECEA8', 145 type => 'AREA', 146 hashes => [ 147 'hash_10_VER_99107edef0e39f2218aa3d3430b2c132', 148 'hash_10_VER_70b00f3c13269b055b0a82db4b54fcaf', 149 'hash_10_VER_cc69a95ca70aea638b613e9239cb43ab', 150 'hash_10_VER_4a03206f51cf873611de8558ef17a18a', 151 ], 152 task => 'hash_09_VER_fc4be251a316ed41cf238cc28e39c4ea', 153 }, 154 ], 155 }, 156 { base_value => '1024', 157 name => 'InnoDB Buffer Pool', 158 # Color palette: http://www.colourlovers.com/palette/354987/DSH 159 dt => { 160 hash => 'hash_01_VER_a95957302b6b4841563f4f8bff53c196', 161 input => 'Get MySQL Stats', 162 database_pages => { 163 data_source_type_id => '1', 164 hash => 'hash_08_VER_4ed43808db7aa534a0ed23be12c013d2', 165 }, 166 free_pages => { 167 data_source_type_id => '1', 168 hash => 'hash_08_VER_f6e245bc08604473ef0c235974d5da0b', 169 }, 170 modified_pages => { 171 data_source_type_id => '1', 172 hash => 'hash_08_VER_d79cce8d2374634521c330517dc23a34', 173 }, 174 pool_size => { 175 data_source_type_id => '1', 176 hash => 'hash_08_VER_b847b3a3cfcb72b0e882df8c9dcb8ed1', 177 }, 178 }, 179 hash => 'hash_00_VER_077946bd544f4b3e515a19570363a8ad', 180 items => [ 181 { color => '3D1500', 182 hashes => [ 183 'hash_10_VER_b4bd5fdb3236aea87296b9dc62c113d6', 184 'hash_10_VER_2da016c09d901ef1874c603df5066c62', 185 ], 186 item => 'pool_size', 187 task => 'hash_09_VER_f906f3d68b49e589e081fb085e83089d', 188 type => 'AREA', 189 }, 190 { color => 'EDAA41', 191 hashes => [ 192 'hash_10_VER_d5f840ff7108fe8f8ed7ed721968aed4', 193 'hash_10_VER_322ef245758eadc47da7345813906c23', 194 'hash_10_VER_9ac84c6cf3bd0e365ebb8297650bfda2', 195 'hash_10_VER_ff00e877e3fbb2d6936ee7d96811b802', 196 ], 197 item => 'database_pages', 198 task => 'hash_09_VER_be85ea3950fbbe126c3aeacaa2a5a4d8', 199 type => 'AREA', 200 }, 201 { color => 'AA3B27', 202 hashes => [ 203 'hash_10_VER_0b94c5cca325085b521b3b2f4bbf853c', 204 'hash_10_VER_c310b852490c8b2b4366a70a2bd327c1', 205 'hash_10_VER_055c392c96c9c3d1330144e086d8e538', 206 'hash_10_VER_374ee660d24ea0226bda45a5cac068bd', 207 ], 208 item => 'free_pages', 209 task => 'hash_09_VER_c9e44501db4a48a64aa7f9f57f19e6c2', 210 type => 'STACK', 211 }, 212 { color => '13343B', 213 hashes => [ 214 'hash_10_VER_b6164822d12842115a1dd8f83c64dde1', 215 'hash_10_VER_fdbe4095e1849e4552c7a05bde424408', 216 'hash_10_VER_c9a2caced895ccfdf4ebb8611a90e120', 217 'hash_10_VER_cb0850a50efd438e5198bac4bdd62258', 218 ], 219 item => 'modified_pages', 220 task => 'hash_09_VER_e03c043984260b32f3a7b268f708f3bb', 221 type => 'LINE1', 222 }, 223 ], 224 }, 225 { base_value => '1000', 226 # Palette: http://www.colourlovers.com/palette/299787/What_Shall_I_Do 227 name => 'InnoDB I/O', 228 dt => { 229 file_fsyncs => { 230 data_source_type_id => '3', 231 hash => 'hash_08_VER_275dd7626468baa60b012e6b879b6ed4', 232 }, 233 file_reads => { 234 data_source_type_id => '3', 235 hash => 'hash_08_VER_cccc859cac719d831991a9a703826076', 236 }, 237 file_writes => { 238 data_source_type_id => '3', 239 hash => 'hash_08_VER_b56356d96ece80ab3872e9c5a15c41ef', 240 }, 241 hash => 'hash_01_VER_2832d758707ee42c7e4dc56fd954ff49', 242 input => 'Get MySQL Stats', 243 log_writes => { 244 data_source_type_id => '3', 245 hash => 'hash_08_VER_38a2f689e06016baf550b35f23cc316c', 246 }, 247 }, 248 hash => 'hash_00_VER_69880b8595e7b8b2bd8b3756eee45279', 249 items => [ 250 { color => '402204', 251 hashes => [ 252 'hash_10_VER_a6a335fe4c74dd311e287538d3dd15a3', 253 'hash_10_VER_bc8ef36feffa49e3890e7a275f445cd1', 254 'hash_10_VER_8e419b91a0c32f716541aead2d12eb53', 255 'hash_10_VER_db42097b80bebc76b2b55b52df74afff', 256 ], 257 item => 'file_reads', 258 task => 'hash_09_VER_e2f484fd5cbee38917422684c9ca0442', 259 type => 'LINE1', 260 }, 261 { color => 'B3092B', 262 hashes => [ 263 'hash_10_VER_aa3de554cedc7fd5a46b9613289bb3dd', 264 'hash_10_VER_1f83e05e3b809a322cba8eb8a3686764', 265 'hash_10_VER_c885a4cf0180e2b0243835317b69472d', 266 'hash_10_VER_153308d2691b5d394442873fecea842b', 267 ], 268 item => 'file_writes', 269 task => 'hash_09_VER_5f41257968f9e61929e172bb1f194b87', 270 type => 'LINE1', 271 }, 272 { color => 'FFBF00', 273 hashes => [ 274 'hash_10_VER_a223e6ea1b8a8e19a3d009de1cbacfb5', 275 'hash_10_VER_8944c8d5734a1be2bb7277f090dad550', 276 'hash_10_VER_1f179326d248b7a4cc03bec2fec82c79', 277 'hash_10_VER_0fd84962ffe3e9c18c93c73a3f6f9e8c', 278 ], 279 item => 'log_writes', 280 task => 'hash_09_VER_7d0623bc0cad011afa1e214bd6e87afa', 281 type => 'LINE1', 282 }, 283 { color => '0ABFCC', 284 hashes => [ 285 'hash_10_VER_2cf042efeab03fa38c9b654856148b33', 286 'hash_10_VER_82cd1541b60c4819e5fdbc6027df76ca', 287 'hash_10_VER_4d396724ccd4b53e994dd16bac39b2a0', 288 'hash_10_VER_fe9bfffacca651c310d8cc43de44d70f', 289 ], 290 item => 'file_fsyncs', 291 task => 'hash_09_VER_3584bf8381d2e4973fddeb22b3097118', 292 type => 'LINE1', 293 }, 294 ], 295 }, 296 { base_value => '1000', 297 name => 'InnoDB Insert Buffer', 298 hash => 'hash_00_VER_0df9e87a907312de7f8afbe2ffec93dc', 299 dt => { 300 hash => 'hash_01_VER_51f2ca909cb855b9ce55d2edc381fcdb', 301 ibuf_inserts => { 302 data_source_type_id => '3', 303 hash => 'hash_08_VER_577d9c3009fc77f597889a15739b2999', 304 }, 305 ibuf_merged => { 306 data_source_type_id => '3', 307 hash => 'hash_08_VER_f363c541dc0c1716e45aacd1f555c9e3', 308 }, 309 ibuf_merges => { 310 data_source_type_id => '3', 311 hash => 'hash_08_VER_a5e3f79cfc8ae5957b2fbebde2665110', 312 }, 313 input => 'Get MySQL Stats', 314 }, 315 items => [ 316 { color => '157419', 317 hashes => [ 318 'hash_10_VER_9cb1247035cba45b4d751b1595543e3e', 319 'hash_10_VER_b7ac95c24b19416cefb581967e7d6551', 320 'hash_10_VER_0b5b57a17bc1393b7d8fdef1950c9562', 321 'hash_10_VER_e94a57d5a9d652d6bd166891f4585a6e', 322 ], 323 item => 'ibuf_inserts', 324 task => 'hash_09_VER_7278955f512cc96c589fd18bc99575b6', 325 type => 'LINE1', 326 }, 327 { color => '0000FF', 328 hashes => [ 329 'hash_10_VER_0e20d50b8874f4006b0daaafea050eb3', 330 'hash_10_VER_090fb06d94e34636b7030efbac897e09', 331 'hash_10_VER_fb579db4b46828709df9bdeac6640086', 332 'hash_10_VER_242d1ee903dd87174cb4a339cd0e3af8', 333 ], 334 item => 'ibuf_merged', 335 task => 'hash_09_VER_a311fa6813a472c14c5d0a9d828d5e8d', 336 type => 'LINE1', 337 }, 338 { color => '862F2F', 339 hashes => [ 340 'hash_10_VER_2b2fccb255ea08ed2ccc611119da713e', 341 'hash_10_VER_1c53cce3463db28a9a1a15175b023d2f', 342 'hash_10_VER_eced2ca89ae4e3d577657680de77257e', 343 'hash_10_VER_acd7b935f51d737bbb6c1be8774d9e9e', 344 ], 345 item => 'ibuf_merges', 346 task => 'hash_09_VER_6f1a86c5aede4a876fd1e0894ccd2128', 347 type => 'LINE1', 348 }, 349 ], 350 }, 351 { base_value => '1000', 352 name => 'InnoDB Insert Buffer Usage', 353 hash => 'hash_00_VER_902b76c7da4d21e3b27cb362eb8fe930', 354 dt => { 355 hash => 'hash_01_VER_daa7cfb939a07c834890b9c741113820', 356 ibuf_cell_count => { 357 data_source_type_id => '1', 358 hash => 'hash_08_VER_596d2092992f67a6293e2005ab6a9f41', 359 }, 360 ibuf_used_cells => { 361 data_source_type_id => '1', 362 hash => 'hash_08_VER_98ab189eca5cba404c4dc05dd0569c21', 363 }, 364 ibuf_free_cells => { 365 data_source_type_id => '1', 366 hash => 'hash_08_VER_504e1965e73d94a3bc8cc849f320641d', 367 }, 368 input => 'Get MySQL Stats', 369 }, 370 items => [ 371 { color => '793A57', 372 hashes => [ 373 'hash_10_VER_58336ffde1cd3276036fd5193aaa3f5e', 374 'hash_10_VER_45c6509aae3f1fff2d653ef4c01ffbf3', 375 'hash_10_VER_b666d5286527bfc6cf11befb7fa8b90e', 376 'hash_10_VER_26f8d4d1445b0a16c246495d3e85ec6e', 377 ], 378 item => 'ibuf_cell_count', 379 task => 'hash_09_VER_7e66211a2cd75c7f439416471bee8223', 380 type => 'AREA', 381 }, 382 { color => '8C873E', 383 hashes => [ 384 'hash_10_VER_bf3ed8074e6d47ffab2bed3cbedf0d07', 385 'hash_10_VER_024d0b20aef8ea9e84245262c989de0a', 386 'hash_10_VER_e97fa4f69bbcc768c0c51f5482112057', 387 'hash_10_VER_9a62414f4fd7e38d8ae3d2408834222f', 388 ], 389 item => 'ibuf_used_cells', 390 task => 'hash_09_VER_04323ea594d7a01d927fd3dd1d4248af', 391 type => 'AREA', 392 }, 393 { color => 'A38A5F', 394 hashes => [ 395 'hash_10_VER_3f0753621bb40689af1ad8ba1f4056db', 396 'hash_10_VER_59eb567a738daf4d75881b0519971c48', 397 'hash_10_VER_78c95090afa06327d9da80719a4023c7', 398 'hash_10_VER_4fd10fa2f5ec97238f94d9b3228e9983', 399 ], 400 item => 'ibuf_free_cells', 401 task => 'hash_09_VER_26c4c495bf57b0a252db73dc2c6f5d69', 402 type => 'STACK', 403 }, 404 ], 405 }, 406 { base_value => '1000', 407 dt => { 408 hash => 'hash_01_VER_32efdb28122ad8fc13781a3516786284', 409 input => 'Get MySQL Stats', 410 os_waits => { 411 data_source_type_id => '3', 412 hash => 'hash_08_VER_7dc9041d7ef9ef794ce8874fbfc9c08a', 413 }, 414 spin_rounds => { 415 data_source_type_id => '3', 416 hash => 'hash_08_VER_233ccd265faa6418e1c90f0f978456ac', 417 }, 418 spin_waits => { 419 data_source_type_id => '3', 420 hash => 'hash_08_VER_2172d167df8925246f27f960162313d7', 421 }, 422 }, 423 hash => 'hash_00_VER_f49cdf4bc4c63ac73a1f348c1badf5cb', 424 items => [ 425 { color => '306078', 426 hashes => [ 427 'hash_10_VER_0cfacd629425b9382e397d924eb9e5b9', 428 'hash_10_VER_015d0e3d82c07dd8f5e5d5eed3c06fb6', 429 'hash_10_VER_823a47c154850710cfcd32f1ae031998', 430 'hash_10_VER_f9c635324cc6e5071f1f2e61972bafc8', 431 ], 432 item => 'spin_rounds', 433 task => 'hash_09_VER_7edef579a44e13e7d8d9d0c64dc017e9', 434 type => 'LINE1', 435 }, 436 { color => '4444FF', 437 hashes => [ 438 'hash_10_VER_668cd623ef34db23760452ca900a7d02', 439 'hash_10_VER_910e179d05b8bfc973d33180bbb74ed4', 440 'hash_10_VER_d6d33c7ebac1e3b5f0b8abe82c913777', 441 'hash_10_VER_f0599853dff3eb73de3b2b8bb87c8437', 442 ], 443 item => 'spin_waits', 444 task => 'hash_09_VER_aea1087ceb7cfcfe0d740963cfa0d665', 445 type => 'LINE1', 446 }, 447 { color => '157419', 448 hashes => [ 449 'hash_10_VER_a9d9931314c74f4ea750cb7413c64288', 450 'hash_10_VER_9ebe098865391dc5bd03c19f95a40e9b', 451 'hash_10_VER_6a971684e07940b60bfbbfa662766844', 452 'hash_10_VER_6f463319ae13a3ba870f27abb4aa24cb', 453 ], 454 item => 'os_waits', 455 task => 'hash_09_VER_af25fd1eccacd2424d04fa05a0af3860', 456 type => 'LINE1', 457 }, 458 ], 459 name => 'InnoDB Semaphores', 460 }, 461 { base_value => '1000', 462 dt => { 463 hash => 'hash_01_VER_945efc3aef3131f5cd18c853a4ab69bc', 464 input => 'Get MySQL Stats', 465 rows_deleted => { 466 data_source_type_id => '3', 467 hash => 'hash_08_VER_b86fd24442ce0593a5ca6b181fedddd0', 468 }, 469 rows_inserted => { 470 data_source_type_id => '3', 471 hash => 'hash_08_VER_f0bf9b3691a1919ed4a62e8b1fba5777', 472 }, 473 rows_read => { 474 data_source_type_id => '3', 475 hash => 'hash_08_VER_2565bc112ed47f8e5138a1384baed29d', 476 }, 477 rows_updated => { 478 data_source_type_id => '3', 479 hash => 'hash_08_VER_0c5b956f565fa9ab5c2e6b1572428bfb', 480 }, 481 }, 482 hash => 'hash_00_VER_1c3716cc7c1ab5b9eb8db1a66e242413', 483 items => [ 484 { color => 'AFECED', 485 hashes => [ 486 'hash_10_VER_bfcc4e719305835965556611a24247c8', 487 'hash_10_VER_8af4489202e51afbe103caba5b7df587', 488 'hash_10_VER_c0b6a77c6b83235d092c37760c80dbb6', 489 'hash_10_VER_391a128d80c44a94a76e4f48cd99a82a', 490 ], 491 item => 'rows_read', 492 task => 'hash_09_VER_7150e8b80b83294b0c1cb4ea46547f5d', 493 type => 'AREA', 494 }, 495 { color => 'DA4725', 496 hashes => [ 497 'hash_10_VER_b7b29c621bce81b6ce14f3d4d91ad191', 498 'hash_10_VER_7555e285f6b9465345bc45b5f7def374', 499 'hash_10_VER_1b5b41e853e676e7914822ea5b8fdcbd', 500 'hash_10_VER_21e7e1e385609130de4ec07325afb341', 501 ], 502 item => 'rows_deleted', 503 task => 'hash_09_VER_194a1e647ad1121127045452016ff5b6', 504 type => 'STACK', 505 }, 506 { color => 'EA8F00', 507 hashes => [ 508 'hash_10_VER_b2e1a6bf7ebcf02421455f7d10e7c44d', 509 'hash_10_VER_06770892cb00d89fc55c09f673b3d81f', 510 'hash_10_VER_b10dce738a425c7ab4a9dcb532deae80', 511 'hash_10_VER_207a4e18f64d6666c87bc65494eabfd4', 512 ], 513 item => 'rows_updated', 514 task => 'hash_09_VER_d628d573cbd54ef6fd5b82e8b5c108a9', 515 type => 'STACK', 516 }, 517 { color => '35962B', 518 hashes => [ 519 'hash_10_VER_12af420b052ee41f80d2051c0d749cd7', 520 'hash_10_VER_03c41074174819824c44e3f3c3ebb431', 521 'hash_10_VER_d4e082f244e43956a4e3201499deb19b', 522 'hash_10_VER_8e405f87ef89d9c53ba75b28d8994e54', 523 ], 524 item => 'rows_inserted', 525 task => 'hash_09_VER_8e7f17e23e138b5e7e72953427125d31', 526 type => 'STACK', 527 }, 528 ], 529 name => 'InnoDB Row Operations', 530 }, 531 { base_value => '1000', 532 dt => { 533 Slow_queries => { 534 data_source_type_id => '3', 535 hash => 'hash_08_VER_3cf81ca2ac9b7bfa0d8330696a4b3fb9', 536 }, 537 Table_locks_immediate => { 538 data_source_type_id => '3', 539 hash => 'hash_08_VER_a1ef49dfdfc2116106b2fb229d44bfb1', 540 }, 541 Table_locks_waited => { 542 data_source_type_id => '3', 543 hash => 'hash_08_VER_99a4d25c080ea056d8c1c2eebd06e49c', 544 }, 545 hash => 'hash_01_VER_ff4afa012799ff00c6d3b4b952279364', 546 input => 'Get MySQL Stats', 547 }, 548 hash => 'hash_00_VER_21eedc2999d70ccca66f8c438773bd22', 549 items => [ 550 { color => 'D2D8F9', 551 hashes => [ 'hash_10_VER_916607bf3ac2a807b9be8b6f05defc72' ], 552 item => 'Table_locks_immediate', 553 task => 'hash_09_VER_24a0286b9701b096d8e9bce7349415fe', 554 type => 'AREA', 555 }, 556 { color => '002A8F', 557 hashes => [ 558 'hash_10_VER_017943a75dd5401b90c89390f3972af5', 559 'hash_10_VER_1cc51160f8e8a16733d30d06e5707dd0', 560 'hash_10_VER_7c50d34458db6fc5b9b4c2024ff260c1', 561 'hash_10_VER_104490b88a906db80e9ba3bec887bed5', 562 ], 563 item => 'Table_locks_immediate', 564 task => 'hash_09_VER_6ecafa71d88f2bc55e538de70d4acb0d', 565 type => 'LINE1', 566 }, 567 { color => 'FF3932', 568 hashes => [ 569 'hash_10_VER_1440318d1ff98253cbf767e736bc2d13', 570 'hash_10_VER_6f5f7ef641d3aa210d44ca586934cdd4', 571 'hash_10_VER_765cfae9cc347000119f2aac56c03409', 572 'hash_10_VER_ce9fb640f081136b351aedd160ff6930', 573 ], 574 item => 'Table_locks_waited', 575 task => 'hash_09_VER_7c91fa1049359d97a4712ee9bd8bb77b', 576 type => 'AREA', 577 }, 578 { color => '35962B', 579 hashes => [ 580 'hash_10_VER_d1fd5b95b4dbc7b7616b6c258fb3565d', 581 'hash_10_VER_38b30e965c31c5f891437ac09c070ce7', 582 'hash_10_VER_2a8e7912f3224a1bd4b8f165b746a029', 583 'hash_10_VER_29875910115e1e96159dd9611f8ca060', 584 ], 585 item => 'Slow_queries', 586 task => 'hash_09_VER_e7d0baf302666d74ddd60e5b9c948f2d', 587 type => 'LINE1', 588 }, 589 ], 590 name => 'MySQL Table Locks', 591 }, 592 { base_value => '1000', 593 dt => { 594 hash => 'hash_01_VER_ff1062a865af90010ebf9f2523faba30', 595 input => 'Get MySQL Stats', 596 Aborted_clients => { 597 data_source_type_id => '3', 598 hash => 'hash_08_VER_6fdf30b2782e1878b1e0e00981b1f91e', 599 }, 600 Aborted_connects => { 601 data_source_type_id => '3', 602 hash => 'hash_08_VER_fb660214cd957e0e8c4eb2267074cb7f', 603 }, 604 Connections => { 605 data_source_type_id => '3', 606 hash => 'hash_08_VER_255b62433743f009d0ac8e8330f051d5', 607 }, 608 Max_used_connections => { 609 data_source_type_id => '1', 610 hash => 'hash_08_VER_4baff738891f9e5f6ab4299a0ae04a54', 611 }, 612 Threads_connected => { 613 data_source_type_id => '1', 614 hash => 'hash_08_VER_38a883d9c3d533741bbfca8c4393e056', 615 }, 616 max_connections => { 617 data_source_type_id => '1', 618 hash => 'hash_08_VER_1d089309d4426bc7d0c53089bc43d8e7', 619 }, 620 }, 621 hash => 'hash_00_VER_3bb8d8f8e1098aa38829373a8bee5520', 622 items => [ 623 { color => 'C0C0C0', 624 hashes => [ 625 'hash_10_VER_b407366c7b77195834928cca70e57fb5', 626 'hash_10_VER_d38bc5f3a0c90cb174d5536574c8973f', 627 ], 628 item => 'max_connections', 629 task => 'hash_09_VER_50589e7471a62f3bda9cbad35c924911', 630 type => 'AREA', 631 }, 632 { color => 'FFD660', 633 hashes => [ 634 'hash_10_VER_012d8d1c201c1fbbac02ad1725f50ccc', 635 'hash_10_VER_a3322eabf1361ab3245cb94a0d1a4ffd', 636 ], 637 item => 'Max_used_connections', 638 task => 'hash_09_VER_2611c283ed660a2e322f2d65c680c17d', 639 type => 'AREA', 640 }, 641 { color => 'FF3932', 642 hashes => [ 643 'hash_10_VER_1eca47b5501d6883663c370f5d1d78a2', 644 'hash_10_VER_5aca02a8aa21a5f5eda4b8316b4011b1', 645 'hash_10_VER_97715c22b902c80edaa91c26d361c45c', 646 'hash_10_VER_f1396330d3ccdcae150a9c08133f5961', 647 ], 648 item => 'Aborted_clients', 649 task => 'hash_09_VER_338f230b1dd367367edcfe4d1f531b97', 650 type => 'LINE1', 651 }, 652 { color => '00FF00', 653 hashes => [ 654 'hash_10_VER_bc775e0e79e4352cb8a599f628e47e94', 655 'hash_10_VER_69a397d3d6652e5c619801054ca4b9ec', 656 'hash_10_VER_d024f2bd6465b634f3ecc8a87fe31552', 657 'hash_10_VER_7d3cc577042ec01a3b0f0b98bf490609', 658 ], 659 item => 'Aborted_connects', 660 task => 'hash_09_VER_df04c04decc0d980c4a89b82c03b137b', 661 type => 'LINE1', 662 }, 663 { color => 'FF7D00', 664 hashes => [ 665 'hash_10_VER_fee53bd507ef0eec287bbf43b45954c5', 666 'hash_10_VER_f175443559fb386d8d3e88a0f2f4dfcc', 667 'hash_10_VER_f1704851a8d470ae51c3f0882c57c789', 668 'hash_10_VER_62202f9bf84b6c29ffe22967fa63846f', 669 ], 670 item => 'Threads_connected', 671 task => 'hash_09_VER_8df1cf31d465732c00a6bea23bebba59', 672 type => 'LINE2', 673 }, 674 { color => '4444FF', 675 hashes => [ 676 'hash_10_VER_88424e1e9429ba83586889a04981af80', 677 'hash_10_VER_8effd39a2ef226831a5f57463ac02947', 678 'hash_10_VER_f22f83a2a5dd1b87c4a03503e755b6a3', 679 'hash_10_VER_3574a5072a462c79490ad5c19b9f569d', 680 ], 681 item => 'Connections', 682 task => 'hash_09_VER_7741c194222128f0500731b647c16649', 683 type => 'LINE1', 684 }, 685 ], 686 name => 'MySQL Connections', 687 }, 688 { base_value => '1000', 689 dt => { 690 Slave_open_temp_tables => { 691 data_source_type_id => '1', 692 hash => 'hash_08_VER_2e9a827fb7906275e0f6d83e382caaff', 693 }, 694 Slave_retried_transactions => { 695 data_source_type_id => '3', 696 hash => 'hash_08_VER_84cce18276e09ae45dc04b8999fdcd17', 697 }, 698 hash => 'hash_01_VER_eee3bf2d001ae6ce70674e8b6e4ea060', 699 input => 'Get MySQL Stats', 700 slave_lag => { 701 data_source_type_id => '1', 702 hash => 'hash_08_VER_9acc439a8f475760be9490b5ba1a2609', 703 }, 704 slave_running => { 705 data_source_type_id => '1', 706 hash => 'hash_08_VER_2480762e3fbd79ec7995d7828ad371c0', 707 }, 708 slave_stopped => { 709 data_source_type_id => '1', 710 hash => 'hash_08_VER_35491918bf231ef2140890b99658d2a4', 711 }, 712 }, 713 hash => 'hash_00_VER_c64622707606d0ba2f7d721f22910ef9', 714 items => [ 715 { color => '96E78A', 716 hashes => [ 'hash_10_VER_af71b4656fde264757f8a53179503145' ], 717 item => 'slave_running', 718 task => 'hash_09_VER_a5f308d8a2aabc496827e6e6a00ee506', 719 type => 'AREA', 720 }, 721 { color => 'CDCFC4', 722 hashes => [ 'hash_10_VER_49b52aec5512934f3f25a8e62eb0ca94' ], 723 item => 'slave_stopped', 724 task => 'hash_09_VER_6fc67062ef86f3d85a47718e61f6fd44', 725 type => 'AREA', 726 }, 727 { color => '4444FF', 728 hashes => [ 729 'hash_10_VER_7c1d40d9c8c82b10cfa96c08348c1a57', 730 'hash_10_VER_55205e503099ed4c75d0f02d0d8e66f1', 731 'hash_10_VER_c9c0462351963255b74958ddf8720ee1', 732 'hash_10_VER_a7bd80a1e4b40239fb50caab6aa8712a', 733 ], 734 item => 'slave_lag', 735 task => 'hash_09_VER_181079bd634a83dc2e3c990566b7f6f4', 736 type => 'LINE1', 737 }, 738 { color => '8D00BA', 739 hashes => [ 740 'hash_10_VER_785e7cb5e897c4200f919f36c11b42c5', 741 'hash_10_VER_1cf4e32b8d89973733e3e26af5e75007', 742 'hash_10_VER_892bed9f93decd0ff3eb9e01f820aa4d', 743 'hash_10_VER_b880dae6e4a2ae4f8e803bb295b1d47f', 744 ], 745 item => 'Slave_open_temp_tables', 746 task => 'hash_09_VER_f57b1923f09d96674373acea6a5d9077', 747 type => 'LINE1', 748 }, 749 { color => 'FF0000', 750 hashes => [ 751 'hash_10_VER_829702036497d955ee9fad739884a74f', 752 'hash_10_VER_778f34962d95adc4985d3d8d639c108c', 753 'hash_10_VER_f9507cbae394b406559beb21efebffd9', 754 'hash_10_VER_63c74949ed83fe522c42ac3bd034f0e7', 755 ], 756 item => 'Slave_retried_transactions', 757 task => 'hash_09_VER_b647396138eb073b819e0aa3440c4051', 758 type => 'LINE1', 759 }, 760 ], 761 name => 'MySQL Replication', 762 }, 763 { base_value => '1024', 764 name => 'MySQL Query Cache', 765 dt => { 766 hash => 'hash_01_VER_dcb49bb998333603cb3b5df43ea8c44e', 767 input => 'Get MySQL Stats', 768 Qcache_hits => { 769 data_source_type_id => '3', 770 hash => 'hash_08_VER_bccc6314ae6c845139270068c82e4b6b', 771 }, 772 Qcache_inserts => { 773 data_source_type_id => '3', 774 hash => 'hash_08_VER_5f1180702e9b3b2e08b6bc8c27bd144f', 775 }, 776 Qcache_lowmem_prunes => { 777 data_source_type_id => '3', 778 hash => 'hash_08_VER_174b858ddf67463a60e1c1f0ff029091', 779 }, 780 Qcache_not_cached => { 781 data_source_type_id => '3', 782 hash => 'hash_08_VER_3c68e6e3e3748bb8ece90af4982f02a7', 783 }, 784 Qcache_queries_in_cache => { 785 data_source_type_id => '1', 786 hash => 'hash_08_VER_d86860608fe1180dd260da81ac2abd4e', 787 }, 788 }, 789 hash => 'hash_00_VER_900203af2448443cee30f45d0ba1931e', 790 items => [ 791 { color => '4444FF', 792 hashes => [ 793 'hash_10_VER_fa67369f01e4bd14187e1c3073cc0114', 794 'hash_10_VER_28864ae44a3aee7bcb4ffc31d9ef3b67', 795 'hash_10_VER_50e3784ff625222e289cb6f0cf9ecad5', 796 'hash_10_VER_efed3077461d037d8368c84337fd8104', 797 ], 798 item => 'Qcache_queries_in_cache', 799 task => 'hash_09_VER_7aceba22cf349da0d82e5ea077c8b9fd', 800 type => 'LINE2', 801 }, 802 { color => 'EAAF00', 803 hashes => [ 804 'hash_10_VER_ace43799392a110da1ee08f0e993588c', 805 'hash_10_VER_f9309f2a0522d1f05371d83fb7030120', 806 'hash_10_VER_d018ae743d7447ec84fc22f6ef846f99', 807 'hash_10_VER_a9fcb8e16eb3899cf28acfd14fd3a406', 808 ], 809 item => 'Qcache_hits', 810 task => 'hash_09_VER_d8237fa1ec411d3b42697848c387c6f9', 811 type => 'LINE2', 812 }, 813 { color => '157419', 814 hashes => [ 815 'hash_10_VER_cadf528007c959ff4a5364248c3f7c64', 816 'hash_10_VER_b3d27981d1ab96a0a5b5e0dd800efbf2', 817 'hash_10_VER_460678d8ed971beb62ed4f93e6d2a6c4', 818 'hash_10_VER_22b8de2307af25915fc8b01bbd931dee', 819 ], 820 item => 'Qcache_inserts', 821 task => 'hash_09_VER_a9448f5e64503d20c160c24b8228c383', 822 type => 'LINE1', 823 }, 824 { color => '00A0C1', 825 hashes => [ 826 'hash_10_VER_e18a5faf15ca4e67bc049f045c5e2156', 827 'hash_10_VER_116ccdd0ca699c3759b3ba2d4645e85a', 828 'hash_10_VER_b0349213843db92c07d18af9effa0c96', 829 'hash_10_VER_e82e0b5fb0cd7ec4c73821e822f6f401', 830 ], 831 item => 'Qcache_not_cached', 832 task => 'hash_09_VER_a3de5c8b0fcc27dfcbda713c876ebb5f', 833 type => 'LINE1', 834 }, 835 { color => 'FF0000', 836 hashes => [ 837 'hash_10_VER_44000ad3a645e604a0bb6471fd87a5bd', 838 'hash_10_VER_3d554a5de87af46c6c35872ae06f666e', 839 'hash_10_VER_4b8f60b6e048855c5d986c6d6f456dae', 840 'hash_10_VER_f2944154ee8aefb3b34e48affafa066b', 841 ], 842 item => 'Qcache_lowmem_prunes', 843 task => 'hash_09_VER_770dded6a3b71a7d37e3c844823e4025', 844 type => 'LINE1', 845 }, 846 ], 847 }, 848 { base_value => '1024', 849 name => 'MySQL Query Cache Memory', 850 dt => { 851 Qcache_free_blocks => { 852 data_source_type_id => '1', 853 hash => 'hash_08_VER_0437e9ad328360a81ed9e2ff8cb6a6a4', 854 }, 855 Qcache_free_memory => { 856 data_source_type_id => '1', 857 hash => 'hash_08_VER_286f230f8afc18b5e651a8825b3cd4ad', 858 }, 859 Qcache_total_blocks => { 860 data_source_type_id => '1', 861 hash => 'hash_08_VER_5cb92677cde12eaefb50d40c19be6ec3', 862 }, 863 hash => 'hash_01_VER_ae8ab2b95959ea1416500257bb8f97a8', 864 input => 'Get MySQL Stats', 865 query_cache_size => { 866 data_source_type_id => '1', 867 hash => 'hash_08_VER_42b55a5f1ef4d871bda37e988b0a437b', 868 }, 869 }, 870 hash => 'hash_00_VER_4d1b4cb6388b98ce74511c0fb7d9aea4', 871 items => [ 872 { color => '74C366', 873 hashes => [ 874 'hash_10_VER_8cd79d88cf715ed762b83785eda5ca6e', 875 'hash_10_VER_33904b0e20bbbe26b546d357dc245860', 876 'hash_10_VER_9cafcf883585668c562a824a40d6ab94', 877 'hash_10_VER_6e0448b811ed871c76f93609524998f1', 878 ], 879 item => 'query_cache_size', 880 task => 'hash_09_VER_91823d0529e0b2f9846986ebc2860ab1', 881 type => 'AREA', 882 }, 883 { color => 'FFC3C0', 884 hashes => [ 885 'hash_10_VER_c505e6f3899dffc80cd61c889ded1f14', 886 'hash_10_VER_94df6afa6ddf0d66aa4f8cc086f41673', 887 'hash_10_VER_2c41e1e44b1f96b5144478e4195bf81e', 888 'hash_10_VER_d793864e8533491ccfd95cadbf7baa2c', 889 ], 890 item => 'Qcache_free_memory', 891 task => 'hash_09_VER_43a1cef6421624b531dffc0b3a2da522', 892 type => 'AREA', 893 }, 894 { color => '8D00BA', 895 hashes => [ 896 'hash_10_VER_f1c1ae7a529e3caca5cc7f0bcbc33d93', 897 'hash_10_VER_0b87994b9b19c1ca50efdd3cb9f91c7e', 898 'hash_10_VER_4a26a4e5c8f3da15e51760a7684ad416', 899 'hash_10_VER_b75c3281d1eec342ccb22a3bee193a24', 900 ], 901 item => 'Qcache_total_blocks', 902 task => 'hash_09_VER_6104587506c44bd63d64624b5b803fa5', 903 type => 'LINE1', 904 }, 905 { color => '837C04', 906 hashes => [ 907 'hash_10_VER_0b50cb2ab04fdaa006ac96adf97ae35d', 908 'hash_10_VER_b24088faf725466c6530a1c97eaadbae', 909 'hash_10_VER_dc90dea268cdd22177897808896476d5', 910 'hash_10_VER_06dbaaab66a804d1620de61487c01478', 911 ], 912 item => 'Qcache_free_blocks', 913 task => 'hash_09_VER_889e70a8f05046d9fa0a9eca58bd4748', 914 type => 'LINE1', 915 }, 916 ], 917 }, 918 { base_value => '1000', 919 dt => { 920 Com_delete => { 921 data_source_type_id => '3', 922 hash => 'hash_08_VER_4ba460f1bfbd6157b792dc7757783180', 923 }, 924 Com_delete_multi => { 925 data_source_type_id => '3', 926 hash => 'hash_08_VER_5b1938835819de77fb18c712928bb95f', 927 }, 928 Com_insert => { 929 data_source_type_id => '3', 930 hash => 'hash_08_VER_dcc9d9c525b2581c2c23764cdfa4781c', 931 }, 932 Com_insert_select => { 933 data_source_type_id => '3', 934 hash => 'hash_08_VER_d7d547c211b3a70154b90f2b0b5f1a55', 935 }, 936 Com_load => { 937 data_source_type_id => '3', 938 hash => 'hash_08_VER_979ef5acce17f8239f27baa35737876d', 939 }, 940 Com_replace => { 941 data_source_type_id => '3', 942 hash => 'hash_08_VER_ffe06d67239e004144206da491b5a2ce', 943 }, 944 Com_replace_select => { 945 data_source_type_id => '3', 946 hash => 'hash_08_VER_a125adf94216436826dd12de7409aabb', 947 }, 948 Com_select => { 949 data_source_type_id => '3', 950 hash => 'hash_08_VER_cbf891f15deaf8a3b40a4a5b045426a5', 951 }, 952 Com_update => { 953 data_source_type_id => '3', 954 hash => 'hash_08_VER_b10367bfaa00559a38127a0f858be6a7', 955 }, 956 Com_update_multi => { 957 data_source_type_id => '3', 958 hash => 'hash_08_VER_ea281f4242ce2ea7f888621627035bf3', 959 }, 960 Questions => { 961 data_source_type_id => '3', 962 hash => 'hash_08_VER_1d0b142c88f7f2df482ed76d52336ff7', 963 }, 964 hash => 'hash_01_VER_4282b0c48e51295bd2db05791462624a', 965 input => 'Get MySQL Stats', 966 }, 967 hash => 'hash_00_VER_4311a4cab8c658b02da902ac0605145b', 968 items => [ 969 { color => 'FFC3C0', 970 hashes => [ 971 'hash_10_VER_dd4cfe720debada3fcb1961c84e471d6', 972 'hash_10_VER_e4a799bf9a7870f7bff19cc2f0b79673', 973 'hash_10_VER_f8c1d6ae910e50bd43c07320040e6920', 974 'hash_10_VER_37da97f97ac6b285ab9e30a01091e816', 975 ], 976 item => 'Questions', 977 task => 'hash_09_VER_be889f8b879844da506c52d9f39daea1', 978 type => 'AREA', 979 }, 980 { color => 'FF0000', 981 hashes => [ 982 'hash_10_VER_f988355c1132303304229ac370107765', 983 'hash_10_VER_e3398e7b6fe32ed9c177a4163d9dc962', 984 'hash_10_VER_2dc358f556cec8486d3f8e96d35f2ecb', 985 'hash_10_VER_07982dbac050337aab5e626125212b03', 986 ], 987 item => 'Com_select', 988 task => 'hash_09_VER_cd6a0dc641793402ed3f207460650055', 989 type => 'AREA', 990 }, 991 { color => 'FF7D00', 992 hashes => [ 993 'hash_10_VER_76c5acf3f9a59df641737fe0b1ee13d1', 994 'hash_10_VER_58c78115c89f747177e99d5877d376a6', 995 'hash_10_VER_586c293f1edc2a839f7a7918e678b02f', 996 'hash_10_VER_98eea6e171cb9e34b35609d51acc997c', 997 ], 998 item => 'Com_delete', 999 task => 'hash_09_VER_d0a2a221567b305bba373419792b09ae', 1000 type => 'STACK', 1001 }, 1002 { color => 'FFF200', 1003 hashes => [ 1004 'hash_10_VER_aa9c8ebf0964d91e14b5e5bf4a4906d5', 1005 'hash_10_VER_1aef77b53c48414f73d58618b5f09372', 1006 'hash_10_VER_a11aec0916bfeb24bedfb4bcbb214fa2', 1007 'hash_10_VER_dea965401d3c9436a614506c6e83ddf9', 1008 ], 1009 item => 'Com_insert', 1010 task => 'hash_09_VER_fae604e384e38ebf0ab722abfc9561ad', 1011 type => 'STACK', 1012 }, 1013 { color => '00CF00', 1014 hashes => [ 1015 'hash_10_VER_833825c84a7385e8c7e8b45e03977f64', 1016 'hash_10_VER_05032a6da48c0a78e6f431f15bdb3fb2', 1017 'hash_10_VER_3052797946ac2189b7a6edc614a79160', 1018 'hash_10_VER_6b567169e0176fe6d268f8fdd2203f20', 1019 ], 1020 item => 'Com_update', 1021 task => 'hash_09_VER_2bd124023b6b9955d715639df7f7aed9', 1022 type => 'STACK', 1023 }, 1024 { color => '2175D9', 1025 hashes => [ 1026 'hash_10_VER_18335556eca0e60a267defd7d7451ae3', 1027 'hash_10_VER_c10c102e58bfebf98c56ef7632a138b1', 1028 'hash_10_VER_76d2eecc801620b60bd8a3fc977a9c4a', 1029 'hash_10_VER_508839deb9410e2c84a1ed191a7fa573', 1030 ], 1031 item => 'Com_replace', 1032 task => 'hash_09_VER_6858890ada867464dc888d1970811d7b', 1033 type => 'STACK', 1034 }, 1035 { color => '55009D', 1036 hashes => [ 1037 'hash_10_VER_f85a1ad9451f5a623dff9e9fe4e5986a', 1038 'hash_10_VER_71581e77f435e6ba99839826189e5d19', 1039 'hash_10_VER_621923a4994b8042c83f6217060440fc', 1040 'hash_10_VER_b99a194be758ab516d788333dd51b4ba', 1041 ], 1042 item => 'Com_load', 1043 task => 'hash_09_VER_a322127279c5bc6417128c8dcc066165', 1044 type => 'STACK', 1045 }, 1046 { color => '942D0C', 1047 hashes => [ 1048 'hash_10_VER_a738ba150a6d303730ecabd1a94d583b', 1049 'hash_10_VER_dfd186b06f5e60e6a659ccac9c42b80b', 1050 'hash_10_VER_b0e2b3108540b28d4b7a70bced22b546', 1051 'hash_10_VER_50fe9877c336e254a47ebe60b73ad6a0', 1052 ], 1053 item => 'Com_delete_multi', 1054 task => 'hash_09_VER_db6ff8e6d69dfdbafe3ad2c7f280fb30', 1055 type => 'STACK', 1056 }, 1057 { color => 'AAABA1', 1058 hashes => [ 1059 'hash_10_VER_2a110db33939221b333fd09e0f1c2f8f', 1060 'hash_10_VER_9497318c48ce3ec4c35498df138bbf0b', 1061 'hash_10_VER_59ef500abc9ff965b7687673d2a32c9f', 1062 'hash_10_VER_23ce3c7e3251618d01adec036fdc771e', 1063 ], 1064 item => 'Com_insert_select', 1065 task => 'hash_09_VER_9323443afa8cfd251f1572649224eb01', 1066 type => 'STACK', 1067 }, 1068 { color => 'D8ACE0', 1069 hashes => [ 1070 'hash_10_VER_a7fd4e8e86393642ab667e12d1406c0f', 1071 'hash_10_VER_d8030b1ab622b89ba28b5289862ff7f0', 1072 'hash_10_VER_49286bd17cdbd1d6623741eab9a94f2c', 1073 'hash_10_VER_6088d896b040bc39d927c170c1e61a7d', 1074 ], 1075 item => 'Com_update_multi', 1076 task => 'hash_09_VER_2ca0cda8eaa8b7caae5137f6189b952c', 1077 type => 'STACK', 1078 }, 1079 { color => '00B99B', 1080 hashes => [ 1081 'hash_10_VER_621220646f1e0759cfb28054d45a00d2', 1082 'hash_10_VER_7bb1d93a79d6bd49f8bd94f3d4205798', 1083 'hash_10_VER_9c9e48155bf23719d46efc12497a38e3', 1084 'hash_10_VER_af052fe308d3a2d4249448e3a4ad4d1b', 1085 ], 1086 item => 'Com_replace_select', 1087 task => 'hash_09_VER_8e8a0b70dbc38a49d1da9a9ee388f0e0', 1088 type => 'STACK', 1089 }, 1090 ], 1091 name => 'MySQL Command Counters', 1092 }, 1093 { base_value => '1000', 1094 name => 'MySQL Select Types', 1095 # Color palette: http://www.colourlovers.com/palette/354987/DSH 1096 dt => { 1097 Select_full_join => { 1098 data_source_type_id => '3', 1099 hash => 'hash_08_VER_87d58602c7e6da00001e6c2818ccbc88', 1100 }, 1101 Select_full_range_join => { 1102 data_source_type_id => '3', 1103 hash => 'hash_08_VER_60902fb5bff97c260ffe0a62df124792', 1104 }, 1105 Select_range => { 1106 data_source_type_id => '3', 1107 hash => 'hash_08_VER_60d50c9828d208ae3baee21469e4f622', 1108 }, 1109 Select_range_check => { 1110 data_source_type_id => '3', 1111 hash => 'hash_08_VER_16ea2230bd0c808a40ed8790699a589c', 1112 }, 1113 Select_scan => { 1114 data_source_type_id => '3', 1115 hash => 'hash_08_VER_a76525a8959d8e1dbc721a4623ab1135', 1116 }, 1117 hash => 'hash_01_VER_9e4c4dd2fc8107703fcde2a94e8af785', 1118 input => 'Get MySQL Stats', 1119 }, 1120 hash => 'hash_00_VER_58c5d9a972b983a8525bfdecdf24ea57', 1121 items => [ 1122 { color => '3D1500', 1123 hashes => [ 1124 'hash_10_VER_78a1882c6d0940ed5d85785f02fb46dd', 1125 'hash_10_VER_aa97bb9f53938f76b9cd0580f352f725', 1126 'hash_10_VER_30f19fdb2c2ec28e0f31c8fa64e6f542', 1127 'hash_10_VER_2fedeb05dc800c03f19e674c89b54113', 1128 ], 1129 item => 'Select_full_join', 1130 task => 'hash_09_VER_3184877202177ddf1520a3dd940ebfee', 1131 type => 'AREA', 1132 }, 1133 { color => 'AA3B27', 1134 hashes => [ 1135 'hash_10_VER_1ce5170cdf3d815e6008b799d449af71', 1136 'hash_10_VER_65dc9971cb10a5c30440249e1fba029e', 1137 'hash_10_VER_3c6cf3efb0129ad98d9778f78c848282', 1138 'hash_10_VER_5878df8aed34db668c2ca4394eeaea7b', 1139 ], 1140 item => 'Select_full_range_join', 1141 task => 'hash_09_VER_4dee3586ccfc06f6bf79151dc16194bb', 1142 type => 'STACK', 1143 }, 1144 { color => 'EDAA41', 1145 hashes => [ 1146 'hash_10_VER_eb43d2d63adbdc3787f6c8580956e0bf', 1147 'hash_10_VER_a56b898dbe16b35fd01cab804d493ff2', 1148 'hash_10_VER_79600ab93c52ee1449139c1366961a7f', 1149 'hash_10_VER_6f57169512eb3ceaa40196373fbd5f49', 1150 ], 1151 item => 'Select_range', 1152 task => 'hash_09_VER_188625bca767113e15ac8dfe23168c8b', 1153 type => 'STACK', 1154 }, 1155 { color => '13343B', 1156 hashes => [ 1157 'hash_10_VER_825d1f721a60c3ce4233fda267592367', 1158 'hash_10_VER_d826fae1ecbb27193d7b5a9f67ca3e3a', 1159 'hash_10_VER_c542c42a2cbcb3c6f5cc83ca9e0558ec', 1160 'hash_10_VER_305b4eebdb07692cdb7ad699936cf683', 1161 ], 1162 item => 'Select_range_check', 1163 task => 'hash_09_VER_1cbd9ef9edbb133faac45d3569bec43d', 1164 type => 'STACK', 1165 }, 1166 { color => '686240', 1167 hashes => [ 1168 'hash_10_VER_98401b1b5f0dfb597c5f4099a3a8dc76', 1169 'hash_10_VER_08bc850d4eec26b9e3c8d7452321087e', 1170 'hash_10_VER_835c1210d74eafa7761a8a842649ffa3', 1171 'hash_10_VER_6656e6af8c3cf5591e79c630bc516f29', 1172 ], 1173 item => 'Select_scan', 1174 task => 'hash_09_VER_4022ff8b06445f87b390aee8a4b40f8f', 1175 type => 'STACK', 1176 }, 1177 ], 1178 }, 1179 { base_value => '1000', 1180 dt => { 1181 Sort_merge_passes => { 1182 data_source_type_id => '3', 1183 hash => 'hash_08_VER_4069ef59e60869d0cdcb6c90daa074c3', 1184 }, 1185 Sort_range => { 1186 data_source_type_id => '3', 1187 hash => 'hash_08_VER_3d195e34d54d1c3ce818642a8faa1062', 1188 }, 1189 Sort_rows => { 1190 data_source_type_id => '3', 1191 hash => 'hash_08_VER_db39ee0ee9191965c0269be1b00f5b2a', 1192 }, 1193 Sort_scan => { 1194 data_source_type_id => '3', 1195 hash => 'hash_08_VER_1527f34fa6fbe98c65ce07ecaab87475', 1196 }, 1197 hash => 'hash_01_VER_bba70f9de6d0159616e947417459ea67', 1198 input => 'Get MySQL Stats', 1199 }, 1200 hash => 'hash_00_VER_1cd29dabd1cc6f8e941d68453a8b20cb', 1201 items => [ 1202 { color => 'FFAB00', 1203 hashes => [ 1204 'hash_10_VER_a740b7c69014ea8e1fcf6b5bb4747f7f', 1205 'hash_10_VER_9a3a20b574368271d24f111ff1f6fdcc', 1206 'hash_10_VER_81870741cd7488e5e4b9a926fffa93bd', 1207 'hash_10_VER_86b880de007dcedf9a9498f1ed09e4d3', 1208 ], 1209 item => 'Sort_rows', 1210 task => 'hash_09_VER_72497b7d5be76fce56f822772b8e805d', 1211 type => 'AREA', 1212 }, 1213 { color => '157419', 1214 hashes => [ 1215 'hash_10_VER_b192171fe1add8e2b5bf10d2a5d4c120', 1216 'hash_10_VER_fd4338ae50341d4a81e11b1216b369c9', 1217 'hash_10_VER_3ef873dce479a66ac8b80f1e2b594ac9', 1218 'hash_10_VER_630ba9a1c2315021fce22e5fa83485be', 1219 ], 1220 item => 'Sort_range', 1221 task => 'hash_09_VER_f2b2217507185f947ea6c602c9b21f62', 1222 type => 'LINE1', 1223 }, 1224 { color => 'DA4725', 1225 hashes => [ 1226 'hash_10_VER_e3b157d7d5ceec409a04655ae22b69c2', 1227 'hash_10_VER_f3d30ac75381dd99434f982a2a00d6fa', 1228 'hash_10_VER_6b67fe5b72c13f4c47329aff687eb013', 1229 'hash_10_VER_b55c762a65cee114206cf813e3d29134', 1230 ], 1231 item => 'Sort_merge_passes', 1232 task => 'hash_09_VER_4c62753dbd0d3316a68e8767736eeafb', 1233 type => 'LINE1', 1234 }, 1235 { color => '4444FF', 1236 hashes => [ 1237 'hash_10_VER_e83dabc71fc26a31551142612092b534', 1238 'hash_10_VER_8c2bc89bfa192ec86a0b02c5e2d8742a', 1239 'hash_10_VER_6c1f0f59b6bf0a023ab30faf54f32897', 1240 'hash_10_VER_89548663a29e888184d8a0c679915323', 1241 ], 1242 item => 'Sort_scan', 1243 task => 'hash_09_VER_b2880639594f7369f799d929c88075d3', 1244 type => 'LINE1', 1245 }, 1246 ], 1247 name => 'MySQL Sorts', 1248 }, 1249 { base_value => '1000', 1250 dt => { 1251 Created_tmp_disk_tables => { 1252 data_source_type_id => '3', 1253 hash => 'hash_08_VER_b27fa767049cf641dc6e26abb321a9c1', 1254 }, 1255 Created_tmp_files => { 1256 data_source_type_id => '3', 1257 hash => 'hash_08_VER_3b238d3760a85cdb480edb21b5452845', 1258 }, 1259 Created_tmp_tables => { 1260 data_source_type_id => '3', 1261 hash => 'hash_08_VER_4c07222a44715e609ebe24d2cf41fa28', 1262 }, 1263 hash => 'hash_01_VER_d0d18f331e3a7eb32e43109ee0eb0bdc', 1264 input => 'Get MySQL Stats', 1265 }, 1266 hash => 'hash_00_VER_ffc0ac1530d49922b2b80e6b9ee0dc0c', 1267 items => [ 1268 { color => 'FFAB00', 1269 hashes => [ 'hash_10_VER_266aee17a394dac4674e907a560cd583' ], 1270 item => 'Created_tmp_tables', 1271 task => 'hash_09_VER_2945647fa55b9bdf8cc1e5609def2e9d', 1272 type => 'AREA', 1273 }, 1274 { color => '837C04', 1275 hashes => [ 1276 'hash_10_VER_1afc8483110fe70199aade6a3ab7172a', 1277 'hash_10_VER_1b823a55371813c10c19428653385130', 1278 'hash_10_VER_28d77a44ac6340af4b8b55d0d5fb5b11', 1279 'hash_10_VER_5cf32b30f3239125797b714af0ef776e', 1280 ], 1281 item => 'Created_tmp_tables', 1282 task => 'hash_09_VER_7483f01bfb45e25d5e54fe62453868c5', 1283 type => 'LINE1', 1284 }, 1285 { color => 'F51D30', 1286 hashes => [ 1287 'hash_10_VER_ad410eb0d87c37bba36d6b3e0529a9e5', 1288 'hash_10_VER_6bed1f7b2a46d9ec239cd7b346657e43', 1289 'hash_10_VER_c38df420a06a7f213f156e093392d0d3', 1290 'hash_10_VER_01d71ae3b70ff36f6d0f99f1e2d90b06', 1291 ], 1292 item => 'Created_tmp_disk_tables', 1293 task => 'hash_09_VER_180f6e2087960c02c28c76d1a5ac9e62', 1294 type => 'LINE1', 1295 }, 1296 { color => '157419', 1297 hashes => [ 1298 'hash_10_VER_38d2340d467bcc7448d4ad39a7a3f541', 1299 'hash_10_VER_dbfcd210b13b12d75d6319326d257060', 1300 'hash_10_VER_2f7226d9f536f05a222f7399591dbfe0', 1301 'hash_10_VER_91337469aac81c5d0da9914b6f60ebc5', 1302 ], 1303 item => 'Created_tmp_files', 1304 task => 'hash_09_VER_72e7be19411f56a842ff6f6750d869b9', 1305 type => 'LINE2', 1306 }, 1307 ], 1308 name => 'MySQL Temporary Objects', 1309 }, 1310 { base_value => '1024', 1311 # Palette: http://www.colourlovers.com/palette/90901/le_pain_quotidien 1312 name => 'MySQL Network Traffic', 1313 dt => { 1314 Bytes_sent => { 1315 data_source_type_id => '3', 1316 hash => 'hash_08_VER_1953484b0466fa323d70e79e3a4ee93a', 1317 }, 1318 Bytes_received => { 1319 data_source_type_id => '3', 1320 hash => 'hash_08_VER_465a226d126681262e2fd6a8ed8ce51d', 1321 }, 1322 hash => 'hash_01_VER_a9306eb70bd17877efefbd3225a0f1bc', 1323 input => 'Get MySQL Stats', 1324 }, 1325 hash => 'hash_00_VER_3a72f928a8e55ef8976a85bb3a051882', 1326 items => [ 1327 { color => '4B2744', 1328 hashes => [ 1329 'hash_10_VER_32e487739b9c79f27ed89c1d15f7a988', 1330 'hash_10_VER_84e485be0cebbd7020277f9ebb6d97cb', 1331 'hash_10_VER_49080ba06909f73558576bdb03364452', 1332 'hash_10_VER_0c3f8d73e16a10be01b289a7e8ffd0c2', 1333 ], 1334 item => 'Bytes_sent', 1335 task => 'hash_09_VER_8ed92b8475d41190916698bd2d1b7ee8', 1336 type => 'AREA', 1337 }, 1338 { color => 'E4C576', 1339 hashes => [ 1340 'hash_10_VER_11dff519e843d101fcfdaa3a1e357456', 1341 'hash_10_VER_d3b37188a1245b589102539f8eca2f60', 1342 'hash_10_VER_c62cb1631a5af6c4667f6f4fd681042e', 1343 'hash_10_VER_6dd4537ed59f8578fb70bbfa700aec67', 1344 ], 1345 item => 'Bytes_received', 1346 task => 'hash_09_VER_c9f94e412128b87e087ed71acae6e8bf', 1347 type => 'AREA', 1348 cdef => 'Negate', 1349 }, 1350 ], 1351 }, 1352 { base_value => '1024', 1353 # Color palette: http://www.colourlovers.com/palette/324729/Compliments 1354 name => 'InnoDB Buffer Pool Activity', 1355 dt => { 1356 hash => 'hash_01_VER_ff6342ba145a883cacfa1bf5e8cb5114', 1357 input => 'Get MySQL Stats', 1358 pages_created => { 1359 data_source_type_id => '3', 1360 hash => 'hash_08_VER_1632c89150754f4d2b2419b5822dd11f', 1361 }, 1362 pages_read => { 1363 data_source_type_id => '3', 1364 hash => 'hash_08_VER_202e45fee8e86fab0d6ac411fddbe531', 1365 }, 1366 pages_written => { 1367 data_source_type_id => '3', 1368 hash => 'hash_08_VER_94d9a0f449cfb1d05ee1df9d51f5ae03', 1369 }, 1370 }, 1371 hash => 'hash_00_VER_e1331b937bc4c20f68d39851d44e93c8', 1372 items => [ 1373 { color => 'D6883A', 1374 hashes => [ 1375 'hash_10_VER_783842a5a255edd82e62bf70e697cdb9', 1376 'hash_10_VER_362d7530e26d26a96d4aec9babe4aa85', 1377 'hash_10_VER_2d3230c6f3a22211c424f467f362b33c', 1378 'hash_10_VER_35a5944f6cb3912c31f62d8a9c9fbe24', 1379 ], 1380 item => 'pages_created', 1381 task => 'hash_09_VER_b08541be08d8e4146687258bc7ff8b46', 1382 type => 'LINE2', 1383 }, 1384 { color => 'E6D883', 1385 hashes => [ 1386 'hash_10_VER_59c8c129997e3143dcc1ebb30ac2969b', 1387 'hash_10_VER_f2e3648338a0b76651b0f2db5c62efc9', 1388 'hash_10_VER_40370c1f675e05b242163f98b178081d', 1389 'hash_10_VER_ea3e43bb706076c720069e9b55a50f9d', 1390 ], 1391 item => 'pages_read', 1392 task => 'hash_09_VER_209b3c52d1bf4a9761763d50106ad18f', 1393 type => 'LINE2', 1394 }, 1395 { color => '55AD84', 1396 hashes => [ 1397 'hash_10_VER_9da42c140202242d3b92df799f61b3cb', 1398 'hash_10_VER_a01e24e2b221c690f65aa173512a5a9a', 1399 'hash_10_VER_a0e6214cf1c317e520e1fcc7bee51724', 1400 'hash_10_VER_52f4a0a610e34a6e1ea9d62ffac827a9', 1401 ], 1402 item => 'pages_written', 1403 task => 'hash_09_VER_7cf26da81167d0e134656db4c99eb5c5', 1404 type => 'LINE2', 1405 }, 1406 ], 1407 }, 1408 { base_value => '1000', 1409 dt => { 1410 hash => 'hash_01_VER_8f5f47efb3af16a6f3b877ddb5deba6d', 1411 input => 'Get MySQL Stats', 1412 pending_aio_log_ios => { 1413 data_source_type_id => '1', 1414 hash => 'hash_08_VER_e802a176af00f7e8d583c8affc699f4e', 1415 }, 1416 pending_aio_sync_ios => { 1417 data_source_type_id => '1', 1418 hash => 'hash_08_VER_a8890df815d6c156a337dca60ffcaaff', 1419 }, 1420 pending_buf_pool_flushes => { 1421 data_source_type_id => '1', 1422 hash => 'hash_08_VER_cfb857472703b9f8c60fd497cb332872', 1423 }, 1424 pending_chkp_writes => { 1425 data_source_type_id => '1', 1426 hash => 'hash_08_VER_c66fa1a69da9b46dbc9801e53feeacbe', 1427 }, 1428 pending_ibuf_aio_reads => { 1429 data_source_type_id => '1', 1430 hash => 'hash_08_VER_70ba2629a4bfec1c310d3b19eb7f40b7', 1431 }, 1432 pending_log_flushes => { 1433 data_source_type_id => '1', 1434 hash => 'hash_08_VER_fea7be0cd5014f436fdad8993f7d300a', 1435 }, 1436 pending_log_writes => { 1437 data_source_type_id => '1', 1438 hash => 'hash_08_VER_5709fab92518d9d2d8368966690d4fdd', 1439 }, 1440 pending_normal_aio_reads => { 1441 data_source_type_id => '1', 1442 hash => 'hash_08_VER_e356afa13eed7fc0a5592ceedba47ab9', 1443 }, 1444 pending_normal_aio_writes => { 1445 data_source_type_id => '1', 1446 hash => 'hash_08_VER_e1dd220da71bceb6a6ef9a8f2fe76e8f', 1447 }, 1448 }, 1449 hash => 'hash_00_VER_42761724e80a1563d4294595107b7188', 1450 items => [ 1451 { color => 'FF0000', 1452 hashes => [ 1453 'hash_10_VER_dd439e4b49c45bbf62c20b746b7cf944', 1454 'hash_10_VER_8d65bc74cd5102d8674118428458cfa6', 1455 'hash_10_VER_1936b847692aaa6fbeda562d94403c26', 1456 'hash_10_VER_7524d5c2a0d8c767ee6a44d5adce8f36', 1457 ], 1458 item => 'pending_aio_log_ios', 1459 task => 'hash_09_VER_7493f6d8f76a153776a88f5a6f666a13', 1460 type => 'LINE1', 1461 }, 1462 { color => 'FF7D00', 1463 hashes => [ 1464 'hash_10_VER_5512e0674dd0a22caed4818febdf7a8b', 1465 'hash_10_VER_b44a8e5c738147d97b473847bfa90b39', 1466 'hash_10_VER_8c23b992ee316813b9e474fb394e2657', 1467 'hash_10_VER_6d1471e3ea89f4ff9c08383505bddb3d', 1468 ], 1469 item => 'pending_aio_sync_ios', 1470 task => 'hash_09_VER_e955f91fd53a930265dba9f8a914e175', 1471 type => 'LINE1', 1472 }, 1473 { color => 'FFF200', 1474 hashes => [ 1475 'hash_10_VER_e41b3643de6b0d0df93d4eba6affb91d', 1476 'hash_10_VER_1805372f87352f13d84dae6a8af685da', 1477 'hash_10_VER_4beda20fc795edcb8b0bb742b9408c2f', 1478 'hash_10_VER_7576b99ae04ad98c66263b3ce26132ff', 1479 ], 1480 item => 'pending_buf_pool_flushes', 1481 task => 'hash_09_VER_8e5357a55cff955f9c8db282c34cf2e8', 1482 type => 'LINE1', 1483 }, 1484 { color => '00A348', 1485 hashes => [ 1486 'hash_10_VER_de313f62d55c7dc3375d19a831c2edea', 1487 'hash_10_VER_15314fd3f31b9edd4b6c715465617277', 1488 'hash_10_VER_7503f98f651c28f8a163589ecf6d1633', 1489 'hash_10_VER_f21cc51e23b0485d9c21787ad6be20dd', 1490 ], 1491 item => 'pending_chkp_writes', 1492 task => 'hash_09_VER_cfa5c2f2a1f32768cc33a7f25eb4cf4a', 1493 type => 'LINE1', 1494 }, 1495 { color => '6DC8FE', 1496 hashes => [ 1497 'hash_10_VER_29ef5333addb20d373a2cbc7f75436a4', 1498 'hash_10_VER_c012d3c95d817dae73f0ef41b7907d43', 1499 'hash_10_VER_6367306163494734a25de57dbc28c6ac', 1500 'hash_10_VER_db9ccc5c7fca0eb9233b496f4128f5de', 1501 ], 1502 item => 'pending_ibuf_aio_reads', 1503 task => 'hash_09_VER_5a1674a64952edebf879f1f2fe2aba34', 1504 type => 'LINE1', 1505 }, 1506 { color => '4444FF', 1507 hashes => [ 1508 'hash_10_VER_ccbec78d1677a7092ae758474c479cf5', 1509 'hash_10_VER_28ef7d7fe29f98dd0b4332f97bd2d073', 1510 'hash_10_VER_07d2fe457909f46046e1a792fa77b570', 1511 'hash_10_VER_5577dc6729f7ed31b857ad414e54aa7a', 1512 ], 1513 item => 'pending_log_flushes', 1514 task => 'hash_09_VER_4c5423739f98cf85840453df9b0519b2', 1515 type => 'LINE1', 1516 }, 1517 { color => '55009D', 1518 hashes => [ 1519 'hash_10_VER_d2e09c1f703e8b83736c32e19aa519f9', 1520 'hash_10_VER_75615a7d416993bd4df845e6a7577421', 1521 'hash_10_VER_3d1839e4a2a2c1f15225c147ad87220b', 1522 'hash_10_VER_45ceda6e1720c745d3d0ef029d47f51f', 1523 ], 1524 item => 'pending_log_writes', 1525 task => 'hash_09_VER_2cd0b5b4b922ec7b2cb99dbf5e0911c3', 1526 type => 'LINE1', 1527 }, 1528 { color => 'B90054', 1529 hashes => [ 1530 'hash_10_VER_daf69bca7e1cffa32458699e9ab8ba25', 1531 'hash_10_VER_373f7ba96ddb5d85e1331e9fb321f4b2', 1532 'hash_10_VER_9b01205230ce16501cccfe974ddec096', 1533 'hash_10_VER_ad4ff238ff6e4446e0cb9dd58f2ffc3f', 1534 ], 1535 item => 'pending_normal_aio_reads', 1536 task => 'hash_09_VER_8b51ea18d0cc77ab651bfd48232cddd8', 1537 type => 'LINE1', 1538 }, 1539 { color => '8F9286', 1540 hashes => [ 1541 'hash_10_VER_beb503ebfe31d7c29899e200f026ee83', 1542 'hash_10_VER_9c4ec2393579d1713cb93c7976f055ae', 1543 'hash_10_VER_2c580ae9c0f556f85e86e794de7810bf', 1544 'hash_10_VER_5464695dd6a4843f70c47da852903fb9', 1545 ], 1546 item => 'pending_normal_aio_writes', 1547 task => 'hash_09_VER_986515db8bb6608b4b0f2f355338745e', 1548 type => 'LINE1', 1549 }, 1550 ], 1551 name => 'InnoDB I/O Pending', 1552 }, 1553 { base_value => '1024', 1554 name => 'InnoDB Log', 1555 dt => { 1556 hash => 'hash_01_VER_fba9a4ab432ec622fea54cb776a85e29', 1557 innodb_log_buffer_size => { 1558 data_source_type_id => '1', 1559 hash => 'hash_08_VER_c17991311d486b6e73aaefddc1495d7f', 1560 }, 1561 input => 'Get MySQL Stats', 1562 log_bytes_flushed => { 1563 data_source_type_id => '3', 1564 hash => 'hash_08_VER_69a8f9b4a6361960338a5db09831addb', 1565 }, 1566 log_bytes_written => { 1567 data_source_type_id => '3', 1568 hash => 'hash_08_VER_9b45c73fb9db0d5562b29af24794479d', 1569 }, 1570 unflushed_log => { 1571 data_source_type_id => '1', 1572 hash => 'hash_08_VER_451c817191559726cfddd316198a2853', 1573 }, 1574 }, 1575 hash => 'hash_00_VER_e2de9f7c7ac195936a47a3c4d74b98bc', 1576 items => [ 1577 { color => '6E3803', 1578 hashes => [ 1579 'hash_10_VER_02e289c1613b1a283a54f6c99aeeadaf', 1580 'hash_10_VER_1671c2356f1ea5d6e9128f22f56c619c', 1581 ], 1582 item => 'innodb_log_buffer_size', 1583 task => 'hash_09_VER_ec517d1a0d799256d51ed86a5f120cbd', 1584 type => 'AREA', 1585 }, 1586 { color => '5B8257', 1587 hashes => [ 1588 'hash_10_VER_c64350e5653b5e9fb14818de1a413476', 1589 'hash_10_VER_7d717c2499f9713b5783c76316541708', 1590 'hash_10_VER_78e153e29946be1448a2b4ed4db3a7c7', 1591 'hash_10_VER_37762f7e8e2f4d4dc83e28a18cd982d6', 1592 ], 1593 item => 'log_bytes_written', 1594 task => 'hash_09_VER_53ce75974570c9813f54b084a7bf6a39', 1595 type => 'AREA', 1596 }, 1597 { color => 'AB4253', 1598 hashes => [ 1599 'hash_10_VER_0bd7d8e50984d8f32686abab1a32293a', 1600 'hash_10_VER_c2cbbfd6949982cda5ff8371222d443b', 1601 'hash_10_VER_ce5e716d94990bca8316915fc8c6d295', 1602 'hash_10_VER_d3fcc946db121ed4de8d8f1f730c6609', 1603 ], 1604 item => 'log_bytes_flushed', 1605 task => 'hash_09_VER_190d0a214749165d2a62eb85f777193a', 1606 type => 'LINE1', 1607 }, 1608 { color => 'AFECED', 1609 hashes => [ 1610 'hash_10_VER_d085a73e94ab72fbbdaf6eff679203a4', 1611 'hash_10_VER_1ece8b77f3cd5f215adfb889a60fdea3', 1612 'hash_10_VER_6f381800df776acad71d99b235af8929', 1613 'hash_10_VER_c13258cea0f7dc8aebdba8f58a2d09c8', 1614 ], 1615 item => 'unflushed_log', 1616 task => 'hash_09_VER_f2096cbd131d5266428948955148d048', 1617 type => 'AREA', 1618 }, 1619 ], 1620 }, 1621 { base_value => '1024', 1622 dt => { 1623 Binlog_cache_disk_use => { 1624 data_source_type_id => '3', 1625 hash => 'hash_08_VER_a41d3fa5e07c27bda6b3bef283a3f200', 1626 }, 1627 Binlog_cache_use => { 1628 data_source_type_id => '3', 1629 hash => 'hash_08_VER_ca7f7ba37c2bd78263b1009dcf467eab', 1630 }, 1631 binary_log_space => { 1632 data_source_type_id => '1', 1633 hash => 'hash_08_VER_b0353ac1fa0f77d2968aebc0166bbd9e', 1634 }, 1635 hash => 'hash_01_VER_cd62ce5984a3e9deee558f734be52827', 1636 input => 'Get MySQL Stats', 1637 relay_log_space => { 1638 data_source_type_id => '1', 1639 hash => 'hash_08_VER_87b49f80e24ab4f6989119525dd26184', 1640 }, 1641 }, 1642 hash => 'hash_00_VER_39993e6432afcf0061234d8817ad36bf', 1643 items => [ 1644 { color => '35962B', 1645 hashes => [ 1646 'hash_10_VER_bdfbb1b39980e88ed94f16c39985fa4f', 1647 'hash_10_VER_8616af578f90be7a458083fabfeab4e1', 1648 'hash_10_VER_0ed6c0a25486bc879a034f811e36da34', 1649 'hash_10_VER_a2c965ce35d96fbce8c3ba07475510de', 1650 ], 1651 item => 'Binlog_cache_use', 1652 task => 'hash_09_VER_02afd2d630540b961ffe2632b16b03e3', 1653 type => 'LINE1', 1654 }, 1655 { color => 'FF0000', 1656 hashes => [ 1657 'hash_10_VER_5b61415534d6fd0b7f68e6c75d9fbe51', 1658 'hash_10_VER_3fec21b5b651fd4c7af44cd0af8c9e35', 1659 'hash_10_VER_3df6144459058a6b8b3c0c0743ac15b1', 1660 'hash_10_VER_2a0c45b03f2ffeb60090760abae23b86', 1661 ], 1662 item => 'Binlog_cache_disk_use', 1663 task => 'hash_09_VER_0f8e0c480652891104e4953236ec09ca', 1664 type => 'LINE1', 1665 }, 1666 { color => '8D00BA', 1667 hashes => [ 1668 'hash_10_VER_ce9f0c0ab443b3a79da9b94335ac1b71', 1669 'hash_10_VER_1b57843bf293f4385ef8e346b40f5c71', 1670 'hash_10_VER_94000e439d20c8ab3890c06419cb253f', 1671 'hash_10_VER_1720ffc5fda1501119fb88a70ff8afc0', 1672 ], 1673 item => 'binary_log_space', 1674 task => 'hash_09_VER_90c7c6b6e6021590e34f17fc8ccb9ae5', 1675 type => 'LINE1', 1676 }, 1677 { color => '8F005C', 1678 hashes => [ 1679 'hash_10_VER_f380d5f2072fedbc4db97a04ca573559', 1680 'hash_10_VER_a778cfaad5b84bc4219bef37ea908bce', 1681 'hash_10_VER_b5b1c10f5e77f9af13c951341d11c0da', 1682 'hash_10_VER_5393c8b1c590861e3f01e4154ed91c68', 1683 ], 1684 item => 'relay_log_space', 1685 task => 'hash_09_VER_4dab3bd0d207740456cc634264a10389', 1686 type => 'LINE1', 1687 }, 1688 ], 1689 name => 'MySQL Binary/Relay Logs', 1690 }, 1691 { name => 'InnoDB Transactions', 1692 base_value => '1000', 1693 hash => 'hash_00_VER_1fd005442e45b70ae097ddc0eab0209e', 1694 dt => { 1695 input => 'Get MySQL Stats', 1696 hash => 'hash_01_VER_f6a40e01342f29e217f54be82730974b', 1697 history_list => { 1698 data_source_type_id => '1', 1699 hash => 'hash_08_VER_73142c0ad2c1bbcd94224d100b82bfaa', 1700 }, 1701 innodb_transactions => { 1702 data_source_type_id => '3', 1703 hash => 'hash_08_VER_0e94a0712e8bca7fb0f0c76effaac4d2', 1704 }, 1705 }, 1706 items => [ 1707 { color => '8F005C', 1708 hashes => [ 1709 'hash_10_VER_555887c11b68bbedd6a8524c6247cb31', 1710 'hash_10_VER_7fc8892111a6f33cbbf4cd5b9886a953', 1711 'hash_10_VER_04f220a42b67c3d288b5ab77e4d8f88d', 1712 'hash_10_VER_e7acbf4c739cc677be448af321410730', 1713 ], 1714 item => 'innodb_transactions', 1715 task => 'hash_09_VER_069cf29a97e3f7d77f8b2e68e46ee6b9', 1716 type => 'LINE1', 1717 }, 1718 { color => 'FF7D00', 1719 hashes => [ 1720 'hash_10_VER_05580498fdfe184e3fad1fbbf77ada6b', 1721 'hash_10_VER_283cd600fb6ae61b3024df06dd8623e5', 1722 'hash_10_VER_af966d9a850275d8c0b12fad13ccf71c', 1723 'hash_10_VER_9e51b283869de058844e0fe9e3cacecb', 1724 ], 1725 item => 'history_list', 1726 task => 'hash_09_VER_2e01f14ad096f43d2f6d5a6252a3a93d', 1727 type => 'LINE1', 1728 }, 1729 ], 1730 }, 1731 { name => 'InnoDB Transactions Active/Locked', 1732 base_value => '1000', 1733 hash => 'hash_00_VER_b5153f8ecf6c970212c8f7697433523a', 1734 dt => { 1735 input => 'Get MySQL Stats', 1736 hash => 'hash_01_VER_22ea7c024900ad5e99ff56574a21d7ca', 1737 active_transactions => { 1738 data_source_type_id => '1', 1739 hash => 'hash_08_VER_616fd388be03c90b9978b51b70ed2fda', 1740 }, 1741 locked_transactions => { 1742 data_source_type_id => '1', 1743 hash => 'hash_08_VER_0e40c07dfbdba49b81fdbae32d4edab4', 1744 }, 1745 current_transactions => { 1746 data_source_type_id => '1', 1747 hash => 'hash_08_VER_e6cf96ff1fc7966fe442dd51cd2bdbcc', 1748 }, 1749 read_views => { 1750 data_source_type_id => '1', 1751 hash => 'hash_08_VER_5e92066e5f110ee444a94c705e7e7691', 1752 }, 1753 }, 1754 items => [ 1755 { color => 'C0C0C0', 1756 hashes => [ 1757 'hash_10_VER_36ea72dd02d1b5b59e7f252b17a3bfbf', 1758 'hash_10_VER_f8114ffe652ccc28835504de31d292b7', 1759 'hash_10_VER_c6aaa0053e9a9d58d2681734c27b2832', 1760 'hash_10_VER_654467ff63e010a2ef4912d2e29a1036', 1761 ], 1762 item => 'active_transactions', 1763 task => 'hash_09_VER_63340f5c2e8c6aacbb60b76f9c31f7dd', 1764 type => 'AREA', 1765 }, 1766 { color => 'FF0000', 1767 hashes => [ 1768 'hash_10_VER_bb93454d739f7dbbdb75468cd4352ec5', 1769 'hash_10_VER_5eed22688ab4e23de578a87a4287fb65', 1770 'hash_10_VER_e674989440124391c9d25220ba00d86b', 1771 'hash_10_VER_4390b5b70c9bf2b9ac5b58b77dd1687b', 1772 ], 1773 item => 'locked_transactions', 1774 task => 'hash_09_VER_bd80b16ce5ba5fcb43148d72c00fb033', 1775 type => 'LINE1', 1776 }, 1777 { color => '4444FF', 1778 hashes => [ 1779 'hash_10_VER_8c5e57c2540c8b4a0e2aca517ac4c9dd', 1780 'hash_10_VER_6cd40ed62a23c46f7d0c74282dcc2235', 1781 'hash_10_VER_608844643878340a2103bb7dd7908fc8', 1782 'hash_10_VER_eccae20cfab8cccabffcb10d824e8b66', 1783 ], 1784 item => 'current_transactions', 1785 task => 'hash_09_VER_e70327f4f272557d3e9312d31120f5bd', 1786 type => 'LINE1', 1787 }, 1788 { color => '74C366', 1789 hashes => [ 1790 'hash_10_VER_458bdc7c36ea9ea78b9eade5ef1b3c0f', 1791 'hash_10_VER_4a743812dad30ce95ce2f4942a1b1015', 1792 'hash_10_VER_fbd96b8c03c65a46bd26b4ed3c2ebaf8', 1793 'hash_10_VER_9f25d39e551924c1ef6dd7b9feb8376a', 1794 ], 1795 item => 'read_views', 1796 task => 'hash_09_VER_6929089137f1c043c56a7031c9fb2f3c', 1797 type => 'LINE1', 1798 }, 1799 ], 1800 }, 1801 { base_value => '1000', 1802 name => 'MySQL Files and Tables', 1803 dt => { 1804 Open_files => { 1805 data_source_type_id => '1', 1806 hash => 'hash_08_VER_5dc3b51fa3acac1b7e7aa55da0267d6d', 1807 }, 1808 Open_tables => { 1809 data_source_type_id => '1', 1810 hash => 'hash_08_VER_833a86f771733356ce7b47c3ad6c4b23', 1811 }, 1812 Opened_tables => { 1813 data_source_type_id => '3', 1814 hash => 'hash_08_VER_1f85e70184e14ffa218204d5eff27ca8', 1815 }, 1816 hash => 'hash_01_VER_2725cfdffa6cefd9469b4ca9b673d274', 1817 input => 'Get MySQL Stats', 1818 table_cache => { 1819 data_source_type_id => '1', 1820 hash => 'hash_08_VER_62dd5b27df7c0f9ee2c37daa2d60acf3', 1821 }, 1822 }, 1823 hash => 'hash_00_VER_33c5519751ba7a909aa507a4c95a5d19', 1824 items => [ 1825 { color => 'D09887', 1826 hashes => [ 1827 'hash_10_VER_bb43289317b8771c767d0e22bba00218', 1828 'hash_10_VER_c8366fca8f60ed626fcd72fea8348e55', 1829 ], 1830 item => 'table_cache', 1831 task => 'hash_09_VER_596a9024d617e8147db1b35eb81d788e', 1832 type => 'AREA', 1833 }, 1834 { color => '4A6959', 1835 hashes => [ 1836 'hash_10_VER_c7c1fe4a8856989ad6ab1740bfec0d46', 1837 'hash_10_VER_497dcd91cd8f2aea215041831e55588d', 1838 'hash_10_VER_f591f5e9ab50e932b438dad53a7ad088', 1839 'hash_10_VER_24105e9231849eb7d53440cd1ea107d9', 1840 ], 1841 item => 'Open_tables', 1842 task => 'hash_09_VER_9fb0ec10218ffb8b2af05b34b11f3b60', 1843 type => 'LINE1', 1844 }, 1845 { color => '1D1159', 1846 hashes => [ 1847 'hash_10_VER_ee28157b1a7e0cba078e916bc3d1cf9c', 1848 'hash_10_VER_797a0953a24f77b4d65f4497ed921659', 1849 'hash_10_VER_e285cce25b143ad285ac6402744120ee', 1850 'hash_10_VER_b54bb9acce4f9103099ac687aad182b7', 1851 ], 1852 item => 'Open_files', 1853 task => 'hash_09_VER_af228524aa3afe1ad25583c3ad5b5de6', 1854 type => 'LINE1', 1855 }, 1856 { color => 'DE0056', 1857 hashes => [ 1858 'hash_10_VER_00849b44ebd02a9e748620bc7081ee4b', 1859 'hash_10_VER_4ecff81d0dac519307b50a4ec8ccc1a0', 1860 'hash_10_VER_f497bf0917d531bfc09693159966e9c3', 1861 'hash_10_VER_d86f135fc819c1e7c645b66ca3fd3526', 1862 ], 1863 item => 'Opened_tables', 1864 task => 'hash_09_VER_6528d45ff1964bc03ecd95d50e4b9ecf', 1865 type => 'LINE1', 1866 }, 1867 ], 1868 }, 1869 { base_value => '1000', 1870 dt => { 1871 hash => 'hash_01_VER_7dd35ba30e2d400558fa57d4344d50ca', 1872 input => 'Get MySQL Stats', 1873 thread_cache_size => { 1874 data_source_type_id => '1', 1875 hash => 'hash_08_VER_44655c9b3c600c912e7ac7245297bcd4', 1876 }, 1877 Threads_connected => { 1878 data_source_type_id => '1', 1879 hash => 'hash_08_VER_1b5429991445610d0381838eac293ca1', 1880 }, 1881 Threads_running => { 1882 data_source_type_id => '1', 1883 hash => 'hash_08_VER_168af32709e712ff11e736ff7a9db032', 1884 }, 1885 Threads_created => { 1886 data_source_type_id => '3', 1887 hash => 'hash_08_VER_177f4b47fa4620e066ba0bcc9e9ca606', 1888 }, 1889 Threads_cached => { 1890 data_source_type_id => '1', 1891 hash => 'hash_08_VER_925a0f68d2fc4e4ad8cec7b2ae830aa0', 1892 }, 1893 }, 1894 hash => 'hash_00_VER_51adb838f4108b4f045b050cd6754f8f', 1895 items => [ 1896 { color => 'E8CDEF', 1897 hashes => [ 1898 'hash_10_VER_e95f3f5d815d18a499c0fbb46dde74c1', 1899 'hash_10_VER_cc06406bf5330f48f9f72131eb7811b4', 1900 ], 1901 item => 'thread_cache_size', 1902 task => 'hash_09_VER_9a0cd2d2c00a75f2c670ad865886b49a', 1903 type => 'AREA', 1904 }, 1905 { color => '08A000', 1906 hashes => [ 1907 'hash_10_VER_75f05f3bdbf2da679ff2dea32d070cf8', 1908 'hash_10_VER_b76504d4ed47e962092138e2890dfdeb', 1909 'hash_10_VER_c85c607bc3651d479babbd9ce71c1dc2', 1910 'hash_10_VER_0cc56033a63b1ba94739d0ce522570af', 1911 ], 1912 item => 'Threads_connected', 1913 task => 'hash_09_VER_40370e70a9191e3393a230087e32c465', 1914 type => 'LINE1', 1915 }, 1916 { color => 'FF3932', 1917 hashes => [ 1918 'hash_10_VER_b95b673dfad1d598fcd5ccf82dc7a469', 1919 'hash_10_VER_8a6f588dc568bbfa43bca11303afd99e', 1920 'hash_10_VER_b3e6c5362bc7261180708bd529b3ed76', 1921 'hash_10_VER_72f139dc196375878fe3a8095b3b8dc6', 1922 ], 1923 item => 'Threads_running', 1924 task => 'hash_09_VER_d5f789f7d6ac0921b2d5d2466186da10', 1925 type => 'LINE1', 1926 }, 1927 { color => '4444FF', 1928 hashes => [ 1929 'hash_10_VER_be5566c7e73156652bba54572da521ec', 1930 'hash_10_VER_45af6233f84badff7b1d371d6ce936bf', 1931 'hash_10_VER_ab20f1a21c6381e85d07467e61a5c365', 1932 'hash_10_VER_4d4dd16dbc33ac4baa5cbc77f66497c9', 1933 ], 1934 item => 'Threads_created', 1935 task => 'hash_09_VER_d16f2abaed115fcdbf5a95bb281519d2', 1936 type => 'LINE1', 1937 }, 1938 { color => 'F39034', 1939 hashes => [ 1940 'hash_10_VER_f5f4248474a749206629369d6bebdb2b', 1941 'hash_10_VER_05a580f4c0a613c5ddf78a1ec430b306', 1942 'hash_10_VER_d4ac79bee93510730f57e0cbb68b8980', 1943 'hash_10_VER_493acce101ff1bddec0f6b3a7cedd732', 1944 ], 1945 item => 'Threads_cached', 1946 task => 'hash_09_VER_9b3689607465e658bd4471aa8ad523be', 1947 type => 'LINE1', 1948 }, 1949 ], 1950 name => 'MySQL Threads', 1951 }, 1952 { name => 'InnoDB Memory Allocation', 1953 base_value => '1024', 1954 hash => 'hash_00_VER_601989a3763b41eec593346b447b9a96', 1955 dt => { 1956 input => 'Get MySQL Stats', 1957 hash => 'hash_01_VER_702f05110733511b7a25a3197dd840bf', 1958 total_mem_alloc => { 1959 data_source_type_id => '1', 1960 hash => 'hash_08_VER_24e7c9debb98e548d8891a247950a923', 1961 }, 1962 additional_pool_alloc => { 1963 data_source_type_id => '1', 1964 hash => 'hash_08_VER_a274a1909518a7c3c8fb7d143f97e55e', 1965 }, 1966 }, 1967 items => [ 1968 { color => '53777A', 1969 hashes => [ 1970 'hash_10_VER_b235fb497a3b734da32b8902bdfd823b', 1971 'hash_10_VER_29de8c74aa79b58262c224607b869551', 1972 'hash_10_VER_31c861c9014aa0ab83311b4398dfbf69', 1973 'hash_10_VER_55d7c8bac42f254e55f882fa014b81bd', 1974 ], 1975 item => 'total_mem_alloc', 1976 task => 'hash_09_VER_28e22b5f2795ade2ebaded0d6b440f92', 1977 type => 'AREA', 1978 }, 1979 { color => 'C02942', 1980 hashes => [ 1981 'hash_10_VER_4c0565a8268db17867eaf80c18b6ff82', 1982 'hash_10_VER_21fc38509908af75117fdc4bc9728b1a', 1983 'hash_10_VER_63937e5acb5247b393c7f25f0db048d6', 1984 'hash_10_VER_03f430c061c1c952c79350380b62ac22', 1985 ], 1986 item => 'additional_pool_alloc', 1987 task => 'hash_09_VER_2feae819090aa43c2fe341470e2a1c65', 1988 type => 'LINE1', 1989 }, 1990 ], 1991 }, 1992 { name => 'InnoDB Adaptive Hash Index', 1993 base_value => '1000', 1994 hash => 'hash_00_VER_02b0400344ac9a89f86095d7f91cfbfb', 1995 dt => { 1996 input => 'Get MySQL Stats', 1997 hash => 'hash_01_VER_34c60491d2ae6360e5c5f68b9bc7e264', 1998 hash_index_cells_total => { 1999 data_source_type_id => '1', 2000 hash => 'hash_08_VER_af73d164be5aa60f8655a5d185230c9a', 2001 }, 2002 hash_index_cells_used => { 2003 data_source_type_id => '1', 2004 hash => 'hash_08_VER_7540de68bbb74c26559d55b797873fa4', 2005 }, 2006 }, 2007 items => [ 2008 { color => '0C4E5D', 2009 hashes => [ 2010 'hash_10_VER_5150fb687ff7dce913f9a5c266d334f8', 2011 'hash_10_VER_b7f6e003a168fe885fc5cfe51316d1ca', 2012 'hash_10_VER_604569890dfcc29d3b919b222e91ceff', 2013 'hash_10_VER_a904dcbec9e75d9619e536405bfea63d', 2014 ], 2015 item => 'hash_index_cells_total', 2016 task => 'hash_09_VER_c6eceb78aa9dcf4bdc74760fe88bb032', 2017 type => 'AREA', 2018 }, 2019 { color => 'D9C7A3', 2020 hashes => [ 2021 'hash_10_VER_e095ab3a1ccabab2f3aab6bb43e05bee', 2022 'hash_10_VER_f5741589db6d478ecb1e8303fdffdff8', 2023 'hash_10_VER_d7fa02e162fd9d66ce6e490909018190', 2024 'hash_10_VER_d4d48ab8e82a1e2eb402da0cf4f8b711', 2025 ], 2026 item => 'hash_index_cells_used', 2027 task => 'hash_09_VER_396c61c1e39e7593b3a285f6f57bc3c2', 2028 type => 'AREA', 2029 }, 2030 ], 2031 }, 2032 { name => 'InnoDB Internal Hash Memory Usage', 2033 base_value => '1024', 2034 hash => 'hash_00_VER_1a21804cda04d082ee6a3e42e6901552', 2035 dt => { 2036 input => 'Get MySQL Stats', 2037 hash => 'hash_01_VER_0e1e424aab246d390ac689c2c0f5524a', 2038 adaptive_hash_memory => { 2039 data_source_type_id => '1', 2040 hash => 'hash_08_VER_ce8f9b38caba7563257a268cc2df1e47', 2041 }, 2042 page_hash_memory => { 2043 data_source_type_id => '1', 2044 hash => 'hash_08_VER_75070c34d0f662fed638fd9650e408ab', 2045 }, 2046 dictionary_cache_memory => { 2047 data_source_type_id => '1', 2048 hash => 'hash_08_VER_7a18fc1e7a9b1459f0049e70916c4d68', 2049 }, 2050 file_system_memory => { 2051 data_source_type_id => '1', 2052 hash => 'hash_08_VER_f418a322cd3f9c659063eec766957242', 2053 }, 2054 lock_system_memory => { 2055 data_source_type_id => '1', 2056 hash => 'hash_08_VER_9d6e44cd2e7c1fc4ff74a789c07ea5e8', 2057 }, 2058 recovery_system_memory => { 2059 data_source_type_id => '1', 2060 hash => 'hash_08_VER_ebef3ce05107e636e1ba7ef06aa89224', 2061 }, 2062 thread_hash_memory => { 2063 data_source_type_id => '1', 2064 hash => 'hash_08_VER_c3a585488226ffc51dc41059909e474c', 2065 }, 2066 }, 2067 items => [ 2068 { color => '793A57', 2069 hashes => [ 2070 'hash_10_VER_d31c7e26a724c41b9353a378284de56e', 2071 'hash_10_VER_51427f33667849783485b7bf120690d4', 2072 'hash_10_VER_c4861fdf9ceb2f49dfbd4c72dbf8351f', 2073 'hash_10_VER_e0d174344f94638ee20525364c70975f', 2074 ], 2075 item => 'adaptive_hash_memory', 2076 task => 'hash_09_VER_cf2c60f46ab8da891254cf883003be1a', 2077 type => 'AREA', 2078 }, 2079 { color => '8C873E', 2080 hashes => [ 2081 'hash_10_VER_f99c6a6af4d2d8345870354091ba6ef1', 2082 'hash_10_VER_d829dda77d609ecfeda4c04ff5bb698c', 2083 'hash_10_VER_6a20bf1ab722d36a25281a5441676b31', 2084 'hash_10_VER_9f531be591cf40bdf25eca3634874b85', 2085 ], 2086 item => 'page_hash_memory', 2087 task => 'hash_09_VER_7eb1d7bdc01e8c50f2a19a18dd10ea49', 2088 type => 'STACK', 2089 }, 2090 { color => 'D1C5A5', 2091 hashes => [ 2092 'hash_10_VER_6e2323aaa35a649e611fa7badc5efd5c', 2093 'hash_10_VER_f2bea163ebd66b67a3709f02c93fe923', 2094 'hash_10_VER_c62a4f9581a873a086c17421d12d1e31', 2095 'hash_10_VER_1ad689a2b8c344e958d0aa1a72509c0e', 2096 ], 2097 item => 'dictionary_cache_memory', 2098 task => 'hash_09_VER_e37d6ba5b1f81ce6970acb0be95f5ffd', 2099 type => 'STACK', 2100 }, 2101 { color => '4D3339', 2102 hashes => [ 2103 'hash_10_VER_932619cd0c60041a8182a679c28f282f', 2104 'hash_10_VER_d9f4d7ccabcd7da117ede5e13e32c6cb', 2105 'hash_10_VER_d7ec7cad87cba2dc64774df4c317b1dd', 2106 'hash_10_VER_701c24b70a76e5057d527a637260c476', 2107 ], 2108 item => 'file_system_memory', 2109 task => 'hash_09_VER_037249cb07c97a5324bf5d48b2c88b6a', 2110 type => 'STACK', 2111 }, 2112 { color => 'A38A5F', 2113 hashes => [ 2114 'hash_10_VER_ac9fd6ffb0217ce291b1755f0b0ec6e8', 2115 'hash_10_VER_07a6ded5ae577760e0be369f5a4478cc', 2116 'hash_10_VER_1d04d8cfab630e17ebd22002415520dc', 2117 'hash_10_VER_348a18e12f5ecfa51c7eec625ac29bb2', 2118 ], 2119 item => 'lock_system_memory', 2120 task => 'hash_09_VER_f248f1fd906cca291996246bddbfcaa9', 2121 type => 'STACK', 2122 }, 2123 { color => 'E97F02', 2124 hashes => [ 2125 'hash_10_VER_01635daf329b44f4acc46ca64a3c2f83', 2126 'hash_10_VER_cd43b17517efc5ea763d0e27f0b15f99', 2127 'hash_10_VER_73ea06d7bf8dbb8b3c2b293a9100f59c', 2128 'hash_10_VER_db82c169c0ade793cabe30836eb0645f', 2129 ], 2130 item => 'recovery_system_memory', 2131 task => 'hash_09_VER_2f5aee8b0b382b972511bc22441f8173', 2132 type => 'STACK', 2133 }, 2134 { color => '23B0BA', 2135 hashes => [ 2136 'hash_10_VER_d1bb6b7a905bfe0ed61f8189fe866bc3', 2137 'hash_10_VER_95558ded8baf5c50cc99024da2817eb6', 2138 'hash_10_VER_b3259ee760c7d6c7c28a202bd31eed5c', 2139 'hash_10_VER_eeb84fa744eb65f8e2078a7658e29ba2', 2140 ], 2141 item => 'thread_hash_memory', 2142 task => 'hash_09_VER_4b78eed30d7034117ea5cfde55be7b28', 2143 type => 'STACK', 2144 }, 2145 ], 2146 }, 2147 { name => 'InnoDB Tables In Use', 2148 base_value => '1000', 2149 hash => 'hash_00_VER_fa44b590108e8e5be45b0032affbd127', 2150 dt => { 2151 input => 'Get MySQL Stats', 2152 hash => 'hash_01_VER_1f5baad834742b7e35ccde8bf94a017d', 2153 innodb_tables_in_use => { 2154 data_source_type_id => '1', 2155 hash => 'hash_08_VER_9aef8ac73b931f2667d1ba21018b156e', 2156 }, 2157 innodb_locked_tables => { 2158 data_source_type_id => '1', 2159 hash => 'hash_08_VER_fcda4c9471d50e702ee7e613e9f5bbbc', 2160 }, 2161 }, 2162 items => [ 2163 { color => 'D99362', 2164 hashes => [ 2165 'hash_10_VER_d10ad18a0a5548817430ca0f39881d0b', 2166 'hash_10_VER_67e7f1188608e9e7b5d73926caac50e0', 2167 'hash_10_VER_522fb5fbf1be97ff28ac65d6675f7a5c', 2168 'hash_10_VER_e042a60fe3a5d663a324dfb3b589e325', 2169 ], 2170 item => 'innodb_tables_in_use', 2171 task => 'hash_09_VER_468122292be1cfd0fc26307953b2ac57', 2172 type => 'AREA', 2173 }, 2174 { color => '663344', 2175 hashes => [ 2176 'hash_10_VER_3c552300a4817b7e479d7add8202830a', 2177 'hash_10_VER_22799eee7d56cce62fe31d7de536741d', 2178 'hash_10_VER_b3aebe60ad13347f8848d83a9eb53742', 2179 'hash_10_VER_dcf87c57b4ddec28ee3f16089b74993c', 2180 ], 2181 item => 'innodb_locked_tables', 2182 task => 'hash_09_VER_73b5c9071009f7a8466beb2829257b7e', 2183 type => 'LINE1', 2184 }, 2185 ], 2186 }, 2187 { name => 'InnoDB Current Lock Waits', 2188 base_value => '1000', 2189 hash => 'hash_00_VER_e9273e40f1e713303682668dc654f143', 2190 dt => { 2191 input => 'Get MySQL Stats', 2192 hash => 'hash_01_VER_426e9d4cd77440b7a1a981ba98abea4e', 2193 innodb_lock_wait_secs => { 2194 data_source_type_id => '1', 2195 hash => 'hash_08_VER_f1744276d2e74b52830165c49b54618c', 2196 }, 2197 }, 2198 items => [ 2199 { color => '201A33', 2200 hashes => [ 2201 'hash_10_VER_44a5e04dd3e04f5d9378cd748a35dd79', 2202 'hash_10_VER_d6181c515d6cc04de8d993671c58952a', 2203 'hash_10_VER_1edc473d4581ca63a6016ee877f18b56', 2204 'hash_10_VER_6e8e0ea8e1bca207eda7d5c06398a0b0', 2205 ], 2206 item => 'innodb_lock_wait_secs', 2207 task => 'hash_09_VER_96c96847d6061283484aa28da332256e', 2208 type => 'LINE1', 2209 }, 2210 ], 2211 }, 2212 { name => 'InnoDB Lock Structures', 2213 base_value => '1000', 2214 hash => 'hash_00_VER_105fdb1beff2a3e8097837c6633feb8f', 2215 dt => { 2216 input => 'Get MySQL Stats', 2217 hash => 'hash_01_VER_79df6175ecab8b8b34c6eeb2885b5a38', 2218 innodb_lock_structs => { 2219 data_source_type_id => '1', 2220 hash => 'hash_08_VER_9a067f29dd948c909b3efa12cabd9ef8', 2221 }, 2222 }, 2223 items => [ 2224 { color => '0C4E5D', 2225 hashes => [ 2226 'hash_10_VER_26dfda88b3c8dc15d83e552191dcd378', 2227 'hash_10_VER_6876a981e759fca71acb125ed3d3a579', 2228 'hash_10_VER_f8b753cfff01918286f1ff5325070841', 2229 'hash_10_VER_f353178cef97cacb700e3d158aa60b86', 2230 ], 2231 item => 'innodb_lock_structs', 2232 task => 'hash_09_VER_0c2fa57d68c3fbe855e98baaabee642d', 2233 type => 'LINE1', 2234 }, 2235 ], 2236 }, 2237 { name => 'InnoDB Checkpoint Age', 2238 base_value => '1024', 2239 hash => 'hash_00_VER_9adba8ca8bd85eaff7c6a9264006e506', 2240 dt => { 2241 input => 'Get MySQL Stats', 2242 hash => 'hash_01_VER_287b4780090438797b4a78a38d044875', 2243 uncheckpointed_bytes => { 2244 data_source_type_id => '1', 2245 hash => 'hash_08_VER_c1feb24905641e7888b5b22a3d503b03', 2246 }, 2247 }, 2248 items => [ 2249 { color => '661100', 2250 hashes => [ 2251 'hash_10_VER_442eaef32ea745fd8603aa9a5ef80295', 2252 'hash_10_VER_8a0ff14d3bc4d6fad766e3e17c30d812', 2253 'hash_10_VER_b0af011746371356f90799a50336807d', 2254 'hash_10_VER_ee2efd28835e9e95d2e0386643769991', 2255 ], 2256 item => 'uncheckpointed_bytes', 2257 task => 'hash_09_VER_e5e6512d8f8f1f810719f7ad298be14f', 2258 type => 'LINE1', 2259 }, 2260 ], 2261 }, 2262 { name => 'InnoDB Row Lock Time', 2263 base_value => '1000', 2264 hash => 'hash_00_VER_ca2b810bbf215753e04c1a14929033a9', 2265 dt => { 2266 input => 'Get MySQL Stats', 2267 hash => 'hash_01_VER_e9e1ed39d2e0a821682503c6871c2955', 2268 Innodb_row_lock_time => { 2269 data_source_type_id => '3', 2270 hash => 'hash_08_VER_70c91dbd06454075c08b72a025be7eb7', 2271 }, 2272 }, 2273 items => [ 2274 { item => 'Innodb_row_lock_time', 2275 color => 'B11D03', 2276 type => 'AREA', 2277 hashes => [ 2278 'hash_10_VER_3f2e6f7a9a769236a9cf324a076aa362', 2279 'hash_10_VER_510a5f3b1584940506b9e04c882470f0', 2280 'hash_10_VER_a882d7cac776d2a73913140d07e24b9a', 2281 'hash_10_VER_c030f59dac8c01aadc5d875930c5b92e', 2282 ], 2283 task => 'hash_09_VER_b3a1710a00fb372febf2c26e56510dcd', 2284 }, 2285 ], 2286 }, 2287 { name => 'InnoDB Row Lock Waits', 2288 base_value => '1000', 2289 hash => 'hash_00_VER_366415f1a0d369e1abfed3e5623dc351', 2290 dt => { 2291 input => 'Get MySQL Stats', 2292 hash => 'hash_01_VER_b1021a92a3451fd282ecc6e869d4ab3c', 2293 Innodb_row_lock_waits => { 2294 data_source_type_id => '3', 2295 hash => 'hash_08_VER_90641853bf96784e399a2aa38b51b4d4', 2296 }, 2297 }, 2298 items => [ 2299 { item => 'Innodb_row_lock_waits', 2300 color => 'E84A5F', 2301 type => 'AREA', 2302 hashes => [ 2303 'hash_10_VER_727d424d76d66234fe807a3476de9c4b', 2304 'hash_10_VER_bdf7cbeefd65c04eb3a34d5581e655af', 2305 'hash_10_VER_173303a1ce6b7151fff3473e3ab8bff8', 2306 'hash_10_VER_cfad38c2995f5efd0e190f3e3cccb484', 2307 ], 2308 task => 'hash_09_VER_be4570e97a05172280ed8034f0cd3e8b', 2309 }, 2310 ], 2311 }, 2312 { name => 'InnoDB Semaphore Waits', 2313 base_value => '1000', 2314 hash => 'hash_00_VER_a7aaf344764d1ee9a38ec386711f669a', 2315 dt => { 2316 input => 'Get MySQL Stats', 2317 hash => 'hash_01_VER_ff1beae64d8885b71893d3e79de8ac91', 2318 innodb_sem_waits => { 2319 data_source_type_id => '1', 2320 hash => 'hash_08_VER_4e9a355586f097462616eff0b3a14330', 2321 }, 2322 }, 2323 items => [ 2324 { color => '7020AF', 2325 hashes => [ 2326 'hash_10_VER_18c0d71e0d953e097d4f0f508a86d143', 2327 'hash_10_VER_c4d6758d17576cea4e41df82641d2585', 2328 'hash_10_VER_6c4a0de40b79e93f89a67d7cb87fb8f9', 2329 'hash_10_VER_49bd3bbfe1edeb6b9650829420a924f8', 2330 ], 2331 item => 'innodb_sem_waits', 2332 task => 'hash_09_VER_07dcdb59507ab32a6fd117565417a5fa', 2333 type => 'AREA', 2334 }, 2335 ], 2336 }, 2337 { name => 'InnoDB Semaphore Wait Time', 2338 base_value => '1000', 2339 hash => 'hash_00_VER_ad2ab681cd7ebae7cfd48f021c1b91e7', 2340 dt => { 2341 input => 'Get MySQL Stats', 2342 hash => 'hash_01_VER_061e2e08fd372c668999e43eb68d8bbc', 2343 innodb_sem_wait_time_ms => { 2344 data_source_type_id => '1', 2345 hash => 'hash_08_VER_d53164739f951807429f46be7ce989e5', 2346 }, 2347 }, 2348 items => [ 2349 { color => '708226', 2350 hashes => [ 2351 'hash_10_VER_359adb5a9ba05d61f32524e4c742866e', 2352 'hash_10_VER_b44684a0de487063f4a5becda6f865b1', 2353 'hash_10_VER_73215cbee8031b0fb0abe022773d2eb2', 2354 'hash_10_VER_b676b2a9bf8ff59c5de5eeb3b3463c9b', 2355 ], 2356 item => 'innodb_sem_wait_time_ms', 2357 task => 'hash_09_VER_c6119f5afc4d2ca926985bbd11a57070', 2358 type => 'AREA', 2359 }, 2360 ], 2361 }, 2362 { base_value => '1000', 2363 name => 'MySQL Processlist', 2364 hash => 'hash_00_VER_92f822b723afb21114f3749df1a65dfa', 2365 dt => { 2366 hash => 'hash_01_VER_4b5c83ab7f24f8c327c88a6e4ac1ce60', 2367 input => 'Get MySQL Stats', 2368 State_closing_tables => { 2369 data_source_type_id => '1', 2370 hash => 'hash_08_VER_2a03ebff50f9f379fe418135d7ee4fe5', 2371 }, 2372 State_copying_to_tmp_table => { 2373 data_source_type_id => '1', 2374 hash => 'hash_08_VER_9873eaa4676fc7a1d10e049e641a1c9f', 2375 }, 2376 State_end => { 2377 data_source_type_id => '1', 2378 hash => 'hash_08_VER_555c9a1e0d7366c53050055c9193cdd0', 2379 }, 2380 State_freeing_items => { 2381 data_source_type_id => '1', 2382 hash => 'hash_08_VER_a67422e4cb4ce0b31addb945234625c2', 2383 }, 2384 State_init => { 2385 data_source_type_id => '1', 2386 hash => 'hash_08_VER_eeb6dda26c93d500cc88adcbe7d5ae16', 2387 }, 2388 State_locked => { 2389 data_source_type_id => '1', 2390 hash => 'hash_08_VER_ef1b0792047b7857ad7e9b98bb1d7e93', 2391 }, 2392 State_login => { 2393 data_source_type_id => '1', 2394 hash => 'hash_08_VER_36a6a169a722caf64ddbd89a7323cec6', 2395 }, 2396 State_preparing => { 2397 data_source_type_id => '1', 2398 hash => 'hash_08_VER_2eec45a8efac2a057fbe060a97a44a01', 2399 }, 2400 State_reading_from_net => { 2401 data_source_type_id => '1', 2402 hash => 'hash_08_VER_0791566476b1d40655a27b84964369a9', 2403 }, 2404 State_sending_data => { 2405 data_source_type_id => '1', 2406 hash => 'hash_08_VER_f20a8400d1384dc0fd3b57c8303e51e3', 2407 }, 2408 State_sorting_result => { 2409 data_source_type_id => '1', 2410 hash => 'hash_08_VER_e5d63d270bde739da892627ed427485b', 2411 }, 2412 State_statistics => { 2413 data_source_type_id => '1', 2414 hash => 'hash_08_VER_037f4b7176337e069ab17a9d4cf3ff3c', 2415 }, 2416 State_updating => { 2417 data_source_type_id => '1', 2418 hash => 'hash_08_VER_1067242a70c101506211ea94f345a54c', 2419 }, 2420 State_writing_to_net => { 2421 data_source_type_id => '1', 2422 hash => 'hash_08_VER_e6e6514631517407fb191a38ebb9a54d', 2423 }, 2424 State_none => { 2425 data_source_type_id => '1', 2426 hash => 'hash_08_VER_e98093b5df57b60f2c6fe8be6c64211a', 2427 }, 2428 State_other => { 2429 data_source_type_id => '1', 2430 hash => 'hash_08_VER_fa80cf3275db897f4649f76d017e01cb', 2431 }, 2432 }, 2433 items => [ 2434# 784890 D1642E 907890 784860 487860 783030 906030 306078 B83A04 6E3803 B56414 2435 # 6E645A 521808 194240 146E69 CC7956 CF6436 CF480E 803405 540202 2436 { color => 'DE0056', 2437 hashes => [ 2438 'hash_10_VER_071a5d94c9f210bc89fc7ade424dbb22', 2439 'hash_10_VER_42253ad481bbb9cae54005f8d843b61a', 2440 'hash_10_VER_fbefacceedfbd99e389ec2a2072e1f02', 2441 'hash_10_VER_b5fcf135e3d6ad27219e2923a07959e5', 2442 ], 2443 item => 'State_closing_tables', 2444 task => 'hash_09_VER_2593d88dd37699174f0cd379534e7505', 2445 type => 'AREA', 2446 }, 2447 { color => '784890', 2448 hashes => [ 2449 'hash_10_VER_792bf0158e312506b509312962b53a97', 2450 'hash_10_VER_42eebae764eda85dc5df8e87b53ea43a', 2451 'hash_10_VER_72a9053d75b10f2215062a949f8e4186', 2452 'hash_10_VER_9d9132b6af540b2c142420d2912e6b99', 2453 ], 2454 item => 'State_copying_to_tmp_table', 2455 task => 'hash_09_VER_8c8c2061826cb28dd5500980db52e3be', 2456 type => 'STACK', 2457 }, 2458 { color => 'D1642E', 2459 hashes => [ 2460 'hash_10_VER_02a9c240201b1bbc33dfc64824dbc9f3', 2461 'hash_10_VER_13ad90254f2970ceae3b0481821a3fa6', 2462 'hash_10_VER_4db6d26c30231832b5c11975eeea8196', 2463 'hash_10_VER_050ccb6eef28c19629697021575fe801', 2464 ], 2465 item => 'State_end', 2466 task => 'hash_09_VER_4f4f681922cd6433ee98d16b27c21d91', 2467 type => 'STACK', 2468 }, 2469 { color => '487860', 2470 hashes => [ 2471 'hash_10_VER_5fb54a5812c19b81a496199fc4867799', 2472 'hash_10_VER_1e10f5e6eb83da370c00f85c9e682a21', 2473 'hash_10_VER_2780822e8ce29851048893a1e9077440', 2474 'hash_10_VER_32873c00b6dff5616ee005a2d7249fd8', 2475 ], 2476 item => 'State_freeing_items', 2477 task => 'hash_09_VER_4a60b132ee85330ec38183861dc07b9b', 2478 type => 'STACK', 2479 }, 2480 { color => '907890', 2481 hashes => [ 2482 'hash_10_VER_22f1ff4f9ed793904002ae6c1dac9e57', 2483 'hash_10_VER_c16bb0bfbf4fbf5a578550cbd0ce0ebc', 2484 'hash_10_VER_835c4d6533cfbccd71876031f85a3b65', 2485 'hash_10_VER_dde4033fdfbf0d2eb2cb37d12f89c140', 2486 ], 2487 item => 'State_init', 2488 task => 'hash_09_VER_6d8013762a2ebf0eccd6f9531606d3c3', 2489 type => 'STACK', 2490 }, 2491 { color => 'DE0056', 2492 hashes => [ 2493 'hash_10_VER_f9e50ea99f9fae7e322fd807439f7e78', 2494 'hash_10_VER_7aafefdea99b722ca04bc6104b56c168', 2495 'hash_10_VER_941c34a80a36384a1fc2852034636b37', 2496 'hash_10_VER_1633a37dd00f4a20736c3462f7275959', 2497 ], 2498 item => 'State_locked', 2499 task => 'hash_09_VER_ee33dbad8ead21395624017d45d266b2', 2500 type => 'STACK', 2501 }, 2502 { color => '1693A7', 2503 hashes => [ 2504 'hash_10_VER_bb48336c5b8333a3ab7329ba66687615', 2505 'hash_10_VER_9c8bb65e23f409afd7e4470cd70e0bdc', 2506 'hash_10_VER_376977e7f2a31232b81712f48ec71b25', 2507 'hash_10_VER_2812464e11245d6251b64767514fa2fc', 2508 ], 2509 item => 'State_login', 2510 task => 'hash_09_VER_5f3c642de0b3b57c9a79e41d9b8b23a3', 2511 type => 'STACK', 2512 }, 2513 { color => '783030', 2514 hashes => [ 2515 'hash_10_VER_9e6cd95cd545e4b5923078d81cf503b1', 2516 'hash_10_VER_1d816f92f071e1213648e359664b33c8', 2517 'hash_10_VER_affb34977c43ccbd62f21c4f3cd0277a', 2518 'hash_10_VER_1a8d7fbb69c0f6c7456240cbc96cbe57', 2519 ], 2520 item => 'State_preparing', 2521 task => 'hash_09_VER_7e75a83939219e73454424ff7aa6c8a9', 2522 type => 'STACK', 2523 }, 2524 { color => 'FF7F00', 2525 hashes => [ 2526 'hash_10_VER_9863f562c387684477211e9751332522', 2527 'hash_10_VER_be25a35a10a2e75a3e63144393992c6b', 2528 'hash_10_VER_c70d2cb3ea00989132f48a757bc0a9c5', 2529 'hash_10_VER_5d158dcf3f91477c63b2caf7d5c1a7ae', 2530 ], 2531 item => 'State_reading_from_net', 2532 task => 'hash_09_VER_bb98cff358b7e1953b86f94a37fb14a2', 2533 type => 'STACK', 2534 }, 2535 { color => '54382A', 2536 hashes => [ 2537 'hash_10_VER_9e2bb6e808a6b1454d53ed4ea6d125fc', 2538 'hash_10_VER_4f249198d06f5802f32856b8b9d0a6e7', 2539 'hash_10_VER_a4be0de027ec06f2a227ad0724579d63', 2540 'hash_10_VER_94285dee91aaed8eedd57936f9c7583d', 2541 ], 2542 item => 'State_sending_data', 2543 task => 'hash_09_VER_160af8a5e0137bac65f8690794ccb77a', 2544 type => 'STACK', 2545 }, 2546 { color => 'B83A04', 2547 hashes => [ 2548 'hash_10_VER_8794a02f7747ed219ee57e805c116ba8', 2549 'hash_10_VER_68d82026091fbf3eb0ca4c600487f036', 2550 'hash_10_VER_1d9ce488ee0482369a8a39f6139965ea', 2551 'hash_10_VER_8124869cd8d39d201a302060faf190a2', 2552 ], 2553 item => 'State_sorting_result', 2554 task => 'hash_09_VER_9091f4f27efa7bab803e372aa016a1d7', 2555 type => 'STACK', 2556 }, 2557 { color => '6E3803', 2558 hashes => [ 2559 'hash_10_VER_e8c8f4480cd23520ba18d996cd5e1fe3', 2560 'hash_10_VER_383571f54ee493555ce4b8868b9eb28e', 2561 'hash_10_VER_e3250c78ef3ee96ace553e722a634899', 2562 'hash_10_VER_fe394d34223d47bf6078341387c0e922', 2563 ], 2564 item => 'State_statistics', 2565 task => 'hash_09_VER_57a9fb98d75005322d1d1f7804a2159f', 2566 type => 'STACK', 2567 }, 2568 { color => 'B56414', 2569 hashes => [ 2570 'hash_10_VER_25cd6d32db03d451893308bf8b6607fc', 2571 'hash_10_VER_af0567d70f0d89d50ceb18ce0c611daf', 2572 'hash_10_VER_548bf880854df8978a67f047c5ceca0d', 2573 'hash_10_VER_c3fc41c87ce816dc584c2e7b1c64db62', 2574 ], 2575 item => 'State_updating', 2576 task => 'hash_09_VER_ef3388f1ab2690748a415e42ee6ad61c', 2577 type => 'STACK', 2578 }, 2579 { color => '6E645A', 2580 hashes => [ 2581 'hash_10_VER_2c8d51eacb721f743cf6dc766a760695', 2582 'hash_10_VER_6a1e3fdfb0e6f16376081e5d9b045178', 2583 'hash_10_VER_7f38a8b8a558743adf138551c9eea039', 2584 'hash_10_VER_9e1a4760a22b3ccd43a2d3b125366d48', 2585 ], 2586 item => 'State_writing_to_net', 2587 task => 'hash_09_VER_44c093e23d682f4ef2e0558cb2a16d7f', 2588 type => 'STACK', 2589 }, 2590 { color => '521808', 2591 hashes => [ 2592 'hash_10_VER_fefcb5f9079a04c61ed44cc8e713d458', 2593 'hash_10_VER_75e27a36187562a334b9c6e1acc924cf', 2594 'hash_10_VER_7908ca613ed4ef2431f2b7f90cdd8a61', 2595 'hash_10_VER_59c29c0738d4ea1eefad8a21ab7b0820', 2596 ], 2597 item => 'State_none', 2598 task => 'hash_09_VER_d9072b703a748f0ac39265d6570536e4', 2599 type => 'STACK', 2600 }, 2601 { color => '194240', 2602 hashes => [ 2603 'hash_10_VER_730cf658ad8101066e5571b5ed71de73', 2604 'hash_10_VER_917a903cc2943a25983a4b2c8f561337', 2605 'hash_10_VER_54fa0c9fc9c3d0ebb8b01a1a0a8962bb', 2606 'hash_10_VER_107a62ac2c454b1f851a288a329c3b7e', 2607 ], 2608 item => 'State_other', 2609 task => 'hash_09_VER_bc4b35c1f300fbb2319303a394da2608', 2610 type => 'STACK', 2611 }, 2612 ], 2613 }, 2614 { base_value => '1000', 2615 name => 'MySQL Transaction Handler', 2616 hash => 'hash_00_VER_eac4a013a536c06daf1d5210ee4b14c2', 2617 dt => { 2618 hash => 'hash_01_VER_a497f9944bde3dd8decfc64061b8ddcb', 2619 input => 'Get MySQL Stats', 2620 Handler_commit => { 2621 data_source_type_id => '3', 2622 hash => 'hash_08_VER_e49aaeb2764f5e8e5ff15c5827984090', 2623 }, 2624 Handler_rollback => { 2625 data_source_type_id => '3', 2626 hash => 'hash_08_VER_1c95b6ed0ee6fe5fe150865a9766a0a3', 2627 }, 2628 Handler_savepoint => { 2629 data_source_type_id => '3', 2630 hash => 'hash_08_VER_bd472a4caad3aaf17971489dd98d146e', 2631 }, 2632 Handler_savepoint_rollback => { 2633 data_source_type_id => '3', 2634 hash => 'hash_08_VER_0cb8145c779a473ff1c7f8afb44c1824', 2635 }, 2636 }, 2637 items => [ 2638 { color => 'DE0056', 2639 hashes => [ 2640 'hash_10_VER_98505c91f609a8b020bf2d059789b3b7', 2641 'hash_10_VER_6a2a5794e67abb03d9898a8a66722fea', 2642 'hash_10_VER_96e7e505f2a52ceb0227423373a8063f', 2643 'hash_10_VER_1cc06b191eaa191b392eeb53323c35b6', 2644 ], 2645 item => 'Handler_commit', 2646 task => 'hash_09_VER_6f563616f5aaead73e6a15cdefe9f337', 2647 type => 'LINE1', 2648 }, 2649 { color => '784890', 2650 hashes => [ 2651 'hash_10_VER_b685716756b63e333d1949eace7f70ea', 2652 'hash_10_VER_1c8c92ed2eb917bff5438f4c15078dfa', 2653 'hash_10_VER_42598c06533e800fd53be723b47b6d5b', 2654 'hash_10_VER_a9d38eb0ced6e4db7a30b9bbb6c24f06', 2655 ], 2656 item => 'Handler_rollback', 2657 task => 'hash_09_VER_995825c835aa757f00cfab801086c6a8', 2658 type => 'LINE1', 2659 }, 2660 { color => 'D1642E', 2661 hashes => [ 2662 'hash_10_VER_5bf03010e3ac42c28ac02de2f4680870', 2663 'hash_10_VER_9825136839f88f2da94e8d624dc67a8d', 2664 'hash_10_VER_5b1f6c15fadfcfefbb646b9a591a5029', 2665 'hash_10_VER_35b68e1ed02d23c1093b17116f5c9600', 2666 ], 2667 item => 'Handler_savepoint', 2668 task => 'hash_09_VER_ce7bb4f77fbb7e61f5356236b341e47e', 2669 type => 'LINE1', 2670 }, 2671 { color => '487860', 2672 hashes => [ 2673 'hash_10_VER_420abbb9c30789fdfd3388bafb3aa025', 2674 'hash_10_VER_abd2ddb6eeba337040feb70e24586007', 2675 'hash_10_VER_ff9c72e9fb520259e4716a6df4119bc9', 2676 'hash_10_VER_0a8a1ec90dcb13202d0a9581124da57a', 2677 ], 2678 item => 'Handler_savepoint_rollback', 2679 task => 'hash_09_VER_06287c10de71eca5b83d58afcb3ce91d', 2680 type => 'LINE1', 2681 }, 2682 ], 2683 }, 2684 { base_value => '1000', 2685 name => 'MySQL Handlers', 2686 hash => 'hash_00_VER_f038b02a88db774984477d9369636c8a', 2687 dt => { 2688 hash => 'hash_01_VER_1744198aeba5c6af715886d6062110f4', 2689 input => 'Get MySQL Stats', 2690 Handler_write => { 2691 data_source_type_id => '3', 2692 hash => 'hash_08_VER_0d3219d73d18af33e1dd9315143a02c2', 2693 }, 2694 Handler_update => { 2695 data_source_type_id => '3', 2696 hash => 'hash_08_VER_ec8391ec89a8e1f924d650f9fe9dd367', 2697 }, 2698 Handler_delete => { 2699 data_source_type_id => '3', 2700 hash => 'hash_08_VER_92a1ddf3cdbe22322444119ae383254f', 2701 }, 2702 Handler_read_first => { 2703 data_source_type_id => '3', 2704 hash => 'hash_08_VER_4571023a7f6135f89893e69b5273a10f', 2705 }, 2706 Handler_read_key => { 2707 data_source_type_id => '3', 2708 hash => 'hash_08_VER_8ea5ff7095e8aa4af3560c76abe1e18c', 2709 }, 2710 Handler_read_next => { 2711 data_source_type_id => '3', 2712 hash => 'hash_08_VER_8ebb94d74cde5bf8276c1fa6e7391a33', 2713 }, 2714 Handler_read_prev => { 2715 data_source_type_id => '3', 2716 hash => 'hash_08_VER_e3140862ff56052529e34c9243233e0e', 2717 }, 2718 Handler_read_rnd => { 2719 data_source_type_id => '3', 2720 hash => 'hash_08_VER_8d89f6bee2cc4873e3a29d0a69c8f2c9', 2721 }, 2722 Handler_read_rnd_next => { 2723 data_source_type_id => '3', 2724 hash => 'hash_08_VER_61e0a1e6b6f96458bc3f437308a50ef7', 2725 }, 2726 }, 2727 items => [ 2728 { color => '4D4A47', 2729 hashes => [ 2730 'hash_10_VER_a56efbbe29d026f02862bfca809bf590', 2731 'hash_10_VER_333b129b710713ea08607822cbed2038', 2732 'hash_10_VER_18adb81f9b92e701a6712b2409e10173', 2733 'hash_10_VER_b75669a310ca424b58b66fcf47defe0a', 2734 ], 2735 item => 'Handler_write', 2736 task => 'hash_09_VER_c77eb9494dd806f737474340b8537a5f', 2737 type => 'AREA', 2738 }, 2739 { color => 'C79F71', 2740 hashes => [ 2741 'hash_10_VER_99e8c4ac20ef9382cf78d1ffb28fe54d', 2742 'hash_10_VER_996f53689776466699d40ab2781f5e82', 2743 'hash_10_VER_b3929273258422fa2177e6d149b31ab7', 2744 'hash_10_VER_93a6e48d691eff462e8231b30316a8c2', 2745 ], 2746 item => 'Handler_update', 2747 task => 'hash_09_VER_6920f18a96825890cf8a4bc2d54fb41e', 2748 type => 'STACK', 2749 }, 2750 { color => 'BDB8B3', 2751 hashes => [ 2752 'hash_10_VER_9f24f4b567f0a4b2fe129db2e35d15aa', 2753 'hash_10_VER_e2c31117289de032f8c08cc14ec477f8', 2754 'hash_10_VER_e25437c079a454c5271f477fe7ea17e6', 2755 'hash_10_VER_eb8a68723d201d3aec1543199a888956', 2756 ], 2757 item => 'Handler_delete', 2758 task => 'hash_09_VER_552439252e667bb86e141dc15a6d4086', 2759 type => 'STACK', 2760 }, 2761 { color => '8C286E', 2762 hashes => [ 2763 'hash_10_VER_d1d5a2571291994279b7d9f25d0adcb4', 2764 'hash_10_VER_80a47e2fb44870cf631ef6d4de1851c9', 2765 'hash_10_VER_4476dc4103d83887aca2673a247cd08e', 2766 'hash_10_VER_f2cf8af8e7ec95afc7b61a18b47eb540', 2767 ], 2768 item => 'Handler_read_first', 2769 task => 'hash_09_VER_e6cdd3211372b3a9663a178435e5567a', 2770 type => 'STACK', 2771 }, 2772 { color => 'BAB27F', 2773 hashes => [ 2774 'hash_10_VER_a7720b8b3e1acb2bf891dcaa670002b4', 2775 'hash_10_VER_fe520c3c770514eeef8d56b30edb49b4', 2776 'hash_10_VER_1e83f4d79d966e8b166b5198c5f428bf', 2777 'hash_10_VER_34dc1f997d19abdf11736d7afff0c344', 2778 ], 2779 item => 'Handler_read_key', 2780 task => 'hash_09_VER_8907324707af53aef274db82bf4b9d3d', 2781 type => 'STACK', 2782 }, 2783 { color => 'C02942', 2784 hashes => [ 2785 'hash_10_VER_b0b798535b8d75d4a9585945254f2b4b', 2786 'hash_10_VER_2e5c22d4cdcea1c9f30ad32211d3836c', 2787 'hash_10_VER_702f8e111b48c715157ac958658c4b8c', 2788 'hash_10_VER_7c54b76ce9f272518e8a0ee0bfd39b47', 2789 ], 2790 item => 'Handler_read_next', 2791 task => 'hash_09_VER_dded9e8d00f4bdb6435ea5f994a1881d', 2792 type => 'STACK', 2793 }, 2794 { color => 'FA6900', 2795 hashes => [ 2796 'hash_10_VER_5f186d6015dfba3d1106952f4c1bb0ca', 2797 'hash_10_VER_252858053548203416049c303ec097a8', 2798 'hash_10_VER_304e8fb4d95ebea5d589e8ed877d582b', 2799 'hash_10_VER_14841f4538dadbd51e7ac76e942d0321', 2800 ], 2801 item => 'Handler_read_prev', 2802 task => 'hash_09_VER_fa43e5839105807fb6ceedb09f5fff2a', 2803 type => 'STACK', 2804 }, 2805 { color => '5A3D31', 2806 hashes => [ 2807 'hash_10_VER_a987368e5eff28db9cbfe423b5642c0f', 2808 'hash_10_VER_06a1bfbd8f6ba3fd905aa8ab7e938a7b', 2809 'hash_10_VER_e69ecc53865b44b285fc650265f37c03', 2810 'hash_10_VER_e05ff5595224800ec56b61c5f225ee9b', 2811 ], 2812 item => 'Handler_read_rnd', 2813 task => 'hash_09_VER_5ae0d9ae4d9ef991f8e8fdde8ed3ca78', 2814 type => 'STACK', 2815 }, 2816 { color => '69D2E7', 2817 hashes => [ 2818 'hash_10_VER_6d59cc406cd1e7e49c08385942df665f', 2819 'hash_10_VER_faeefb662aaa2e819e2601db4ce53dd2', 2820 'hash_10_VER_39af5daeca97920d8ac6912ec8c62c78', 2821 'hash_10_VER_f67c01dffaa9f72981b9ec0a36c37004', 2822 ], 2823 item => 'Handler_read_rnd_next', 2824 task => 'hash_09_VER_dd9000583e15a2ca9680401a1184ac68', 2825 type => 'STACK', 2826 }, 2827 ], 2828 }, 2829 { base_value => '1000', 2830 name => 'MySQL Query Time Histogram (Count)', 2831 hash => 'hash_00_VER_5018a50a8ea76fc01a06311c13f21c49', 2832 dt => { 2833 hash => 'hash_01_VER_6d146f32149bf7c394da56d798c81df9', 2834 input => 'Get MySQL Stats', 2835 Query_time_count_00 => { 2836 data_source_type_id => '3', 2837 hash => 'hash_08_VER_2c6b74c45ca57e6fb1c2448c7a8e1e0e', 2838 }, 2839 Query_time_count_01 => { 2840 data_source_type_id => '3', 2841 hash => 'hash_08_VER_ea81b2e2a1434593abd13f1cebabd9bb', 2842 }, 2843 Query_time_count_02 => { 2844 data_source_type_id => '3', 2845 hash => 'hash_08_VER_c3ac238e0e31908859ff27b1b35d38e8', 2846 }, 2847 Query_time_count_03 => { 2848 data_source_type_id => '3', 2849 hash => 'hash_08_VER_5f1e743ecfe71fe4bcced2c49afb9f8f', 2850 }, 2851 Query_time_count_04 => { 2852 data_source_type_id => '3', 2853 hash => 'hash_08_VER_626d1f13de98a1f2b616b6917cc4fca0', 2854 }, 2855 Query_time_count_05 => { 2856 data_source_type_id => '3', 2857 hash => 'hash_08_VER_d4e32d48dc7e497ffc774927ce57fd3e', 2858 }, 2859 Query_time_count_06 => { 2860 data_source_type_id => '3', 2861 hash => 'hash_08_VER_df4b8a50ac45f442c5b6a7f0e549d301', 2862 }, 2863 Query_time_count_07 => { 2864 data_source_type_id => '3', 2865 hash => 'hash_08_VER_cccb93798a6fad4da0acc5ea328b8216', 2866 }, 2867 Query_time_count_08 => { 2868 data_source_type_id => '3', 2869 hash => 'hash_08_VER_60d6b22bf946eefe9e6319de951577a3', 2870 }, 2871 Query_time_count_09 => { 2872 data_source_type_id => '3', 2873 hash => 'hash_08_VER_087f91519e29263eb8aa57dbbc02dfd1', 2874 }, 2875 Query_time_count_10 => { 2876 data_source_type_id => '3', 2877 hash => 'hash_08_VER_9ff891175f36e11b6ab03063e31b6f2f', 2878 }, 2879 Query_time_count_11 => { 2880 data_source_type_id => '3', 2881 hash => 'hash_08_VER_07dc92c81602f3197c890d0472b5b2b4', 2882 }, 2883 Query_time_count_12 => { 2884 data_source_type_id => '3', 2885 hash => 'hash_08_VER_6532695bb9e8e0e2e161c631a347077d', 2886 }, 2887 Query_time_count_13 => { 2888 data_source_type_id => '3', 2889 hash => 'hash_08_VER_46d0d3177f106a93a5cc66bc77306d46', 2890 }, 2891 }, 2892 items => [ 2893 { item => 'Query_time_count_00', 2894 color => 'DE0056', 2895 hashes => [ 2896 'hash_10_VER_08c10338a942c47eb5d8061d98f89729', 2897 'hash_10_VER_f52cf6ca1f6ed26dbfac4b7ad4dfbc5a', 2898 'hash_10_VER_9dbf8bf3ea1fa803460975f4c5da5f24', 2899 'hash_10_VER_e683dde882800122c2118a9f743dec95', 2900 'hash_10_VER_5d0981d0c6528379ba4909fed38c652c', 2901 ], 2902 task => 'hash_09_VER_ef2e486e602e10ab8f45ea7c0ae3e140', 2903 type => 'AREA', 2904 }, 2905 { item => 'Query_time_count_01', 2906 color => '784890', 2907 hashes => [ 2908 'hash_10_VER_4b693f09a81ab1db783ab17de3789f26', 2909 'hash_10_VER_c26e712241285a2cf22fd73ebb39d020', 2910 'hash_10_VER_efd33d54976eacc8e0f04636c2185142', 2911 'hash_10_VER_d97e8b46a4ba423207865222e1dfc9bf', 2912 'hash_10_VER_a6e618818edf9b5ee34084f620564ebe', 2913 ], 2914 task => 'hash_09_VER_66d850a77bf2ed407ec8924138ac6cdc', 2915 type => 'STACK', 2916 }, 2917 { item => 'Query_time_count_02', 2918 color => 'D1642E', 2919 hashes => [ 2920 'hash_10_VER_9e785847208c8738d150c9c20ab799a4', 2921 'hash_10_VER_4cabdffca2bc82a688911d369883a78a', 2922 'hash_10_VER_6521db9ce70360fafb032dbeadd69774', 2923 'hash_10_VER_7152e2a2db4a5dfe0aff0e5f19c1410d', 2924 'hash_10_VER_366bf607ef34d4a72606bd4bac52fbf2', 2925 ], 2926 task => 'hash_09_VER_049684f4e2f53323c6c9e1a00336a023', 2927 type => 'STACK', 2928 }, 2929 { item => 'Query_time_count_03', 2930 color => '487860', 2931 hashes => [ 2932 'hash_10_VER_62c4840df6b20c9bb01665a26642ec68', 2933 'hash_10_VER_2924e8784904f6b5589685cfceaa610d', 2934 'hash_10_VER_ab7480fa463217e43aca45bb971f926e', 2935 'hash_10_VER_fe0febf8c7788002fc7fbb732b95d13e', 2936 'hash_10_VER_33a9d7c5a761bca9c3ff7eb6f78eb4e4', 2937 ], 2938 task => 'hash_09_VER_6045fa65ad84b40c528bdb9a2e1294b4', 2939 type => 'STACK', 2940 }, 2941 { item => 'Query_time_count_04', 2942 color => '907890', 2943 hashes => [ 2944 'hash_10_VER_345a48dacb7cc1a6ca65fdc1cf9550fa', 2945 'hash_10_VER_2eb28eda894a2e0563b535baf5c55c0e', 2946 'hash_10_VER_04393d034850669377a7a8648eba0b72', 2947 'hash_10_VER_0b2f05ad0d8fbbe04886a5503c8c1307', 2948 'hash_10_VER_f2c1e091ca84baf054e5944f6a6fa2fe', 2949 ], 2950 task => 'hash_09_VER_f8b0b7d51f51a5157f6f024b13c0b231', 2951 type => 'STACK', 2952 }, 2953 { item => 'Query_time_count_05', 2954 color => 'DE0056', 2955 hashes => [ 2956 'hash_10_VER_04a95cdbf902b5fc977eb122b33e99b1', 2957 'hash_10_VER_843ac8ffe0fcba8a34d07e8cbac867a8', 2958 'hash_10_VER_16d27f325b51f989281f3a4189f60b82', 2959 'hash_10_VER_ed0fa015ed32e13de13a589f3d3f2960', 2960 'hash_10_VER_6408b0165000992280538aa93a78f3f0', 2961 ], 2962 task => 'hash_09_VER_661d2fffdcdb28ac8b644049ba6aae93', 2963 type => 'STACK', 2964 }, 2965 { item => 'Query_time_count_06', 2966 color => '1693A7', 2967 hashes => [ 2968 'hash_10_VER_57c53baab6f0f75e59f0492b7b914ca8', 2969 'hash_10_VER_df699c9622780c8b33510bac3e4e55da', 2970 'hash_10_VER_dd648b011a8f158f92c08d6d4ee5570c', 2971 'hash_10_VER_31863aa8b141a94cfc34cf2ea3e09ebe', 2972 'hash_10_VER_5d52fd9ab2cea7e63b38fda279d76b7d', 2973 ], 2974 task => 'hash_09_VER_f64439f6e71817759567278a4ba40a98', 2975 type => 'STACK', 2976 }, 2977 { item => 'Query_time_count_07', 2978 color => '783030', 2979 hashes => [ 2980 'hash_10_VER_5e94c82b137828def8daef5a4199e072', 2981 'hash_10_VER_b681bd2e23fb54cdb32baec84dfcf128', 2982 'hash_10_VER_0f56ee1e90b63609d58f939aa43fcd6b', 2983 'hash_10_VER_15fd8728f91049dc79f639db7d311c36', 2984 'hash_10_VER_feb4e695c759de471fce8ada5f4681ee', 2985 ], 2986 task => 'hash_09_VER_089b5798264efd31afa9f400bd1ae1d6', 2987 type => 'STACK', 2988 }, 2989 { item => 'Query_time_count_08', 2990 color => 'FF7F00', 2991 hashes => [ 2992 'hash_10_VER_c5a2d216430ec1f09c65613af56efa35', 2993 'hash_10_VER_69cc8cb6981c01a55dbeb808ac8945c0', 2994 'hash_10_VER_190770cf3101e3c57ad8931d5ce2cfd8', 2995 'hash_10_VER_cf1fa0ae56fbd81e550b035bcde7d847', 2996 'hash_10_VER_d3e081a61f7810c6a088af805a78ade0', 2997 ], 2998 task => 'hash_09_VER_373ca98db6fcb659aab63393bdc8e961', 2999 type => 'STACK', 3000 }, 3001 { item => 'Query_time_count_09', 3002 color => '54382A', 3003 hashes => [ 3004 'hash_10_VER_aa66dffd2932c3bd553e089638d6083d', 3005 'hash_10_VER_d92523843f91425e89929eea018f8d10', 3006 'hash_10_VER_4c9cfcc3fb8388158f3dab4fdd7e7603', 3007 'hash_10_VER_ad38f1e9bb8ed809d77bc70bbf6c2226', 3008 'hash_10_VER_fbac3ece36f63d9baa1dd24fa35711be', 3009 ], 3010 task => 'hash_09_VER_e465397db63a8600e8aadbe69c8cae6b', 3011 type => 'STACK', 3012 }, 3013 { item => 'Query_time_count_10', 3014 color => 'B83A04', 3015 hashes => [ 3016 'hash_10_VER_f80f931d32592fb52c8540ec35fe4033', 3017 'hash_10_VER_748227f6c32d810e66e17c93b09f23b7', 3018 'hash_10_VER_e950775b39dab441e347c0ce89946d57', 3019 'hash_10_VER_95eef605153a2d5c99a1690711140eb0', 3020 'hash_10_VER_27fdc023a94306b75720021a69eba423', 3021 ], 3022 task => 'hash_09_VER_b821b3c930e5f473e64bfd25e2916aae', 3023 type => 'STACK', 3024 }, 3025 { item => 'Query_time_count_11', 3026 color => '6E3803', 3027 hashes => [ 3028 'hash_10_VER_5017a55ae7fb1cced36916a9361941da', 3029 'hash_10_VER_cdb84bac943b2c9170eef588346d8075', 3030 'hash_10_VER_14695d26f2801042fd6462b590e539b7', 3031 'hash_10_VER_ee094474bf06bee4d907157f3864c88c', 3032 'hash_10_VER_5d4f0cf98ae0d9db8f70de927148f468', 3033 ], 3034 task => 'hash_09_VER_df219db2e32afb8c07c7fe85d2bd072b', 3035 type => 'STACK', 3036 }, 3037 { item => 'Query_time_count_12', 3038 color => 'B56414', 3039 hashes => [ 3040 'hash_10_VER_ebd2e2ef8df079f10ac6dc757bda4b3d', 3041 'hash_10_VER_219b5f095258b79b7d95bc56304e9066', 3042 'hash_10_VER_999392ab047be4eb9f6e90b353ce67cb', 3043 'hash_10_VER_c23afd50d436aef4ff79ccd164d431c7', 3044 'hash_10_VER_d606c6c732905a5b973d7bb20481bb2e', 3045 ], 3046 task => 'hash_09_VER_ebd17bdec743effb94aaded4c85c060d', 3047 type => 'STACK', 3048 }, 3049 { item => 'Query_time_count_13', 3050 color => '6E645A', 3051 hashes => [ 3052 'hash_10_VER_771f79379aedbb487ae905ac0413ce0b', 3053 'hash_10_VER_a3cbcaf44a5c29a027703c2855544de0', 3054 'hash_10_VER_54cbe6ba1a056431e26bb3832f23aa7d', 3055 'hash_10_VER_0438a386e5e83580f913aa8e75f64758', 3056 'hash_10_VER_0acf541af361f6e37e650c28e6840371', 3057 ], 3058 task => 'hash_09_VER_51cc45d3cdfaea3fe029df3f390065de', 3059 type => 'STACK', 3060 }, 3061 ], 3062 }, 3063 { base_value => '1000', 3064 name => 'MySQL Query Response Time (Microseconds)', 3065 hash => 'hash_00_VER_82ab1f42b923b53de1f47cfb28df8325', 3066 dt => { 3067 hash => 'hash_01_VER_eef7730aa743c8f0f65c2412ed502b8d', 3068 input => 'Get MySQL Stats', 3069 Query_time_total_00 => { 3070 data_source_type_id => '3', 3071 hash => 'hash_08_VER_4d93f0aefa6bc07f3912c83e0436a086', 3072 }, 3073 Query_time_total_01 => { 3074 data_source_type_id => '3', 3075 hash => 'hash_08_VER_b4c13348952d8d8bec0d4ebdf9f0a01e', 3076 }, 3077 Query_time_total_02 => { 3078 data_source_type_id => '3', 3079 hash => 'hash_08_VER_4a4b901622c2d400667d467ff85beab2', 3080 }, 3081 Query_time_total_03 => { 3082 data_source_type_id => '3', 3083 hash => 'hash_08_VER_ef4a787140a7c2f0416bfc596ea204c7', 3084 }, 3085 Query_time_total_04 => { 3086 data_source_type_id => '3', 3087 hash => 'hash_08_VER_01124222e61788878f0234a7358b470d', 3088 }, 3089 Query_time_total_05 => { 3090 data_source_type_id => '3', 3091 hash => 'hash_08_VER_6c87fae7265f7fcc73316d1a67bddf8b', 3092 }, 3093 Query_time_total_06 => { 3094 data_source_type_id => '3', 3095 hash => 'hash_08_VER_1aae7dae1ad9ca9ee990b4003034843a', 3096 }, 3097 Query_time_total_07 => { 3098 data_source_type_id => '3', 3099 hash => 'hash_08_VER_c3692126dcaffddb654b2a4dde65af13', 3100 }, 3101 Query_time_total_08 => { 3102 data_source_type_id => '3', 3103 hash => 'hash_08_VER_885db284ece91f42d77353fcab7c72ab', 3104 }, 3105 Query_time_total_09 => { 3106 data_source_type_id => '3', 3107 hash => 'hash_08_VER_2d2298fdf44b081f8e539af562708e40', 3108 }, 3109 Query_time_total_10 => { 3110 data_source_type_id => '3', 3111 hash => 'hash_08_VER_b1218e8bb32068074943c359a034c76c', 3112 }, 3113 Query_time_total_11 => { 3114 data_source_type_id => '3', 3115 hash => 'hash_08_VER_fda6b59537a39179c485955560fdd2b8', 3116 }, 3117 Query_time_total_12 => { 3118 data_source_type_id => '3', 3119 hash => 'hash_08_VER_83a8d8aca375fd4e1ae391a79a0a87b2', 3120 }, 3121 Query_time_total_13 => { 3122 data_source_type_id => '3', 3123 hash => 'hash_08_VER_b4640cdc8506c3204fe220ac5f2e48b3', 3124 }, 3125 }, 3126 items => [ 3127 { item => 'Query_time_total_00', 3128 color => 'DE0056', 3129 hashes => [ 3130 'hash_10_VER_e1d2019589af76c53450ab4f9e171be7', 3131 'hash_10_VER_efbb16cf094e50101d1993b89bbe67ad', 3132 'hash_10_VER_f168475a43854da77b135fc5f3d2df45', 3133 'hash_10_VER_6d1aaa24140bfb2394671cc8872ac3e9', 3134 'hash_10_VER_37ea49ebcace4e140e6fdfda2615a942', 3135 ], 3136 task => 'hash_09_VER_99aa486f91709bc20cf1c1050018db48', 3137 type => 'AREA', 3138 }, 3139 { item => 'Query_time_total_01', 3140 color => '784890', 3141 hashes => [ 3142 'hash_10_VER_e2a85644503c7fec6975039841d97599', 3143 'hash_10_VER_e27d1c3ef2fbd75712806cfa094f67b7', 3144 'hash_10_VER_4a0c8006b77be53170e372aebd2a7be7', 3145 'hash_10_VER_142d619cc8906561a22e6731906e1ca8', 3146 'hash_10_VER_2e3da103f231035fc142fefacf4df953', 3147 ], 3148 task => 'hash_09_VER_4be2a3660afc95af68d8a1c83d9e1cc5', 3149 type => 'STACK', 3150 }, 3151 { item => 'Query_time_total_02', 3152 color => 'D1642E', 3153 hashes => [ 3154 'hash_10_VER_5facfda4f89ede6002c1f76a62dc624e', 3155 'hash_10_VER_45b150955a90d567c8ce8297569f8443', 3156 'hash_10_VER_ed1ce7dc2fc7a6179b7bfff8df26c225', 3157 'hash_10_VER_edf9beec29bd86e55a8165f36e50f642', 3158 'hash_10_VER_e0a3433d0bb05bbe9b932e48dc9f56b2', 3159 ], 3160 task => 'hash_09_VER_9a0644da9d8b728abd7227ded91d1d45', 3161 type => 'STACK', 3162 }, 3163 { item => 'Query_time_total_03', 3164 color => '487860', 3165 hashes => [ 3166 'hash_10_VER_6ae93a14f632c2936c913214abc43d58', 3167 'hash_10_VER_2a0d115b7db025d1b2c32f7229e93654', 3168 'hash_10_VER_55d6915220da6a09e7c4da21a1953762', 3169 'hash_10_VER_492ff15474b7922ccc8cd024486ee562', 3170 'hash_10_VER_8816294fc01f726eec82f16101b6157e', 3171 ], 3172 task => 'hash_09_VER_1fc535b0b5038a548255ac78a8161a26', 3173 type => 'STACK', 3174 }, 3175 { item => 'Query_time_total_04', 3176 color => '907890', 3177 hashes => [ 3178 'hash_10_VER_0a48371a4691be6172fa5c409b38fe8c', 3179 'hash_10_VER_106463f932a67b2fc35f9a36ca23580a', 3180 'hash_10_VER_eb61f46a528669f247c84d44288860f4', 3181 'hash_10_VER_241e0023b6736388df0ab3d6c444993d', 3182 'hash_10_VER_77ef0c17d4811858a0ec0e3db09239f4', 3183 ], 3184 task => 'hash_09_VER_cc56da9fc3c7064621b6af10f00f8cef', 3185 type => 'STACK', 3186 }, 3187 { item => 'Query_time_total_05', 3188 color => 'DE0056', 3189 hashes => [ 3190 'hash_10_VER_5657e012b35fbc79f46cc82b85e9f3c6', 3191 'hash_10_VER_4fb328de7c91f7e1301d666d661b8c18', 3192 'hash_10_VER_a8c8ebea881cc1160b84467ecfdcc3c4', 3193 'hash_10_VER_e19d0c2950098c39c1ff2e6b523fcaa7', 3194 'hash_10_VER_ba336afbf63fe3523fa445e6d866b935', 3195 ], 3196 task => 'hash_09_VER_71cd5f97e18438773169bddb96009af1', 3197 type => 'STACK', 3198 }, 3199 { item => 'Query_time_total_06', 3200 color => '1693A7', 3201 hashes => [ 3202 'hash_10_VER_725c6ba1ffc5bf2f1ec10507b6c66cfe', 3203 'hash_10_VER_1b8d7c1386c46ae29263aa1df4a99866', 3204 'hash_10_VER_2b59a07e15a73e793e235736fd7da322', 3205 'hash_10_VER_2fdbc95247f61d14bc9442f1bc1004a9', 3206 'hash_10_VER_58576524edeb3b8cdc3ca0f9e79d62aa', 3207 ], 3208 task => 'hash_09_VER_722d00fac05125272144bfe6667b7d37', 3209 type => 'STACK', 3210 }, 3211 { item => 'Query_time_total_07', 3212 color => '783030', 3213 hashes => [ 3214 'hash_10_VER_54ee5a3c083d259f8f5dee1ce953be7a', 3215 'hash_10_VER_ef3356ef4ca699e2ff48aaca9bc9388a', 3216 'hash_10_VER_2cecffd7a5f0f0ba3add3ee6c08fee10', 3217 'hash_10_VER_d9917cff306b99aaddee1e4fcb62617d', 3218 'hash_10_VER_0141da3c850d13e871633b521ab65a58', 3219 ], 3220 task => 'hash_09_VER_7d046c351673cb06b08c77e564ae17ec', 3221 type => 'STACK', 3222 }, 3223 { item => 'Query_time_total_08', 3224 color => 'FF7F00', 3225 hashes => [ 3226 'hash_10_VER_1cce50ca8301bf88ba2193b4503bff85', 3227 'hash_10_VER_41e529cd908214ba17227fa7712df770', 3228 'hash_10_VER_ec93a5acc82cfe73ea9658e0990dc9c0', 3229 'hash_10_VER_35a8f35b2596163d53742519066b82a7', 3230 'hash_10_VER_8eba750335a568105ffcc7ef6854079f', 3231 ], 3232 task => 'hash_09_VER_53ff368c219b4a7247e946d039d8ffd8', 3233 type => 'STACK', 3234 }, 3235 { item => 'Query_time_total_09', 3236 color => '54382A', 3237 hashes => [ 3238 'hash_10_VER_f54959e7f1cf6545f0d99ab283543f3b', 3239 'hash_10_VER_73f11005aebe709369dcea268ef59694', 3240 'hash_10_VER_adc2e983d40d41140206bdd83fc51602', 3241 'hash_10_VER_ee8d27530927d2488fcffe9c8de37e43', 3242 'hash_10_VER_641cc473c0ca42be68870a5e6c20faad', 3243 ], 3244 task => 'hash_09_VER_7bf8545736c41717fcb98bd788612807', 3245 type => 'STACK', 3246 }, 3247 { item => 'Query_time_total_10', 3248 color => 'B83A04', 3249 hashes => [ 3250 'hash_10_VER_6a901fe7956543adbcf7b24e1975a15b', 3251 'hash_10_VER_b5aeceb2edb13f110fc25cfd564f48df', 3252 'hash_10_VER_aedd2c00ccf7b5bb6811062d33854976', 3253 'hash_10_VER_2fc712167821cc286587e69cb2c1313f', 3254 'hash_10_VER_5a532ab7b308a5bcfa32d65e7c6c8116', 3255 ], 3256 task => 'hash_09_VER_44e7a4a802976e81180e7668b8b88533', 3257 type => 'STACK', 3258 }, 3259 { item => 'Query_time_total_11', 3260 color => '6E3803', 3261 hashes => [ 3262 'hash_10_VER_aea9e8368be028e1c5b2573ce281cc1a', 3263 'hash_10_VER_e612717b8dcd55412d7c9031382e0a6b', 3264 'hash_10_VER_bf6f16bf2d45e1c35552b1671fa7b95a', 3265 'hash_10_VER_b7708c92e6d2b262eff9983c96a766e2', 3266 'hash_10_VER_93f737d5a504cac6f2a585107b250011', 3267 ], 3268 task => 'hash_09_VER_2219c7a4b8af339e561444131fc0f072', 3269 type => 'STACK', 3270 }, 3271 { item => 'Query_time_total_12', 3272 color => 'B56414', 3273 hashes => [ 3274 'hash_10_VER_56e5c4fd0019766685021e1cff8986b3', 3275 'hash_10_VER_1c0b9d90aa235d05151f95c6304cfbe9', 3276 'hash_10_VER_6e4edb3a607c6cec1883627ee7bee077', 3277 'hash_10_VER_82a3879bb2836967a354cf175452eed3', 3278 'hash_10_VER_396b869defb45151523ef7786572c0b8', 3279 ], 3280 task => 'hash_09_VER_53eb5638f75fac7e0c7db3dd8f301ff2', 3281 type => 'STACK', 3282 }, 3283 { item => 'Query_time_total_13', 3284 color => '6E645A', 3285 hashes => [ 3286 'hash_10_VER_ec8dfa4676e12924b5d8828965c618e6', 3287 'hash_10_VER_8b9cb15559436564f7f3dc6c738cf06f', 3288 'hash_10_VER_0b700548bc01e90ea4f89a00188269ee', 3289 'hash_10_VER_e025ce79a232edd22ef5945dfe99e6ce', 3290 'hash_10_VER_763f563b10716bbe86f824c73395420d', 3291 ], 3292 task => 'hash_09_VER_d423a5a09d88e35096518e480e16f055', 3293 type => 'STACK', 3294 }, 3295 ], 3296 }, 3297 { name => 'InnoDB Buffer Pool Efficiency', 3298 base_value => '1000', 3299 hash => 'hash_00_VER_b4a2ee04d77bd8fc16555289fe38f646', 3300 dt => { 3301 input => 'Get MySQL Stats', 3302 hash => 'hash_01_VER_95b5e55a88a5d21f941f70b930d1251f', 3303 pool_read_requests => { 3304 data_source_type_id => '3', 3305 hash => 'hash_08_VER_7697410ed5c61c07787d1f0a410b4066', 3306 }, 3307 pool_reads => { 3308 data_source_type_id => '3', 3309 hash => 'hash_08_VER_7acdf0f165f21668aa14530479d9fc79', 3310 }, 3311 }, 3312 items => [ 3313 { color => '6EA100', 3314 hashes => [ 3315 'hash_10_VER_eab4958981ab6316d4e71369340a3b82', 3316 'hash_10_VER_b2a3deb5aebe1626f6d0ae80a6df8d94', 3317 'hash_10_VER_fd53819289f90c5604c225e73072c6ac', 3318 'hash_10_VER_cbd52390554edff0b5c80ff9ebf7cbb1', 3319 ], 3320 item => 'pool_read_requests', 3321 task => 'hash_09_VER_97a6ba20380c2661ebfb32a5b0975ee2', 3322 type => 'LINE1', 3323 }, 3324 { color => 'AA3B27', 3325 hashes => [ 3326 'hash_10_VER_325a658eb3078e8df227f74169758625', 3327 'hash_10_VER_bd2f1b82625bb5ceca91ea1638e37191', 3328 'hash_10_VER_14a612f04dbee94b108c295e80032ee9', 3329 'hash_10_VER_85bea1a4c2b53fd3d877eed8d6b6ed03', 3330 ], 3331 item => 'pool_reads', 3332 task => 'hash_09_VER_655c03f0a4fddacac153607dfd51a238', 3333 type => 'LINE1', 3334 }, 3335 ], 3336 }, 3337 ], 3338 inputs => { 3339 'Get MySQL Stats' => { 3340 hash => 'hash_03_VER_436e47b578d778e94d10a552d7d35bdf', 3341 input_string => 3342 '<path_php_binary> -q <path_cacti>/scripts/ss_get_mysql_stats.php --host <hostname> --items <items> --user <username> --pass <password> --port <port> --server-id <serverid>', 3343 inputs => [ 3344 { allow_nulls => '', 3345 hash => 'hash_07_VER_c8cef6437d22aa62790728f605a68d8e', 3346 name => 'hostname', 3347 }, 3348 { allow_nulls => 'on', 3349 hash => 'hash_07_VER_e37f83f54b89afdf523468a914b36de0', 3350 name => 'port', 3351 }, 3352 { allow_nulls => 'on', 3353 hash => 'hash_07_VER_aec8e98c244308171f95390d31604295', 3354 name => 'username', 3355 }, 3356 { allow_nulls => 'on', 3357 hash => 'hash_07_VER_0dde201d3dde810ddb9eeed6b444bf50', 3358 name => 'password', 3359 }, 3360 { allow_nulls => 'on', 3361 hash => 'hash_07_VER_5a1b802ba7e92609f8aa2b0521e221e1', 3362 name => 'serverid' 3363 }, 3364 ], 3365 outputs => { 3366 Aborted_clients => 'hash_07_VER_89a607a1bcd6416e464ad38245fecfd8', 3367 Aborted_connects => 'hash_07_VER_7b2d2030e3ff45ff1b0706db49182176', 3368 Binlog_cache_disk_use => 3369 'hash_07_VER_6b4757e0eb867b042569d5c24018289e', 3370 Binlog_cache_use => 'hash_07_VER_35398509ac7a7268e935dc0d37087846', 3371 Bytes_received => 'hash_07_VER_2c0580a7ad561ab3271b1051c1f633c1', 3372 Bytes_sent => 'hash_07_VER_30d625afb8a7af347051d7e1385b54ff', 3373 Com_delete => 'hash_07_VER_806554bfd63d1cc677261292aae36356', 3374 Com_delete_multi => 'hash_07_VER_05041639bb2909b16d8b33c9ca03e8a3', 3375 Com_insert => 'hash_07_VER_50ead4dcd91a3a5cda313c02dee4e836', 3376 Com_insert_select => 3377 'hash_07_VER_526cfe1b73b4d0c6a6d944de0e725e6e', 3378 Com_load => 'hash_07_VER_c2122e47e509a2c9dbf347a4d8bb65f0', 3379 Com_replace => 'hash_07_VER_8cd99da9bcd790d55368be2c8a311a0d', 3380 Com_replace_select => 3381 'hash_07_VER_11b5fbd2a60694b091ca65f6719cf67f', 3382 Com_select => 'hash_07_VER_3181f9ca4263c3a97c7c2b59adb28c0a', 3383 Com_update => 'hash_07_VER_27f7cecacdf80987bd4874791eca98b7', 3384 Com_update_multi => 'hash_07_VER_5f86603f53f09c7422f4120f26be811f', 3385 Connections => 'hash_07_VER_c194150e0eabd33a2b7b8b3f3fbb6255', 3386 Created_tmp_disk_tables => 3387 'hash_07_VER_e12d5f77152cc161961daee1bbb4c894', 3388 Created_tmp_files => 3389 'hash_07_VER_a6089850ca849b37ab32877039f883d0', 3390 Created_tmp_tables => 3391 'hash_07_VER_744a5188f81220bb3d3a4533866cf98d', 3392 Key_read_requests => 3393 'hash_07_VER_c873497a97aaae34af2a8f1fef0f534a', 3394 Key_reads => 'hash_07_VER_58b10d9d480fdf03da459b81cc5e75de', 3395 Key_write_requests => 3396 'hash_07_VER_10e6f697981d21381d35c7102b377b2e', 3397 Key_writes => 'hash_07_VER_cf294c9afda77038558a5dd2ac4a8845', 3398 Max_used_connections => 3399 'hash_07_VER_3fef877d94b440b7371634975dc62c14', 3400 Open_files => 'hash_07_VER_a6e09170873f1fb277a2b95f6a07459a', 3401 Open_tables => 'hash_07_VER_76e703944ff9dc5e10c61bdc95f0ac53', 3402 Opened_tables => 'hash_07_VER_7717d70bb60fccb0dd5e88c5fddbd351', 3403 Qcache_free_blocks => 3404 'hash_07_VER_0eb392faca757e7cce18b5c65777c074', 3405 Qcache_free_memory => 3406 'hash_07_VER_c69d8c3272c02c53d8200157df4354ce', 3407 Qcache_hits => 'hash_07_VER_e7a87afca2ab8c11c15be58df38e5d54', 3408 Qcache_inserts => 'hash_07_VER_73f0a1e82bbfaedaef8cd94b07f0ada7', 3409 Qcache_lowmem_prunes => 3410 'hash_07_VER_5244b2a498581c2604fab9d91a28cc91', 3411 Qcache_not_cached => 3412 'hash_07_VER_adf93e592ba7a48d8b58525bbe25578e', 3413 Qcache_queries_in_cache => 3414 'hash_07_VER_dcea8beec989a4391ad56aa0189ac85c', 3415 Qcache_total_blocks => 3416 'hash_07_VER_b3780c030d284171833971514b28e8f3', 3417 Questions => 'hash_07_VER_3c8293dbc41f3acebcbc14630d0e292a', 3418 Select_full_join => 'hash_07_VER_3b35f87ec6fe979c96d7935fb47eeee0', 3419 Select_full_range_join => 3420 'hash_07_VER_8a839218205921fd5204bc662dfcd3d6', 3421 Select_range => 'hash_07_VER_3406c5e8831a63676cfb9cfa68e7bd63', 3422 Select_range_check => 3423 'hash_07_VER_c45d99e36babd93d8494e64ae78ad2f4', 3424 Select_scan => 'hash_07_VER_7fac25a17f2792c76c0155493a34a533', 3425 Slave_open_temp_tables => 3426 'hash_07_VER_fc68fcf835e7d80a72b7cac3d3ce9d3c', 3427 Slave_retried_transactions => 3428 'hash_07_VER_07afdb9bf7a4d02034059edab34805ba', 3429 Slow_launch_threads => 3430 'hash_07_VER_528100ebd1ba16c8c5f6468948067f0c', 3431 Slow_queries => 'hash_07_VER_ff37fac4f1f1815c6670aec8c01656a7', 3432 Sort_merge_passes => 3433 'hash_07_VER_021d93dcf35ebad67fb37ceb2f783949', 3434 Sort_range => 'hash_07_VER_8f192fb3db156f6ca3bd6bf86849fa96', 3435 Sort_rows => 'hash_07_VER_984d83ac3b9e4fac2fe1415c47949d5f', 3436 Sort_scan => 'hash_07_VER_712d0795b5b8eedc635c39a3b9477007', 3437 Table_locks_immediate => 3438 'hash_07_VER_b99a1709fa8b9f06246e29961815f07b', 3439 Table_locks_waited => 3440 'hash_07_VER_04ef1b2aa4f91816479df61913e7aea6', 3441 Threads_cached => 'hash_07_VER_ef7ee514647412cd25925cccec177baf', 3442 Threads_connected => 3443 'hash_07_VER_dae83df175b99c3daf528becc132d3e8', 3444 Threads_created => 'hash_07_VER_5e7972ec32f9500b1c3d097d2adf4e37', 3445 Threads_running => 'hash_07_VER_9e3474c954018d0b39e2b4c5edf388a3', 3446 binary_log_space => 'hash_07_VER_d3df1d9eca7bde2db3a0ecba08ded26c', 3447 binlog_cache_size => 3448 'hash_07_VER_ad0e3f74d17d864a50dafb7083284a4c', 3449 current_transactions => 3450 'hash_07_VER_753d51fad343b3995f3621bb7aee421b', 3451 active_transactions => 'hash_07_VER_b2b795b58cfb3af9966f4eb345dca08b', 3452 locked_transactions => 'hash_07_VER_f1934cf547d165f0d3912a2283ef9c65', 3453 database_pages => 'hash_07_VER_25f7437b8ad060e3d87da33e2dadb31f', 3454 file_fsyncs => 'hash_07_VER_30f32be47cec617a2eb2a67caf2f1aa5', 3455 file_reads => 'hash_07_VER_6ac708182319dda5f442d02b6fc5d3f0', 3456 file_writes => 'hash_07_VER_2e33693897dc0e560a0f3d77683c0ad6', 3457 free_pages => 'hash_07_VER_370d924ad1c3c3f96c83364328880c3c', 3458 history_list => 'hash_07_VER_3d822c49393f838f3c5485a8a36b4cf0', 3459 ibuf_inserts => 'hash_07_VER_e1e4016ae780d3764b2959fb79cb26d4', 3460 ibuf_merged => 'hash_07_VER_c48c4d0e1196a08fa1bffa6612132587', 3461 ibuf_merges => 'hash_07_VER_33315d78b6a3a94afc7551789fc206d6', 3462 innodb_log_buffer_size => 3463 'hash_07_VER_f3566adfb1a203172ce396cd86110b99', 3464 innodb_open_files => 3465 'hash_07_VER_e496e5df913a1463607d6dcbbe3b610a', 3466 innodb_transactions => 3467 'hash_07_VER_42522580401a653d5dd41a4687fd93f6', 3468 log_bytes_flushed => 3469 'hash_07_VER_531f7361b43e4caafd0946de82724379', 3470 log_bytes_written => 3471 'hash_07_VER_f6848264f0e07457f87736061cb9c292', 3472 log_writes => 'hash_07_VER_65a2a583eb8e3d112595ed58501d9efa', 3473 max_connections => 'hash_07_VER_0c413107d5d2b19429a5c3839a9005ab', 3474 modified_pages => 'hash_07_VER_3099761f439d0677d76c998e6db892d1', 3475 open_files_limit => 'hash_07_VER_9793e02c347b168715c84fa8ce628c22', 3476 os_waits => 'hash_07_VER_134b7d8127ddb350af706b5cb3f9984d', 3477 pages_created => 'hash_07_VER_96c727b75ad50fb912256959730d4a1f', 3478 pages_read => 'hash_07_VER_4a8b8f0018af79fdc39f92c7a9269f14', 3479 pages_written => 'hash_07_VER_58dd7a41df4d6398c90ade54ae42859e', 3480 pending_aio_log_ios => 3481 'hash_07_VER_5decc07514eb0a7692af2533838589aa', 3482 pending_aio_sync_ios => 3483 'hash_07_VER_aa8ec2f278428c8d2c2e60fbf7797f39', 3484 pending_buf_pool_flushes => 3485 'hash_07_VER_e3d909a3a85a3c4eafa58338d0f400f4', 3486 pending_chkp_writes => 3487 'hash_07_VER_3c4467a68c8d44eea248bb2c82bfad25', 3488 pending_ibuf_aio_reads => 3489 'hash_07_VER_0e7ca5fbc9fb133a39ace3e4ab22357a', 3490 pending_log_flushes => 3491 'hash_07_VER_ab0de3f46c986ffd4582106e7f2e301c', 3492 pending_log_writes => 3493 'hash_07_VER_1e24673c30fb16325314e20542389607', 3494 pending_normal_aio_reads => 3495 'hash_07_VER_cfaa0b83f53d9914ab86c26385e7c551', 3496 pending_normal_aio_writes => 3497 'hash_07_VER_e24594f343a17c4050ee8d65bb4350f5', 3498 pool_size => 'hash_07_VER_03d172bbfc0b859a2a06aae0d5ae190d', 3499 query_cache_size => 'hash_07_VER_640eae511115af930e3e27d757d39179', 3500 read_views => 'hash_07_VER_39346ac5a629c49f526d52fd1f4394d1', 3501 relay_log_space => 'hash_07_VER_a2b35aedd4e4637d3d317e926417f5af', 3502 rows_deleted => 'hash_07_VER_1f8a75e05f1e137785ae2d0b19f009dc', 3503 rows_inserted => 'hash_07_VER_bce4385051a564cae424333909594b1b', 3504 rows_read => 'hash_07_VER_95e9540bb6b0f738b606aa0a2bb9700c', 3505 rows_updated => 'hash_07_VER_9202020ea0b9e9a62b1ed1bba2429835', 3506 slave_lag => 'hash_07_VER_adda99ab98e4b5980fbb84116d959cfe', 3507 slave_running => 'hash_07_VER_5baa98d743a677bd77628cde517cf391', 3508 slave_stopped => 'hash_07_VER_d737b0246251bb075c937a82ed275826', 3509 spin_rounds => 'hash_07_VER_58887d197d97509d2b479e5f1dab95e4', 3510 spin_waits => 'hash_07_VER_6262eb4ad726450c5dac2bf508fbab56', 3511 table_cache => 'hash_07_VER_1fb6119d3d61fc252907abe3fb784eaf', 3512 thread_cache_size => 3513 'hash_07_VER_5adbe9f13c7afd427ae0947fa5d87aae', 3514 unflushed_log => 'hash_07_VER_d07042a0a0e23263de8c8cbe5559f75a', 3515 State_closing_tables => 'hash_07_VER_7e7df679b853f0a577d20bd708c61784', 3516 State_copying_to_tmp_table => 'hash_07_VER_5a184c2b55686097f8d2316053b5b7a7', 3517 State_end => 'hash_07_VER_5e0a14229856f3b2b3ce1e1f2df73faf', 3518 State_freeing_items => 'hash_07_VER_aac83626db23433abc9736c117e7eb84', 3519 State_init => 'hash_07_VER_4b46be8cb72cccd3c282e21b5d3d5621', 3520 State_locked => 'hash_07_VER_41a886707377b12658b4560c61664283', 3521 State_login => 'hash_07_VER_fc652711e17c314b98ea1664830f1cbb', 3522 State_preparing => 'hash_07_VER_8802ca02598be615c3af46701339156c', 3523 State_reading_from_net => 'hash_07_VER_6202eb7a183186c81812d220291f2df0', 3524 State_sending_data => 'hash_07_VER_c98959751945511f71fc71564063ac28', 3525 State_sorting_result => 'hash_07_VER_d604ae518fbe6e9402e8216408c65d53', 3526 State_statistics => 'hash_07_VER_a348e1b4da9dec9dda6ea14c595e6932', 3527 State_updating => 'hash_07_VER_19067de8c3b39d27325c74df6755c8b8', 3528 State_writing_to_net => 'hash_07_VER_9cb9aa3a98f5008e201629730914c3a0', 3529 State_none => 'hash_07_VER_8a3075bd545fbcc0ab77ad4f00e83d00', 3530 State_other => 'hash_07_VER_d6215b36d36a8d23576f7f4e8bf1d8a4', 3531 Handler_commit => 'hash_07_VER_902f133f5f6e948146197c4d22476a37', 3532 Handler_delete => 'hash_07_VER_4721efcdbbc45073f905394807569ed5', 3533 Handler_discover => 'hash_07_VER_2724913d927f723f866b32ac2e336eed', 3534 Handler_prepare => 'hash_07_VER_9355fd9284818955449ad3edc2cd7559', 3535 Handler_read_first => 'hash_07_VER_9bbda44a3706208ba25f53eeedf7b251', 3536 Handler_read_key => 'hash_07_VER_fe62e88fdf842804e3fc128787ca2548', 3537 Handler_read_next => 'hash_07_VER_d10711bdc1be1d7738d0d302662fd0c1', 3538 Handler_read_prev => 'hash_07_VER_0a38952040c98d55083986747a9d8b8e', 3539 Handler_read_rnd => 'hash_07_VER_ee3a431b5eb47eeb455937454862a63c', 3540 Handler_read_rnd_next => 'hash_07_VER_1322906aeb3ca2c2ab2b30970fad9edc', 3541 Handler_rollback => 'hash_07_VER_742a40bc2c218f71dce1a65fddefef38', 3542 Handler_savepoint => 'hash_07_VER_9bda6ae9f2ba76dad792b86f43742710', 3543 Handler_savepoint_rollback => 'hash_07_VER_c428c541808de94e9a34021acd98c4dc', 3544 Handler_update => 'hash_07_VER_6709bbc43bdae23f15219ad1ba98e7ad', 3545 Handler_write => 'hash_07_VER_aaff0fd41d8e214813909c2d0aa54112', 3546 additional_pool_alloc => 'hash_07_VER_c87536ebfdb9158aa224cfb004350d4b', 3547 total_mem_alloc => 'hash_07_VER_dc2833697bee772765b94e627e23544c', 3548 hash_index_cells_total => 'hash_07_VER_0fafe0705b1478b932577da40c2bcef9', 3549 hash_index_cells_used => 'hash_07_VER_f37040307da168dde8970e4298e13a3f', 3550 innodb_lock_structs => 'hash_07_VER_a00fc31cb46de274e6dbb06a433f1ffd', 3551 innodb_lock_wait_secs => 'hash_07_VER_1adeeb3ee2097922ae1435af203faeb9', 3552 innodb_tables_in_use => 'hash_07_VER_a53e15269da77bf04dce7233b60907a6', 3553 innodb_locked_tables => 'hash_07_VER_ac3bdee4ed5d88e1e8c2f049050400b5', 3554 uncheckpointed_bytes => 'hash_07_VER_74793606c4a753706099cf13220d4583', 3555 innodb_sem_waits => 'hash_07_VER_992de8144f80e0a78f09e4cfcad75587', 3556 innodb_sem_wait_time_ms => 'hash_07_VER_ca5ef04dda2447274cb5f3bcd6837900', 3557 ibuf_cell_count => 'hash_07_VER_6913c4bb2c47b73e16c7733c5073e59a', 3558 ibuf_used_cells => 'hash_07_VER_65ac17bbfb330d7ff7bf1010d3152f27', 3559 ibuf_free_cells => 'hash_07_VER_185de6e6db39ec31d473d06a2fb704f3', 3560 adaptive_hash_memory => 'hash_07_VER_a64a6c311cd5b0aa3bc14cb05824277f', 3561 page_hash_memory => 'hash_07_VER_0dae94cc6c7ef58e7e611c96a446454f', 3562 dictionary_cache_memory => 'hash_07_VER_c911c6e188effabe90bc16f71c4d5a79', 3563 file_system_memory => 'hash_07_VER_93faf70a2348ea98e09caf5b6d246a37', 3564 lock_system_memory => 'hash_07_VER_012a63f2f91657122110bd696069a318', 3565 recovery_system_memory => 'hash_07_VER_bd2607bec2469de7d32e1142773c5706', 3566 thread_hash_memory => 'hash_07_VER_29c7ea358a3beba846a7f6d485a9c4a0', 3567 Key_buf_bytes_unflushed => 'hash_07_VER_6365cf19dcd3830e026e7821f4cb9ba2', 3568 Key_buf_bytes_used => 'hash_07_VER_03b1786f4470870aa212970e8589564d', 3569 key_buffer_size => 'hash_07_VER_388c4258973c1304f14bbfb370ee564f', 3570 Innodb_row_lock_waits => 'hash_07_VER_88bcc8053c379a3e11163fb60d0a1909', 3571 Innodb_row_lock_time => 'hash_07_VER_562ced54dfb4efb6bf4800528c8826e9', 3572 Query_time_count_00 => 'hash_07_VER_fc8a92a52f17edf5534cf3e91c234972', 3573 Query_time_count_01 => 'hash_07_VER_a5eab67e66239d308f9720647dd377a7', 3574 Query_time_count_02 => 'hash_07_VER_1c73a6539877d42a7f025292473c3dfd', 3575 Query_time_count_03 => 'hash_07_VER_71ca975a84b8aa045dff58bf3fccf512', 3576 Query_time_count_04 => 'hash_07_VER_29d6eb8762ec06e9b5c2b5ac372136e6', 3577 Query_time_count_05 => 'hash_07_VER_8d74e79bbe81e46384948363d6450c10', 3578 Query_time_count_06 => 'hash_07_VER_51ce0e56e56ccc15ce79d0a5c9b018f0', 3579 Query_time_count_07 => 'hash_07_VER_d8ed8804a2a9b8eeb0d1184f945126fb', 3580 Query_time_count_08 => 'hash_07_VER_71423bc0d46fccaaf25f6e2d6ea818d1', 3581 Query_time_count_09 => 'hash_07_VER_0b5f72f88cab4dbb4b9f230c8156a535', 3582 Query_time_count_10 => 'hash_07_VER_5767398d9719bb0b21409e701f0c0127', 3583 Query_time_count_11 => 'hash_07_VER_828c9dafd59110721b924ecb91712f89', 3584 Query_time_count_12 => 'hash_07_VER_e1c0be6f9145d2f7c6a0021a075be219', 3585 Query_time_count_13 => 'hash_07_VER_f44369cc2b2110534a6e5a9c398c4d4a', 3586 Query_time_total_00 => 'hash_07_VER_1a067b7495fdc7dcf7b74d467891adab', 3587 Query_time_total_01 => 'hash_07_VER_fed1e89e92ad69c5da96b632115b58bd', 3588 Query_time_total_02 => 'hash_07_VER_aa38682f88a1111d5519f10c8d425c43', 3589 Query_time_total_03 => 'hash_07_VER_3018646b6c4cfd4301f155ef06b5c941', 3590 Query_time_total_04 => 'hash_07_VER_f93126864ad7c328fd9eca272eaefdb1', 3591 Query_time_total_05 => 'hash_07_VER_6758fa7987490b910aacbedceb9ffde8', 3592 Query_time_total_06 => 'hash_07_VER_393896b12c4b6a56ab36497784358e89', 3593 Query_time_total_07 => 'hash_07_VER_3be2b2de292103692fa05cda9c666ff5', 3594 Query_time_total_08 => 'hash_07_VER_ce6c891093b1d90ab8c8e33207768d65', 3595 Query_time_total_09 => 'hash_07_VER_c8b8be84c06881a740252c1c7e6db761', 3596 Query_time_total_10 => 'hash_07_VER_f08647bb3c147ad5310dda72f4044a98', 3597 Query_time_total_11 => 'hash_07_VER_f6fad42d83701dd1ef0582724dbb3671', 3598 Query_time_total_12 => 'hash_07_VER_4c6ac6fec8817219a655badc713d4447', 3599 Query_time_total_13 => 'hash_07_VER_a67533f9bbc6b46b44c29083c148a190', 3600 pool_reads => 'hash_07_VER_a5806a736164cfd1600387f11481f3c4', 3601 pool_read_requests => 'hash_07_VER_aeb404311664f9492ca9b171a6881573', 3602 }, 3603 type_id => 1 3604 }, 3605 }, 3606} 3607