Set Optimal MySQL configuration in my.cnf?

First, you need to open my.cnf file. The following is the query to get the directory location of the config file on Windows −

mysql> select @@datadir;

Output

+---------------------------------------------+
| @@datadir                                   |
+---------------------------------------------+
| C:\ProgramData\MySQL\MySQL Server 8.0\Data\ |
+---------------------------------------------+
1 row in set (0.00 sec)

Here is the snapshot of the directory −

Now open my.cnf file. The snapshot is as follows −

If you want to add more data to cache, then use the following query −

innodb_buffer_pool_size = 1024M

If you want to write more data, then use the following query −

innodb_log_file_size = 512M

We have set both the above options in my.conf file as shown below −

Karthikeya Boyini

Published on 19-Mar-2019 07:58:50

• Related Questions & Answers
• Change MySQL default character set to UTF-8 in my.cnf?
• How to find MySQL my.cnf on my windows computer?
• Optimal Division in C++
• How should I enable LOAD DATA LOCAL INFILE in my.cnf in MySQL?
• Optimal Account Balancing in C++
• Optimal Binary Search Tree
• MySQL command for display current configuration variables?
• MySQL command for displaying current configuration variables?
• Implement MySQL query using multiple OR statements. Any optimal alternative?
• Optimal Lopsided Trees in Data Structure
• How do we set what value is the optimal value for the gauge in HTML?
• Optimal Binary Search Trees in Data Structures
• PowerShell Desired State Configuration
• C++ Program for Optimal Page Replacement Algorithm
• Checking backup configuration in SAP HANA