Latest Announcemnent
New thread

Server High Load On Mysql

Status
Not open for further replies.
B

Black Tiger

Active Member
249
2011
13
0
hi we have problem on our server database high load problem on our server. some time 100% usage of cpu
mysql . we use innodb and myislm both on our database . we have too many queries selected and inserted at a time.
our server detail
Intel Xeon E3-1230 3.20Ghz
8GB Ram
our my.cnf file this
Code: 
local-infile=0

 max_connections = 600
 max_user_connections=1000
 key_buffer_size = 1G
 myisam_sort_buffer_size = 64M
 read_buffer_size = 64M
 table_open_cache = 5000
 thread_cache_size = 384
 wait_timeout = 20
 connect_timeout = 10
 tmp_table_size = 256M
 max_heap_table_size = 128M
 max_allowed_packet = 64M
 net_buffer_length = 16384
 max_connect_errors = 10
 concurrent_insert = 2
 read_rnd_buffer_size = 786432
 bulk_insert_buffer_size = 8M
 query_cache_limit = 5M
 query_cache_size = 128M
 query_cache_type = 1
 query_prealloc_size = 262144
 query_alloc_block_size = 65535
 transaction_alloc_block_size = 8192
 transaction_prealloc_size = 4096
 max_write_lock_count = 8
 slow_query_log
 log-error
 external-locking=FALSE
 open_files_limit=50000
  
 [mysqld_safe]
 log-error=/var/log/mysqld.log
 pid-file=/var/run/mysqld/mysqld.pid
  
 [mysqldump]
 quick
 max_allowed_packet = 16M
  
 [isamchk]
 key_buffer = 1G
 sort_buffer = 384M
 read_buffer = 512M
 write_buffer = 256M
  
 [myisamchk]
 key_buffer = 1G
 sort_buffer = 384M
 read_buffer = 512M
 write_buffer = 256M
  
 #### Per connection configuration ####
 sort_buffer_size = 1M
 join_buffer_size = 1M
 thread_stack = 192K

please tell us what changes on it .
 
6 comments
Need help

Hello,

I can help you to sort out this load issue in your server. Please share your skype ID.


Thanks
Unixsavant
 
what are type of hard disk you are using - single drive on SATA/NLS or SSD based? try executing watch mysqladmin pr on your SSH root to see what's being process behind your MySQL.
 
The server Specs are okey for me. I believe it was not only related to the MYSQL database:
  1. What is your daily traffic (visitors per day)?
  2. What control panel are you using (cpanel/virtualmin/etc.)?
  3. How many domains are there?
  4. What are the stats for iowait? can you do the iotop and find %iowait there?
  5. Are you under a DDoS attack? or are your website/domains are 'related to any attack'

My recommendation is:
  • Try using cloudflare for minimizing attack and cache your contents
  • Try using nginx, instead of default Apache
  • Try using multi HDD, instead of 1 HDD (or 1 SSD)
 
Status
Not open for further replies.
Back
Top