Limitations on tables w/o primary keys

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi,

Just noticed that :-

“DELETE operation is unsupported on tables without primary key. Also rows in tables without primary key may appear in different order on different nodes. As a result SELECT…LIMIT… may return slightly different sets.”

has been removed from [url]Percona XtraDB Cluster but is still present in the pdf manual. Has that limitation been removed and the pdf not yet updated or is the web page wrong?

Thanks

Ben

2

This limitation was lifted when this feature was added: [url]Percona XtraDB Cluster

However, it’s still generally a best practice to have explicit PKs. If you don’t define them, then you will have in implicit hidden 6-byte PK in your Innodb table taking up space that you can’t use for any querying. Innodb is very much optimized towards PK lookups, so it benefits you to have one you can query by.