2015 Xin Xing MySQL tutorial Spring edition fourth optimization modeling, Xin Xing mysql
After some time, the fourth tutorial of the xinxing MySQL tutorial in 2015 was finally completed. It was positioned as modeling optimization. For example, click to enter. The book contains about 120 pages, all cases are completed in win7, it mainly introduces table creation statements, data types, paradigm and anti-paradigm, modeling practices, modeling experience, optimization basics, indexing, data fragmentation, and so on.
In this part of modeling, different people may like to use different tools, but I used to prefer powerdesigner. Now I use more MySQL, so I switched to MySQL Workbench. It can be said that MySQL Workbench does have fewer functions, but it has already met basic needs. Some of the most common functions are available, in addition, commonly used formats such as png images, SQL statements, and mwb formats are supported.
In this part of optimization, I am not talking about it very well. It is a bit of a sense that the length is compressed too much. The content on forty pages is just a bit more in-depth about the index, other basics are not in place, but the basic optimization steps and common methods are explained in the optimization basics. I hope it will help you. The last piece of data fragment is just to add an article I wrote earlier, because I have written some information about data fragment before.
In short, if friends feel helpful, download and read it.