cmdbuffer — Clustered version of querybuffer. Uses specialized commands instead of general table locking
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| cbid | int unsigned auto_increment | unique id | ||
| journalid | int unsigned | 0 | Journal id the command affects. This is so that all of a user's queued actions can be run before that user is potentially movedbetween clusters. | |
| cmd | varchar(30) | Text of the command name. | ||
| instime | datetime | 0000-00-00 00:00:00 | The time the query was buffered. Not used by applications, but useful for debugging/humans. | |
| args | text | A URL string of arguments. |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| cmd | INDEX | |
| journalid | INDEX |