search

Releem / mysqlconfigurer

Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.
https://releem.com
GNU General Public License v3.0
252 stars 26 forks source link

Number of parameters tuned in the basic version is different than number specified in configuration header #247

Closed yoni-yad2 closed 5 months ago

yoni-yad2 commented 6 months ago

I see this message on top of the "Configuration" recommendations screen:

"Notice: On the Basic plan Releem monitors and tunes only 10 parameters. "

But actually 14 parameters were recommended for change (the others are grayed out):

  1. innodb_change_buffer_max_size
  2. innodb_adaptive_flushing_lwm
  3. innodb_max_dirty_pages_pct
  4. innodb_autoextend_increment
  5. thread_stack
  6. transaction_prealloc_size
  7. key_buffer_size
  8. max_heap_table_size
  9. tmp_table_size
  10. innodb_buffer_pool_instances
  11. innodb_buffer_pool_size
  12. innodb_redo_log_capacity
  13. innodb_page_cleaners
  14. innodb_buffer_pool_chunk_size
drupaladmin commented 6 months ago

Thanks for your feedback.

We're looking your server.

I'll keep you informed.

drupaladmin commented 5 months ago

Thank you for your patience. @yoni-yad2

We've fixed that. Now on Free version Releem will recommend the following ten variables depending on MySQL/MariaDB versions:

drupaladmin commented 5 months ago

Improved list of variables and tagger variables tuned on the free plan https://releem.com/docs/mysql-performance-parameters