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

Illegal division by zero at ./mysqltuner.pl line 2745 #558

Closed
surief89 opened this issue Jul 15, 2021 · 1 comment
Closed

Illegal division by zero at ./mysqltuner.pl line 2745 #558

surief89 opened this issue Jul 15, 2021 · 1 comment
Assignees

Comments

@surief89
Copy link

Hello,
I updated mysqltuner to newer version, I already use mysql tuner from a long time ago, previously I used version 2018 :(
But when I updated and running newer version got error

Use of uninitialized value $mystat{"Table_open_cache_hits"} in multiplication
(*) at ./mysqltuner.pl line 2745 (#1)

what value of my config can adjust?

Thanks for your support

jmrenouard added a commit that referenced this issue Jul 15, 2021
Wrong table cache hit rate calculation #548
jmrenouard added a commit that referenced this issue Jul 15, 2021
Wrong table cache hit rate calculation #548
@jmrenouard jmrenouard self-assigned this Jul 15, 2021
@surief89
Copy link
Author

it's seem working now sir
[OK] Thread cache hit rate: 83% (978 created / 6K connections)
[!!] Table cache hit rate: 0% (1K hits / 149K requests)
and recomendation from mysqltuner in below

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

No branches or pull requests

2 participants