I am willing to consider that we would need to switch to another database solution to handle this volume of data, but would like a solution for MySQL in the interim if possible. For suggestions of ...