kylewolfe — 2013-01-08T12:02:11-05:00 — #1
So this is becoming amazingly over complicated...
I want a clustered table for fast read speed, (CUST_ID, ACTION_DATE) ASC
This has to be a clustered table (rows are physically stored in this order) I'm getting an error of unknown storage engine 'ndbcluster' in mysql and can find no good documentation on it.
Any help creating a clustered table on latest version of mysql please?
r937 — 2013-01-08T18:23:05-05:00 — #2
the NDBCLUSTER storage engine is used to enable running several MySQL servers in a cluster... not what you're looking for, i assume
as far as i recall, innodb tables store rows in sequence based on the primary key
however, for the fastest read speed, try myisam -- this has the disadvantage that it locks the table (not individual rows) for updates, though
kylewolfe — 2013-01-09T09:17:27-05:00 — #3
So short answer is that mysql does not have the ability to use a clustered index on more than one column that is not the primary key?
r937 — 2013-01-09T10:52:03-05:00 — #4
i cannot confirm this, but i expect it is so