Database Reference
In-Depth Information
Although the profiling system can report additional information about
operations (such as, the CPU time, and even the internal server's function names),
phpMyAdmin currently displays only the name of the operation and its duration.
Partitioning
User-defined partitioning (
http://dev.mysql.com/doc/refman/5.1/en/
partitioning.html
) is offered in MySQL 5.1. Using this feature in phpMyAdmin
requires knowledge of its syntax because there are many partition types. Also, for
each partition type, the number of partitions and the values associated with each
partition are too random to be easily represented on a web interface.
Table creation
Let's try it by creating a table named
test
with one field. On the table creation
panel, if connected to a MySQL 5.1 server, phpMyAdmin shows a
PARTITION
definition
dialog:
Here, we type in a
PARTITION BY RANGE
clause, which will create partitions on
the
id
column.
Search WWH ::
Custom Search