参考书籍:
[MySQL技术内幕:SQL编程].姜承尧
[MySQL技术内幕:InnoDB存储引擎].姜承尧
MySQLEffective MySQL之SQL语句最优化
http://downloads.mysql.com/docs/refman-5.7-en.pdf
http://wenku.it168.com/d_000930711.shtml
http://wenku.it168.com/d_000327394.shtml
MySQL与InnoDB
数据准备
数据库下载地址:https://launchpad.net/test-db/employees-db-1/1.0.6/+download/employees_db-full-1.0.6.tar.bz2
wget https://launchpad.net/test-db/employees-db-1/1.0.6/+download/employees_db-full-1.0.6.tar.bz2
tar -jxvf employees_db-dump-files-1.0.5.tar.bz2
/usr/local/mysql/bin/mysql -uroot -p < employees.sql
关于数据精度
定点数值与浮点数值
D1(m1, n1) x D2(m2, n2) = D3(m1+m2, n1 + n2)
关于分区
数据调优
- 调优与SQL语句
- 调优与索引
- 调优与数据库结构
- InnoDB表调优
InnoDB原理:
SQL优化实践