UPDATE `kontrollbase`.`alerts_def` SET `alert_solution` = 'This alert has found a large number of aborted connections to the database. A common cause of this is improperly closed connections from the application or locked tables causing subsequent connections to abort due to the connection timeout being reached. This alert recommends auditing your code for connections being properly closed or queries being tested in a staging environment to watch for locked tables.',
`alert_function` = '$Aborted_connects > 999' WHERE `alerts_def`.`id` =1 LIMIT 1 ;
ALTER TABLE `server_statistics` CHANGE `os_mem_total` `os_mem_total` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `os_mem_used` `os_mem_used` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `os_swap_total` `os_swap_total` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `os_swap_free` `os_swap_free` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `length_data` `length_data` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `length_index` `length_index` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `engine_myisam_size_data` `engine_myisam_size_data` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `engine_myisam_size_index` `engine_myisam_size_index` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `engine_innodb_size_data` `engine_innodb_size_data` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `engine_innodb_size_index` `engine_innodb_size_index` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `auto_increment_increment` `auto_increment_increment` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `auto_increment_offset` `auto_increment_offset` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `back_log` `back_log` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `binlog_cache_size` `binlog_cache_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `bulk_insert_buffer_size` `bulk_insert_buffer_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `completion_type` `completion_type` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `concurrent_insert` `concurrent_insert` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `connect_timeout` `connect_timeout` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `datetime_format` `datetime_format` VARCHAR(128);
ALTER TABLE `server_statistics` CHANGE `default_week_format` `default_week_format` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `delayed_insert_limit` `delayed_insert_limit` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `delayed_insert_timeout` `delayed_insert_timeout` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `delayed_queue_size` `delayed_queue_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `div_precision_increment` `div_precision_increment` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `expire_logs_days` `expire_logs_days` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `flush_time` `flush_time` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `ft_max_word_len` `ft_max_word_len` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `ft_min_word_len` `ft_min_word_len` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `ft_query_expansion_limit` `ft_query_expansion_limit` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `group_concat_max_len` `group_concat_max_len` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_additional_mem_pool_size` `innodb_additional_mem_pool_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_autoextend_increment` `innodb_autoextend_increment` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_buffer_pool_awe_mem_mb` `innodb_buffer_pool_awe_mem_mb` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_buffer_pool_size` `innodb_buffer_pool_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_commit_concurrency` `innodb_commit_concurrency` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_concurrency_tickets` `innodb_concurrency_tickets` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_fast_shutdown` `innodb_fast_shutdown` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_file_io_threads` `innodb_file_io_threads` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_force_recovery` `innodb_force_recovery` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_lock_wait_timeout` `innodb_lock_wait_timeout` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_log_buffer_size` `innodb_log_buffer_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_log_file_size` `innodb_log_file_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_log_files_in_group` `innodb_log_files_in_group` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_max_dirty_pages_pct` `innodb_max_dirty_pages_pct` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_max_purge_lag` `innodb_max_purge_lag` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_mirrored_log_groups` `innodb_mirrored_log_groups` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_open_files` `innodb_open_files` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_sync_spin_loops` `innodb_sync_spin_loops` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_thread_concurrency` `innodb_thread_concurrency` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_thread_sleep_delay` `innodb_thread_sleep_delay` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_read_ahead` `innodb_read_ahead` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_ibuf_contract_const` `innodb_ibuf_contract_const` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_ibuf_contract_burst` `innodb_ibuf_contract_burst` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_buf_flush_const` `innodb_buf_flush_const` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `innodb_buf_flush_burst` `innodb_buf_flush_burst` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `interactive_timeout` `interactive_timeout` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `join_buffer_size` `join_buffer_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `key_buffer_size` `key_buffer_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `key_cache_age_threshold` `key_cache_age_threshold` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `key_cache_block_size` `key_cache_block_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `key_cache_division_limit` `key_cache_division_limit` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `large_page_size` `large_page_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `log_warnings` `log_warnings` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `long_query_time` `long_query_time` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `lower_case_table_names` `lower_case_table_names` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_allowed_packet` `max_allowed_packet` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_binlog_cache_size` `max_binlog_cache_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_binlog_size` `max_binlog_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_connect_errors` `max_connect_errors` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_connections` `max_connections` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_delayed_threads` `max_delayed_threads` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_error_count` `max_error_count` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_heap_table_size` `max_heap_table_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_insert_delayed_threads` `max_insert_delayed_threads` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_join_size` `max_join_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_length_for_sort_data` `max_length_for_sort_data` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_prepared_stmt_count` `max_prepared_stmt_count` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_relay_log_size` `max_relay_log_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_seeks_for_key` `max_seeks_for_key` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_sort_length` `max_sort_length` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_sp_recursion_depth` `max_sp_recursion_depth` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_tmp_tables` `max_tmp_tables` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_user_connections` `max_user_connections` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `max_write_lock_count` `max_write_lock_count` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `min_examined_row_limit` `min_examined_row_limit` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `multi_range_count` `multi_range_count` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `myisam_data_pointer_size` `myisam_data_pointer_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `myisam_max_sort_file_size` `myisam_max_sort_file_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `myisam_repair_threads` `myisam_repair_threads` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `myisam_sort_buffer_size` `myisam_sort_buffer_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `net_buffer_length` `net_buffer_length` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `net_read_timeout` `net_read_timeout` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `net_retry_count` `net_retry_count` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `net_write_timeout` `net_write_timeout` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `open_files_limit` `open_files_limit` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `optimizer_prune_level` `optimizer_prune_level` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `optimizer_search_depth` `optimizer_search_depth` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `port` `port` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `preload_buffer_size` `preload_buffer_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `protocol_version` `protocol_version` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `query_alloc_block_size` `query_alloc_block_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `query_cache_limit` `query_cache_limit` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `query_cache_min_res_unit` `query_cache_min_res_unit` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `query_cache_size` `query_cache_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `query_prealloc_size` `query_prealloc_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `range_alloc_block_size` `range_alloc_block_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `log_slow_rate_limit` `log_slow_rate_limit` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `read_buffer_size` `read_buffer_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `read_rnd_buffer_size` `read_rnd_buffer_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `relay_log_space_limit` `relay_log_space_limit` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `rpl_recovery_rank` `rpl_recovery_rank` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `server_id` `server_id` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `slave_net_timeout` `slave_net_timeout` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `slave_transaction_retries` `slave_transaction_retries` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `slow_launch_time` `slow_launch_time` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `sort_buffer_size` `sort_buffer_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `sync_binlog` `sync_binlog` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `table_cache` `table_cache` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `table_lock_wait_timeout` `table_lock_wait_timeout` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `thread_cache_size` `thread_cache_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `thread_stack` `thread_stack` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `tmp_table_size` `tmp_table_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `transaction_alloc_block_size` `transaction_alloc_block_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `transaction_prealloc_size` `transaction_prealloc_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `wait_timeout` `wait_timeout` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Aborted_clients` `Aborted_clients` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Aborted_connects` `Aborted_connects` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Binlog_cache_disk_use` `Binlog_cache_disk_use` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Binlog_cache_use` `Binlog_cache_use` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Bytes_received` `Bytes_received` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Bytes_sent` `Bytes_sent` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_admin_commands` `Com_admin_commands` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_alter_db` `Com_alter_db` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_alter_table` `Com_alter_table` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_analyze` `Com_analyze` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_backup_table` `Com_backup_table` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_begin` `Com_begin` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_call_procedure` `Com_call_procedure` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_change_db` `Com_change_db` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_change_master` `Com_change_master` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_check` `Com_check` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_checksum` `Com_checksum` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_commit` `Com_commit` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_create_db` `Com_create_db` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_create_function` `Com_create_function` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_create_index` `Com_create_index` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_create_table` `Com_create_table` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_create_user` `Com_create_user` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_dealloc_sql` `Com_dealloc_sql` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_delete` `Com_delete` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_delete_multi` `Com_delete_multi` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_do` `Com_do` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_drop_db` `Com_drop_db` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_drop_function` `Com_drop_function` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_drop_index` `Com_drop_index` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_drop_table` `Com_drop_table` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_drop_user` `Com_drop_user` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_execute_sql` `Com_execute_sql` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_flush` `Com_flush` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_grant` `Com_grant` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_ha_close` `Com_ha_close` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_ha_open` `Com_ha_open` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_ha_read` `Com_ha_read` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_help` `Com_help` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_insert` `Com_insert` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_insert_select` `Com_insert_select` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_kill` `Com_kill` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_load` `Com_load` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_load_master_data` `Com_load_master_data` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_load_master_table` `Com_load_master_table` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_lock_tables` `Com_lock_tables` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_optimize` `Com_optimize` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_preload_keys` `Com_preload_keys` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_prepare_sql` `Com_prepare_sql` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_purge` `Com_purge` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_purge_before_date` `Com_purge_before_date` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_rename_table` `Com_rename_table` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_repair` `Com_repair` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_replace` `Com_replace` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_replace_select` `Com_replace_select` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_reset` `Com_reset` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_restore_table` `Com_restore_table` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_revoke` `Com_revoke` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_revoke_all` `Com_revoke_all` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_rollback` `Com_rollback` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_savepoint` `Com_savepoint` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_select` `Com_select` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_set_option` `Com_set_option` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_binlog_events` `Com_show_binlog_events` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_binlogs` `Com_show_binlogs` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_charsets` `Com_show_charsets` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_collations` `Com_show_collations` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_column_types` `Com_show_column_types` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_create_db` `Com_show_create_db` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_create_table` `Com_show_create_table` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_databases` `Com_show_databases` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_errors` `Com_show_errors` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_fields` `Com_show_fields` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_grants` `Com_show_grants` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_innodb_status` `Com_show_innodb_status` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_keys` `Com_show_keys` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_logs` `Com_show_logs` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_master_status` `Com_show_master_status` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_ndb_status` `Com_show_ndb_status` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_new_master` `Com_show_new_master` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_open_tables` `Com_show_open_tables` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_privileges` `Com_show_privileges` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_processlist` `Com_show_processlist` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_slave_hosts` `Com_show_slave_hosts` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_slave_status` `Com_show_slave_status` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_status` `Com_show_status` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_storage_engines` `Com_show_storage_engines` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_tables` `Com_show_tables` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_triggers` `Com_show_triggers` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_variables` `Com_show_variables` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_show_warnings` `Com_show_warnings` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_slave_start` `Com_slave_start` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_slave_stop` `Com_slave_stop` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_stmt_close` `Com_stmt_close` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_stmt_execute` `Com_stmt_execute` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_stmt_fetch` `Com_stmt_fetch` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_stmt_prepare` `Com_stmt_prepare` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_stmt_reset` `Com_stmt_reset` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_stmt_send_long_data` `Com_stmt_send_long_data` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_truncate` `Com_truncate` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_unlock_tables` `Com_unlock_tables` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_update` `Com_update` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_update_multi` `Com_update_multi` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_xa_commit` `Com_xa_commit` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_xa_end` `Com_xa_end` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_xa_prepare` `Com_xa_prepare` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_xa_recover` `Com_xa_recover` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_xa_rollback` `Com_xa_rollback` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Com_xa_start` `Com_xa_start` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Compression` `Compression` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Connections` `Connections` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Created_tmp_disk_tables` `Created_tmp_disk_tables` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Created_tmp_files` `Created_tmp_files` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Created_tmp_tables` `Created_tmp_tables` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Delayed_errors` `Delayed_errors` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Delayed_insert_threads` `Delayed_insert_threads` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Delayed_writes` `Delayed_writes` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Flush_commands` `Flush_commands` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_commit` `Handler_commit` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_delete` `Handler_delete` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_discover` `Handler_discover` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_prepare` `Handler_prepare` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_read_first` `Handler_read_first` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_read_key` `Handler_read_key` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_read_next` `Handler_read_next` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_read_prev` `Handler_read_prev` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_read_rnd` `Handler_read_rnd` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_read_rnd_next` `Handler_read_rnd_next` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_rollback` `Handler_rollback` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_savepoint` `Handler_savepoint` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_savepoint_rollback` `Handler_savepoint_rollback` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_update` `Handler_update` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Handler_write` `Handler_write` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_buffer_pool_pages_data` `Innodb_buffer_pool_pages_data` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_buffer_pool_pages_dirty` `Innodb_buffer_pool_pages_dirty` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_buffer_pool_pages_flushed` `Innodb_buffer_pool_pages_flushed` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_buffer_pool_pages_free` `Innodb_buffer_pool_pages_free` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_buffer_pool_pages_misc` `Innodb_buffer_pool_pages_misc` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_buffer_pool_pages_total` `Innodb_buffer_pool_pages_total` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_buffer_pool_read_ahead_rnd` `Innodb_buffer_pool_read_ahead_rnd` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_buffer_pool_read_ahead_seq` `Innodb_buffer_pool_read_ahead_seq` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_buffer_pool_read_requests` `Innodb_buffer_pool_read_requests` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_buffer_pool_reads` `Innodb_buffer_pool_reads` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_buffer_pool_wait_free` `Innodb_buffer_pool_wait_free` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_buffer_pool_write_requests` `Innodb_buffer_pool_write_requests` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_data_fsyncs` `Innodb_data_fsyncs` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_data_pending_fsyncs` `Innodb_data_pending_fsyncs` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_data_pending_reads` `Innodb_data_pending_reads` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_data_pending_writes` `Innodb_data_pending_writes` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_data_read` `Innodb_data_read` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_data_reads` `Innodb_data_reads` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_data_writes` `Innodb_data_writes` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_data_written` `Innodb_data_written` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_dblwr_pages_written` `Innodb_dblwr_pages_written` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_dblwr_writes` `Innodb_dblwr_writes` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_log_waits` `Innodb_log_waits` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_log_write_requests` `Innodb_log_write_requests` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_log_writes` `Innodb_log_writes` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_os_log_fsyncs` `Innodb_os_log_fsyncs` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_os_log_pending_fsyncs` `Innodb_os_log_pending_fsyncs` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_os_log_pending_writes` `Innodb_os_log_pending_writes` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_os_log_written` `Innodb_os_log_written` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_page_size` `Innodb_page_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_pages_created` `Innodb_pages_created` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_pages_read` `Innodb_pages_read` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_pages_written` `Innodb_pages_written` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_row_lock_current_waits` `Innodb_row_lock_current_waits` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_row_lock_time` `Innodb_row_lock_time` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_row_lock_time_avg` `Innodb_row_lock_time_avg` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_row_lock_time_max` `Innodb_row_lock_time_max` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_row_lock_waits` `Innodb_row_lock_waits` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_rows_deleted` `Innodb_rows_deleted` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_rows_inserted` `Innodb_rows_inserted` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_rows_read` `Innodb_rows_read` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Innodb_rows_updated` `Innodb_rows_updated` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Key_blocks_not_flushed` `Key_blocks_not_flushed` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Key_blocks_unused` `Key_blocks_unused` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Key_blocks_used` `Key_blocks_used` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Key_read_requests` `Key_read_requests` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Key_reads` `Key_reads` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Key_write_requests` `Key_write_requests` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Key_writes` `Key_writes` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Max_used_connections` `Max_used_connections` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Not_flushed_delayed_rows` `Not_flushed_delayed_rows` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Open_files` `Open_files` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Open_streams` `Open_streams` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Open_tables` `Open_tables` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Opened_tables` `Opened_tables` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Prepared_stmt_count` `Prepared_stmt_count` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Qcache_free_blocks` `Qcache_free_blocks` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Qcache_free_memory` `Qcache_free_memory` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Qcache_hits` `Qcache_hits` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Qcache_inserts` `Qcache_inserts` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Qcache_lowmem_prunes` `Qcache_lowmem_prunes` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Qcache_not_cached` `Qcache_not_cached` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Qcache_queries_in_cache` `Qcache_queries_in_cache` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Qcache_total_blocks` `Qcache_total_blocks` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Questions` `Questions` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Rpl_status` `Rpl_status` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Select_full_join` `Select_full_join` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Select_full_range_join` `Select_full_range_join` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Select_range` `Select_range` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Select_range_check` `Select_range_check` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Select_scan` `Select_scan` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Slave_open_temp_tables` `Slave_open_temp_tables` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Slave_retried_transactions` `Slave_retried_transactions` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Slave_running` `Slave_running` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Slow_launch_threads` `Slow_launch_threads` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Slow_queries` `Slow_queries` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Sort_merge_passes` `Sort_merge_passes` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Sort_range` `Sort_range` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Sort_rows` `Sort_rows` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Sort_scan` `Sort_scan` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Table_locks_immediate` `Table_locks_immediate` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Table_locks_waited` `Table_locks_waited` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Tc_log_max_pages_used` `Tc_log_max_pages_used` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Tc_log_page_size` `Tc_log_page_size` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Tc_log_page_waits` `Tc_log_page_waits` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Threads_cached` `Threads_cached` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Threads_connected` `Threads_connected` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Threads_created` `Threads_created` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Threads_running` `Threads_running` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Uptime` `Uptime` BIGINT(128) UNSIGNED NOT NULL;
ALTER TABLE `server_statistics` CHANGE `Seconds_Behind_Master` `Seconds_Behind_Master` BIGINT(128) UNSIGNED NOT NULL;

CREATE VIEW view_analytics_overview AS SELECT (max(`server_statistics`.`os_mem_used`) / pow(1024,3)) AS `max_os_mem_used`,(min(`server_statistics`.`os_mem_used`) / pow(1024,3)) AS `min_os_mem_used`,(avg(`server_statistics`.`os_mem_used`) / pow(1024,3)) AS `avg_os_mem_used`,(std(`server_statistics`.`os_mem_used`) / pow(1024,3)) AS `stdev_os_mem_used`,(max((`server_statistics`.`length_data` + `server_statistics`.`length_index`)) / pow(1024,3)) AS `max_size`,(min((`server_statistics`.`length_data` + `server_statistics`.`length_index`)) / pow(1024,3)) AS `min_size`,(avg((`server_statistics`.`length_data` + `server_statistics`.`length_index`)) / pow(1024,3)) AS `avg_size`,(std((`server_statistics`.`length_data` + `server_statistics`.`length_index`)) / pow(1024,3)) AS `stdev_size`,max(`server_statistics`.`num_connections`) AS `max_connections`,min(`server_statistics`.`num_connections`) AS `min_connections`,avg(`server_statistics`.`num_connections`) AS `avg_connections`,std(`server_statistics`.`num_connections`) AS `stdev_connections`,max(`server_statistics`.`queries_per_second`) AS `max_qps`,min(`server_statistics`.`queries_per_second`) AS `min_qps`,avg(`server_statistics`.`queries_per_second`) AS `avg_qps`,std(`server_statistics`.`queries_per_second`) AS `stdev_qps` FROM `server_statistics` WHERE Creation_time < (curdate() - interval 7 day);

CREATE TABLE  `analytics_overview_data` (
`id` BIGINT( 32 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`max_os_mem_used` DOUBLE NOT NULL ,
`min_os_mem_used` DOUBLE NOT NULL ,
`avg_os_mem_used` DOUBLE NOT NULL ,
`stdev_os_mem_used` DOUBLE NOT NULL ,
`max_size` DOUBLE NOT NULL ,
`min_size` DOUBLE NOT NULL ,
`avg_size` DOUBLE NOT NULL ,
`stdev_size` DOUBLE NOT NULL ,
`max_connections` INT( 16 ) UNSIGNED NOT NULL ,
`min_connections` INT( 16 ) UNSIGNED NOT NULL ,
`avg_connections` DECIMAL( 14, 4 ) NOT NULL ,
`stdev_connections` DECIMAL( 26, 4 ) NOT NULL ,
`max_qps` FLOAT NOT NULL ,
`min_qps` FLOAT NOT NULL ,
`avg_qps` DOUBLE NOT NULL ,
`stdev_qps` DOUBLE NOT NULL ,
`Creation_time` DATETIME NOT NULL ,
INDEX (  `Creation_time` )
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT =  'data updated daily by kontroll-overview_daily.pl script';