cmdbuffer

cmdbuffer — Clustered. This replaced the global querybuffer table. That table was used to hold queries to do later, in an efficient batch under an explicit table lock. By contrast, this table is used with specialized commands rather than general table locking.

cmdbuffer

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 moved between 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