Dron's thoughts attic

MySQL шпаргалки

http://zapili.net/vps/articles/shpargalka-po-komandam-mysql/

https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/#repo-qg-yum-fresh-install

https://artkiev.com/blog/mysql-optimization-query-cache.htm

https://haydenjames.io/mysql-query-cache-size-performance/

https://www.digitalocean.com/community/tutorials/how-to-use-mytop-to-monitor-mysql-performance

https://dba.stackexchange.com/questions/56482/how-can-i-determine-the-maximum-possible-number-of-threads

https://stackoverflow.com/questions/173726/when-and-why-are-database-joins-expensive

https://www.infoworld.com/article/3210905/10-essential-performance-tips-for-mysql.html

https://www.percona.com/blog/2006/05/26/myisam-mmap-feature-51/

https://www.percona.com/blog/2017/11/09/mysql-linux-context-switches/

High CPU system time usage on MySQL server - Memory allocators

https://www.remoteshaman.com/unix/common/jemalloc-for-all-app-in-linux

https://www.percona.com/blog/2012/07/05/impact-of-memory-allocators-on-mysql-performance/

https://www.percona.com/blog/2013/03/08/mysql-performance-impact-of-memory-allocators-part-2/

https://blog.programs74.ru/how-to-use-jemalloc-and-tcmalloc-in-oracle-mysql-on-debian-9/

http://jemalloc.net/

https://www.percona.com/blog/2008/08/12/beware-of-myisam-key-cache-mutex-contention/

https://dev.mysql.com/doc/refman/5.6/en/multiple-key-caches.html

https://www.percona.com/blog/2008/11/26/using-multiple-key-caches-for-myisam-scalability/

https://www.percona.com/blog/2006/05/13/to-pack-or-not-to-pack-myisam-key-compression/

https://www.soliantconsulting.com/blog/mysql-optimization-faster-selects-myisam-fixed-row-format/

https://www.percona.com/blog/2006/06/17/using-myisam-in-production/

https://www.percona.com/blog/2006/06/13/myisam-concurrent-insert/

https://dba.stackexchange.com/questions/53486/when-and-how-would-myisam-concurrent-insert-always-be-a-problem

https://www.percona.com/blog/2016/05/10/query-rewrite-plugin-can-harm-performance/

http://mysqlentomologist.blogspot.com/2017/01/perf-basics-for-mysql-profiling.html

https://www.slideshare.net/MySQLGeek/diagnosing-mysql-performance-problems

https://www.tecmint.com/mysql-mariadb-performance-tuning-and-optimization/4/

https://homeunix.nl/manual/mysql/performance-schema.html

Введение в PERFORMANCE_SCHEMA

http://www.markleith.co.uk/2010/09/24/tracking-mutex-locks-in-a-process-list-mysql-55s-performance_schema/

https://www.mysql.com/news-and-events/events/VDD-MySQL-July13/profiling_with_performance_schema.pdf

https://www.percona.com/blog/2015/01/06/getting-mutex-information-from-mysqls-performance_schema/

https://www.percona.com/blog/2008/11/24/using-information_schema-instead-of-shell-scripting/

https://www.percona.com/blog/2011/12/23/solving-information_schema-slowness/

Как ускорить Mysqldump

https://www.percona.com/blog/2007/10/12/myisam-scalability-and-innodb-falcon-benchmarks/

https://mysqlmymon.com/