MySQL Document Summary continued

Here are the notes for reading the official MySQL document 6-10:

MySQL permissions settings: stored in MySQL database contains a table

1. User's most important permission setting table, all accounts, global permissions

2. DB database level permissions settings

3, TABLES_PRIV data table level of permission settings

4. Colums_priv permission settings at the row level

5, Proc_priv stored procedures, functions of the permission settings

MySQL permissions verification generally first check the user table if passed then authorize, no then continue the DB table, if passed then add to the user table, and authorize, continuation of the above rules ...

MySQL generally loads all the permission tables into memory at startup, if you do the following,, GRANT REVOKE SET PASSWORD orRENAME USER命令，mysql会立即重新加载grant table；

If you modify the grant table, such as INSERT, uodate, it will not take effect unless MySQL restart or executes the flush privileges command. MySQL's change in permissions is generally for the next request

MySQL optimization:

1:mysql the new version no longer evaluates whether the index is used or not, but will evaluate various factors such as table size, number of rows, and I/O block size.

MySQL Document Summary continued