Hardware Feedback And Optimization Help

[Bobsuch]

Hey,


I was hoping somebody could help me with a seeing whether or not I need to downgrade my server and some Optimization help for Apache and Mysql.

Server:
Intel

[Bobsuch]

Hope somebody can help me out with this :)

[bfarber]

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

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

[Bobsuch]

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?

[bfarber]

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

[Bobsuch]

Done, could you also help me give me some help or ways to improve my httpd config file?
The apache httpd configuration file hasn't been touched or modified since I've been on this server

Thanks :)

[bfarber]

Try this post

http://www.ipsbeyond.com/forums/index.php?...st&p=149964