1:大负载下还是要使用dedicated server,而非EC2 等云主机
2:云中mysql无法使用vip
3:当mysql运行的时候,通过set修改了配置,同时也要记得在my.cnf中进行修改,
摘录如下:
4:skip_name_reserve 理解:
5:query_cache应该被禁掉
6:binary log 理解:
7:The Table Cache:当表的数目非常多的时候,这个值的设置比较重要
8:The Thread Cache
9:The Buffer Pool:
The InnoDB buffer pool is usually the largest and most important
memory buffer in the entire server.
10:innodb_flush_method:
most performance experts agree that O_DIRECT is the setting
to use here
11:The InnoDB Log Files And Log Buffer
innodb_log_file_size :可以计算出来大概为多少, percona的blog有这样的文章,数目和磁盘数据有关系,这里说默认是2个,就保持默认值吧
The InnoDB log can be configured in several files; it’s 2 by default.
You can leave this as-is.
many production servers are running with logs
between 256MB and 2GB,
12:innodb_flush_log_at_trx_commit 0/1/2
13:innodb_stats_on_metadata :
14:innodb_file_per_table
15:
16:
阅读(967) | 评论(0) | 转发(0) |