## Thanks 以下为SOAR的灵感及代码来源,我们站在伟人的肩膀上,让DBA的工作和生活更美好。 * [vitess](https://github.com/vitessio/vitess) * [SQLAdvisor](https://github.com/Meituan-Dianping/SQLAdvisor) * [pt-query-advisor](https://www.percona.com/doc/percona-toolkit/2.1/pt-query-advisor.html) * [sqlcheck](https://github.com/jarulraj/sqlcheck) * [pg_idx_advisor](https://github.com/cohenjo/pg_idx_advisor) * [mysql-xplain-xplain](https://github.com/rap2hpoutre/mysql-xplain-xplain) * [explain-analyzer](https://github.com/Preetam/explain-analyzer) * [Explain](https://github.com/goghcrow/explain/blob/master/Explain.php) * [sql-beautify](https://github.com/jkramer/sql-beautify) * [go-mysql](https://github.com/percona/go-mysql) * [pretty](https://github.com/kr/pretty) * [golang_escape](https://github.com/liule/golang_escape) * [mymysql](https://github.com/ziutek/mymysql) * [beego/logs](https://github.com/astaxie/beego/logs) * [uniuri](https://github.com/dchest/uniuri) * [gjson](https://github.com/tidwall/gjson) ## Reference Articles * [MySQL Reference Manual Chapter 8 Optimization](https://dev.mysql.com/doc/refman/8.0/en/optimization.html) * [Indexing 101: Optimizing MySQL queries on a single table](https://www.percona.com/blog/2015/04/27/indexing-101-optimizing-mysql-queries-on-a-single-table/) * [MySQL: Building the best INDEX for a given SELECT](http://mysql.rjweb.org/doc.php/index_cookbook_mysql) * [MySQL INDEX Cookbook](http://mysql.rjweb.org/slides/cook.pdf) * [Random Sampling for Histogram Construction: How much is enough?](http://www.mathcs.emory.edu/~cheung/papers/StreamDB/Histogram/1998-Chaudhuri-Histo.pdf) * [10 Cool SQL Optimisations That do not Depend on the Cost Model](https://blog.jooq.org/2017/09/28/10-cool-sql-optimisations-that-do-not-depend-on-the-cost-model/) ## Books * 《高性能MySQL》/《High Performance MySQL》 * 《数据库索引设计与优化》/《Relational Database Index Design and the Optimizers》 * 《数据库系统概论》/《Database System Concepts》 * 《SQL反模式》/《SQL Antipatterns》 * 《数据库查询优化器的艺术》/《The Art of Database Query Optimizer》 * 《SQL优化最佳实践》/《SQL Optimization Best Practice》 * 《SQL编程风格》/《Sql Programming Style》