Tips for Optimizing MySQL
A few days ago chatting with John Rossi on the complexity of the process is to optimize a MySQL database, improving the way in which consultations are conducted, and so on. You could say that the use of database is one of the aspects that most punishes our server.
Optimize
database is quite fun but difficult, the main problem is that you never know with complete accuracy whether what you are doing what is best, as an example if we put too rude, we can see that a query that runs across the base data without using indexes or anything like that is a “violation of resources” for the server if the fields are many, but if the use that is given is very little we will have no problem “apparent” and the consultation we return the correct data. Traverse a database of end to end could be one of the worst things you can do, however, if you do not apply a significant amount of work we will probably never problems falling or anything like that.
Well as you will see a proper optimization of database has its complications, but fortunately there are people who care for your help, and from his experience, we get hundreds of tips. I leave a list of tutorials for optimization that was collected some time ago.
* Top 1000 SQL Performance Tips: This list is the best thing I saw, probably because of its convenience and because it has divided the council for its implementation, I know this list by Armonth, says that even in a summary made Sense Web. Highly recommended.
* 10 SQL Tips: A PDF very interesting but I do not recommend it for people who are not very accustomed to working with SQL or just beginning, it can be very confusing if you have experience now is very good.
* SQL Procedures Performance: Hints and Tips: Short but interesting, give us some advice from IBM to improve the performance of our consultations.
* SQL Performance Tuning using Indexes: Good tutorial that teaches the proper use of indexes. While not exclusively focused on the optimization, tells us very well and should do certain things.
Needless to say, I always have at hand some things, like the official site of MySQL can also serve to keep the steak MySQL and if they can download the book on MySQL I recommended some time ago. If anyone knows or has links to hand a book to recommend, it will be very grateful.