db_driver=mysql db_version=8.0.42-0ubuntu0.20.04.1 MYSQL.innodb_buffer_pool_instances=8 MYSQL.innodb_buffer_pool_size=2147483648 MYSQL.innodb_file_per_table=ON MYSQL.innodb_flush_log_at_trx_commit=1 MYSQL.innodb_flush_method=fsync MYSQL.innodb_io_capacity=200 MYSQL.innodb_log_file_size=50331648 MYSQL.innodb_read_io_threads=4 MYSQL.innodb_redo_log_capacity=104857600 MYSQL.innodb_write_io_threads=4 MYSQL.interactive_timeout=28800 MYSQL.join_buffer_size=262144 MYSQL.long_query_time=1.000000 MYSQL.max_allowed_packet=67108864 MYSQL.max_connections=151 MYSQL.max_execution_time=0 MYSQL.max_heap_table_size=67108864 MYSQL.net_read_timeout=30 MYSQL.net_write_timeout=60 MYSQL.optimizer_switch=index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,use_invisible_indexes=off,skip_scan=on,hash_join=on,subquery_to_derived=off,prefer_ordering_index=o MYSQL.performance_schema=ON MYSQL.read_buffer_size=131072 MYSQL.read_rnd_buffer_size=262144 MYSQL.slow_query_log=ON MYSQL.sort_buffer_size=262144 MYSQL.sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION MYSQL.table_open_cache=4000 MYSQL.thread_cache_size=9 MYSQL.tmp_table_size=67108864 MYSQL.wait_timeout=28800 --- DB STATUS COUNTERS --- STATUS.Aborted_connects=0 STATUS.Created_tmp_disk_tables=6 STATUS.Created_tmp_files=11 STATUS.Created_tmp_tables=81 STATUS.Handler_read_key=12326169 STATUS.Handler_read_rnd_next=273477696 STATUS.Innodb_buffer_pool_pages_free=8192 STATUS.Innodb_buffer_pool_pages_total=131072 STATUS.Innodb_buffer_pool_read_requests=302606298 STATUS.Innodb_buffer_pool_reads=5423937 STATUS.Innodb_data_reads=5426369 STATUS.Innodb_data_writes=3030 STATUS.Max_used_connections=5 STATUS.Questions=17702 STATUS.Select_full_join=46 STATUS.Slow_queries=61 STATUS.Threads_connected=2 STATUS.Threads_running=3 STATUS.Uptime=70393 --- TABLE METADATA ESTIMATES --- TABLE.actions engine=InnoDB estimated_rows=19934 data_mb=1.5 index_mb=0.0 TABLE.incident_data engine=InnoDB estimated_rows=107705 data_mb=24.5 index_mb=29.7 TABLE.perpetrators engine=InnoDB estimated_rows=9579444 data_mb=5247.0 index_mb=810.8 TABLE.relations engine=InnoDB estimated_rows=29 data_mb=0.0 index_mb=0.0 TABLE.services engine=InnoDB estimated_rows=12 data_mb=0.0 index_mb=0.0 TABLE.victim engine=InnoDB estimated_rows=84076 data_mb=8.5 index_mb=7.5 --- INDEX DEFINITIONS FOR RELEVANT TABLES --- INDEX.actions.actions_uuid_unique.1=uuid INDEX.actions.idx_actions_victim_id.1=victim_id INDEX.actions.PRIMARY.1=id INDEX.incident_data.idx_districtid.1=districtid INDEX.incident_data.idx_parishid.1=parishid INDEX.incident_data.idx_subcountyid.1=subcountyid INDEX.incident_data.incident_data_uuid_unique.1=uuid INDEX.incident_data.incident_date_id_idx.1=incident_date INDEX.incident_data.incident_date_id_idx.2=id INDEX.incident_data.incident_district_date_idx.1=districtid INDEX.incident_data.incident_district_date_idx.2=incident_date INDEX.incident_data.incident_dup_check_idx.1=victimid INDEX.incident_data.incident_dup_check_idx.2=incidentid INDEX.incident_data.incident_dup_check_idx.3=incident_date INDEX.incident_data.incident_owner_date_idx.1=created_by INDEX.incident_data.incident_owner_date_idx.2=incident_date INDEX.incident_data.incident_type_date_idx.1=incidentid INDEX.incident_data.incident_type_date_idx.2=incident_date INDEX.incident_data.PRIMARY.1=id INDEX.perpetrators.idx_perpetrators_victimid_relation.1=victimid INDEX.perpetrators.idx_perpetrators_victimid_relation.2=relation INDEX.perpetrators.perpetrators_uuid_unique.1=uuid INDEX.perpetrators.PRIMARY.1=id INDEX.victim.idx_districtid.1=districtid INDEX.victim.idx_parishid.1=parishid INDEX.victim.idx_subcountyid.1=subcountyid INDEX.victim.idx_victim_created_by.1=created_by INDEX.victim.PRIMARY.1=id INDEX.victim.victim_crb_date_district_idx.1=crb_number INDEX.victim.victim_crb_date_district_idx.2=interview_date INDEX.victim.victim_crb_date_district_idx.3=districtid INDEX.victim.victim_survivor_date_district_idx.1=survivor_code INDEX.victim.victim_survivor_date_district_idx.2=interview_date INDEX.victim.victim_survivor_date_district_idx.3=districtid INDEX.victim.victim_uuid_unique.1=uuid