MySQL causes nothing but problems, and is pretty much only used:
a) ~~as a transmission medium between the wiki and the bot~~
b) as a transmission medium between notification systems and the bot
c) as a place to store config files
Examples of the problems we have regularly:
* Objects crossing sessions/txns
* Txns not being committed
* Objects not being refreshed between commands/sessions
* Write conflicts
* Slow read/write performance on underlying schema
* ~~Integration with hmbwiki isn't great and makes dev harder~~
These are the tables we currently have in the schema:
| Table name | Usage status |
|-------------------|-------|
|`blockmonitor` | Could be merged into `channel`
|`categoryitems` |
|`channel` |
|`channelwatchers` |
|`crosschannel` |
|`flagaccesslog` |
|`flaggroup` |
|`flaggroup_user` |
|`ignoredpages` |
|`interwikiprefix` |
|`keywords` |
|`message` |
|`shorturlcache` |
|`site` |
|`user` |
|`watcher` |
|`welcomeroverride` |
|`welcomeusers` |