Mysql optimization

fullgore · 11-08-2006, 11:36 AM

How can I optimize the Mysql 4?

tronayne · 11-08-2006, 01:42 PM

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

To

Code:

/etc/my.cnf

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

fullgore · 11-09-2006, 11:24 AM

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

To

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.