Development

MysqlOptimization (diff)

You must first sign up to be able to contribute.

Changes between Version 1 and Version 2 of MysqlOptimization

Show
Ignore:
Author:
todd (IP: 65.25.105.128)
Timestamp:
08/19/06 13:13:42 (11 years ago)
Comment:

Added table of contents and references section

Legend:

Unmodified
Added
Removed
Modified
  • MysqlOptimization

    v1 v2  
     1[[PageOutline(2)]] 
     2 
    13= MySQL Optimization = 
    24 
    1921For each section I'm going to explain what status and variable items to look for and how to optimize.  It will be rather short and to the point.  To adjust any of these settings at runtime use the SET GLOBAL command mentioned above. 
    2022 
    21 == key_buffer_size == 
     23== Key Buffer Size == 
    2224 
    2325One thing MySQL can do is buffer primary keys.  This makes access records using primary keys (which most should do) run much faster.  Run `SHOW STATUS LIKE 'key_read%';`. 
    7274 
    7375`Created_tmp_disk_tables` is the number of tables the server had to create on disk.  If this number is big, consider increasing the `tmp_table_size` variable so temporary tables are created in memory as opposed to on disk. 
     76 
     77== References == 
     78 * [http://mirrors.ee.teiath.gr/mysql/tech-resources/articles/mysql-query-cache.html A Practical Look at the MySQL Query Cache (whitepaper)] 
     79 * [http://dev.mysql.com/doc/refman/5.0/en/index.html Official MySQL 5.0 Manual] 
     80   * [http://dev.mysql.com/doc/refman/5.0/en/query-cache.html 5.14 The MySQL Query Cache] 
     81   * [http://dev.mysql.com/doc/refman/5.0/en/optimization.html 7 Optimization ]