tag:blogger.com,1999:blog-15319370.post6531770173905277751..comments2024-03-29T12:51:32.931+01:00Comments on Roland Bouman's blog: MySQL: Partition-wise backups with mysqldumprpboumanhttp://www.blogger.com/profile/13365137747952711328noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-15319370.post-24870745212305689832012-11-26T22:15:11.008+01:002012-11-26T22:15:11.008+01:00I'm interested in your partition backup script...I'm interested in your partition backup script, but the page on forge.mysql.com is no longer available.<br /><br />Can you post it somewhere else?<br /><br />ThanksLeehttps://www.blogger.com/profile/04485224114756179007noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-70200426626459564712012-09-03T15:31:15.526+02:002012-09-03T15:31:15.526+02:00set global innodb_stats_on_metadata=0
see http://...set global innodb_stats_on_metadata=0<br /><br />see http://www.mysqlperformanceblog.com/2011/12/23/solving-information_schema-slowness/Anonymoushttps://www.blogger.com/profile/02016932804110818760noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-18921742319041555922012-09-03T15:29:53.504+02:002012-09-03T15:29:53.504+02:00set global innodb_stats_on_metadata=0
see http://...set global innodb_stats_on_metadata=0<br /><br />see http://www.mysqlperformanceblog.com/2011/12/23/solving-information_schema-slowness/Anonymoushttps://www.blogger.com/profile/02016932804110818760noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-68129716003493944582010-08-23T20:40:05.163+02:002010-08-23T20:40:05.163+02:00Anonymous, the script is at MySQL Forge:
http://f...Anonymous, the script is at MySQL Forge:<br /><br />http://forge.mysql.com/tools/tool.php?id=258rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-90249046023245810072010-08-23T19:55:05.112+02:002010-08-23T19:55:05.112+02:00The script is where ?The script is where ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-45463369892275932592010-03-30T16:17:37.375+02:002010-03-30T16:17:37.375+02:00Mattias,
thanks for this suggestion! It is a ver...Mattias, <br /><br />thanks for this suggestion! It is a very interesting plan.<br /><br />Currently I use the partitioning expression as-is from the information_schema.PARTITIONS table.<br /><br /><br />I guess that I would need to parse those expressions and rewrite them - I am not sure this will be so simple. What worries me a bit is that a simplistic rewrite could introduce an error and mess up the backup. <br /><br />Do you have a suggestion to solve this issue?<br /><br />Thanks in advance, and kind regards.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-38986738986927032862010-03-30T15:47:20.793+02:002010-03-30T15:47:20.793+02:00Hi, if you change the where clause from
"YEA...Hi, if you change the where clause from <br />"YEAR(joined) < 1960"<br />"YEAR(joined) >= 1960 and YEAR(joined) < 1970"<br />to<br />"joined < '1960-01-01' or YEAR(joined) is NULL"<br />"joined >= '1960-01-01' and joined < '1970-01-01' AND YEAR(joined) is not NULL"<br /><br />Then it would also make use of pruning for all partitions accept the first.<br /><br />For YEAR, 'is [not] NULL' is not neccessary, but for TO_DAYS it is, since all rows where the partitioning expression evaluates to NULL will end up in the first partition.<br /><br />(Have not tried it though...)Unknownhttps://www.blogger.com/profile/17754461110335991577noreply@blogger.com