Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2018
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.99 KB | None | 0 0
  1. -------- Recommendations ---------------------------------------------------------------------------
  2. General recommendations:
  3. Run OPTIMIZE TABLE to defragment tables for better performance
  4. OPTIMIZE TABLE `probankrot`.`cache`; -- can free 438.10181427002 MB
  5. OPTIMIZE TABLE `probankrot`.`cache_form`; -- can free 4437.50187683105 MB
  6. OPTIMIZE TABLE `probankrot`.`cache_views_data`; -- can free 128.98123550415 MB
  7. OPTIMIZE TABLE `probankrot`.`watchdog`; -- can free 5868.7052116394 MB
  8. OPTIMIZE TABLE `torgigov`.`cache_form`; -- can free 196 MB
  9. Total freed space after theses OPTIMIZE TABLE : 11069.2901382446 Mb
  10. Set up a Secure Password for user@host ( SET PASSWORD FOR 'user'@'SpecificDNSorIp' = PASSWORD('secure_password'); )
  11. Enable the slow query log to troubleshoot bad queries
  12. Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
  13. Increasing the query_cache size over 128M may reduce performance
  14. Increase table_open_cache gradually to avoid file descriptor limits
  15. Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
  16. This is MyISAM only table_cache scalability problem, InnoDB not affected.
  17. See more details here: https://bugs.mysql.com/bug.php?id=49177
  18. This bug already fixed in MySQL 5.7.9 and newer MySQL versions.
  19. Beware that open_files_limit (2158) variable
  20. should be greater than table_open_cache (1024)
  21. Consider installing Sys schema from https://github.com/mysql/mysql-sys
  22. Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: http://bit.ly/2wgkDvS
  23. Variables to adjust:
  24. query_cache_size (=0)
  25. query_cache_type (=0)
  26. query_cache_size (> 983M) [see warning above]
  27. table_open_cache (> 1024)
  28. innodb_buffer_pool_size (>= 57.2G) if possible.
  29. innodb_log_file_size should be (=61M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
  30. innodb_log_buffer_size (>= 8M)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement