I just finished upgrading to a dedicated
http://hostgator.com/dedicated (standard)
Started out around 1-2 avg server load. Now about 10 hours later it's around 4-8 avg server load.
What's a safe avg server load for my specs? I think i have 8 cores but I'm not sure because I think 4 aren't technically real cores.
The fact that the avg server load seems like it's growing again scares me, but we'll see by tomorrow...
(2012-11-08, 05:30 AM)crazy4cs Wrote: [ -> ]Can you install CSF? (Config Server Firewall), it will let you easily block attacks. Or you can use iptables.
Which one is easier?
and how sure are you about ips over 15 being flooders or ddos? how often do people get attacked?
Now i'm getting alot of MySQL errors. First it was
SQL Error:
1203 - User neochi_mybb3 already has more than 'max_user_connections' active connections
Then after my host tried to raise this limit I started getting
SQL Error:
1041 - Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
They then revert the max user connection limit but I'm still getting the out of memory alot...
Here's my dedicated servers specs:
http://hostgator.com/dedicated (standard plan)
Here's my MySQL conf:
[mysqld]
slow_query_log=1
slow_query_log_file=/var/log/mysql_slow_queries.log
innodb_file_per_table=1
tmp_table_size = 384M
max_heap_table_size = 384M
query_cache_size=64M # increment by 32M, max of 384M if busy MySQL server
thread_cache_size=64M # can be increased on servers with large numbers of active users
key_buffer_size=32M
max_allowed_packet=16M # don't change unless required for large blobs
table_cache=1024 # can be increased if more Opened tables - SHOW STATUS LIKE 'Opened_tables';
table_definition_cache=8192 # increase by the same factor as table_cache
innodb_buffer_pool_size=128M # check mysql -e "SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool%';" - free vs total
innodb_flush_method=O_DIRECT
open_files_limit=16384
max_connections=125 # Should be between 100-150, increase slowly because it causes MySQL to consume more memory!
max_user_connections=25
wait_timeout=20 # can be increased if using persistent connections
#delayed_insert_timeout=20 # Turn on if max_connections being reached due to delayed inserts
#delayed_queue_size=300 # Turn on if max_connections being reached due to delayed inserts
#query_cache_limit=2M # leave at default unless there is a good reason
#join_buffer=2M # leave at default unless there is a good reason
#sort_buffer_size=2M # leave at default unless there is a good reason
#read_rnd_buffer_size=256K # leave at default unless there is a good reason
#read_buffer_size=2M # leave at default unless there is a good reason
myisam_sort_buffer_size=2M # can be increased per sessions if needed for alter tables (indexes, repair)
thread_concurrency=8 # Number of physical + virtual CPU's, be careful of adding more
#general_log=1
slow_query_log=1
log-output=TABLE # select * from mysql.general_log order by event_time desc limit 10;
long_query_time=20 # select * from mysql.slow_log order by start_time desc limit 10;
Can someone please help me with this?
help, this isn't resolved.