AD

MySQL performance tuning experience of the best 21

****phpchina**/?action-viewnews-itemid-39336-page-3

1 for the query cache to optimize your query
2.EXPLAIN your SELECT query
3 When one line of data using LIMIT1
4 construction of the index for the search field
5, when used in the Join Table equivalent type of cases, and index
6 Do not ORDER BY RAND ()
7 Avoid SELECT *
8 always set an ID for each table
9. VARCHAR instead of using ENUM
10 from PROCEDURE ANALYSE () to obtain suggestions
11. As far as possible the use of NOT NULL
12. Prepared Statements
13. Unbuffered query
14. The IP address saved as UNSIGNED INT
15 Fixed-length table will be faster
16 vertical split
17 split large DELETE or INSERT statement
18. The smaller the column faster
19 Choosing the right storage engine
20 using an object-relational mapper (Object Relational Mapper)
21. Be careful "permanent link"

Annex
标签: storage engine, performance tuning, object relational, mapper, varchar, search field, enum, ip address, unsigned int, vertical split
分类: Database
时间: 2011-08-15

相关文章

  1. MySQL performance tuning experience the best 21

    MySQL performance tuning experience the best 21 1. For the query cache to optimize your query MySQL's query ca ...
  2. Twenty real MySQL performance tuning Experience Optimization

    1. For the query cache to optimize your query Most of the MySQL query cache is enabled on both servers. This i ...
  3. MySQL performance tuning experience of the best 20 + section

    Today, the entire operation of the database application performance is increasingly becoming a bottleneck, and ...
  4. Mysql performance tuning and architecture - notes

    Login mysql host: mysql-uadm-pbbnd_adm - prompt = "\ \ u @ \ \ h \ \ Y: \ \ m: \ \ r: \ \ m: \ \ s>&qu ...
  5. MYSQL performance tuning and architecture design study notes book 1

    "MYSQL performance tuning and architecture books," Ali Baba's famous masterpiece MYSQL DBA Jane sunr ...
  6. Baidu mysql performance tuning ppt

    Keywords: Mysql, performance optimization, Baidu InfoQ last weekend listening to Bin Baidu engineers to optimi ...
  7. MySQL Performance Tuning must 25

    Today, the operation of the database application performance is increasingly becoming the bottleneck, and this ...
  8. MySQL Performance Tuning must 25 (rpm)

    Today, the operation of the database application performance is increasingly becoming the bottleneck, and this ...
  9. MySQL Performance Tuning must 25 (reproduced)

    Original Address: http://www.iteye.com/topic/1114134 Today, the operation of the database application performa ...
  10. Colleagues this afternoon to share the MYSQL performance tuning

    Afternoon of sharing, co-workers about the next mysql performance optimization on several experiences, it make ...
  11. MySQL Performance Tuning Best Practices 21

    Today, the operation of the database application performance is increasingly becoming the bottleneck, and this ...
  12. Twenty kinds of real tune MySQL performance optimization experience sharing

    1 for the query cache to optimize your query Most of the MySQL query cache is enabled on both servers. This is ...
  13. [Transfer] MySQL performance optimization experience the best of 20 +

    Transfer: http://coolshell.cn/articles/1846.html Today, the operation of the database application performance ...
  14. MYSQL performance tuning [Summary]

    1, sub-library sub-table Obviously, a main table (the table is very important, for example, the user table) un ...
  15. MYSQL performance tuning Overview - Undercover Personal sorting

    1, the hardware optimization a> memory - Large memory, large memory bits wide, try not to use the SWAP; b&g ...
  16. The system variables to set up the MySQL performance tuning

    How to set the MySQL system variables to tune performance? (1), back_log: Requires some number of connections ...
  17. mysql performance tuning methods of inspection and

    This switched: http://sudone.com/linux/mysql_debug.html I have been using this database mysql software, more s ...
  18. MYSQL performance tuning

    ORIGINAL: http://www.zwjoy.com/blog/?p=3 1 business needs <br /> Description: The unreasonable demand of ...
  19. The autocommit mysql performance tuning

    Placeholder