-
Notifications
You must be signed in to change notification settings - Fork 265
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
[Bug]: update table mo_catalog.mo_mysql_compatibility_mode too slow #15597
Labels
kind/bug
Something isn't working
severity/s0
Extreme impact: Cause the application to break down and seriously affect the use
Milestone
Comments
ref: #15560 |
@daviszhen PTAL and triage |
7 tasks
未投入 |
9 similar comments
未投入 |
未投入 |
未投入 |
未投入 |
未投入 |
未投入 |
未投入 |
未投入 |
未投入 |
系统变量调整后,再确认下。 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
kind/bug
Something isn't working
severity/s0
Extreme impact: Cause the application to break down and seriously affect the use
Is there an existing issue for the same bug?
Branch Name
v1.1.3
Commit ID
95801d8
Other Environment Information
Actual Behavior
以100qps 获取mo连接并执行一条简单sql
![image](https://private-user-images.githubusercontent.com/4971300/323514669-105730ed-c88e-4503-aa2c-2d28f3237345.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjA0ODExMjgsIm5iZiI6MTcyMDQ4MDgyOCwicGF0aCI6Ii80OTcxMzAwLzMyMzUxNDY2OS0xMDU3MzBlZC1jODhlLTQ1MDMtYWEyYy0yZDI4ZjMyMzczNDUucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDcwOCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA3MDhUMjMyMDI4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9ZTFiYTI5ZGM4NmZjY2Q5NmQxZjc5YTI2OTkyZjZhYjNjOTRmZjNjNTNhMjFiMzkxM2ZhNjIzMTFmMGYzNzRhMCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.mgZQOxYK_PEoNRhDATv7T1SY35OEluVPk8r75iRy2YE)
select count(*) from t (t表只有一条数据)
,记录执行时间:上图左边是commit: 95801d8 的执行时间,右边是commit: 14c4496,执行时间差距巨大,而且左边执行时间会越来越长。
它们在代码上的区别:左边在auth的时候需要执行两条update语句
update mo_catalog.mo_mysql_compatibility_mode set variable_value = '%s' where account_id = %d and variable_name = '%s';
,右边不执行。这是执行时抓取的cpu profile
![image](https://private-user-images.githubusercontent.com/4971300/323516627-c2938f25-e734-4546-8f0c-2542dfb6155d.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjA0ODExMjgsIm5iZiI6MTcyMDQ4MDgyOCwicGF0aCI6Ii80OTcxMzAwLzMyMzUxNjYyNy1jMjkzOGYyNS1lNzM0LTQ1NDYtOGYwYy0yNTQyZGZiNjE1NWQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDcwOCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA3MDhUMjMyMDI4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NGE1NzdkYzM1M2E2NTQxMWE0NmY4MjNlYzMwYTY1ZmU3ZTk4MzUwZDgwOWQ4ZmFjNjE5YjQ2NGFhYjA3MTE5OSZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.U2a_0_LLpkX4aLbTdedLLZSuZsRmx0h2KedzhgBBlwA)
cpu top:
flame graph:
![image](https://private-user-images.githubusercontent.com/4971300/323516904-7c1c4684-cbe9-46e8-8362-67ce11cb2661.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjA0ODExMjgsIm5iZiI6MTcyMDQ4MDgyOCwicGF0aCI6Ii80OTcxMzAwLzMyMzUxNjkwNC03YzFjNDY4NC1jYmU5LTQ2ZTgtODM2Mi02N2NlMTFjYjI2NjEucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDcwOCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA3MDhUMjMyMDI4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9ODU4OWY5YzcyOWY5MTk1NWNlMTE5MTY5ZDgyZjNlMjA1NzhmODdiM2U5ZDY2ODBiODViNTBkZTQ4ZDFlNGZkNiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.lDxTPW1EOYiEbVQoHAY0IHWLzQ4Cc86JV5--E3-q1LA)
Expected Behavior
No response
Steps to Reproduce
Additional information
No response
The text was updated successfully, but these errors were encountered: