LinuxQuestions.org - Mysql optimization

- Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)

- - Mysql optimization (https://www.linuxquestions.org/questions/linux-server-73/mysql-optimization-499783/)

Mysql optimization

How can I optimize the Mysql 4?

For... what?

You can (and should have) copied one of

Code:

/etc/my-huge.cnf

/etc/my-large.cnf

/etc/my-medium.cnf

/etc/my-small.cnf

Code:

/etc/my.cnf

as a good starting point (read the my-*.cnf files to chose your system size and other options).

Quote:

Originally Posted by tronayne

For... what?

You can (and should have) copied one of

Code:

/etc/my-huge.cnf

/etc/my-large.cnf

/etc/my-medium.cnf

/etc/my-small.cnf

Code:

/etc/my.cnf

as a good starting point (read the my-*.cnf files to chose your system size and other options).

Thank´s man....
I was trying to optimize the Mysql because I´m testing it with an ERP system and some operations (include, select, etc) were very slow, now and gonna continue the test to verify the efficiency of the change.