iihero : 日志 就是上面那个,就那么多呀!rucypli: “for all windows platform” 实际安装不行呀!
2012-04-27T01:54:35.031250Z 0 [Note] Plugin 'FEDERATED' is disabled. 2012-04-27T01:54:35.031250Z 0 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000 2012-04-27T01:54:35.031250Z 0 [Warning] InnoDB: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2012-04-27T01:54:35.031250Z 0 [Note] InnoDB: The InnoDB memory heap is disabled 2012-04-27T01:54:35.031250Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2012-04-27T01:54:35.031250Z 0 [Note] InnoDB: Uses system mutexes 2012-04-27T01:54:35.031250Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2012-04-27T01:54:35.046875Z 0 [Note] InnoDB: Number of pools: 1 2012-04-27T01:54:35.046875Z 0 [Note] InnoDB: Not using CPU crc32 instructionsACMAIN_CHM: 这就是 全部内容
my.ini # 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] port=3306 basedir ="E:/Mysql5.7/" datadir ="E:/Mysql5.7/data/" tmpdir ="E:/Mysql5.7/data/" socket ="E:/Mysql5.7/data/mysql.sock" log-error="E:/Mysql5.7/data/mysql_error.log" #server_id = 2 #skip-locking max_connections=1000 query_cache_size=32M table_open_cache=256 query_cache_size=15M tmp_table_size=32M thread_cache_size=8 innodb_data_home_dir="E:/Mysql5.7/data/" innodb_additional_mem_pool_size=8M innodb_flush_log_at_trx_commit =1 innodb_log_buffer_size=128M innodb_buffer_pool_size=128M innodb_log_file_size=10M innodb_thread_concurrency=16 join_buffer_size = 128M sort_buffer_size = 32M read_rnd_buffer_size = 32M max_allowed_packet = 32M explicit_defaults_for_timestamp=true sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" #sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [client] default-character-set=utf8
我安装了一个,用这个配置文件也报错误 InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
日志 就是上面那个,就那么多呀!rucypli:
“for all windows platform” 实际安装不行呀!
2012-04-27T01:54:35.031250Z 0 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000
2012-04-27T01:54:35.031250Z 0 [Warning] InnoDB: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2012-04-27T01:54:35.031250Z 0 [Note] InnoDB: The InnoDB memory heap is disabled
2012-04-27T01:54:35.031250Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2012-04-27T01:54:35.031250Z 0 [Note] InnoDB: Uses system mutexes
2012-04-27T01:54:35.031250Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2012-04-27T01:54:35.046875Z 0 [Note] InnoDB: Number of pools: 1
2012-04-27T01:54:35.046875Z 0 [Note] InnoDB: Not using CPU crc32 instructionsACMAIN_CHM: 这就是 全部内容
# 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]
port=3306
basedir ="E:/Mysql5.7/"
datadir ="E:/Mysql5.7/data/"
tmpdir ="E:/Mysql5.7/data/"
socket ="E:/Mysql5.7/data/mysql.sock"
log-error="E:/Mysql5.7/data/mysql_error.log" #server_id = 2
#skip-locking max_connections=1000
query_cache_size=32M
table_open_cache=256
query_cache_size=15M tmp_table_size=32M
thread_cache_size=8 innodb_data_home_dir="E:/Mysql5.7/data/"
innodb_additional_mem_pool_size=8M
innodb_flush_log_at_trx_commit =1 innodb_log_buffer_size=128M
innodb_buffer_pool_size=128M
innodb_log_file_size=10M
innodb_thread_concurrency=16 join_buffer_size = 128M
sort_buffer_size = 32M
read_rnd_buffer_size = 32M max_allowed_packet = 32M explicit_defaults_for_timestamp=true
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [client]
default-character-set=utf8
InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB