摘要: dont create index on each column for multicolumn index, the column order matters for B-Tree index UNIQUE and PRIMARY KEY are constraints, not indexes. 阅读全文
posted @ 2016-07-14 19:46 学思罔殆 阅读(176) 评论(0) 推荐(0) 编辑
摘要: 1. max_connections open_files_limit table_open_cache 如何配置 table_open_cache = max_connections * N (N is the maximun number of tables open in each conne 阅读全文
posted @ 2016-07-14 16:00 学思罔殆 阅读(232) 评论(0) 推荐(0) 编辑