2 votes

Partitioning vs Archiving Data for a specific use case

currently there's no performance issues but we are anticipating the growth, where at some point there's going to be issues in queries. Partitioning isn't a general query performance feature - if you ...
user avatar
1 vote

Optimise query for fetching data across multiple days in a partitioned table

Your standards are very high here and might not be attainable. As your date range increases, you get less and less benefit from partitioning by date. Indeed, it might already be counterproductive, as ...
user avatar
  • 32.6k
1 vote

MySQL partition failed

You can't compare DATE with string or any other values, the best way to do it assuming the filed type you are using is date is using an embedded function in MySQL TO_DAYS, you need to change the than (...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible