Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 2

Displaying posts with tag: Plans (reset)

MySQL bug 69179 – INFORMATION_SCHEMA.PARTITIONS causes query plan changes
+1 Vote Up -0Vote Down

Shard-Query examines INFORMATION_SCHEMA.PARTITIONS to determine if a table is partitioned.  When a table is partitioned, Shard-Query creates multiple background queries, each limited to a single partition.  Unfortunately, it seems that examining INFORMATION_SCHEMA.PARTITIONS causes query plans to change after the view is accessed.

I have reported bug 69179 to MySQL AB  Oracle Corporation(old habits die hard).

Be careful: If you have automated tools (like schema management GUI tools) then make sure they …

  [Read more...]
Settling in for a Winter's Blogfest
+0 Vote Up -0Vote Down

This is the 1st post in my MoFo Futures 2009 blog series. | Post 2 »

Christmas is nearly upon the Christian and Consumerist parts of the globe. Along much of my latitude, snow is piling up in record quantities and weather warnings abound. Even in oft-green Vancouver, there is a foot or so of the white stuff accumulated in my yard and the parking lot outside my window often echos with the sounds of snow-beached cars helplessly spinning their wheels.

Usually all these things taken together would mean a series of harrowing drives to visit family, followed by lovely hours staying warm …

  [Read more...]
Showing entries 1 to 2

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.