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

Cannot calculate MyISAM index size - re-run script as root user #453

Closed
solracsf opened this issue Sep 10, 2019 · 3 comments
Closed

Cannot calculate MyISAM index size - re-run script as root user #453

solracsf opened this issue Sep 10, 2019 · 3 comments
Assignees
Labels

Comments

@solracsf
Copy link
Contributor

solracsf commented Sep 10, 2019

Script has been run as root user (both OS and MySQL).

[!!] Cannot calculate MyISAM index size - re-run script as root user

  • 8.0.17 MySQL Community Server
  • Ubuntu 18.04
  • MySQLTuner 1.7.15
@jmrenouard
Copy link
Collaborator

New message is:
MyISAM Metrics are disabled on last MySQL versions. for MySQL 8.0

On MySQL oracle too few information to perform calculations

mysql> show global status like 'myis%';
Empty set (0.00 sec)

mysql> show global variables like 'myis%';
+---------------------------+----------------------+
| Variable_name | Value |
+---------------------------+----------------------+
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 9223372036853727232 |
| myisam_mmap_size | 18446744073709551615 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| myisam_stats_method | nulls_unequal |
| myisam_use_mmap | OFF |
+---------------------------+----------------------+
8 rows in set (0.00 sec)

@jmrenouard jmrenouard added the bug label Sep 25, 2019
@jmrenouard jmrenouard self-assigned this Sep 25, 2019
@jmrenouard jmrenouard reopened this Sep 25, 2019
@jmrenouard
Copy link
Collaborator

Last version 1.7.16 should fix this issue.

@downhiller
Copy link

I still get this error message on 1.7.20

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

No branches or pull requests

3 participants