https://wiki.iwillfearnoevil.com/mediawiki/index.php?action=history&feed=atom&title=Nms-database 2026-04-06T04:46:12Z Revision history for this page on the wiki MediaWiki 1.39.2 https://wiki.iwillfearnoevil.com/mediawiki/index.php?title=Nms-database&diff=322&oldid=prev 2023-06-06T20:25:20Z

<p><span dir="auto"><span class="autocomment">Database Information</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:25, 6 June 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l11">Line 11:</td> <td colspan="2" class="diff-lineno">Line 11:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* housekeeping should clean orphans on a normal cadence 'automagically' to cover when a user does something that breaks logic or orphans information.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* housekeeping should clean orphans on a normal cadence 'automagically' to cover when a user does something that breaks logic or orphans information.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* need better stored procedures investigated</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* need better stored procedures investigated</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* enable slow query logging and begin sanity checking some of the more complex queries</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <!-- diff cache key mediawiki:diff::1.12:old-321:rev-322 --> </table>

Chubbard https://wiki.iwillfearnoevil.com/mediawiki/index.php?title=Nms-database&diff=321&oldid=prev 2023-06-06T15:20:49Z

<p>Created page with &quot;=== Database Information === Currently running against database sitting on backup01. This is the old MySQL 5.7. Need to update to MariaDB for both performance as well as possible new datatype support. Work todo: * migrate to recent database release * investigate support of Postgres Reminders: * Nothing database version specific * avoid foreign key constraints. This is not common and ineffecient, however going this route will make the system more forgiving when ran...&quot;</p> <p><b>New page</b></p><div>=== Database Information ===<br /> Currently running against database sitting on backup01. This is the old MySQL 5.7. Need to update to MariaDB for both performance as well as possible new datatype support. <br /> <br /> Work todo:<br /> * migrate to recent database release<br /> * investigate support of Postgres<br /> <br /> Reminders:<br /> * Nothing database version specific<br /> * avoid foreign key constraints. This is not common and ineffecient, however going this route will make the system more forgiving when random people call API's manually to do things that ignore order of operations. People WILL do this even though they should not, might as well make sure the whole system does not burn when dumb things happen.<br /> * housekeeping should clean orphans on a normal cadence 'automagically' to cover when a user does something that breaks logic or orphans information.<br /> * need better stored procedures investigated<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> [[Category:NMS]]</div>

Chubbard