Database: nagios3 +----------------------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+-----------------------------------------------------------------------------------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +----------------------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+-----------------------------------------------------------------------------------+ | nagios_acknowledgements | InnoDB | 9 | Dynamic | 0 | 0 | 16384 | | 0 | 0 | 1 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Current and historical host and service acknowledgements; InnoDB free: 55296 kB | | nagios_commands | InnoDB | 9 | Dynamic | 70 | 234 | 16384 | | 16384 | 0 | 1983 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Command definitions; InnoDB free: 55296 kB | | nagios_commenthistory | InnoDB | 9 | Dynamic | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Historical host and service comments; InnoDB free: 55296 kB | | nagios_comments | InnoDB | 9 | Dynamic | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | InnoDB free: 55296 kB | | nagios_configfiles | InnoDB | 9 | Dynamic | 1 | 16384 | 16384 | | 16384 | 0 | 30 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Configuration files; InnoDB free: 55296 kB | | nagios_configfilevariables | InnoDB | 9 | Dynamic | 79 | 207 | 16384 | | 16384 | 0 | 2292 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Configuration file variables; InnoDB free: 55296 kB | | nagios_conninfo | InnoDB | 9 | Dynamic | 28 | 585 | 16384 | | 0 | 0 | 29 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | NDO2DB daemon connection information; InnoDB free: 55296 kB | | nagios_contact_addresses | InnoDB | 9 | Dynamic | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Contact addresses; InnoDB free: 55296 kB | | nagios_contact_notificationcommands | InnoDB | 9 | Dynamic | 240 | 68 | 16384 | | 16384 | 0 | 6961 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Contact host and service notification commands; InnoDB free: 55296 kB | | nagios_contactgroup_members | InnoDB | 9 | Fixed | 40 | 409 | 16384 | | 16384 | 0 | 1161 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Contactgroup members; InnoDB free: 55296 kB | | nagios_contactgroups | InnoDB | 9 | Dynamic | 13 | 1260 | 16384 | | 16384 | 0 | 378 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Contactgroup definitions; InnoDB free: 55296 kB | | nagios_contactnotificationmethods | InnoDB | 9 | Dynamic | 1333 | 86 | 114688 | | 65536 | 0 | 1194 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Historical record of contact notification methods; InnoDB free: 55296 kB | | nagios_contactnotifications | InnoDB | 9 | Fixed | 1351 | 84 | 114688 | | 65536 | 0 | 1194 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Historical record of contact notifications; InnoDB free: 55296 kB | | nagios_contacts | InnoDB | 9 | Dynamic | 20 | 819 | 16384 | | 16384 | 0 | 581 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Contact definitions; InnoDB free: 55296 kB | | nagios_contactstatus | InnoDB | 9 | Fixed | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Contact status; InnoDB free: 55296 kB | | nagios_customvariables | InnoDB | 9 | Dynamic | 0 | 0 | 16384 | | 32768 | 0 | 1 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Custom variables; InnoDB free: 55296 kB | | nagios_customvariablestatus | InnoDB | 9 | Dynamic | 0 | 0 | 16384 | | 32768 | 0 | 1 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Custom variable status information; InnoDB free: 55296 kB | | nagios_dbversion | InnoDB | 9 | Dynamic | 1 | 16384 | 16384 | | 0 | 0 | | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | InnoDB free: 55296 kB | | nagios_downtimehistory | InnoDB | 9 | Dynamic | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Historical scheduled host and service downtime; InnoDB free: 55296 kB | | nagios_eventhandlers | InnoDB | 9 | Dynamic | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:46 | | | latin1_swedish_ci | | | Historical host and service event handlers; InnoDB free: 55296 kB | | nagios_externalcommands | InnoDB | 9 | Dynamic | 55 | 1191 | 65536 | | 0 | 0 | 213 | 2007-11-14 08:51:47 | | | latin1_swedish_ci | | | Historical record of processed external commands; InnoDB free: 55296 kB | | nagios_flappinghistory | InnoDB | 9 | Fixed | 0 | 0 | 16384 | | 0 | 0 | 1 | 2007-11-14 08:51:47 | | | latin1_swedish_ci | | | Current and historical record of host and service flapping; InnoDB free: 55296 kB | | nagios_host_contactgroups | InnoDB | 9 | Fixed | 15786 | 100 | 1589248 | | 376832 | 0 | 15360 | 2007-11-14 08:51:47 | | | latin1_swedish_ci | | | Host contact groups; InnoDB free: 55296 kB | | nagios_host_contacts | InnoDB | 9 | Fixed | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:47 | | | latin1_swedish_ci | | | InnoDB free: 55296 kB | | nagios_host_parenthosts | InnoDB | 9 | Fixed | 232 | 70 | 16384 | | 16384 | 0 | 6709 | 2007-11-14 08:51:47 | | | latin1_swedish_ci | | | Parent hosts; InnoDB free: 55296 kB | | nagios_hostchecks | InnoDB | 9 | Dynamic | 6853 | 384 | 2637824 | | 376832 | 0 | 24716 | 2007-11-14 08:51:47 | | | latin1_swedish_ci | | | Historical host checks; InnoDB free: 55296 kB | | nagios_hostdependencies | InnoDB | 9 | Fixed | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:47 | | | latin1_swedish_ci | | | Host dependency definitions; InnoDB free: 55296 kB | | nagios_hostescalation_contactgroups | InnoDB | 9 | Fixed | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:47 | | | latin1_swedish_ci | | | Host escalation contact groups; InnoDB free: 55296 kB | | nagios_hostescalation_contacts | InnoDB | 9 | Fixed | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:47 | | | latin1_swedish_ci | | | InnoDB free: 55296 kB | | nagios_hostescalations | InnoDB | 9 | Fixed | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:48 | | | latin1_swedish_ci | | | Host escalation definitions; InnoDB free: 55296 kB | | nagios_hostgroup_members | InnoDB | 9 | Fixed | 385 | 127 | 49152 | | 16384 | 0 | 15516 | 2007-11-14 08:51:48 | | | latin1_swedish_ci | | | Hostgroup members; InnoDB free: 55296 kB | | nagios_hostgroups | InnoDB | 9 | Dynamic | 44 | 372 | 16384 | | 16384 | 0 | 1264 | 2007-11-14 08:51:48 | | | latin1_swedish_ci | | | Hostgroup definitions; InnoDB free: 55296 kB | | nagios_hosts | InnoDB | 9 | Dynamic | 218 | 601 | 131072 | | 16384 | 0 | 6854 | 2007-11-14 08:51:48 | | | latin1_swedish_ci | | | Host definitions; InnoDB free: 55296 kB | | nagios_hoststatus | InnoDB | 9 | Dynamic | 245 | 534 | 131072 | | 16384 | 0 | 6853 | 2007-11-14 08:51:48 | | | latin1_swedish_ci | | | Current host status information; InnoDB free: 55296 kB | | nagios_instances | InnoDB | 9 | Dynamic | 1 | 16384 | 16384 | | 0 | 0 | 2 | 2007-11-14 08:51:48 | | | latin1_swedish_ci | | | Location names of various Nagios installations; InnoDB free: 55296 kB | | nagios_logentries | InnoDB | 9 | Dynamic | 32267 | 211 | 6832128 | | 0 | 0 | 32590 | 2007-11-14 08:51:48 | | | latin1_swedish_ci | | | Historical record of log entries; InnoDB free: 55296 kB | | nagios_notifications | InnoDB | 9 | Dynamic | 367 | 223 | 81920 | | 16384 | 0 | 326 | 2007-11-14 08:51:50 | | | latin1_swedish_ci | | | Historical record of host and service notifications; InnoDB free: 55296 kB | | nagios_objects | InnoDB | 9 | Dynamic | 1020 | 96 | 98304 | | 114688 | 0 | 1089 | 2007-11-14 08:51:50 | | | latin1_swedish_ci | | | Current and historical objects of all kinds; InnoDB free: 55296 kB | | nagios_processevents | InnoDB | 9 | Dynamic | 152 | 107 | 16384 | | 0 | 0 | 153 | 2007-11-14 08:51:50 | | | latin1_swedish_ci | | | Historical Nagios process events; InnoDB free: 55296 kB | | nagios_programstatus | InnoDB | 9 | Dynamic | 1 | 16384 | 16384 | | 16384 | 0 | 30 | 2007-11-14 08:51:50 | | | latin1_swedish_ci | | | Current program status information; InnoDB free: 55296 kB | | nagios_runtimevariables | InnoDB | 9 | Dynamic | 18 | 910 | 16384 | | 16384 | 0 | 505 | 2007-11-14 08:51:50 | | | latin1_swedish_ci | | | Runtime variables from the Nagios daemon; InnoDB free: 55296 kB | | nagios_scheduleddowntime | InnoDB | 9 | Dynamic | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:50 | | | latin1_swedish_ci | | | Current scheduled host and service downtime; InnoDB free: 55296 kB | | nagios_service_contactgroups | InnoDB | 9 | Fixed | 47357 | 55 | 2637824 | | 1589248 | 0 | 47105 | 2007-11-14 08:51:50 | | | latin1_swedish_ci | | | Service contact groups; InnoDB free: 55296 kB | | nagios_service_contacts | InnoDB | 9 | Fixed | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:51:51 | | | latin1_swedish_ci | | | InnoDB free: 55296 kB | | nagios_servicechecks | InnoDB | 9 | Dynamic | 1031179 | 317 | 326991872 | | 58359808 | 0 | 3057932 | 2007-11-14 08:51:51 | | | latin1_swedish_ci | | | Historical service checks; InnoDB free: 55296 kB | | nagios_servicedependencies | InnoDB | 9 | Fixed | 697 | 117 | 81920 | | 49152 | 0 | 16745 | 2007-11-14 08:56:56 | | | latin1_swedish_ci | | | Service dependency definitions; InnoDB free: 55296 kB | | nagios_serviceescalation_contactgroups | InnoDB | 9 | Fixed | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:56:56 | | | latin1_swedish_ci | | | Service escalation contact groups; InnoDB free: 55296 kB | | nagios_serviceescalation_contacts | InnoDB | 9 | Fixed | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:56:56 | | | latin1_swedish_ci | | | InnoDB free: 55296 kB | | nagios_serviceescalations | InnoDB | 9 | Fixed | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:56:56 | | | latin1_swedish_ci | | | Service escalation definitions; InnoDB free: 55296 kB | | nagios_servicegroup_members | InnoDB | 9 | Fixed | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:56:56 | | | latin1_swedish_ci | | | Servicegroup members; InnoDB free: 55296 kB | | nagios_servicegroups | InnoDB | 9 | Dynamic | 0 | 0 | 16384 | | 16384 | 0 | 1 | 2007-11-14 08:56:56 | | | latin1_swedish_ci | | | Servicegroup definitions; InnoDB free: 55296 kB | | nagios_services | InnoDB | 9 | Dynamic | 694 | 354 | 245760 | | 16384 | 0 | 18540 | 2007-11-14 08:56:56 | | | latin1_swedish_ci | | | Service definitions; InnoDB free: 55296 kB | | nagios_servicestatus | InnoDB | 9 | Dynamic | 705 | 441 | 311296 | | 16384 | 0 | 18800 | 2007-11-14 08:56:57 | | | latin1_swedish_ci | | | Current service status information; InnoDB free: 55296 kB | | nagios_statehistory | InnoDB | 9 | Dynamic | 11593 | 137 | 1589248 | | 0 | 0 | 11142 | 2007-11-14 08:56:57 | | | latin1_swedish_ci | | | Historical host and service state changes; InnoDB free: 55296 kB | | nagios_systemcommands | InnoDB | 9 | Dynamic | 4282 | 371 | 1589248 | | 147456 | 0 | 14562 | 2007-11-14 08:56:58 | | | latin1_swedish_ci | | | Historical system commands that are executed; InnoDB free: 55296 kB | | nagios_timedeventqueue | InnoDB | 9 | Fixed | 848 | 115 | 98304 | | 0 | 0 | 3422789 | 2007-11-14 08:56:58 | | | latin1_swedish_ci | | | Current Nagios event queue; InnoDB free: 55296 kB | | nagios_timedevents | InnoDB | 9 | Fixed | 65077 | 104 | 6832128 | | 4734976 | 0 | 3417360 | 2007-11-14 08:56:58 | | | latin1_swedish_ci | | | Historical events from the Nagios event queue; InnoDB free: 55296 kB | | nagios_timeperiod_timeranges | InnoDB | 9 | Fixed | 75 | 218 | 16384 | | 16384 | 0 | 2176 | 2007-11-14 08:57:02 | | | latin1_swedish_ci | | | Timeperiod definitions; InnoDB free: 55296 kB | | nagios_timeperiods | InnoDB | 9 | Dynamic | 9 | 1820 | 16384 | | 16384 | 0 | 262 | 2007-11-14 08:57:02 | | | latin1_swedish_ci | | | Timeperiod definitions; InnoDB free: 55296 kB | +----------------------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+-----------------------------------------------------------------------------------+