6 reputation
2
bio website
location
age
visits member for 1 year, 11 months
seen Feb 13 '13 at 7:23

Mar
6
awarded  Student
Dec
6
awarded  Editor
Dec
6
revised Is there a way to write intelligent queries against a merge table in MySQL that represents a bunch of tables partitioned by date?
added 804 characters in body
Dec
6
comment Is there a way to write intelligent queries against a merge table in MySQL that represents a bunch of tables partitioned by date?
The resulting merge table has about 400 million rows and is 188GB. The table I'm trying to join it to is 39 million rows and 40GB
Dec
6
comment Is there a way to write intelligent queries against a merge table in MySQL that represents a bunch of tables partitioned by date?
So, if I understand you correctly, you're saying that I should add a column defined as date(<my datetime column>) and index that, and then start all my joins with that column. Correct?
Dec
6
comment Is there a way to write intelligent queries against a merge table in MySQL that represents a bunch of tables partitioned by date?
Sure would be nice if returns worked in comments...
Dec
6
comment Is there a way to write intelligent queries against a merge table in MySQL that represents a bunch of tables partitioned by date?
Here's how the merge table is defined: CREATE TABLE table_a ( <a bunch of columns and indexes> ) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 UNION=( <a bunch of tables> );
Dec
5
asked Is there a way to write intelligent queries against a merge table in MySQL that represents a bunch of tables partitioned by date?