记录mysql

用于记录自己的mysql学习。

1：当update一条语句大于8000多字节时，需要修改Mysql 配置属性，把表属性改为COMPRESSED,然后mysql.ini配置文件修改（有些是UTF8通用的）：

[client]
port=3307


[mysql]
default-character-set=utf8


[mysqld]
port=3307


basedir="C:/Program Files (x86)/MySQL/MySQL Server 5.5/"


datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"


character-set-server=utf8


default-storage-engine=INNODB


sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"


max_connections=100


query_cache_size=64M


table_cache=256


tmp_table_size=35M


back_log = 128


interactive_timeout = 604800
lower_case_table_names=0
max_allowed_packet=16M
#************************ MyISAM Specific options ************************


thread_cache_size=8


myisam_max_sort_file_size=100G


myisam_sort_buffer_size=69M


key_buffer_size=55M


read_buffer_size=64K
read_rnd_buffer_size=256K


sort_buffer_size=256K




#************************ INNODB Specific options ************************


innodb_buffer_pool_size=1000M


innodb_flush_log_at_trx_commit=2


innodb_log_buffer_size=8M


innodb_additional_mem_pool_size=20M


innodb_thread_concurrency=8


innodb_log_file_size=54M


innodb-file-per-table = 1
innodb_file_format = Barracuda

2：