问题原文
原帖链接 · eos · CC BY-SA 4.0
I have read lot of posts & manuals to try to find out how to increase memory in MySQL 5.6 on Ubuntu, which say there are 3 methods:
- By editing innodb_buffer_pool_size in the my.cnf
- By command line option on starting MySQL
- Dynamically with SQL commands.
I assume 2 and 3 will be lost when MySQL is restarted, which leaves 1.
The problem is, there are no such settings in my /etc/mysql/my.conf.
The string "inno" does not exist in the conf file, nor does "buffer_size" or "buffer-size" (but "key_buffer" is in there).
I installed it via:
# apt-get install mysql-server-5.6
Any ideas where I can change the value?
Did I somehow install MySQL without the InnoDB engine?
Am I looking in the wrong file?
There are some other .cnf files under /etc/mysql, but they have nothing like innodb in them either.
mysql> show variables like 'inno%'
:
innodb_buffer_pool_size | 134217728 |
So it looks like InnoDB is installed, I just can't find where its config file is.
Any help appreciated.
已采纳解答
原帖链接 · FlyingZebra1 · CC BY-SA 4.0
Here's what worked for me (ubuntu 19, mysql 8):
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
add in this at the bottom of the file
innodb_buffer_pool_size = 8G
save and exit. restart MySQL.
sudo systemctl restart mysql
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
