MySQL Forums
Forum List  »  Partitioning

Re: partition mgmt on windows
Posted by: Mark Matthews
Date: December 15, 2005 03:46PM

Mikael Ronstrom wrote:
> Bill MacKenzie wrote:
> > using 5.1.3 on win 2003 server
> >
> > Hi all - trying to use add partition, drop
> > partition on windows but doesn't work. are
> these
> > statements enabled for windows?
>
> They should be activated yes, don't know of any
> specialty for Windows here
> although I've never tried using it on Windows
> myself.
>
> linux? also, why
> > is symbolic linking not enabled on this
> alpha
> > release?
>
> Don't know
>
> is data directory/index directory ever
> > going to enabled? Thanks
>
> I've heard something of a bug report in this area
> so it's supposed to work but will work as soon
> as the bug is fixed.
>
> Rgrds Mikael

Are you testing partitioning using the "mysqld-max.exe" binary? Partitioning is only enabled in "max" builds currently. I tested 5.1.3 on windows running "-max", and the examples in the manual work as expected. However, the "standard" binary didn't work correctly, and failed as you described. Therefore, I'd make sure you're using the -max binary before testing further.

Unfortunately, if you use the standard "mysqld.exe" binary, partition creation will fail silently, leaving you with whatever the engine that was specified as a non-partitioned table, which the partition management statemens will not work against (but once again, fail silently).

This is an existing bug, see http://bugs.mysql.com/bug.php?id=15561

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html

Options: ReplyQuote


Subject
Views
Written By
Posted
4620
December 12, 2005 03:42PM
2423
December 14, 2005 12:23PM
Re: partition mgmt on windows
2706
December 15, 2005 03:46PM


Sorry, you can't reply to this topic. It has been closed.

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.