mysqlconfigurer

Releem 1.15.0, 2024-04-30

• Added new option to disable Query Cache manually. Feature request #289
• Added Max Query Length option allows Releem to save full queries for analysis. Closes #291
• Added Query Inspect popup displays the details of queries.
• Fixed IP address update in the dashboard if real IP address was changed. Closes #292
• Fixed Releem can't recognize that innodb_log_file_buffering is enabled. Closes #285
• Fixed Latency on the Servers page displays not in ms. Closes #303
• Fixed Incorrect aggregation on weekly and monthly charts.
• Fixed Using innodb_log_file_size instead of innodb_redo_log_capacity for Percona 8.x
• Removed transaction_prealloc_size for Percona 8.0.29 and later

Releem 1.14.0, 2024-03-31

• Added SQL Query Analytics block to the Dashboard. Closes #256
• Added new task collection of performance_schema.events_statements_summary_by_digest to Releem Agent
• Added new metric to the Dashboard Aborted_clients
• Fixed incorrect permissions after installation. Closes #272
• Fixed File integrity issue after the agent update. Closes #277
• Fixed open_files_limit issue for AWS RDS. Closes #284
• Fixed recommendations of variables that couldn't be changed ffor AWS RDS Aurora. Closes #281
• Fixed Releem Agent fatal error when an agent couldn't get disk information. Closes #276
• Improved Wizard to add new servers

Releem 1.13.0, 2024-02-29

• Added MySQL memory_limit and long_query_time to settings in the Releem dashboard. Closes #208
• Added sending logs to Platform when agent crashed
• Added detection that configuration was changed without MySQL restart (for AWS RDS customers). Closes #270
• Added collection information about the file system. Closes #189
• Added version of Releem Agent for i686. Closes #263
• Improved description of MySQL Health Checks
• Integrated RabbitMQ to remove dependence on AWS Lambda and process metrics asynchronously
• Changed time of metrics to Releem Platform time instead of time on customers servers Closes #264
• Removed transaction_prealloc_size from recommendations for MySQL 8.0.29 as deprecated. Closes #267

