{% trans 'Partitions' %} {{ Util_showMySQLDocu('partitioning') }} {% if partitions is empty %} {{ Message_notice('No partitioning defined!'|trans) }} {% else %}

{% trans 'Partitioned by:' %} {{ partition_method }}({{ partition_expression }})

{% if has_sub_partitions %}

{% trans 'Sub partitioned by:' %} {{ sub_partition_method }}({{ sub_partition_expression }})

{% endif %} {% if has_description %} {% endif %} {% for partition in partitions %} {% if has_sub_partitions %} {% else %} {% endif %} {% if has_description %} {% endif %} {% for action, icon in action_icons %} {% endfor %} {% if has_sub_partitions %} {% for sub_partition in partition.getSubPartitions() %} {% if has_description %} {% endif %} {% endfor %} {% endif %} {% endfor %}
# {% trans 'Partition' %}{% trans 'Expression' %}{% trans 'Rows' %} {% trans 'Data length' %} {% trans 'Index length' %} {% trans 'Comment' %} {% trans 'Action' %}
{{ partition.getOrdinal() }} {{ partition.getOrdinal() }}{{ partition.getName() }} {{- partition.getExpression() -}} {{- partition.getMethod() == 'LIST' ? ' IN (' : ' < ' -}} {{- partition.getDescription() -}} {{- partition.getMethod() == 'LIST' ? ')' -}} {{ partition.getRows() }} {% set data_length = Util_formatByteDown( partition.getDataLength(), 3, 1 ) %} {{ data_length[0] }} {{ data_length[1] }} {% set index_length = Util_formatByteDown( partition.getIndexLength(), 3, 1 ) %} {{ index_length[0] }} {{ index_length[1] }} {{ partition.getComment() }} {{ icon|raw }}
{{ sub_partition.getOrdinal() }} {{ sub_partition.getName() }}{{ sub_partition.getRows() }} {% set data_length = Util_formatByteDown( sub_partition.getDataLength(), 3, 1 ) %} {{ data_length[0] }} {{ data_length[1] }} {% set index_length = Util_formatByteDown( sub_partition.getIndexLength(), 3, 1 ) %} {{ index_length[0] }} {{ index_length[1] }} {{ sub_partition.getComment() }}
{% endif %}