A deep look at MySQL 5.5 partitioning enhancements

 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS A deep look at MySQL 5.5 partitioning enhancements
# 1  
Old 12-24-2009
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...
Login or Register to Ask a Question

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; ... (5 Replies)
Discussion started by: breezevinay
5 Replies

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 Replies)
Discussion started by: anumkoshy
3 Replies

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 (3 Replies)
Discussion started by: swamy455
3 Replies

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... (4 Replies)
Discussion started by: gforty
4 Replies
Login or Register to Ask a Question
MYSQLND_MS_MATCH_WILD(3)						 1						  MYSQLND_MS_MATCH_WILD(3)

mysqlnd_ms_match_wild - Finds whether a table name matches a wildcard pattern or not

SYNOPSIS
bool mysqlnd_ms_match_wild (string $table_name, string $wildcard) DESCRIPTION
Finds whether a table name matches a wildcard pattern or not. This function is not of much practical relevance with PECL mysqlnd_ms 1.1.0 because the plugin does not support MySQL replication table filtering yet. PARAMETERS
o $table_name - The table name to check if it is matched by the wildcard. o $wildcard - The wildcard pattern to check against the table name. The wildcard pattern supports the same placeholders as MySQL replication filters do. MySQL replication filters can be configured by using the MySQL Server configuration options --replicate-wild-do-table and --replicate-wild-do-db. Please, consult the MySQL Reference Manual to learn more about this MySQL Server feature. The sup- ported placeholders are: o % - zero or more literals o _ - one literal Placeholders can be escaped using . RETURN VALUES
Returns TRUE table_name is matched by wildcard. Otherwise, returns FALSE EXAMPLES
Example #1 mysqlnd_ms_match_wild(3) example <?php var_dump(mysqlnd_ms_match_wild("schema_name.table_name", "schema%")); var_dump(mysqlnd_ms_match_wild("abc", "_")); var_dump(mysqlnd_ms_match_wild("table1", "table_")); var_dump(mysqlnd_ms_match_wild("asia_customers", "%customers")); var_dump(mysqlnd_ms_match_wild("funny%table","funny\%table")); var_dump(mysqlnd_ms_match_wild("funnytable", "funny%table")); ?> The above example will output: bool(true) bool(false) bool(true) bool(true) bool(true) bool(true) PHP Documentation Group MYSQLND_MS_MATCH_WILD(3)