Abstract:

Common means of optimization of MySQL database at the present stage are summarized.All occasions where the storage engine of MySQL database can be applied and the advantages and disadvantages of indexing mechanism are discussed.In addition,the superiority in the storage process and the importance of hardware performance are analyzed and discussed.On this basis,database segmentation techniques are introduced,and finally the basic method of database sharding and the cluster model is put forward.

Key words: storage engine;index;database sharding;cluster