Database Issues
I’ve been trying to prune old prices from the raw prices table all day and it’s caused some severe performance problems for this entire server. For whatever reason, MySQL is not happy with that table and is taking obscenely long to delete records and/or drop old indexes that are no longer needed. We had to kill the server outright and I’m now doing some table repairs. I believe all the apps should still work, but medians may not get updated tomorrow depending on how bad a state the tables are in.
Any MySQL gurus out there? Is there a reason dropping an index from a table would take forever and a day?