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

some strange suggestions in new version #671

Open
zoddshop opened this issue Jun 7, 2023 · 4 comments
Open

some strange suggestions in new version #671

zoddshop opened this issue Jun 7, 2023 · 4 comments

Comments

@zoddshop
Copy link

zoddshop commented Jun 7, 2023

mysqltuner started giving me strange suggestions. it seems everytime i run it it is slightly different as well.

it suggested
query_cache_type = 0
query_cache_size = 32M
query_cache_limit = 0
-this makes no sense because 0 means off. also the limit is less than the size.

@zoddshop
Copy link
Author

zoddshop commented Jun 7, 2023

it also keeps suggesting
query_cache_size (> 16M)
when it is already set to 32M

@zoddshop
Copy link
Author

Recently is keeps suggesting
join_buffer_size (> 200.0M, or always use indexes with JOINs)
No matter how high I incerase it it wants me to increase it more.
I think there is a definite bug here. 200M join buffer size is not good.

@jmrenouard
Copy link
Collaborator

Hi @zoddshop
Can you open a new issue about join_buffer_size ?
In fact, this is two separate issue IHMO

@jmrenouard
Copy link
Collaborator

I see where is the issue, I will try to do something on it tommorow

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