'partitioning' Tag

  • common_schema 1.2: security, partition management, processes, QueryScript goodies

    November 13, 2012

    common_schema 1.2 is released! This version comes shortly after 1.1, yet contains quite a few interesting goodies: Account blocking Security audit RANGE partition management Slave status Better blocking and idle transaction management QueryScript goodies: echo, report while-otherwise statement; foreach-otherwise statement Better variable scope handling Complete support for variable expansion Transaction support within QueryScript More summary […]

  • Your magical RANGE partitioning maintenance query

    October 9, 2012

    If you use RANGE (or RANGE COLUMNS) partitioning, and in particular when partitioning by date/time, then your are subject to the following questions: how and when do you create the "next" partition? How and when do you drop your older partitions? Many people use in-house scripting to do that, and Giuseppe Maxia wrote Partition Helper. […]

Powered by Wordpress and MySQL. Theme by openark.org