# 운영 slow log 파일 항목별 목록 (시각, 실행 시간, 검사 행 수 — SQL 본문 제외)
# 실행: 2026-09-15 작업 후, 서버에서 sudo awk (07-post-analysis.md)
# 해석 (mariadb-dumpslow 결과와 대조):
#   - 매일 04:00 약 5초: best_record 전체 SELECT (mysqldump 백업, 182.217.174.221에서 접속)
#   - 9/7 17:44~18:07: 같은 백업 SELECT 반복 (백업 스크립트 작업일)
#   - 9/15 23:04~23:05: 이번 작업의 전체 백업 덤프 (best_record, app_highest_record)
#   - 9/15 23:08~23:09: 이번 작업의 중복 DELETE, ALTER (기준 0.5초 구간)
#   → 애플리케이션 쿼리는 한 건도 없음
260411 0:33:48 query_time=3.726172 rows_examined=960302
260720 13:17:19 query_time=8.465366 rows_examined=1152373
260907 11:07:44 query_time=4.731627 rows_examined=1205709
260907 17:44:24 query_time=5.373405 rows_examined=1207886
260907 17:47:40 query_time=5.050474 rows_examined=1207886
260907 17:49:33 query_time=5.715444 rows_examined=1207887
260907 17:56:10 query_time=5.223918 rows_examined=1207889
260907 17:59:55 query_time=5.035981 rows_examined=1207891
260907 18:03:59 query_time=4.990276 rows_examined=1207894
260907 18:07:19 query_time=6.269200 rows_examined=1207895
260907 22:08:15 query_time=5.216182 rows_examined=1207992
260908 4:00:04 query_time=5.407491 rows_examined=1205749
260908 16:45:30 query_time=5.190510 rows_examined=1196675
260909 4:00:03 query_time=5.027793 rows_examined=1196916
260910 4:00:04 query_time=5.324048 rows_examined=1199920
260911 4:00:04 query_time=5.302520 rows_examined=1201807
260912 4:00:03 query_time=5.428563 rows_examined=1204565
260913 4:00:04 query_time=5.146780 rows_examined=1204942
260914 4:00:03 query_time=5.309808 rows_examined=1205500
260915 4:00:04 query_time=5.348284 rows_examined=1207030
260915 23:04:05 query_time=0.671469 rows_examined=229443
260915 23:04:07 query_time=4.840010 rows_examined=1210525
260915 23:05:00 query_time=0.659826 rows_examined=229443
260915 23:05:01 query_time=4.653876 rows_examined=1210525
260915 23:08:21 query_time=0.929698 rows_examined=935362
260915 23:09:08 query_time=4.790929 rows_examined=0
260915 23:09:13 query_time=4.819872 rows_examined=0
260915 23:09:18 query_time=0.723314 rows_examined=0
260915 23:09:19 query_time=1.063310 rows_examined=0
