当前位置:网站首页>Upgrade MySQL 5.1 to 5.68
Upgrade MySQL 5.1 to 5.68
2022-04-23 15:38:00 【franket】
Modify the configuration file my.cnf
[root@upgrade-slave ~]# diff /tmp/old.my.cnf /tmp/new.my.cnf
11c11
< table_cache = 2048
---
> table_open_cache = 2048
18d17
< thread_concurrency = 8
22c21
< default_table_type = INNODB
---
> default_storage_engine = INNODB
44c43
< myisam_recover
---
> myisam_recover_options
48d46
< innodb_ibuf_max_size = 1G
[root@upgrade-slave ~]#
Try to start mysql
[root@upgrade-slave ~]# /etc/init.d/mysql start
Starting MySQL (Percona Server)............ [ OK ]
[root@upgrade-slave ~]#
/var/lib/mysql/upgrade-slave.err The log still reports an error
151126 21:35:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-11-26 21:35:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-26 21:35:59 0 [Note] /usr/sbin/mysqld (mysqld 5.6.27-75.0-log) starting as process 15776 ...
2015-11-26 21:35:59 15776 [Warning] option 'innodb-autoextend-increment': unsigned value 33554432 adjusted to 1000
2015-11-26 21:35:59 15776 [Note] Plugin 'FEDERATED' is disabled.
2015-11-26 21:35:59 7f104092f7e0 InnoDB: Warning: 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.
2015-11-26 21:35:59 15776 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-11-26 21:35:59 15776 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-26 21:35:59 15776 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-11-26 21:35:59 15776 [Note] InnoDB: Memory barrier is not used
2015-11-26 21:35:59 15776 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-26 21:35:59 15776 [Note] InnoDB: Using Linux native AIO
2015-11-26 21:35:59 15776 [Note] InnoDB: Using CPU crc32 instructions
2015-11-26 21:35:59 15776 [Note] InnoDB: Initializing buffer pool, size = 20.0G
2015-11-26 21:36:06 15776 [Note] InnoDB: Completed initialization of buffer pool
2015-11-26 21:36:07 15776 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-26 21:36:09 15776 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-26 21:36:09 15776 [Note] InnoDB: Waiting for purge to start
2015-11-26 21:36:09 15776 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.27-75.0 started; log sequence number 4538183224168
2015-11-26 21:36:09 15776 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a6f64eac-9442-11e5-944e-44a842184bd8.
2015-11-26 21:36:09 15776 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-11-26 21:36:09 15776 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-11-26 21:36:09 15776 [Note] Server hostname (bind-address): '*'; port: 3306
2015-11-26 21:36:09 15776 [Note] IPv6 is available.
2015-11-26 21:36:09 15776 [Note] - '::' resolves to '::';
2015-11-26 21:36:09 15776 [Note] Server socket created on IP: '::'.
2015-11-26 21:36:09 15776 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
2015-11-26 21:36:09 15776 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2015-11-26 21:36:09 15776 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2015-11-26 21:36:09 15776 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2015-11-26 21:36:09 15776 [Note] Event Scheduler: Loaded 0 events
2015-11-26 21:36:09 15776 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.27-75.0-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release
版权声明
本文为[franket]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204231406039272.html
边栏推荐
- 木木一路走好呀
- Educational codeforces round 127 A-E problem solution
- utils.DeprecatedIn35 因升级可能取消,该如何办
- Code live collection ▏ software test report template Fan Wen is here
- Baidu written test 2022.4.12 + programming topic: simple integer problem
- 导入地址表分析(根据库文件名求出:导入函数数量、函数序号、函数名称)
- Squid agent
- 软件性能测试报告起着什么作用?第三方测试报告如何收费?
- Deep learning - Super parameter setting
- Do keyword search, duplicate keyword search, or do not match
猜你喜欢
For examination
导入地址表分析(根据库文件名求出:导入函数数量、函数序号、函数名称)
今日睡眠质量记录76分
Deep learning - Super parameter setting
Today's sleep quality record 76 points
网站压测工具Apache-ab,webbench,Apache-Jemeter
【Leetcode-每日一题】安装栅栏
Mumu, go all the way
How did the computer reinstall the system? The display has no signal
JVM-第2章-类加载子系统(Class Loader Subsystem)
随机推荐
The El tree implementation only displays a certain level of check boxes and selects radio
时序模型:门控循环单元网络(GRU)
kubernetes之常用Pod控制器的使用
Connect PHP to MySQL via PDO ODBC
JSON date time date format
字符串最后一个单词的长度
布隆过滤器在亿级流量电商系统的应用
What if the package cannot be found
KNN, kmeans and GMM
APISIX jwt-auth 插件存在错误响应中泄露信息的风险公告(CVE-2022-29266)
cadence SPB17.4 - Active Class and Subclass
T2 iCloud日历无法同步
PHP operators
MySQL query library size
How did the computer reinstall the system? The display has no signal
现在做自媒体能赚钱吗?看完这篇文章你就明白了
Mysql database explanation (8)
After time judgment of date
一刷313-剑指 Offer 06. 从尾到头打印链表(e)
redis-shake 使用中遇到的错误整理