source_link_id, destination_link_id_list [,parameters])


A UDF installed with the Spider Storage Engine, this function copies table data from source_link_id to destination_link_id_list. The service does not need to be stopped in order to copy.

If the Spider table is partitioned, the name must be of the format table_name#P#partition_name. The partition name can be viewed in the mysql.spider_tables table, for example:

SELECT table_name FROM mysql.spider_tables;
| table_name  |
| spt_a#P#pt1 |
| spt_a#P#pt2 |
| spt_a#P#pt3 |

Returns 1 if the data was copied successfully, or 0 if copying the data failed.


Comments loading...