database:mysql:locktable
差異處
這裏顯示兩個版本的差異處。
| Both sides previous revision 前次修改 下次修改 | 前次修改 | ||
|
database:mysql:locktable [2014/01/11 12:09] ali88 |
database:mysql:locktable [2014/01/11 14:49] (目前版本) ali88 |
||
|---|---|---|---|
| 行 40: | 行 40: | ||
| - | ====Lock tables QQ LOW_PRIORITY write==== | + | ====Lock tables QQ LOW_PRIORITY write(此項指令在 MySQL 5.5.x以上式忽已經失效了)==== |
| * 降低write lock 優先權 使 read lock 優先權提高 | * 降低write lock 優先權 使 read lock 優先權提高 | ||
| 行 46: | 行 46: | ||
| | |mysql>lock tables QQ write; | | | | | |mysql>lock tables QQ write; | | | | ||
| | | |mysql>lock tables QQ read;(在write Queue中 等待) | | | | | |mysql>lock tables QQ read;(在write Queue中 等待) | | | ||
| - | | | | |mysql>lock tables QQ write;(在write Queue中 等待) | | + | | | | |mysql>lock tables QQ LOW_PRIORITY write;(在write Queue中 等待) | |
| | |mysql>unlock tables; |mysql>Query OK, 0 rows affected (剛在等待的 lock tables QQ read;被執行) | | | | |mysql>unlock tables; |mysql>Query OK, 0 rows affected (剛在等待的 lock tables QQ read;被執行) | | | ||
| - | | | |mysql>unlock tables; | mysql>Query OK, 0 rows affected (剛在等待的 lock tables QQ write;被執行) | | + | | | |mysql>unlock tables; | mysql>Query OK, 0 rows affected (剛在等待的 lock tables QQ LOW_PRIORITY write;被執行) | |
| | | | |mysql>unlock tables; | | | | | |mysql>unlock tables; | | ||
database/mysql/locktable.1389442176.txt.gz · 上一次變更: 2014/01/11 12:09 由 ali88
若無特別註明，本 wiki 上的內容都是採用以下授權方式： CC Attribution-Share Alike 3.0 Unported
