A deep look at MySQL 5.5 partitioning enhancements

Top Forums Web Development MySQL DevZone RSS A deep look at MySQL 5.5 partitioning enhancements

12-24-2009

Registered User

26,240, 27

Join Date: Sep 2000

Last Activity: 1 August 2008, 3:09 PM EDT

Posts: 26,240

Thanks Given: 0

Thanked 27 Times in 26 Posts

A deep look at MySQL 5.5 partitioning enhancements

The release of MySQL 5.5 has brought several enhancements. While most of the coverage went, understandably, to the semi-synchronous replication, the enhancements of partitioning were neglected, and sometimes there was some degree of misunderstanding on their true meaning. With this article, we want to explain these cool enhancements, especially the parts that were not fully understood.

More...

Linux Bot

View Public Profile for Linux Bot

Find all posts by Linux Bot

Previous Thread | Next Thread

4 More Discussions You Might Find Interesting

1. Programming

Deep copy of structure in C

Hi , I have a scenario where i need to copy the iter to another local variable , where iter is of type MCC_T_SYS_ADDRINFO *iter . struct addrinfo { int ai_flags; int ai_family; int ai_socktype; int ai_protocol; ...

2. Shell Programming and Scripting

email enhancements

can i create an email which can handle links, or email links, using mailx or any other utility

3. Shell Programming and Scripting

recursion too deep

I am running a korn shell script which has a recursive function. The script ran for 117 iterations and ended up with the following error "recursion too deep". what should be done to avert this? Thanks in advance Swamy p.s. I am on UNIX MPRAS V4

4. UNIX for Dummies Questions & Answers

I need to ls all files in 4-6 deep dirs

I need to print to file , a listing of all files below a certain directory. Example: I need to print to file a listing of all files below the etc dir (including the subdirectories) with their full path. Any ideas on how to do this with one command. Or is this something I need to do on all...

LEARN ABOUT DEBIAN

mysql::diff

MySQL::Diff(3pm)					User Contributed Perl Documentation					  MySQL::Diff(3pm)

NAME

       MySQL::Diff - Generates a database upgrade instruction set

SYNOPSIS

	 use MySQL::Diff;

	 my $md = MySQL::Diff->new( %options );
	 my $db1 = $md->register_db($ARGV[0], 1);
	 my $db2 = $md->register_db($ARGV[1], 2);
	 my $diffs = $md->diff();

DESCRIPTION

       Generates the SQL instructions required to upgrade the first database to match the second.

METHODS

   Constructor
       new( %options )
	   Instantiate the objects, providing the command line options for database access and process requirements.

   Public Methods
       Fuller documentation will appear here in time :)

       o   register_db($name,$inx)

	   Reference the database, and setup a connection. The name can be an already existing 'MySQL::Diff::Database' database object. The index
	   can be '1' or '2', and refers both to the order of the diff, and to the host, port, username and password arguments that have been
	   supplied.

       o   db1()

       o   db2()

	   Return the first and second databases registered via "register_db()".

       o   diff()

	   Performs the diff, returning a string containing the commands needed to change the schema of the first database into that of the
	   second.

COPYRIGHT AND LICENSE

       Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

SEE ALSO

       mysqldiff, MySQL::Diff::Database, MySQL::Diff::Table, MySQL::Diff::Utils

AUTHOR

       Adam Spiers <mysqldiff@adamspiers.org>

perl v5.14.2							    2012-04-06							  MySQL::Diff(3pm)

MySQL DevZone RSS