Dron's thoughts attic

Эта страница только для чтения. Вы можете посмотреть её исходный текст, но не можете его изменить. Сообщите администратору, если считаете, что это неправильно.
[[https://habr.com/ru/post/105954/|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/


[[https://dba.stackexchange.com/questions/195338/high-cpu-system-time-usage-on-mysql-server/195580|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

[[https://habr.com/ru/post/126358/|Введение в 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/







[[https://ruhighload.com/%D0%9A%D0%B0%D0%BA+%D1%83%D1%81%D0%BA%D0%BE%D1%80%D0%B8%D1%82%D1%8C+mysqldump%3F|Как ускорить Mysqldump]]





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



https://mysqlmymon.com/