We currently have a MySQL data set that was started about 10 years ago that aggregates a log of data, and accumulates millions of rows each month. The people that developed our system started separating the data into months, however they did this by creating an entirely new database with that month name (e.g. jan2001, mar2009, aug2012), and one table in each database named "detail". Each month a cronjob kicks off and spins up and entirely new database, with the table "detail", and the application starts writing the data to said table.
At this point the combined number of rows in all the "detail" tables is 448,231,722. This data is only used for analytics purposes at this point, so the speed of the query returning the data does not need to be instantaneous. One assumption we have is that the data will never be deleted.
I am wondering if you could suggest a better method of condensing or consolidating the data into a more manageable schema?