Consider switching DB to MySQL

Question

mcantelon opened this issue a year ago · 2 comments

This is apparently a very simple switch. Might mean a slight tweak to some of our schema (adding limits to VARCHARs where they're not present?).

Answer 1 · 2024-01-12T18:16:22.000Z

According to Santi, "creating an index for aip.create_time makes the storage_locations_usage_over_time go from 44s to generate, to 18s".

ALTER TABLE aipscan.aip ADD INDEX create_date_index (create_date);

ALTER TABLE aipscan.file ADD INDEX date_created_index (date_created);

Answer 2 · 2024-01-15T22:38:12.000Z

A PR's been created and approved that allows MySQL use.