mysql5.6安装非常简单 不说了
本人穷 买了个512内存的机器用来玩 发现已启动mysql 内存就不够用了 很烦恼 后来终于搞定了 现把配置记录下来防止忘记# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[mysqld]
explicit_defaults_for_timestamp=true #查询缓存
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
innodb_file_per_table#对每张表使用单独的文件
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
basedir =/usr/local/webserver/mysql
datadir =/usr/local/webserver/mysql/data
port =3306
# server_id = .....
# socket = .....
skip-name-resolve # 禁止MySQL对外部连接进行DNS解析
back_log = 200# MySQL能有的连接数量
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
performance_schema_max_table_instances=600
table_definition_cache=400
table_open_cache=256
join_buffer_size = 2M
sort_buffer_size = 2M
long_query_time=1
innodb_buffer_pool_size=64M#InnoDB引擎缓冲
query_cache_size=2M#查询缓存
tmp_table_size=12M#临时表大小
read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES