Methods for searching errors in SQL application
Sveta Smirnova
Russian Version
Content
Introduction
Part 1. Single queries.
Chapter 1. Query.
Chapter 2. Why you get wrong data.
Chapter 3. Wrong data in database or what to do with problem DML query.
Chapter 4. Miscellaneous.
Partial summary.
Chapter 5. Alternate methods for finding problem query.
Summary.
Part 2. Concurrent queries.
Chapter 6. Locks and deadlocks.
Chapter 7. Concurrent transactions.
Summary.
Part 3. Other cases.
Chapter 8. Large amount of data.
Chapter 9. Misterious vanishing of the server.
Chapter 10. Lost connection to MySQL server during query
Summary.
Part 4. Techniques, used for debugging of Production applications.
Chapter 11. Techniques, used for debugging of Production applications.
Summary.
Appendix. Methods of copying and moving of MySQL databases.
Appendix. Diagram of actions which should be performed when error found.
Epilogue.
Links.
Author 2010 Sveta Smirnova
COPYRIGHT © 2010 S.Smirnova and S. Lasunov
sveta_at_js-client_dot_com