Server Down ?

[THL]

Hi guys...

I've been away the past week and I've numerous server down time emails from my hosting provider.

The setup is a managed dedicated server spec as follows..

Processor: Intel Q9400 QUAD CORE

[Gary.]

PS: NEVER USE "g"

excuse my french but - Your setup is CRAP.

My.cnf

with that memory I would use.

[mysqld]

max_connections = 1000

safe-show-database

skip-locking

key_buffer = 256m

max_allowed_packet = 64M

table_cache = 256

sort_buffer_size = 128m

read_buffer_size = 256m

read_rnd_buffer_size = 128m

myisam_sort_buffer_size = 256m

thread_cache_size = 128

query_cache_size= 128M

thread_concurrency = 64

wait_timeout = 30

innodb_file_per_table

skip-innodb

open_files_limit = 8192

[mysqldump]

quick

max_allowed_packet = 32M

[mysql]

no-auto-rehash

[isamchk]

key_buffer = 128M

sort_buffer_size = 128M

read_buffer = 64M

write_buffer = 64M

[myisamchk]

key_buffer = 128M

sort_buffer_size = 128M

read_buffer = 64M

write_buffer = 64M

Read Buffer 2m you had ! This is for a server based on 256Mb ram LOL.

Use above settings as my Vhoice ! I dont guarentee anything but please note, my.cnf is just ROOT confi allowed - This does not acount on what apache / modules your using.

The above guide is whats based on your RAM only.


I say this SO MANY TIMES.

If you wish to use KeepAlive On:

Make sure your keep KeepAliveTimeout is VERY LOW.

KeepAliveTimeout 2 MAXIMUM

5 is extremely high if you say you have 1000 Connections.

[Bono]

Eh nice recommendation, you just recommended him values which are 4x bigger than his current memory and who does need 1000 connections, this is all just waste of memory.

[Gary.]

Eh nice recommendation, you just recommended him values which are 4x bigger than his current memory and who does need 1000 connections, this is all just waste of memory.

32m = 1Gb - Max I advertised was 256 which would OUTPUT 8GB.

Also he said 1000 Conenctions - I assume he has one BIG hosting server.

1000 conenctions is not alot for an active site. EG: This site could do 800 in no time thats just 1 site - if you choose less LOTS of users will have problems conencting.

[THL]

What about the setting for

max_heap_table_size = 512M 

tmp_table_size = 128M 

Should I remove these or adjust them?

Also can you go into more detail regarding apache modules..? :unsure:

ps and were to edit them maybe some optimum setting too :whistle:

Thanks for the input guys... ;)

[Bono]

32m = 1Gb - Max I advertised was 256 which would OUTPUT 8GB.

Also he said 1000 Conenctions - I assume he has one BIG hosting server.

1000 conenctions is not alot for an active site. EG: This site could do 800 in no time thats just 1 site - if you choose less LOTS of users will have problems conencting.

1000 connections means 1000 mysql connections and if he is not runing ebay.com he doesn't need that much, 5% of that would be enough but to be on safe side 10% is enough, everything above is waste of memory.
My max connections in last 3 months is 46, and my site has 10 million pageviews per month.

Anyways those settings are huge, ideal for 32GB dedicated database server and not for his server.

And to the top, you need to monitor your server to check what is causing your server to be unresponsive, like DDOS attack, out of memory and swapping, too many connections and so on, there could be bunch of reasons. But you will not fix them just copy pasting someones settings, anyway for current day when you get that site is unresponsive you can check with sar command to check how good are load and memory stats.

On few dell servers I had problem that under load network driver just broke, and it took few minutes to watch dog bring it up so you can also check dmesg for ethx errors.

[THL]

Lost me fella... I'm just a novice at this game :unsure: :)