In the last chapter we discussed methods of testing problems which can happen only on production server. Lets repeat them:
Method #25: if something unexpected happens check error log first.
Method #26: turn InnoDB Monitor to on to have information about all InnoDB transactions in the error log file.
Method #27: use slow query log to find all slow queries.
Method #28: use MySQL Sandbox for fast and convenient testing of your application using several versions of MySQL server.
Method #29: use part of data when work with queries which return wrong results from huge tables.
Author 2010 Sveta Smirnova
COPYRIGHT © 2010 S.Smirnova and S. Lasunov