Archive for October, 2012

pt-online-schema-change and partitions – a word of caution

Just a quick word of wisdom to those seeking to cleverly change the partitioning on a live table using a tool like pt-online-schema-change from the Percona Toolkit. You will lose data if you don't account for ALL of your data's ranges upfront. (E.g: MAXVALUE oriented partition). The reason being is how...
Read More

PHP: array_merge(array $a, [ array …]);

Wait, PHP wants to array_merge an array with... itself? Take another look at this: array_merge(array $a, [ array ...]); If you're good at reading API's - you'll see how ... odd this is. Seeing as I just got nipped in the butt by forgetting to have another array to merge into -...
Read More