- 论坛徽章:
- 1
|
之前安装5.6.14 出现这个报错 ，我把 ibdata1 ib_logfile0 ib_logfile1 删除了 就能启动了。
今天安装了5.7.9 出现这个报错 删除了 还是没效果，是不是我配置错误， 我用的还是以前老的my.cnf配置。能帮忙指定下吗？感谢 附上配置
XXX@XXXXX:[/etc]cat my.cnf
[client]
port = 3306
socket = /tmp/mysql_3306.sock
[mysqld]
port = 3306
socket = /tmp/mysql_3306.sock
pid-file = /data/mysql/mysql_data_3306/mysql.pid
character_set_server = utf8
basedir = /usr/local/mysql
datadir = /data/mysql/mysql_data_3306
#bind-address = 10.40.80.24
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
# SAFETY #
max_allowed_packet = 32M
max_connect_errors = 1000000
max_connections = 40960
skip_name_resolve
skip-external-locking
#skip-networking
# BINARY LOGGING #
log-bin = /data/mysql/log_bin/mysql-bin-3306
log_bin_index = /data/mysql/log_bin/mysql-bin-3306.index
expire-logs-days = 1
sync-binlog = 0
server-id = 1
max_binlog_size = 1024M
#binlog-format = ROW
#binlog-do-db = mysql
#replicate-do-db = mysql
# LOGGING #
log-error = /data/mysql/mysql_log/mysql-error-3306.log
#log-queries-not-using-indexes = 1
slow-query-log = 1
long_query_time = 1
slow-query-log-file = /data/mysql/mysql_log/mysql-slow-3306.log
# REPLICATION #
#relay-log = /data/mysql/log_bin/mysql-relay-bin-3306
#relay_log_index=/data/mysql/log_bin/mysql-relay-bin-3306.index
#slave-net-timeout = 60
#log-slave-updates = 1
# MyISAM #
key_buffer_size = 128M
# CACHES AND LIMITS #
tmp_table_size = 64M
max_heap_table_size = 32M
thread_cache_size = 50
open_files_limit = 65535
table_definition_cache = 4096
table_open_cache = 4096
sort_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 32M
thread_cache_size = 16
query_cache_size= 64M
# INNODB #
innodb_data_home_dir = /data/mysql/mysql_data_3306
#innodb_data_file_path = ibdata1:128M;ibdata2:10M:autoextend
innodb_data_file_path=ibdata1:512M:autoextend
innodb_log_group_home_dir = /data/mysql/mysql_data_3306
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_lock_wait_timeout = 50
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 128M
innodb_log_buffer_size = 16M
#innodb_flush_log_at_trx_commit = 2
innodb_flush_log_at_trx_commit = 0
innodb_file_per_table = 1
innodb_file_format = Barracuda
innodb_buffer_pool_instances = 2
innodb_thread_concurrency = 12
innodb_write_io_threads = 8
innodb_read_io_threads = 8
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 8G
innodb_additional_mem_pool_size = 32M
[mysqldump]
quick
max_allowed_packet = 32M
[mysql]
no-auto-rehash
prompt="\\u@\\h:[\\d] \\R:\\m:\\s>"
[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 8M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
=================================
附上启动 错误
XXX@XXXXX:[/data/mysql/mysql_log]cat mysql-error-3306.log
160608 14:37:14 mysqld_safe Starting mysqld daemon with databases from /data/mysql/mysql_data_3306
2016-06-08T06:37:14.780429Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-06-08T06:37:14.780552Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2016-06-08T06:37:14.780602Z 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.9-log) starting as process 25069 ...
2016-06-08T06:37:14.794224Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See xxxx
2016-06-08T06:37:14.794341Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-06-08T06:37:14.794360Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-06-08T06:37:14.794370Z 0 [Note] InnoDB: Uses event mutexes
2016-06-08T06:37:14.794379Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2016-06-08T06:37:14.794388Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-08T06:37:14.805854Z 0 [Note] InnoDB: Number of pools: 1
2016-06-08T06:37:14.806002Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-06-08T06:37:14.822564Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8G, instances = 2, chunk size = 128M
2016-06-08T06:37:15.631931Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-06-08T06:37:15.693340Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-06-08T06:37:15.733489Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-08T06:37:15.992426Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-06-08T06:37:15.992524Z 0 [Note] InnoDB: Setting file '/data/mysql/mysql_data_3306/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-06-08T06:37:16.144182Z 0 [Note] InnoDB: File '/data/mysql/mysql_data_3306/ibtmp1' size is now 12 MB.
2016-06-08T06:37:16.145881Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-06-08T06:37:16.145908Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-06-08T06:37:16.146235Z 0 [Note] InnoDB: Waiting for purge to start
2016-06-08T06:37:16.196915Z 0 [Note] InnoDB: 5.7.9 started; log sequence number 1209962
2016-06-08T06:37:16.197197Z 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/mysql_data_3306/ib_buffer_pool
2016-06-08T06:37:16.197350Z 0 [Note] InnoDB: not started
2016-06-08T06:37:16.197487Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-06-08T06:37:16.198251Z 0 [Warning] InnoDB: Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to XXX for how to resolve the issue.
mysqld: Table 'mysql.plugin' doesn't exist
2016-06-08T06:37:16.198318Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-06-08T06:37:16.198572Z 0 [ERROR] unknown variable 'thread_concurrency=8'
2016-06-08T06:37:16.198587Z 0 [ERROR] Aborting
2016-06-08T06:37:16.198602Z 0 [Note] Binlog end
2016-06-08T06:37:16.198665Z 0 [Note] Shutting down plugin 'ngram'
2016-06-08T06:37:16.198678Z 0 [Note] Shutting down plugin 'partition'
2016-06-08T06:37:16.198687Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-06-08T06:37:16.198694Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-06-08T06:37:16.198700Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-06-08T06:37:16.198821Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-06-08T06:37:16.198892Z 0 [Note] Shutting down plugin 'MyISAM'
2016-06-08T06:37:16.198908Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-06-08T06:37:16.198915Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-06-08T06:37:16.198921Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-06-08T06:37:16.198938Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-06-08T06:37:16.198945Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-06-08T06:37:16.198950Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-06-08T06:37:16.198956Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-06-08T06:37:16.198962Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-06-08T06:37:16.198968Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-06-08T06:37:16.198973Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-06-08T06:37:16.198979Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-06-08T06:37:16.198985Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-06-08T06:37:16.198991Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-06-08T06:37:16.198997Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-06-08T06:37:16.199002Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-06-08T06:37:16.199008Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-06-08T06:37:16.199014Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-06-08T06:37:16.199020Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-06-08T06:37:16.199025Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-06-08T06:37:16.199031Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-06-08T06:37:16.199037Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-06-08T06:37:16.199043Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-06-08T06:37:16.199048Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-06-08T06:37:16.199054Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-06-08T06:37:16.199060Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-06-08T06:37:16.199066Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-06-08T06:37:16.199071Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-06-08T06:37:16.199077Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-06-08T06:37:16.199083Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-06-08T06:37:16.199089Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-06-08T06:37:16.199094Z 0 [Note] Shutting down plugin 'InnoDB'
2016-06-08T06:37:16.199199Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-06-08T06:37:16.199307Z 0 [Note] InnoDB: Starting shutdown...
2016-06-08T06:37:16.199352Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160608 14:37:16
2016-06-08T06:37:16.199394Z 0 [Note] InnoDB: Dumping buffer pool(s) to /data/mysql/mysql_data_3306/ib_buffer_pool
2016-06-08T06:37:16.199583Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160608 14:37:16
2016-06-08T06:37:17.925647Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209981
2016-06-08T06:37:17.926049Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-06-08T06:37:17.926066Z 0 [Note] Shutting down plugin 'MEMORY'
2016-06-08T06:37:17.926076Z 0 [Note] Shutting down plugin 'CSV'
2016-06-08T06:37:17.926084Z 0 [Note] Shutting down plugin 'sha256_password'
2016-06-08T06:37:17.926091Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-06-08T06:37:17.926300Z 0 [Note] Shutting down plugin 'binlog'
2016-06-08T06:37:17.926886Z 0 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
160608 14:37:17 mysqld_safe mysqld from pid file /data/mysql/mysql_data_3306/mysql.pid ended |
|
免费注册
发表于 2016-06-08 17:09
