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 PHP

mysql_get_proto_info

MYSQL_GET_PROTO_INFO(3) 						 1						   MYSQL_GET_PROTO_INFO(3)

mysql_get_proto_info - Get MySQL protocol info

SYNOPSIS

       Warning

	      This  extension  is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
	      be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

		     omysqli_get_proto_info(3)

       int mysql_get_proto_info ([resource  $link_identifier = NULL])

DESCRIPTION

	Retrieves the MySQL protocol.

	      o $
		link_identifier -The MySQL connection. If the link identifier is not specified,  the  last  link  opened  by  mysql_connect(3)	is
		assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
		is found or established, an E_WARNING level error is generated.

	Returns the MySQL protocol on success or FALSE on failure.

       Example #1

	      mysql_get_proto_info(3) example

	      <?php
	      $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
	      if (!$link) {
		  die('Could not connect: ' . mysql_error());
	      }
	      printf("MySQL protocol version: %s
", mysql_get_proto_info());
	      ?>

	      The above example will output something similar to:

	      MySQL protocol version: 10

       mysql_get_client_info(3), mysql_get_host_info(3), mysql_get_server_info(3).

PHP Documentation Group 												   MYSQL_GET_PROTO_INFO(3)

MySQL DevZone RSS