Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CREATE DATABASE IF NOT EXISTS inception;这个语句能改写吗?会一直在等锁(Waiting for backup lock) #649

Open
feiazifeiazi opened this issue May 23, 2024 · 3 comments

Comments

@feiazifeiazi
Copy link

feiazifeiazi commented May 23, 2024

描述
CREATE DATABASE IF NOT EXISTS inception;
这个语句不知道在什么情况下会执行
能只在goInception启动时执行一次吗?

重现
当xtrabackup程序执行增量备份时,就在会话中看到。就会发现这个长查询SQL。

image

环境

  • 数据库mysql 8.0
  • archery v.10.0

参数

@zmix999
Copy link
Contributor

zmix999 commented May 23, 2024

看下enable_sql_statistic 这个参数是不是打开了

@feiazifeiazi
Copy link
Author

feiazifeiazi commented May 23, 2024

看下enable_sql_statistic 这个参数是不是打开了

对的。是打开的。 看了介绍说说做一些统计相关,写数据到statistic表。

# 开启统计功能
enable_sql_statistic = true

@zmix999
Copy link
Contributor

zmix999 commented May 23, 2024

用不到这功能可以关掉

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants