Pinned Loading

1. html5up-readonly html5up-readonly Public

   Jekyll Theme based on https://html5up.net/read-only

   JavaScript 1 1

2. shell-scripts shell-scripts Public

   Collection of shell scripts for linux servers

   Shell 1

3. world-maps world-maps Public

   Playing around with various world map projections.

   HTML 1

4. For the given database table, determ... For the given database table, determine a lower varchar limit that could be used for each varchar column.

   1

   <?php

   2

   3

   // WARNING: unsafe script, possible sql injection, it should use mysqli::real_escape_string().

   4

   // But I needed a quick simple script to find columns that I could be safely shrink. 

   5

5. Monitor open tables to determine wha... Monitor open tables to determine what tables are actively used across all databases.

   1

   <?php

   2

   3

   // Goal: Call regularly to build a list of which tables (and database schemas) that are most frequently used.

   4

   // IE: place in crontab or similar, run every few minutes, and review after a week.

   5

   // polls "open tables", and updates "list.csv", format: "datbase,table,count".