Jump to content

Hardware Feedback And Optimization Help


Guest Bobsuch

Recommended Posts

  • 3 weeks later...

I'd very RARELY recommend downgrading, unless cost is a big issue. It's always better to have too much than too little. ;)


I get what you mean :P


You could probably optimize your mysql config file a lot more than it is now.


Would that mean I should maybe increase my max_allowed_packet and max_connections higher?
Link to comment
Share on other sites

Those two variables are not as important as others.

max_allowed_packet controls how big a packet you can send. Unless you are hitting this limit (you will get a specific mysql error stating so) increasing it is not needed.

Things like key_buffer size and sort_buffer and read_buffer - those things have a pretty big impact.

Check out this site for example: http://www.databasejournal.com/features/my...cle.php/3367871

And this free utility: http://hackmysql.com/mysqlreport

Link to comment
Share on other sites

  • 2 weeks later...

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...