LIMIT 原きで UPDATE を佩うと採絞鏑られるか
?
0 likes?1,170 views
The document discusses MySQL replication and how updates and limits work in a master-slave replication setup. Specifically, it notes that updates on the master are replicated to slaves and the order of rows may change due to sorting from an ORDER BY clause or the automatic reordering of rows that occurs in B-tree indexes. It also mentions that the LIMIT clause only affects the results returned to the client and does not limit the number of rows updated on the master or replicated to slaves.
LIMIT 原きで UPDATE を佩うと採絞鏑られるか
- 1. LIMIT UPDATE @yuya_takeyama 2011 7 2
- 2. MySQL5 2011 7 2
- 3. !!! !!! UPDATE LIMIT ORDER BY Master/Slave => 2011 7 2
- 4. Why? 2011 7 2
- 5. 2011 7 2
- 6. 1 Master N Slave 2011 7 2
- 7. 1 Master N Slave 2011 7 2
- 8. SQL 2011 7 2
- 9. 2011 7 2
- 10. @nippondanji Art of MySQL Replication http://www.slideshare.net/nippondanji/art-of-mysql-replication-4824469 2011 7 2
- 11. B-Tree 2011 7 2
- 12. ID 1 Richard 24 2 Tom 64 3 Aaron 23 4 Tony 12 5 Ritchie 33 6 Jimmy 47 7 Eric 53 8 James 5 9 Kirk 84 10 Lars 43 2011 7 2
- 13. ID 3 Aaron 23 7 Eric 53 8 James 5 6 Jimmy 47 9 Kirk 84 10 Lars 43 1 Richard 24 5 Ritchie 33 2 Tom 64 4 Tony 12 2011 7 2
- 14. 2011 7 2
- 15. 2011 7 2
- 16. RDBMS -> -> MySQL 2011 7 2
- 17. ... UPDATE !!! LIMIT 2011 7 2