Diff -- /var/www/vhosts/3dshawn.com/site1/TEMPLATES/table_locks.html
Diff
/var/www/vhosts/3dshawn.com/site1/TEMPLATES/table_locks.html
added on local at 2026-07-10 18:57:32
Added
+22
lines
Removed
-0
lines
Context
0
unchanged
Blobs
from
to 9d9c50ed3b30
to 9d9c50ed3b30
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.| 1 | <div class="page-head"> | |
| 2 | <span class="page-eyebrow"><span class="dot"></span> Monitor</span> | |
| 3 | <h1 class="page-title">Table locks</h1> | |
| 4 | <p class="page-subtitle">Snapshots of MySQL <code>SHOW OPEN TABLES</code> over time. Helpful for spotting long-held locks that stall the app.</p> | |
| 5 | </div> | |
| 6 | <div class="module glow-rose"> | |
| 7 | <div class="module-head"><div class="left"> | |
| 8 | <div class="module-icon"><svg viewBox="0 0 24 24" width="14" height="14" fill="none" stroke="currentColor" stroke-width="2"><rect x="3" y="11" width="18" height="11" rx="2"/><path d="M7 11V7a5 5 0 0 1 10 0v4"/></svg></div> | |
| 9 | <div class="module-title">Lock history</div><span class="module-subtitle">$total events. Most recent first.</span> | |
| 10 | </div></div> | |
| 11 | <div class="module-body tight"> | |
| 12 | [if:$has_rows] | |
| 13 | <table class="tbl"> | |
| 14 | <thead><tr><th>DB.Table</th><th style="width:110px">Server</th><th style="width:80px">In use</th><th style="width:100px">Name locked</th><th style="width:160px">When</th></tr></thead> | |
| 15 | <tbody> | |
| 16 | [loop:@rows]<tr><td class="mono"><strong>$db_name</strong>.<span class="dim">$table_name</span></td><td class="dim">$server_name</td><td class="mono">$in_use</td><td class="mono">$name_locked</td><td class="mono dim">$date_time</td></tr>[/loop] | |
| 17 | </tbody> | |
| 18 | </table> | |
| 19 | [/if] | |
| 20 | [if:!$has_rows]<div style="padding:36px 14px;text-align:center;color:var(--text-dim);font-size:13.5px">No lock events captured.</div>[/if] | |
| 21 | </div> | |
| 22 | </div> |