Forum Stats

  • 3,734,173 Users
  • 2,246,901 Discussions
  • 7,857,155 Comments

Discussions

Need my.cnf for MySQL 8.0 on CentOS 7

3428355
3428355 Member Posts: 3
edited Mar 14, 2019 9:28AM in MySQL Community Space

Please share my.cnf for MySQL 8.0 having 4 CPU & 8 GB RAM on CentOS 7.6

Innodb, myisam tables are used, read-write intensive application.

Tagged:

Best Answer

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 350 Employee
    edited Mar 14, 2019 9:28AM Accepted Answer

    The one supplied when you install should work pretty well and the 8.0 server is very aware of the underlying hardware.

    However, mixing InnoDB and MyIsam is not something I recommend.  Go with InnoDB and convert the MyISAM tables over for best performance.

Answers

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 350 Employee
    edited Mar 14, 2019 9:28AM Accepted Answer

    The one supplied when you install should work pretty well and the 8.0 server is very aware of the underlying hardware.

    However, mixing InnoDB and MyIsam is not something I recommend.  Go with InnoDB and convert the MyISAM tables over for best performance.

Sign In or Register to comment.