- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 −
Updated on 30-Jul-2019 22:30:25
- Related Questions & Answers
- Optimal Division in C++
- 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?
- Which version is my MySQL?
- Optimal Lopsided Trees in Data Structure
- How can I set my auto-increment value to begin from 1 in MySQL?
- Explain how to convert CFG to CNF
- How do we set what value is the optimal value for the gauge in HTML?
- Optimal Binary Search Trees in Data Structures
- Design an unambiguous CFG in CNF that generates E?
- Convert the given Context free grammar to CNF
- PowerShell Desired State Configuration
Advertisements