# DB Parameters in RHEL This article provides the steps to configure MySQL database parameters in a RHEL environment for OvalEdge applications. It includes the location of MySQL configuration files, required database parameters, and steps to apply the configuration changes. Proper database configuration helps ensure stable connectivity, optimized performance, and reliable metadata operations within OvalEdge. ### Prerequisites Ensure the following prerequisites are met before starting the configuration: * Install MySQL 8.4.x on the RHEL server * Create the ovaledgedb database * Ensure sudo privileges are available on the server * Ensure the MySQL service is installed and running For MySQL 8.4.x installation and ovaledgedb creation, refer to the following document: [Installation of MySQL 8.4.x on RHEL 8+](https://docs.google.com/document/d/1iLXRrqCbguPsood0nTy0uduTVA3h3EWUBRltC5itiIw/edit?tab=t.0) ## Locate the MySQL Configuration File * In RHEL environments, the MySQL configuration file is generally available at the following location: ``` sudo vi /etc/my.cnf ``` * For custom MySQL installations, the configuration file may be available at: ``` sudo vi /etc/my.cnf.d/mysql-server.cnf ``` ## Configure MySQL Parameters ### Open the MySQL Configuration File * Open the MySQL configuration file using one of the following commands: ``` sudo vi /etc/my.cnf ``` or ``` sudo vi /etc/my.cnf.d/mysql-server.cnf ``` ### Update the MySQL Parameters * Add or update the following parameters under the \[mysqld] section in the MySQL configuration file. ``` [mysqld] max_binlog_size=1G binlog_expire_logs_seconds=2592000 group_concat_max_len=4294967295 max_connections=600 max_allowed_packet=1G bind-address=0.0.0.0 innodb_buffer_pool_size=8G ``` Sample Reference Screenshot:
#### Parameter Description
ParameterDescription
max_binlog_sizeDefines the maximum size of binary log files
binlog_expire_logs_secondsDefines binary log retention duration
group_concat_max_lenIncreases maximum length for GROUP_CONCAT() results
max_connectionsDefines the maximum number of concurrent MySQL connections
max_allowed_packetDefines the maximum packet size permitted by MySQL
bind-addressAllows remote connections to the MySQL server
innodb_buffer_pool_sizeAllocates memory for InnoDB caching and performance optimization
* Save the file and exit the editor after updating the parameters. ## Apply Configuration Changes ### Restart the MySQL Service * Run the following command to apply the updated configuration:
``` sudo systemctl restart mysqld ``` ### Verify MySQL Service Status * Run the following command to verify that the MySQL service is running successfully:
``` sudo systemctl status mysqld ``` Sample Reference Screenshot:
*** Copyright © 2026, OvalEdge LLC, Peachtree Corners, GA, USA. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.ovaledge.com/release8.1/deployment-and-maintenance/configuration/db-parameters-in-rhel.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.