Timeline for WordPress MySQL writes during "Flush Tables With Read Lock" are rejected instead of being queued
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Nov 21, 2014 at 16:28 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
added 148 characters in body
|
| Nov 21, 2014 at 15:52 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
added 833 characters in body
|
| Nov 21, 2014 at 15:22 | comment | added | Dan |
sorry, the color coding got me. FLUSH TABLES WITH READ LOCK is the same statement I've been trying. So the problem is the OTHER statement, this one? SET GLOBAL read_only = ON;
|
|
| Nov 21, 2014 at 15:19 | comment | added | Dan | <br> <br/>**Regarding the 2 recommendations ** <br/>1.) Looking to stay with MyISAM at this point <br/> <br/>2.) Replication: need to stay with a single server for the time being. Figured I'd go to replication eventually. <br/>That said, is there any major reason to NOT install a 2nd MySQL instance (the slave) on the same server? docs on that seem pretty clear. <br/>Currently on 15k SAS RAID 1, but plan on upgrading to similar system with SSD RAID 0 as soon as possible/feasible. | |
| Nov 21, 2014 at 15:16 | comment | added | RolandoMySQLDBA |
Please look back at my answer. I didn't say FLUSH TABLES LOCK;. I said FLUSH TABLES WITH READ LOCK;.
|
|
| Nov 21, 2014 at 15:12 | comment | added | Dan |
Thanks for the in-depth answer!! > Just remove read_only Your first answer to my original question - above the 2 recommendations - I can't seem to make that work. mysql> flush tables lock; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lock' at line 1 Am I missing something? sounds like that WOULD absolutely be what I'm trying to do at this point.
|
|
| Nov 21, 2014 at 13:05 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |