readonly_user

readonly_user — Global. Used by the move user cluster script. Both before and after updating a user's read-only flag we add the user to this table, which is just an index onto users who - might - be in read-only. A maintenance task will periodically clean those and make sure nobody is stranded in read-only, without resorting to a full tablescan of the user table, by checking if users are still locked, removing those that are not from this table, querying the job server (if up) for users that are still locked and unlocking those that can be unlocked.

readonly_user

Column name Type Null Default Description
userid int unsigned   0  
Key name Type Column(s)
PRIMARY PRIMARY