Releem 1.12.0, 2024-01-31 (What's New At Releem | January 2024)

• Improved Servers page to highligt servers with unapplied recommendations
• Added email reports for newly recommended MySQL configurations Closes #193
• Disabled apply button for old agents
• Published list of MySQL variables that Releem tuned on Free plan
• Migrated database metrics from MySQL to ClickHouse and improve performance of Dashboard by 25%
• Fixed bugs on RAM and IOPS charts

Releem 1.11.0, 2023-12-31 (What's New At Releem | December 2023)

• Added notification on increasing open_files_limit. Closes #171
• Added server restarts to MySQL Metrics graphs. Closes #191
• Added Automatic applying configuration by clicking button in the web interface.
• Added automatic rollback function if any issues arise while applying a new configuration. Closes #187
• Added new Health check - Table Definition Cache
• Fixed unable to bring recommendations for servers with disabled InnoDB. Closes #213
• Fixed InnoDB log file size Health Check calculation. Closes #234
• Fixed Releem Agent installation guide for AWS RDS. Closes #223
• Fixed Releem Agent tends to stop by itself from time to time. Closes #210

Releem 1.9.0, 2023-10-31 (What's New At Releem | October 2023)

• Improved InnoDB Log File Size Health Check. Closes #202
• Improved Table Cache Hit Rate Health Check. Closes #201
• Added Open Files Utilization
• Added Table Locking Efficiency
• Added InnoDB Dirty Pages Ratio
• Added default start page for users with multiple servers. Closes #177
• Added new Help windows with Frequently Asked Questions.
• Fixed RDS Memory Usage. Closes #212
• Fixed query_cache_type. Closes #214
• Fixed query_cache_size. Closes #216
• Fixed the time of applying configuration events on the day graph. Closes #220
• Improved documentation.

Releem 1.8.0, 2023-09-30 (What's New At Releem | September 2023)

• Added OS version to the Releem Score block
• Fixed the issue with graphs for the America/Mexico_City timezone Closes #196.
• Added a detailed description for the [Memory Limit] (https://releem.com/docs/getstarted#rec586933587). Closes #205.
• Added unapplied recommendations to the server list. Closes #176.
• Fixed innodb_page_cleaners wasn't changed during applying configuration. Closes #197.

Releem 1.7.0, 2023-08-31 (What's New At Releem | August 2023)

• Added Automated Updates for Releem Agent installed in docker container. Closes #184
• Improved version for mobile and Firefox compatibility.
• Improved Query Cache suggestions. Closes #135
• Fixed 'innodb_max_dirty_pages_pct' bug on MySQL 5.5. Closes #183
• Fixed metrics collecttion issue for db servers with Sphinx engine. Closes #174 , Closes #175
• Fixed bug for users with unapproved email. Closes #179
• Fixed bug with saving errors in MySQL configuration when Releem Platform reply with errors.

Releem 1.6.0, 2023-07-31 (What's New At Releem | July 2023)

• Added IOPS graph to Releem Dashboard.
• Added System Information to System Metrics block. Closes #169
• Improved MySQL Metrics graph and included ‘Applying Configuration’ events on the timeline.
• Improved graphs and made Y-axis absolute and not relative. Closes #167
• Removed innodb_flush_log_at_trx_commit automatic recommendations. Closes #170
• Fixed minor issues with the 'innodb_buffer_pool_instance' and 'thread_cache' MySQL variables.
• Improved Releem Agent installation for older MySQL and MariaDB versions without Performance Schema.

Releem 1.5.0, 2023-06-30 (What's New At Releem | June 2023)

• Improved the Recommended configuration window to show users all variables that Releem tunes and details on variables.
• Improved MySQL metric charts with buttons and avg metrics
• Improved design of Recommendation block re current applied configuration and enabled Configure button.
• Fixed bug in Releem Agent to work with old databases. Closes #163
• Fixed bug in full data metrics collection that prevented collecting minute metrics.
• Added collecting configuration performance metric (Latency) in the period when configuration applied
• Added support of MariaDB 11

Releem 1.4.0, 2023-05-31 (What's New At Releem | May 2023)

• Improved “Add server” page to simplify the installation depending on the environment
• Added new states for the Recommendation block to make clear the current state of Releem.
• Fixed bug in Releem Agent to collect information on database size once in 12 hours to prevent performance issues.
• Added change period of all metrics collection in docker. Closes #161
• Added new variables 'innodb_change_buffering', 'innodb_autoextend_increment', 'innodb_change_buffer_max_size', 'thread_stack', 'innodb_adaptive_flushing_lwm', 'transaction_prealloc_size', 'innodb_max_dirty_pages_pct'

Releem 1.3.0, 2023-04-30

• Improved Documentation
• Fixed bug agents for AWS periodical restarts. Closes #159
• Fixed bug in Releem Agents calculation of iops for cpanel with cagefs. Closes #149
• Added fast detection of applying MySQL configuration
• Added detection that MySQL server was restarted
• Added support for arm64 architecture

Releem 1.2.0, 2023-03-31 (What's New At Releem | March 2023)

• Added deletion servers in the Releem Customer Portal
• Improved charts performance in the Releem Customer Portal
• Added a start screen for users without servers in the Releem Customer Portal
• Improved the installation process of Releem Agent and show users if Agent installed not properly
• Added hostname for Releem Agent in docker containers
• Added Events

Releem 1.1.0, 2023-02-28 (What's New At Releem | February 2023)

• Added Display RDS instances in the Releem Customer Portal
• Added MySQL Health Checks in the Releem Customer Portal
• Redesigned Recommendation block in the Releem Customer Portal
• Renamed and redesigned MySQL Performance Score block to Releem Score
• Added Releem Agent Uninstallation
• Fixed MySQL socket detection in mysql_host

Releem 1.0.0, 2023-01-31 (What’s New At Releem | January 2023)

• Added new insights (QPS and Latency) to Weekly Reports
• Added CPU, IOPS, Memory charts for all users in the Releem Customer Portal
• Added Collecting RDS metrics from Enhanced monitoring
• Added Period selector to see data on graphs for more than 1 day in the Releem Customer Portal
• Added Initialize server in docker.
• Added Automated deployment via Fargate in AWS account.
• Fixed connection to db using hostname.
• Fixed default value to timer.
• Fixed Output after successfull installation. Closes #142
• Fixed Set domain name in mysql_host automatically in case using RDS. Closes #138
• Fixed Agent crashed when set domain name instead of IP in mysql_host. Closes #137
• Fixed Failed installation when password contains "!". Closes #121

Releem 0.9.9, 2022-12-31
Added system metrics collection CPU, RAM, Swap, IOPS
Added Slow Log Graph in the Releem Customer Portal
Added CPU, IOPS, and Memory gauges for all users in the Releem Customer Portal
Added Docker integration container. Closes #108
Added Connection to MySQL via socket. Closes #117
Added All Servers page in the Releem Customer Portal
Improved Best Practices and Recommendations Block in the Releem Customer Portal
Improved Documentation
Fixed Installation with custom ip address. Closes #118
Fixed Releem Agent stopped after server reboot. Closes #122
Fixed During installation /etc/mysql/my.cnf was broke. Closes #126

Releem 0.9.8, 2022-11-30
Added slow log queriest collection
Added Latency Graph in the Releem Customer Portal
Added collecting metrics from Performance Scheme
Improved Releem Agent installation process just in one command
Fixed output color. Closes #109
Fixed Exclude "MySQL client" information. Closes #45
Fixed Can't open error on CloudLinux. Closes #101

Releem 0.9.7, 2022-10-31

• Added installation logs collection.
• Improved metrics collection using new Releem Agent implemented using Go.
• Improved installation. Removed cron to collect metrics.
• Redesigned front page of Releem Customer Portal.
• Fixed run installation with sudo user.

Releem 0.9.6, 2022-09-30

• Added Queries per Second metric collection
• Added graph QPS in Releem Customer Portal
• Redesigned Dashboard in Releem Customer Portal
• Added Weekly Reelem Reports
• Improved server metrics aggregation algorithm (hostnames instead IP adresses) Closes #100
• Fixed warning during execution. Closes #93

Releem 0.9.5, 2022-08-31

• Added Apply recommended MySQL configuration and rollback to the previous configuration. Closes #63
• Added Automatic update.
• Added innodb_page_cleaners and innodb_purge_threads calculations.
• Improved performance of Releem Agent to minimize workload run on servers with hundreds of databases. Closes #30

Releem 0.9.4, 2022-07-31

• Added FreeBSD support. Closes #95
• Added innodb_redo_log_capacity calculation
• Added query_cache_min_res_unit calculation
• Improved calculation thread_cache_size. Closes #91
• Fixed Error is:'int' object has no attribute 'strip'
• Fixed Error KeyError: 'Virtual Machine'

Releem 0.9.3, 2022-06-30

• Added thread_pool_size calculation.
• Improved performance of metrics page.
• Improved MySQL Performance Score.
• Fixed innodb_buffer_pool_size calculation.
• Fixed height of Recommended Configuration block.

Releem 0.9.2, 2022-05-31

• Added manual selection of innodb_flush_log_at_trx_commit in Releem Customer Portal for every server.
• Added innodb_log_buffer_size calculaction.
• Added optimizer_search_depth calculaction.
• Improved innodb_log_file_size variable. Closes #3
• Improved Documentation.
• Fixed Metrics Collection Issue. Closes #87

Releem 0.9.1, 2022-04-30

• Added display of Memory Limit in Releem Customer Portal
• Improved MySQL Performance Score
• Fixed duplicated servers in Releem Customer Portal
• Removed servers where Releem Agent is not active.

Releem MySQLConfigurer 0.9.0, 2022-03-30

• Added checks of the database server version
• Added configuration file releem.conf
• Added -u option to update Releem Agent
• Added list of variable changes. Closes #75
• Improved calculation of max_heap_table_size
• Improved calculation of tmp_table_size
• Fixed MySQLTuner version
• Fixed metrics collection

Releem MySQLConfigurer 0.8.0, 2022-01-12

• Added support of MariaDB 10.6. Closes #82
• Added Automated subscriptions and credit card payments
• Added hostnames to servers list. Closes #77
• Improved documentation

Releem MySQLConfigurer 0.7.0, 2021-11-16

• Added Display timezone on server page. Closes #72
• Added Documentation.
• Added Automated Installation of Releem Agent
• Fixed Cache values too high. Closes #73
• Fixed Error when no Innodb tables only MyISAM. Closes #76
• Fixed The values on the left and right are not in the same terminology. Closes #74
• Removed MySQLTuner Recommendations