Files
tazlin 73c3ea8737 fix(stats compiles): watermark-incremental totals and BIGINT token accumulators (5.1.2)
- compile_imagegen_stats_totals/compile_textgen_stats_totals carry all-time totals forward from the previous snapshot and aggregate only rows past last_stat_id, replacing ~10 full-table scans per minute over the never-pruned 55/78 GB stats tables (~32s -> ~2.7s DB time/min); window aggregates collapse into one FILTER pass
- compiled_text_gen_stats_totals token columns and total_requests widen to BIGINT: the 30-day token sum passed the int32 ceiling on 2026-07-18 and every run since aborted on INSERT, freezing the text totals endpoints on an 11-day-old snapshot
- sql_statements/5.1.2.txt (watermark columns, BIGINT widenings, ix_users_contact, ix_users_proxy_passkey_present recorded idempotently) must be applied before this release starts, since stored procedures auto-apply on startup and the new bodies reference last_stat_id
- HORDE_VERSION 5.1.2
2026-07-28 22:00:19 -04:00

4 lines
104 B
Plaintext

SPDX-FileCopyrightText: Tazlin <tazlin.on.github@gmail.com>
SPDX-License-Identifier: AGPL-3.0-or-later