******************** Script profiler ******************** Total time: 0.014189 Total SQL time: 0.008906 SQL count: 20 (selects: 20 | executes: 11) Peak memory usage: 4M Memory limit: 128M 1. role.get [CRoleHelper.php:172] Parameters: Array ( [output] => Array ( [0] => roleid [1] => name [2] => type ) [selectRules] => Array ( [0] => ui [1] => ui.default_access [2] => modules [3] => modules.default_access [4] => api.access [5] => api.mode [6] => api [7] => actions [8] => actions.default_access ) [roleids] => 2 ) Result: Array ( [0] => Array ( [roleid] => 2 [name] => Admin role [type] => 2 [rules] => Array ( [ui] => Array ( [0] => Array ( [name] => inventory.hosts [status] => 1 ) [1] => Array ( [name] => inventory.overview [status] => 1 ) [2] => Array ( [name] => monitoring.dashboard [status] => 1 ) [3] => Array ( [name] => monitoring.hosts [status] => 1 ) [4] => Array ( [name] => monitoring.latest_data [status] => 1 ) [5] => Array ( [name] => monitoring.maps [status] => 1 ) [6] => Array ( [name] => monitoring.problems [status] => 1 ) [7] => Array ( [name] => reports.availability_report [status] => 1 ) [8] => Array ( [name] => reports.top_triggers [status] => 1 ) [9] => Array ( [name] => services.services [status] => 1 ) [10] => Array ( [name] => services.sla_report [status] => 1 ) [11] => Array ( [name] => configuration.actions [status] => 1 ) [12] => Array ( [name] => configuration.discovery [status] => 1 ) [13] => Array ( [name] => configuration.host_groups [status] => 1 ) [14] => Array ( [name] => configuration.hosts [status] => 1 ) [15] => Array ( [name] => configuration.maintenance [status] => 1 ) [16] => Array ( [name] => configuration.templates [status] => 1 ) [17] => Array ( [name] => monitoring.discovery [status] => 1 ) [18] => Array ( [name] => reports.notifications [status] => 1 ) [19] => Array ( [name] => reports.scheduled_reports [status] => 1 ) [20] => Array ( [name] => services.actions [status] => 1 ) [21] => Array ( [name] => services.sla [status] => 1 ) ) [ui.default_access] => 1 [modules] => Array ( ) [modules.default_access] => 1 [api.access] => 1 [api.mode] => 0 [api] => Array ( ) [actions] => Array ( [0] => Array ( [name] => edit_dashboards [status] => 1 ) [1] => Array ( [name] => edit_maps [status] => 1 ) [2] => Array ( [name] => acknowledge_problems [status] => 1 ) [3] => Array ( [name] => close_problems [status] => 1 ) [4] => Array ( [name] => change_severity [status] => 1 ) [5] => Array ( [name] => add_problem_comments [status] => 1 ) [6] => Array ( [name] => execute_scripts [status] => 1 ) [7] => Array ( [name] => manage_api_tokens [status] => 1 ) [8] => Array ( [name] => edit_maintenance [status] => 1 ) [9] => Array ( [name] => manage_scheduled_reports [status] => 1 ) [10] => Array ( [name] => manage_sla [status] => 1 ) ) [actions.default_access] => 1 ) ) ) 2. item.get [CControllerWidgetGraphView.php:99] Parameters: Array ( [output] => Array ( [0] => key_ ) [itemids] => 30966 [webitems] => 1 ) Result: Array ( ) 3. item.get [CControllerWidgetGraphView.php:105] Parameters: Array ( [output] => Array ( [0] => itemid [1] => name ) [selectHosts] => Array ( [0] => name ) [hostids] => 10296 [filter] => Array ( [key_] => [value_type] => Array ( [0] => 0 [1] => 3 ) ) [webitems] => 1 ) Result: Array ( [0] => Array ( [itemid] => 92273 [name] => Aborted_clients [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [1] => Array ( [itemid] => 92274 [name] => Aborted_connects [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [2] => Array ( [itemid] => 92275 [name] => Access_denied_errors [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [3] => Array ( [itemid] => 92093 [name] => Auto Increment Increment [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [4] => Array ( [itemid] => 92094 [name] => Auto Increment Offset [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [5] => Array ( [itemid] => 92412 [name] => Backup Cleanup duration [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [6] => Array ( [itemid] => 92413 [name] => Backup Cleanup rc [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [7] => Array ( [itemid] => 92414 [name] => Binlog Backup duration [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [8] => Array ( [itemid] => 92415 [name] => Binlog Backup rc [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [9] => Array ( [itemid] => 92431 [name] => Binlog size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [10] => Array ( [itemid] => 92276 [name] => Binlog Statement Cache Disk Writes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [11] => Array ( [itemid] => 92101 [name] => Binlog Statement Cache Size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [12] => Array ( [itemid] => 92277 [name] => Binlog Statement Cache Writes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [13] => Array ( [itemid] => 92102 [name] => Binlog Transaction Cache Size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [14] => Array ( [itemid] => 92278 [name] => Binlog Trx Cache Disk Writes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [15] => Array ( [itemid] => 92279 [name] => Binlog Trx Cache Writes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [16] => Array ( [itemid] => 92280 [name] => Binlog_bytes_written [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [17] => Array ( [itemid] => 92224 [name] => block_io_delays [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [18] => Array ( [itemid] => 92281 [name] => Bytes_received [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [19] => Array ( [itemid] => 92282 [name] => Bytes_sent [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [20] => Array ( [itemid] => 92225 [name] => Check process [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [21] => Array ( [itemid] => 92226 [name] => children_guest_time [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [22] => Array ( [itemid] => 92227 [name] => children_major_faults [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [23] => Array ( [itemid] => 92228 [name] => children_minor_faults [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [24] => Array ( [itemid] => 92229 [name] => children_system_time [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [25] => Array ( [itemid] => 92230 [name] => children_user_time [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [26] => Array ( [itemid] => 92284 [name] => Com call procedure [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [27] => Array ( [itemid] => 92285 [name] => Com change db [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [28] => Array ( [itemid] => 92286 [name] => Com delete [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [29] => Array ( [itemid] => 92287 [name] => Com delete multi [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [30] => Array ( [itemid] => 92288 [name] => Com insert [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [31] => Array ( [itemid] => 92289 [name] => Com insert select [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [32] => Array ( [itemid] => 92290 [name] => Com replace [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [33] => Array ( [itemid] => 92291 [name] => Com replace select [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [34] => Array ( [itemid] => 92292 [name] => Com select [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [35] => Array ( [itemid] => 92293 [name] => Com update [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [36] => Array ( [itemid] => 92294 [name] => Com update multi [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [37] => Array ( [itemid] => 92416 [name] => Config Backup duration [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [38] => Array ( [itemid] => 92417 [name] => Config Backup rc [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [39] => Array ( [itemid] => 92295 [name] => Connections [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [40] => Array ( [itemid] => 92436 [name] => Connections of User mysql [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [41] => Array ( [itemid] => 92437 [name] => Connections of User root [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [42] => Array ( [itemid] => 92296 [name] => Created_tmp_disk_tables [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [43] => Array ( [itemid] => 92297 [name] => Created_tmp_files [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [44] => Array ( [itemid] => 92298 [name] => Created_tmp_tables [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [45] => Array ( [itemid] => 92103 [name] => Expire Logs days [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [46] => Array ( [itemid] => 92231 [name] => FD Size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [47] => Array ( [itemid] => 92254 [name] => Flush time [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [48] => Array ( [itemid] => 92418 [name] => Full Logical Backup duration [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [49] => Array ( [itemid] => 92419 [name] => Full Logical Backup rc [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [50] => Array ( [itemid] => 92420 [name] => Full Logical Backup Size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [51] => Array ( [itemid] => 92421 [name] => Full Physical Backup duration [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [52] => Array ( [itemid] => 92422 [name] => Full Physical Backup rc [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [53] => Array ( [itemid] => 92423 [name] => Full Physical Backup Size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [54] => Array ( [itemid] => 92232 [name] => guest_time [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [55] => Array ( [itemid] => 92305 [name] => Handler delete [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [56] => Array ( [itemid] => 92306 [name] => Handler read first [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [57] => Array ( [itemid] => 92307 [name] => Handler read key [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [58] => Array ( [itemid] => 92308 [name] => Handler read last [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [59] => Array ( [itemid] => 92309 [name] => Handler read next [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [60] => Array ( [itemid] => 92310 [name] => Handler read prev [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [61] => Array ( [itemid] => 92311 [name] => Handler read rnd [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [62] => Array ( [itemid] => 92312 [name] => Handler read rnd next [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [63] => Array ( [itemid] => 92313 [name] => Handler update [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [64] => Array ( [itemid] => 92314 [name] => Handler write [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [65] => Array ( [itemid] => 92125 [name] => InnoDB Adaptive Hash Index searches [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [66] => Array ( [itemid] => 92126 [name] => InnoDB Buffer Pool Bytes Data [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [67] => Array ( [itemid] => 92127 [name] => InnoDB Buffer Pool Bytes Dirty [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [68] => Array ( [itemid] => 92128 [name] => InnoDB Buffer Pool Bytes Free [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [69] => Array ( [itemid] => 92129 [name] => InnoDB Buffer Pool Bytes Misc [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [70] => Array ( [itemid] => 92130 [name] => InnoDB Buffer Pool Bytes Total [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [71] => Array ( [itemid] => 92131 [name] => InnoDB Buffer Pool Hit Ratio [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [72] => Array ( [itemid] => 92132 [name] => InnoDB Buffer Pool Instances [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [73] => Array ( [itemid] => 92133 [name] => InnoDB Buffer Pool max dirty Bytes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [74] => Array ( [itemid] => 92134 [name] => InnoDB Buffer Pool max dirty Pages [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [75] => Array ( [itemid] => 92135 [name] => InnoDB Buffer Pool Pages Data [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [76] => Array ( [itemid] => 92136 [name] => InnoDB Buffer Pool Pages Dirty [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [77] => Array ( [itemid] => 92137 [name] => InnoDB Buffer Pool Pages flushed [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [78] => Array ( [itemid] => 92138 [name] => InnoDB Buffer Pool Pages Free [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [79] => Array ( [itemid] => 92139 [name] => InnoDB Buffer Pool Pages Misc [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [80] => Array ( [itemid] => 92140 [name] => InnoDB Buffer Pool Pages Total [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [81] => Array ( [itemid] => 92141 [name] => InnoDB Buffer Pool Read Requests [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [82] => Array ( [itemid] => 92142 [name] => InnoDB Buffer Pool Reads [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [83] => Array ( [itemid] => 92143 [name] => InnoDB Buffer Pool size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [84] => Array ( [itemid] => 92144 [name] => InnoDB Buffer Pool wait free [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [85] => Array ( [itemid] => 92145 [name] => InnoDB Buffer Pool write requests [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [86] => Array ( [itemid] => 92146 [name] => InnoDB checkpoint age [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [87] => Array ( [itemid] => 92147 [name] => InnoDB Compress Time [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [88] => Array ( [itemid] => 92148 [name] => InnoDB Data Bytes Read [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [89] => Array ( [itemid] => 92149 [name] => InnoDB Data Bytes Written [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [90] => Array ( [itemid] => 92150 [name] => InnoDB Data Fsyncs [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [91] => Array ( [itemid] => 92151 [name] => InnoDB Data Pending Fsyncs [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [92] => Array ( [itemid] => 92152 [name] => InnoDB Data Pending Reads [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [93] => Array ( [itemid] => 92153 [name] => InnoDB Data Pending Writes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [94] => Array ( [itemid] => 92154 [name] => InnoDB Data Reads [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [95] => Array ( [itemid] => 92155 [name] => InnoDB Data Writes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [96] => Array ( [itemid] => 92159 [name] => InnoDB Flush Log at Transaction Commit [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [97] => Array ( [itemid] => 92161 [name] => InnoDB Force Recovery [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [98] => Array ( [itemid] => 92163 [name] => InnoDB Hash Node Size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [99] => Array ( [itemid] => 92164 [name] => InnoDB Hash Searches [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [100] => Array ( [itemid] => 92165 [name] => InnoDB I/O capacity [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [101] => Array ( [itemid] => 92166 [name] => InnoDB Last Checkpoint at [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [102] => Array ( [itemid] => 92167 [name] => InnoDB Log Buffer Size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [103] => Array ( [itemid] => 92168 [name] => InnoDB Log Buffer Waits [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [104] => Array ( [itemid] => 92169 [name] => InnoDB Log bytes written [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [105] => Array ( [itemid] => 92170 [name] => InnoDB Log File Size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [106] => Array ( [itemid] => 92171 [name] => InnoDB Log Files in Group [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [107] => Array ( [itemid] => 92172 [name] => InnoDB Log Flushed up to [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [108] => Array ( [itemid] => 92173 [name] => InnoDB Log Fsyncs [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [109] => Array ( [itemid] => 92174 [name] => InnoDB Log Group capacity [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [110] => Array ( [itemid] => 92175 [name] => InnoDB Log occupancy [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [111] => Array ( [itemid] => 92176 [name] => InnoDB Log Pending Fsyncs [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [112] => Array ( [itemid] => 92177 [name] => InnoDB Log Pending Writes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [113] => Array ( [itemid] => 92178 [name] => InnoDB Log Sequence Number [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [114] => Array ( [itemid] => 92179 [name] => InnoDB Log write requests [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [115] => Array ( [itemid] => 92180 [name] => InnoDB Log writes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [116] => Array ( [itemid] => 92181 [name] => InnoDB max Open Files [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [117] => Array ( [itemid] => 92182 [name] => InnoDB max. dirty pages % [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [118] => Array ( [itemid] => 92184 [name] => InnoDB Mutex O/S Waits [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [119] => Array ( [itemid] => 92185 [name] => InnoDB Mutex Spin Rounds [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [120] => Array ( [itemid] => 92186 [name] => InnoDB Mutex Spin Waits [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [121] => Array ( [itemid] => 92187 [name] => InnoDB new Deadlock error [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [122] => Array ( [itemid] => 92188 [name] => InnoDB new Foreign Key error [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [123] => Array ( [itemid] => 92189 [name] => InnoDB non-Hash Searches [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [124] => Array ( [itemid] => 92190 [name] => InnoDB non-Hash Searches (B-tree searches) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [125] => Array ( [itemid] => 92192 [name] => InnoDB NUMA memory allocation [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [126] => Array ( [itemid] => 92193 [name] => InnoDB NUMA memory of node n0 [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [127] => Array ( [itemid] => 92194 [name] => InnoDB NUMA memory of node n1 [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [128] => Array ( [itemid] => 92195 [name] => InnoDB NUMA memory of node n2 [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [129] => Array ( [itemid] => 92196 [name] => InnoDB NUMA memory of node n3 [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [130] => Array ( [itemid] => 92197 [name] => InnoDB NUMA nodes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [131] => Array ( [itemid] => 92198 [name] => InnoDB Number of Open Files [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [132] => Array ( [itemid] => 92199 [name] => InnoDB Open Read Views inside InnoDB Core [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [133] => Array ( [itemid] => 92200 [name] => InnoDB Page Size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [134] => Array ( [itemid] => 92201 [name] => InnoDB Pages Flushed up to [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [135] => Array ( [itemid] => 92203 [name] => InnoDB Queries in Queue [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [136] => Array ( [itemid] => 92204 [name] => InnoDB Queries Inside InnoDB Core [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [137] => Array ( [itemid] => 92205 [name] => InnoDB Redo Log capacity [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [138] => Array ( [itemid] => 92206 [name] => InnoDB Row Lock time (total) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [139] => Array ( [itemid] => 92207 [name] => InnoDB Row Lock waits (total) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [140] => Array ( [itemid] => 92440 [name] => InnoDB Row Locks of User mysql [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [141] => Array ( [itemid] => 92441 [name] => InnoDB Row Locks of User root [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [142] => Array ( [itemid] => 92208 [name] => InnoDB Rows Deleted [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [143] => Array ( [itemid] => 92209 [name] => InnoDB Rows Inserted [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [144] => Array ( [itemid] => 92210 [name] => InnoDB Rows Locked [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [145] => Array ( [itemid] => 92211 [name] => InnoDB Rows Modified [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [146] => Array ( [itemid] => 92212 [name] => InnoDB Rows Read [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [147] => Array ( [itemid] => 92213 [name] => InnoDB Rows Updated [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [148] => Array ( [itemid] => 92214 [name] => InnoDB Temporary Table amount [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [149] => Array ( [itemid] => 92215 [name] => InnoDB Temporary Table size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [150] => Array ( [itemid] => 92216 [name] => InnoDB Transaction Committing [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [151] => Array ( [itemid] => 92217 [name] => InnoDB Transaction History Length [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [152] => Array ( [itemid] => 92218 [name] => InnoDB Transaction History Length (new) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [153] => Array ( [itemid] => 92219 [name] => InnoDB Transaction Lock Memory [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [154] => Array ( [itemid] => 92220 [name] => InnoDB Transaction Lock Waiting [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [155] => Array ( [itemid] => 92221 [name] => InnoDB Transaction Rolling Back [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [156] => Array ( [itemid] => 92222 [name] => InnoDB Transaction Running [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [157] => Array ( [itemid] => 92223 [name] => InnoDB Uncompress Time [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [158] => Array ( [itemid] => 92432 [name] => Instance size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [159] => Array ( [itemid] => 92111 [name] => IO thread read position [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [160] => Array ( [itemid] => 92112 [name] => IO thread write position [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [161] => Array ( [itemid] => 92233 [name] => last_cpu_number [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [162] => Array ( [itemid] => 92318 [name] => Log Warnings [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [163] => Array ( [itemid] => 92319 [name] => Long Query Time [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [164] => Array ( [itemid] => 92234 [name] => major_faults [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [165] => Array ( [itemid] => 92104 [name] => Master binlog position [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [166] => Array ( [itemid] => 92320 [name] => Max. allowed packet size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [167] => Array ( [itemid] => 92321 [name] => Max. Connections [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [168] => Array ( [itemid] => 92322 [name] => Max. Heap Table size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [169] => Array ( [itemid] => 92323 [name] => Max. Sort Length [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [170] => Array ( [itemid] => 92324 [name] => Max. used Connections [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [171] => Array ( [itemid] => 92325 [name] => Max. User Connections [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [172] => Array ( [itemid] => 92235 [name] => minor_faults [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [173] => Array ( [itemid] => 92255 [name] => MyISAM Blocks not flushed (dirty) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [174] => Array ( [itemid] => 92256 [name] => MyISAM Blocks not flushed (dirty) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [175] => Array ( [itemid] => 92257 [name] => MyISAM Blocks unused [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [176] => Array ( [itemid] => 92258 [name] => MyISAM Blocks unused [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [177] => Array ( [itemid] => 92259 [name] => MyISAM Blocks used (HWM) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [178] => Array ( [itemid] => 92260 [name] => MyISAM Blocks used (HWM) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [179] => Array ( [itemid] => 92261 [name] => MyISAM Blocks used (now) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [180] => Array ( [itemid] => 92262 [name] => MyISAM Blocks used (now) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [181] => Array ( [itemid] => 92263 [name] => MyISAM Blocks warm [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [182] => Array ( [itemid] => 92264 [name] => MyISAM Blocks warm [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [183] => Array ( [itemid] => 92265 [name] => MyISAM Buffer size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [184] => Array ( [itemid] => 92266 [name] => MyISAM Buffer size (blk) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [185] => Array ( [itemid] => 92267 [name] => MyISAM Key Buffer Hit Rate [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [186] => Array ( [itemid] => 92268 [name] => MyISAM Key Cache Block size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [187] => Array ( [itemid] => 92269 [name] => MyISAM Key read requests [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [188] => Array ( [itemid] => 92270 [name] => MyISAM Key reads [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [189] => Array ( [itemid] => 92271 [name] => MyISAM Key write requests [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [190] => Array ( [itemid] => 92272 [name] => MyISAM Key writes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [191] => Array ( [itemid] => 92328 [name] => MySQL is alive [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [192] => Array ( [itemid] => 92329 [name] => MySQL uptime [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [193] => Array ( [itemid] => 92331 [name] => MySQL version (machine readable) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [194] => Array ( [itemid] => 92236 [name] => nice_value [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [195] => Array ( [itemid] => 92237 [name] => Nonvoluntary Context Switches [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [196] => Array ( [itemid] => 92105 [name] => Number of actual binlog [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [197] => Array ( [itemid] => 92106 [name] => Number of available binlogs [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [198] => Array ( [itemid] => 92238 [name] => Number of file descriptors [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [199] => Array ( [itemid] => 92107 [name] => Number of registered slaves [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [200] => Array ( [itemid] => 92239 [name] => Number of Threads [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [201] => Array ( [itemid] => 92332 [name] => Open files [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [202] => Array ( [itemid] => 92333 [name] => Open files limit [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [203] => Array ( [itemid] => 92334 [name] => Open table definitions [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [204] => Array ( [itemid] => 92335 [name] => Open tables [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [205] => Array ( [itemid] => 92336 [name] => Opened files [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [206] => Array ( [itemid] => 92337 [name] => Opened table definitions [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [207] => Array ( [itemid] => 92338 [name] => Opened tables [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [208] => Array ( [itemid] => 92240 [name] => Physical RAM [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [209] => Array ( [itemid] => 92424 [name] => Privilege Backup duration [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [210] => Array ( [itemid] => 92425 [name] => Privilege Backup rc [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [211] => Array ( [itemid] => 92339 [name] => Processlist Metadata Lock waits [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [212] => Array ( [itemid] => 92340 [name] => Processlist Sending data [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [213] => Array ( [itemid] => 92341 [name] => Processlist Sleep [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [214] => Array ( [itemid] => 92342 [name] => Processlist Table level lock waits [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [215] => Array ( [itemid] => 92343 [name] => Processlist total threads [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [216] => Array ( [itemid] => 92344 [name] => Processlist updating [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [217] => Array ( [itemid] => 92345 [name] => Queries [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [218] => Array ( [itemid] => 92346 [name] => Query Cache blk / Query [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [219] => Array ( [itemid] => 92347 [name] => Query Cache byte / block [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [220] => Array ( [itemid] => 92348 [name] => Query Cache free Blocks [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [221] => Array ( [itemid] => 92349 [name] => Query Cache free Memory [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [222] => Array ( [itemid] => 92350 [name] => Query Cache Hits [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [223] => Array ( [itemid] => 92351 [name] => Query Cache Inserts [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [224] => Array ( [itemid] => 92352 [name] => Query Cache low Memory prunes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [225] => Array ( [itemid] => 92353 [name] => Query Cache not cached [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [226] => Array ( [itemid] => 92354 [name] => Query Cache Queries in Cache [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [227] => Array ( [itemid] => 92355 [name] => Query Cache size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [228] => Array ( [itemid] => 92356 [name] => Query Cache total blocks [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [229] => Array ( [itemid] => 92358 [name] => Query Cache used Blocks [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [230] => Array ( [itemid] => 92359 [name] => Query Cache used Memory [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [231] => Array ( [itemid] => 92360 [name] => Questions [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [232] => Array ( [itemid] => 92361 [name] => Read buffer size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [233] => Array ( [itemid] => 92241 [name] => Resident Memory (RSS) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [234] => Array ( [itemid] => 92242 [name] => Resident Memory Peak (HWM) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [235] => Array ( [itemid] => 92243 [name] => resident_memory_size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [236] => Array ( [itemid] => 92244 [name] => rt_priority [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [237] => Array ( [itemid] => 92245 [name] => scheduling_policy [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [238] => Array ( [itemid] => 92246 [name] => scheduling_priortiy [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [239] => Array ( [itemid] => 92426 [name] => Schema Backup duration [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [240] => Array ( [itemid] => 92427 [name] => Schema Backup rc [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [241] => Array ( [itemid] => 92428 [name] => Schema Backup Size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [242] => Array ( [itemid] => 92362 [name] => Select_full_join [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [243] => Array ( [itemid] => 92363 [name] => Select_full_range_join [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [244] => Array ( [itemid] => 92364 [name] => Select_range_check [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [245] => Array ( [itemid] => 92365 [name] => Select_scan [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [246] => Array ( [itemid] => 92434 [name] => Size of Schema mysql [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [247] => Array ( [itemid] => 92435 [name] => Size of Schema test [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [248] => Array ( [itemid] => 92113 [name] => Slave behind Master [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [249] => Array ( [itemid] => 92115 [name] => Slave IO thread running [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [250] => Array ( [itemid] => 92120 [name] => Slave SQL thread running [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [251] => Array ( [itemid] => 92367 [name] => Slow launching threads [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [252] => Array ( [itemid] => 92368 [name] => Slow queries [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [253] => Array ( [itemid] => 92370 [name] => Sort Buffer Size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [254] => Array ( [itemid] => 92371 [name] => Sort merge passes [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [255] => Array ( [itemid] => 92443 [name] => Sort Merge Passes of User mysql [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [256] => Array ( [itemid] => 92444 [name] => Sort Merge Passes of User root [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [257] => Array ( [itemid] => 92372 [name] => Sort range [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [258] => Array ( [itemid] => 92373 [name] => Sort rows [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [259] => Array ( [itemid] => 92374 [name] => Sort scan [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [260] => Array ( [itemid] => 92121 [name] => SQL thread execute position [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [261] => Array ( [itemid] => 92429 [name] => Structure Backup duration [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [262] => Array ( [itemid] => 92430 [name] => Structure Backup rc [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [263] => Array ( [itemid] => 92108 [name] => Sync Binlog [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [264] => Array ( [itemid] => 92109 [name] => Sync Master Info [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [265] => Array ( [itemid] => 92122 [name] => Sync Relay Log [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [266] => Array ( [itemid] => 92123 [name] => Sync Relay Log Info [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [267] => Array ( [itemid] => 92247 [name] => system_time [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [268] => Array ( [itemid] => 92376 [name] => Table Definition Cache [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [269] => Array ( [itemid] => 92377 [name] => Table locks immediate [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [270] => Array ( [itemid] => 92378 [name] => Table locks waited [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [271] => Array ( [itemid] => 92379 [name] => Table Open Cache [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [272] => Array ( [itemid] => 92380 [name] => Table Open Cache active Instances [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [273] => Array ( [itemid] => 92381 [name] => Table Open Cache Entries [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [274] => Array ( [itemid] => 92382 [name] => Table Open Cache hits [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [275] => Array ( [itemid] => 92383 [name] => Table Open Cache Instances [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [276] => Array ( [itemid] => 92384 [name] => Table Open Cache misses [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [277] => Array ( [itemid] => 92385 [name] => Table Open Cache overflows [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [278] => Array ( [itemid] => 92124 [name] => Tables without Primary Key [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [279] => Array ( [itemid] => 92386 [name] => Temporary Table size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [280] => Array ( [itemid] => 92387 [name] => Temporary Tables amount [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [281] => Array ( [itemid] => 92388 [name] => Temporary Tables size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [282] => Array ( [itemid] => 92446 [name] => Temporay Disk Tables of User mysql [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [283] => Array ( [itemid] => 92447 [name] => Temporay Disk Tables of User root [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [284] => Array ( [itemid] => 92389 [name] => Thread Cache size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [285] => Array ( [itemid] => 92390 [name] => Thread Pool: idle threads [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [286] => Array ( [itemid] => 92391 [name] => Thread Pool: max threads [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [287] => Array ( [itemid] => 92392 [name] => Thread Pool: threads [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [288] => Array ( [itemid] => 92393 [name] => Thread Stack size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [289] => Array ( [itemid] => 92248 [name] => Threads [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [290] => Array ( [itemid] => 92394 [name] => Threads cached [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [291] => Array ( [itemid] => 92395 [name] => Threads connected [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [292] => Array ( [itemid] => 92396 [name] => Threads created [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [293] => Array ( [itemid] => 92397 [name] => Threads running [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [294] => Array ( [itemid] => 92110 [name] => Total size of all binlogs [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [295] => Array ( [itemid] => 92249 [name] => user_time [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [296] => Array ( [itemid] => 92399 [name] => Vendor database version behind newest [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [297] => Array ( [itemid] => 92400 [name] => Vendor database version is supported [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [298] => Array ( [itemid] => 92401 [name] => Vendor database version support ends [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [299] => Array ( [itemid] => 92250 [name] => Virtual Memory Peak (HWM) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [300] => Array ( [itemid] => 92251 [name] => Virtual Memory Size (VSZ) [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [301] => Array ( [itemid] => 92252 [name] => virtual_memory_size [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) [302] => Array ( [itemid] => 92253 [name] => Voluntary Context Switches [hosts] => Array ( [0] => Array ( [hostid] => 10296 [name] => xxxx-db4.mysqld2 ) ) ) ) 4. settings.get [CSettingsHelper.php:108] Parameters: Array ( [output] => extend ) Result: Array ( [default_theme] => blue-theme [search_limit] => 1000 [max_in_table] => 50 [server_check_interval] => 10 [work_period] => 1-5,00:00-24:00 [show_technical_errors] => 0 [history_period] => 24h [period_default] => 1h [max_period] => 2y [severity_color_0] => 97AAB3 [severity_color_1] => 7499FF [severity_color_2] => FFC859 [severity_color_3] => FFA059 [severity_color_4] => E97659 [severity_color_5] => E45959 [severity_name_0] => Not classified [severity_name_1] => Information [severity_name_2] => Warning [severity_name_3] => Average [severity_name_4] => High [severity_name_5] => Disaster [custom_color] => 0 [ok_period] => 30m [blink_period] => 30m [problem_unack_color] => CC0000 [problem_ack_color] => CC0000 [ok_unack_color] => 009900 [ok_ack_color] => 009900 [problem_unack_style] => 1 [problem_ack_style] => 1 [ok_unack_style] => 1 [ok_ack_style] => 1 [discovery_groupid] => 5 [default_inventory_mode] => -1 [alert_usrgrpid] => 7 [snmptrap_logging] => 1 [default_lang] => en_GB [default_timezone] => system [login_attempts] => 5 [login_block] => 30s [validate_uri_schemes] => 1 [uri_valid_schemes] => http,https,ftp,file,mailto,tel,ssh [x_frame_options] => SAMEORIGIN [iframe_sandboxing_enabled] => 1 [iframe_sandboxing_exceptions] => [max_overview_table_size] => 50 [connect_timeout] => 3s [socket_timeout] => 3s [media_type_test_timeout] => 65s [script_timeout] => 60s [item_test_timeout] => 60s [url] => [report_test_timeout] => 60s [auditlog_enabled] => 1 [ha_failover_delay] => 1m [geomaps_tile_provider] => OpenStreetMap.Mapnik [geomaps_tile_url] => [geomaps_max_zoom] => 0 [geomaps_attribution] => ) SQL (0.000178): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.00015): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000297): SELECT r.roleid,r.name,r.type FROM role r WHERE r.roleid='2' zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → DBselect() in include/classes/api/services/CRole.php:98 SQL (0.000293): SELECT role_ruleid,roleid,type,name,value_int,value_str,value_moduleid,value_serviceid FROM role_rule WHERE roleid=2 zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → CRole->addRelatedObjects() → DB::select() → DBselect() in include/classes/db/DB.php:1062 SQL (0.000285): SELECT md.moduleid FROM module md WHERE md.status=1 zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → CRole->addRelatedObjects() → CRole->getRelatedModulesRules() → CRole::getEnabledModuleIds() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:77 SQL (0.000179): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000336): SELECT md.moduleid,md.id,md.relative_path,md.config FROM module md WHERE md.status=1 ORDER BY md.relative_path zabbix.php:22 → require_once() → ZBase->run() → ZBase->initModuleManager() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:77 SQL (0.000416): SELECT NULL FROM users u WHERE u.userid=67 FOR UPDATE zabbix.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:37 SQL (0.000596): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=67 AND idx='web.sidebar.mode' zabbix.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:183 SQL (0.00018): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000364): SELECT usrgrpid FROM users_groups WHERE userid='67' zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:80 SQL (0.000757): SELECT i.itemid,i.key_ FROM items i WHERE i.flags IN (0,4) AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid=49 WHERE i.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND i.itemid=30966 zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:394 SQL (0.000198): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000172): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.002777): SELECT i.itemid,i.name,i.hostid FROM items i WHERE i.flags IN (0,4) AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid=49 WHERE i.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND i.hostid=10296 AND i.value_type IN (0,3) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:394 SQL (0.000502): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10296 AND h.status IN (0,1,3) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → CItem->addRelatedObjects() → CItemGeneral->addRelatedObjects() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1168 SQL (0.000196): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000154): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000715): SELECT c.configid,c.default_theme,c.search_limit,c.max_in_table,c.server_check_interval,c.work_period,c.show_technical_errors,c.history_period,c.period_default,c.max_period,c.severity_color_0,c.severity_color_1,c.severity_color_2,c.severity_color_3,c.severity_color_4,c.severity_color_5,c.severity_name_0,c.severity_name_1,c.severity_name_2,c.severity_name_3,c.severity_name_4,c.severity_name_5,c.custom_color,c.ok_period,c.blink_period,c.problem_unack_color,c.problem_ack_color,c.ok_unack_color,c.ok_ack_color,c.problem_unack_style,c.problem_ack_style,c.ok_unack_style,c.ok_ack_style,c.discovery_groupid,c.default_inventory_mode,c.alert_usrgrpid,c.snmptrap_logging,c.default_lang,c.default_timezone,c.login_attempts,c.login_block,c.validate_uri_schemes,c.uri_valid_schemes,c.x_frame_options,c.iframe_sandboxing_enabled,c.iframe_sandboxing_exceptions,c.max_overview_table_size,c.connect_timeout,c.socket_timeout,c.media_type_test_timeout,c.script_timeout,c.item_test_timeout,c.url,c.report_test_timeout,c.auditlog_enabled,c.ha_failover_delay,c.geomaps_tile_provider,c.geomaps_tile_url,c.geomaps_max_zoom,c.geomaps_attribution FROM config c zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CSettings->get() → DBselect() in include/classes/api/services/CSettings.php:74 SQL (0.000161): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 Local ******************** Script profiler ******************** Total time: 0.003295 Total SQL time: 0.003987 SQL count: 12 (selects: 16 | executes: 7) Peak memory usage: 2M Memory limit: 128M 1. role.get [CRoleHelper.php:172] Parameters: Array ( [output] => Array ( [0] => roleid [1] => name [2] => type ) [selectRules] => Array ( [0] => ui [1] => ui.default_access [2] => modules [3] => modules.default_access [4] => api.access [5] => api.mode [6] => api [7] => actions [8] => actions.default_access ) [roleids] => 2 ) Result: Array ( [0] => Array ( [roleid] => 2 [name] => Admin role [type] => 2 [rules] => Array ( [ui] => Array ( [0] => Array ( [name] => inventory.hosts [status] => 1 ) [1] => Array ( [name] => inventory.overview [status] => 1 ) [2] => Array ( [name] => monitoring.dashboard [status] => 1 ) [3] => Array ( [name] => monitoring.hosts [status] => 1 ) [4] => Array ( [name] => monitoring.latest_data [status] => 1 ) [5] => Array ( [name] => monitoring.maps [status] => 1 ) [6] => Array ( [name] => monitoring.problems [status] => 1 ) [7] => Array ( [name] => reports.availability_report [status] => 1 ) [8] => Array ( [name] => reports.top_triggers [status] => 1 ) [9] => Array ( [name] => services.services [status] => 1 ) [10] => Array ( [name] => services.sla_report [status] => 1 ) [11] => Array ( [name] => configuration.actions [status] => 1 ) [12] => Array ( [name] => configuration.discovery [status] => 1 ) [13] => Array ( [name] => configuration.host_groups [status] => 1 ) [14] => Array ( [name] => configuration.hosts [status] => 1 ) [15] => Array ( [name] => configuration.maintenance [status] => 1 ) [16] => Array ( [name] => configuration.templates [status] => 1 ) [17] => Array ( [name] => monitoring.discovery [status] => 1 ) [18] => Array ( [name] => reports.notifications [status] => 1 ) [19] => Array ( [name] => reports.scheduled_reports [status] => 1 ) [20] => Array ( [name] => services.actions [status] => 1 ) [21] => Array ( [name] => services.sla [status] => 1 ) ) [ui.default_access] => 1 [modules] => Array ( ) [modules.default_access] => 1 [api.access] => 1 [api.mode] => 0 [api] => Array ( ) [actions] => Array ( [0] => Array ( [name] => edit_dashboards [status] => 1 ) [1] => Array ( [name] => edit_maps [status] => 1 ) [2] => Array ( [name] => acknowledge_problems [status] => 1 ) [3] => Array ( [name] => close_problems [status] => 1 ) [4] => Array ( [name] => change_severity [status] => 1 ) [5] => Array ( [name] => add_problem_comments [status] => 1 ) [6] => Array ( [name] => execute_scripts [status] => 1 ) [7] => Array ( [name] => manage_api_tokens [status] => 1 ) [8] => Array ( [name] => edit_maintenance [status] => 1 ) [9] => Array ( [name] => manage_scheduled_reports [status] => 1 ) [10] => Array ( [name] => manage_sla [status] => 1 ) ) [actions.default_access] => 1 ) ) ) 2. settings.get [CSettingsHelper.php:108] Parameters: Array ( [output] => extend ) Result: Array ( [default_theme] => blue-theme [search_limit] => 1000 [max_in_table] => 50 [server_check_interval] => 10 [work_period] => 1-5,00:00-24:00 [show_technical_errors] => 0 [history_period] => 24h [period_default] => 1h [max_period] => 2y [severity_color_0] => 97AAB3 [severity_color_1] => 7499FF [severity_color_2] => FFC859 [severity_color_3] => FFA059 [severity_color_4] => E97659 [severity_color_5] => E45959 [severity_name_0] => Not classified [severity_name_1] => Information [severity_name_2] => Warning [severity_name_3] => Average [severity_name_4] => High [severity_name_5] => Disaster [custom_color] => 0 [ok_period] => 30m [blink_period] => 30m [problem_unack_color] => CC0000 [problem_ack_color] => CC0000 [ok_unack_color] => 009900 [ok_ack_color] => 009900 [problem_unack_style] => 1 [problem_ack_style] => 1 [ok_unack_style] => 1 [ok_ack_style] => 1 [discovery_groupid] => 5 [default_inventory_mode] => -1 [alert_usrgrpid] => 7 [snmptrap_logging] => 1 [default_lang] => en_GB [default_timezone] => system [login_attempts] => 5 [login_block] => 30s [validate_uri_schemes] => 1 [uri_valid_schemes] => http,https,ftp,file,mailto,tel,ssh [x_frame_options] => SAMEORIGIN [iframe_sandboxing_enabled] => 1 [iframe_sandboxing_exceptions] => [max_overview_table_size] => 50 [connect_timeout] => 3s [socket_timeout] => 3s [media_type_test_timeout] => 65s [script_timeout] => 60s [item_test_timeout] => 60s [url] => [report_test_timeout] => 60s [auditlog_enabled] => 1 [ha_failover_delay] => 1m [geomaps_tile_provider] => OpenStreetMap.Mapnik [geomaps_tile_url] => [geomaps_max_zoom] => 0 [geomaps_attribution] => ) SQL (0.000163): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000221): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000407): SELECT r.roleid,r.name,r.type FROM role r WHERE r.roleid='2' zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → DBselect() in include/classes/api/services/CRole.php:98 SQL (0.000519): SELECT role_ruleid,roleid,type,name,value_int,value_str,value_moduleid,value_serviceid FROM role_rule WHERE roleid=2 zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → CRole->addRelatedObjects() → DB::select() → DBselect() in include/classes/db/DB.php:1062 SQL (0.000451): SELECT md.moduleid FROM module md WHERE md.status=1 zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → CRole->addRelatedObjects() → CRole->getRelatedModulesRules() → CRole::getEnabledModuleIds() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:77 SQL (0.000219): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.00041): SELECT md.moduleid,md.id,md.relative_path,md.config FROM module md WHERE md.status=1 ORDER BY md.relative_path zabbix.php:22 → require_once() → ZBase->run() → ZBase->initModuleManager() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:77 SQL (0.000255): SELECT NULL FROM users u WHERE u.userid=67 FOR UPDATE zabbix.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:37 SQL (0.000406): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=67 AND idx='web.sidebar.mode' zabbix.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:183 SQL (0.000119): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000629): SELECT c.configid,c.default_theme,c.search_limit,c.max_in_table,c.server_check_interval,c.work_period,c.show_technical_errors,c.history_period,c.period_default,c.max_period,c.severity_color_0,c.severity_color_1,c.severity_color_2,c.severity_color_3,c.severity_color_4,c.severity_color_5,c.severity_name_0,c.severity_name_1,c.severity_name_2,c.severity_name_3,c.severity_name_4,c.severity_name_5,c.custom_color,c.ok_period,c.blink_period,c.problem_unack_color,c.problem_ack_color,c.ok_unack_color,c.ok_ack_color,c.problem_unack_style,c.problem_ack_style,c.ok_unack_style,c.ok_ack_style,c.discovery_groupid,c.default_inventory_mode,c.alert_usrgrpid,c.snmptrap_logging,c.default_lang,c.default_timezone,c.login_attempts,c.login_block,c.validate_uri_schemes,c.uri_valid_schemes,c.x_frame_options,c.iframe_sandboxing_enabled,c.iframe_sandboxing_exceptions,c.max_overview_table_size,c.connect_timeout,c.socket_timeout,c.media_type_test_timeout,c.script_timeout,c.item_test_timeout,c.url,c.report_test_timeout,c.auditlog_enabled,c.ha_failover_delay,c.geomaps_tile_provider,c.geomaps_tile_url,c.geomaps_max_zoom,c.geomaps_attribution FROM config c zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CSettings->get() → DBselect() in include/classes/api/services/CSettings.php:74 SQL (0.000188): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 test No permissions to referred object or it does not exist! ******************** Script profiler ******************** Total time: 0.007313 Total SQL time: 0.005543 SQL count: 20 (selects: 20 | executes: 11) Peak memory usage: 2M Memory limit: 128M 1. role.get [CRoleHelper.php:172] Parameters: Array ( [output] => Array ( [0] => roleid [1] => name [2] => type ) [selectRules] => Array ( [0] => ui [1] => ui.default_access [2] => modules [3] => modules.default_access [4] => api.access [5] => api.mode [6] => api [7] => actions [8] => actions.default_access ) [roleids] => 2 ) Result: Array ( [0] => Array ( [roleid] => 2 [name] => Admin role [type] => 2 [rules] => Array ( [ui] => Array ( [0] => Array ( [name] => inventory.hosts [status] => 1 ) [1] => Array ( [name] => inventory.overview [status] => 1 ) [2] => Array ( [name] => monitoring.dashboard [status] => 1 ) [3] => Array ( [name] => monitoring.hosts [status] => 1 ) [4] => Array ( [name] => monitoring.latest_data [status] => 1 ) [5] => Array ( [name] => monitoring.maps [status] => 1 ) [6] => Array ( [name] => monitoring.problems [status] => 1 ) [7] => Array ( [name] => reports.availability_report [status] => 1 ) [8] => Array ( [name] => reports.top_triggers [status] => 1 ) [9] => Array ( [name] => services.services [status] => 1 ) [10] => Array ( [name] => services.sla_report [status] => 1 ) [11] => Array ( [name] => configuration.actions [status] => 1 ) [12] => Array ( [name] => configuration.discovery [status] => 1 ) [13] => Array ( [name] => configuration.host_groups [status] => 1 ) [14] => Array ( [name] => configuration.hosts [status] => 1 ) [15] => Array ( [name] => configuration.maintenance [status] => 1 ) [16] => Array ( [name] => configuration.templates [status] => 1 ) [17] => Array ( [name] => monitoring.discovery [status] => 1 ) [18] => Array ( [name] => reports.notifications [status] => 1 ) [19] => Array ( [name] => reports.scheduled_reports [status] => 1 ) [20] => Array ( [name] => services.actions [status] => 1 ) [21] => Array ( [name] => services.sla [status] => 1 ) ) [ui.default_access] => 1 [modules] => Array ( ) [modules.default_access] => 1 [api.access] => 1 [api.mode] => 0 [api] => Array ( ) [actions] => Array ( [0] => Array ( [name] => edit_dashboards [status] => 1 ) [1] => Array ( [name] => edit_maps [status] => 1 ) [2] => Array ( [name] => acknowledge_problems [status] => 1 ) [3] => Array ( [name] => close_problems [status] => 1 ) [4] => Array ( [name] => change_severity [status] => 1 ) [5] => Array ( [name] => add_problem_comments [status] => 1 ) [6] => Array ( [name] => execute_scripts [status] => 1 ) [7] => Array ( [name] => manage_api_tokens [status] => 1 ) [8] => Array ( [name] => edit_maintenance [status] => 1 ) [9] => Array ( [name] => manage_scheduled_reports [status] => 1 ) [10] => Array ( [name] => manage_sla [status] => 1 ) ) [actions.default_access] => 1 ) ) ) 2. host.get [CControllerWidgetGraphView.php:127] Parameters: Array ( [output] => Array ( [0] => hostid [1] => host [2] => name ) [hostids] => 10296 ) Result: Array ( [0] => Array ( [hostid] => 10296 [host] => xxxx.xxxx-db4.mysqld2 [name] => xxxx-db4.mysqld2 ) ) 3. graph.get [CControllerWidgetGraphView.php:136] Parameters: Array ( [output] => extend [selectGraphItems] => extend [selectHosts] => Array ( ) [graphids] => 722 ) Result: Array ( ) 4. settings.get [CSettingsHelper.php:108] Parameters: Array ( [output] => extend ) Result: Array ( [default_theme] => blue-theme [search_limit] => 1000 [max_in_table] => 50 [server_check_interval] => 10 [work_period] => 1-5,00:00-24:00 [show_technical_errors] => 0 [history_period] => 24h [period_default] => 1h [max_period] => 2y [severity_color_0] => 97AAB3 [severity_color_1] => 7499FF [severity_color_2] => FFC859 [severity_color_3] => FFA059 [severity_color_4] => E97659 [severity_color_5] => E45959 [severity_name_0] => Not classified [severity_name_1] => Information [severity_name_2] => Warning [severity_name_3] => Average [severity_name_4] => High [severity_name_5] => Disaster [custom_color] => 0 [ok_period] => 30m [blink_period] => 30m [problem_unack_color] => CC0000 [problem_ack_color] => CC0000 [ok_unack_color] => 009900 [ok_ack_color] => 009900 [problem_unack_style] => 1 [problem_ack_style] => 1 [ok_unack_style] => 1 [ok_ack_style] => 1 [discovery_groupid] => 5 [default_inventory_mode] => -1 [alert_usrgrpid] => 7 [snmptrap_logging] => 1 [default_lang] => en_GB [default_timezone] => system [login_attempts] => 5 [login_block] => 30s [validate_uri_schemes] => 1 [uri_valid_schemes] => http,https,ftp,file,mailto,tel,ssh [x_frame_options] => SAMEORIGIN [iframe_sandboxing_enabled] => 1 [iframe_sandboxing_exceptions] => [max_overview_table_size] => 50 [connect_timeout] => 3s [socket_timeout] => 3s [media_type_test_timeout] => 65s [script_timeout] => 60s [item_test_timeout] => 60s [url] => [report_test_timeout] => 60s [auditlog_enabled] => 1 [ha_failover_delay] => 1m [geomaps_tile_provider] => OpenStreetMap.Mapnik [geomaps_tile_url] => [geomaps_max_zoom] => 0 [geomaps_attribution] => ) SQL (0.000144): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000107): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000206): SELECT r.roleid,r.name,r.type FROM role r WHERE r.roleid='2' zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → DBselect() in include/classes/api/services/CRole.php:98 SQL (0.000287): SELECT role_ruleid,roleid,type,name,value_int,value_str,value_moduleid,value_serviceid FROM role_rule WHERE roleid=2 zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → CRole->addRelatedObjects() → DB::select() → DBselect() in include/classes/db/DB.php:1062 SQL (0.000225): SELECT md.moduleid FROM module md WHERE md.status=1 zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → CRole->addRelatedObjects() → CRole->getRelatedModulesRules() → CRole::getEnabledModuleIds() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:77 SQL (7.9E-5): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000315): SELECT md.moduleid,md.id,md.relative_path,md.config FROM module md WHERE md.status=1 ORDER BY md.relative_path zabbix.php:22 → require_once() → ZBase->run() → ZBase->initModuleManager() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:77 SQL (0.000333): SELECT NULL FROM users u WHERE u.userid=67 FOR UPDATE zabbix.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:37 SQL (0.000386): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=67 AND idx='web.sidebar.mode' zabbix.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:183 SQL (0.000577): SELECT MAX(g.graphtype) AS graphtype,MIN(gi.yaxisside) AS yaxissidel,MAX(gi.yaxisside) AS yaxissider,MAX(g.height) AS height FROM graphs g,graphs_items gi WHERE g.graphid='722' AND gi.graphid=g.graphid zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → getGraphDims() → DBselect() in include/graphs.inc.php:117 SQL (0.000208): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000355): SELECT usrgrpid FROM users_groups WHERE userid='67' zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:80 SQL (0.000633): SELECT h.hostid,h.host,h.name FROM hosts h WHERE h.flags IN (0,4) AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid=49 WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid=10296 AND h.status IN (0,1) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1168 SQL (0.000102): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.00013): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000659): SELECT g.* FROM graphs g WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=49 WHERE g.graphid=gi.graphid AND gi.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND g.graphid=722 AND g.flags IN (0,4) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:262 SQL (0.000115): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (7.9E-5): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000475): SELECT c.configid,c.default_theme,c.search_limit,c.max_in_table,c.server_check_interval,c.work_period,c.show_technical_errors,c.history_period,c.period_default,c.max_period,c.severity_color_0,c.severity_color_1,c.severity_color_2,c.severity_color_3,c.severity_color_4,c.severity_color_5,c.severity_name_0,c.severity_name_1,c.severity_name_2,c.severity_name_3,c.severity_name_4,c.severity_name_5,c.custom_color,c.ok_period,c.blink_period,c.problem_unack_color,c.problem_ack_color,c.ok_unack_color,c.ok_ack_color,c.problem_unack_style,c.problem_ack_style,c.ok_unack_style,c.ok_ack_style,c.discovery_groupid,c.default_inventory_mode,c.alert_usrgrpid,c.snmptrap_logging,c.default_lang,c.default_timezone,c.login_attempts,c.login_block,c.validate_uri_schemes,c.uri_valid_schemes,c.x_frame_options,c.iframe_sandboxing_enabled,c.iframe_sandboxing_exceptions,c.max_overview_table_size,c.connect_timeout,c.socket_timeout,c.media_type_test_timeout,c.script_timeout,c.item_test_timeout,c.url,c.report_test_timeout,c.auditlog_enabled,c.ha_failover_delay,c.geomaps_tile_provider,c.geomaps_tile_url,c.geomaps_max_zoom,c.geomaps_attribution FROM config c zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CSettings->get() → DBselect() in include/classes/api/services/CSettings.php:74 SQL (0.000128): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179