Около месяца назад открылся отличный ресурс (http://www.mysqlperformanceblog.com/) по вопросам связанным с увеличением производительности MySQL. Опубликовано много интересных заметок, в которых часто описываются не очевидные, но важные моменты связанные оптимизацией, использованием индексов и тюнингу различных параметров конфигурации.

Например:

-  MySQL Server Variables - SQL layer or Storage Engine specific (http://www.mysqlperformanceblog.com/2006/06/08/mysql-server-variables-sql-layer-or-storage-engine-specific/)

-  Are larger buffers always better ? (http://www.mysqlperformanceblog.com/2006/06/06/are-larger-buffers-always-better/)

-  InnoDB thread concurrency (http://www.mysqlperformanceblog.com/2006/06/05/innodb-thread-concurrency/)

-  InnoDB page size (http://www.mysqlperformanceblog.com/2006/06/04/innodb-page-size/)

-  InnoDB memory usage (http://www.mysqlperformanceblog.com/2006/05/30/innodb-memory-usage/)

-  Join performance of MyISAM and Innodb (http://www.mysqlperformanceblog.com/2006/05/29/join-performance-of-myisam-and-innodb/)

-  MyISAM mmap feature (5.1) (http://www.mysqlperformanceblog.com/2006/05/26/myisam-mmap-feature-51/)

-  Indexes in MySQL (http://www.mysqlperformanceblog.com/2006/06/02/indexes-in-mysql/)

-  Descending indexing and loose index scan (http://www.mysqlperformanceblog.com/2006/05/09/descending-indexing-and-loose-index-scan/)

-  MySQL Replication Performance (http://www.mysqlperformanceblog.com/2006/05/27/jeremy-cole-on-mysql-replication/)

-  MySQL Server Memory Usage (http://www.mysqlperformanceblog.com/2006/05/17/mysql-server-memory-usage/)

-  Optimizing MySQL on Source Code Level (http://www.mysqlperformanceblog.com/2006/05/16/optimizing-mysql-on-source-code-level/)

-  To pack or not to pack - MyISAM Key compression (http://www.mysqlperformanceblog.com/2006/05/13/to-pack-or-not-to-pack-myisam-key-compression/)

URL: http://www.mysqlperformanceblog.com/
Новость: http://www.opennet.dev/opennews/art.shtml?num=7696