前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >general_log 问题处理7

general_log 问题处理7

作者头像
franket
发布2022-03-21 18:26:34
2880
发布2022-03-21 18:26:34
举报
文章被收录于专栏:技术杂记

此时多出来一个文件 general_log.CSM

代码语言:javascript
复制
[root@upgrade-slave mysql]# ll general_log.*
-rw-rw----. 1 mysql mysql   35 Dec 15 00:22 general_log.CSM
-rw-rw----. 1 mysql mysql    0 Dec 15 00:18 general_log.CSV
-rw-------. 1 mysql mysql 8776 Dec 15 00:22 general_log.frm
[root@upgrade-slave mysql]# 

再次尝试升级

代码语言:javascript
复制
[root@upgrade-slave ~]# time mysql_upgrade -u root -p
Enter password: 
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' 
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' 
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slave_master_info                            OK
mysql.slave_relay_log_info                         OK
mysql.slave_worker_info                            OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Running 'mysql_fix_privilege_tables'...
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' 
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' 
Warning: Using a password on the command line interface can be insecure.
azheng_db.answers                                  OK
azheng_db.feedbacks                                OK
azheng_db.logged_exceptions                        OK
azheng_db.question_answers                         OK
azheng_db.questions                                OK
azheng_db.rule_answers                             OK
...
...
text_db.categories                                 OK
text_db.exception_logger_logged_exceptions         OK
text_db.missions                                   OK
text_db.schema_migrations                          OK
text_db.taggings                                   OK
text_db.tags                                       OK
text_db.users                                      OK
OK

real	0m59.267s
user	0m0.098s
sys	0m0.099s
[root@upgrade-slave ~]# 

本文系转载,前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文系转载前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档