up vote 0 down vote favorite
share [g+] share [fb]

From time to time my ipb board freeze for a minute, When it happens mytop shows the following query

60 Query SELECT m.*, m.member_id as mem_id, m.ip_address as mem_ip,p.*,pp.*,par.*,val

and atop shows that my hd 100% busy (all comes from mysql)

my.cnf

[mysqld]
port= 3306
skip-name-resolve
skip-external-locking

# connections
max_connections = 10000
interactive_timeout=180
wait_timeout=30
connect_timeout=10

max_allowed_packet = 16M
thread_cache_size=16

key_buffer_size=10M

innodb_buffer_pool_size = 5G
#innodb_buffer_pool_instances=5
#innodb_read_ahead_threshold=64
#innodb_file_per_table = 0
innodb_log_file_size = 200M
innodb_log_files_in_group = 2
#innodb_log_buffer_size=20M
#innodb_flush_method = O_DSYNC
#innodb_flush_log_at_trx_commit=2

server setup: 16GB ram, Intel(R) Xeon(R) CPU E5506 @ 2.13GHz, raid 0, centos 64bit

link|improve this question
So are you asking why your I/O is at 100 percent? It looks like that is the question, but it doesn't appear to be spelled out explicitly. – Rilindo Dec 23 '11 at 22:28
Yes and what can i do to solve it – Crazy_Bash Dec 23 '11 at 22:42
what's the size of your database? do you use innodb for all the tables involved in that query? what does explain select m.*... show for your query? can it be that that query creates temporary tables that thrash your io subsystem? – pQd Dec 23 '11 at 22:52
1  
well i think you need to show us more ... like show full proceslist when this happens, describe table <table>, describe <your_query>, show table status like 'table_name' ... – Fox Dec 23 '11 at 23:03
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.