Database

Table Name Purpose
GridUser table gets entries for everyone who uses the grid, local and foreign
UserAccounts table is just that – local accounts

Performance

MySQL Performance Flowchart (rackerhacker)
Optimize MySQL Performance with mysqltuner (mediakey)