tag:blogger.com,1999:blog-16959946.post365544942409361165..comments2023-12-09T16:44:47.897+01:00Comments on The Data Charmer: A quick usability hack with partitioningGiuseppe Maxiahttp://www.blogger.com/profile/15801583338057324813noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-16959946.post-19885732691145168472015-06-04T18:30:09.190+02:002015-06-04T18:30:09.190+02:00Excellent help. I hope i could get some answer bec...Excellent help. I hope i could get some answer because i have a big problem with my huge table.<br />I have partition a table by month (to_days) according the guideness. But when i run a query from ie '2014-03-01' to '2014-06-30' everything works find but if i expand my query from '2014-03-01' to '2014-07-30' or from '2014-04-01' to '2014-08-30' nothing works. Explain shows me the right partitions but the rows info is the amount of total rows (like if it were scanning the whole table). Im looking for several resources and i have read everyone, and i dont know where else to find because neither on spanish nor on english i could have found a solution.<br />By the way, i have 19 partitions from 2014/03-2015/06.<br />I have indexed by date_load<br />I have a composite constraint (id --autoincrement, and date_load)<br />I have tried to make index after or before partition and nothing works<br />I have tried changing the engine and nothing<br />My Mysqlserver version is 5.1 ...and something (not remember it very well).<br />Server is on Debian<br />Anonymoushttps://www.blogger.com/profile/11285265541588326574noreply@blogger.com