Default partitioning scheme-opracowanie

Nasza ocena:

Wyświetleń: 399
Komentarze: 0

Pobierz ten dokument za darmo

Podgląd dokumentu
Default partitioning scheme-opracowanie - strona 1

Fragment notatki:

Default partitioning scheme. All MySQL Cluster tables are by default partitioned by KEY using
the table's primary key as the partitioning key. If no primary key is explicitly set for the table, the
“hidden” primary key automatically created by the NDB storage engine is used instead. For additional
discussion of these and related issues, see Section 18.2.5, “KEY Partitioning”.
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDBCLUSTER
table not to meet either or both of the following two requirements are not permitted, and fail with an
1. The table must have an explicit primary key.
2. All columns listed in the table's partitioning expression must be part of the primary key.
... zobacz całą notatkę

Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz