MySQL Linux.

[Joveice]

I want to add this to the my.cnf

innodb_file_per_table=1
innodb_buffer_pool_size=4G
innodb_log_file_size=1G
innodb_buffer_pool_instances=4
innodb_log_buffer_size=128M

But when I add it and then start the MySQL server it doesent start.

How do I fix this?

[Mark77]

Any log files?

 

I'd refer you to https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html

 

[Joveice]

2 hours ago, Mark77 said:

Any log files?

 

I'd refer you to https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html

 

Yea I tryed that, but that dident work too and I don't know where the log files are.

[HarryNyquist]

On ubuntu, MySQL logs to /var/log/mysql. I would presume other linux distros log somewhere similar.

Edited July 25, 2016 by HarryNyquist
Premature post

[Joveice]

5 minutes ago, HarryNyquist said:

On ubuntu, MySQL logs to /var/log/mysql. I would presume other linux distros log somewhere similar.

I'm using Ubuntu so that works fine. But I'm gonna trash this issue and I wonder something, If I download Ubuntu server 16 would it work with everything 14 did with?

And I will be installing MariaDB since I hear MySQL is starting to get outdated and there is a performance boost + more security updates for mariadb