2015 Sinsing MySQL Tutorial Spring edition fourth Optimization modeling

After a period of finishing, the 2015 Sinsing MySQL tutorial fourth finally completed, its positioning is modeling optimization, for: Click to enter, the book total of 120 pages or so, all the cases are completed under the Win7, it mainly introduces the contents of the table statements, data types, paradigms and anti-paradigm, modeling practices, Modeling experience, Optimization basics, indexing, data fragmentation, and more.

In this part of modeling, maybe different people like to use different tools, but I prefer to use PowerDesigner, now because of the use of MySQL more, and then turned to MySQL Workbench, it can be said that MySQL Workbench really less function , but it has met the basic needs, particularly common features are available, and can be exported to PNG images, export SQL statements, typed into the MWB format, etc. are commonly used are supported.

In the optimization of this part, not good, a little out of the feeling, or because the length of the compression is too strong, 40 pages of content, but the index is relatively deep, the other basic talk is not in place, but in the optimization basis there is still the basic steps of optimization and common methods explained out, I hope you have some help. And the last piece of data is just to add an article I've written before, because I've written about data fragments before, and here it is added.

In short, if your friends feel helpful, you might want to download them and read them.

2015 Sinsing MySQL Tutorial Spring edition fourth Optimization modeling