search

TitanRO / Issues

0 stars 0 forks source link

Picklog occasionally in slow_query_log #22

Closed trojal closed 6 years ago

trojal commented 6 years ago 
{
 insertId:  "1#291195673885#4143296244761691651#slow#1524721135693223622#1604-0@ac"  
 receiveTimestamp:  "2018-04-26T05:39:02.197864181Z"  
 resource: {…}  
 textPayload:  "INSERT DELAYED INTO `picklog` (`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, `opt_idx0`, `opt_val0`, `opt_idx1`, `opt_val1`, `opt_idx2`, `opt_val2`, `opt_idx3`, `opt_val3`, `opt_idx4`, `opt_val4`, `map`, `unique_id`) VALUES (NOW(), '1076', 'M', '909', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'pay_dun00', '0');"  
 timestamp:  "2018-04-26T05:38:55.842654Z"  
}
trojal commented 6 years ago

Fixed on test server, DB performance optimization. innodb_flush_log_at_trx_commit=2 innodb_buffer_pool_size=21G innodb_log_file_size=256M innodb_log_buffer_size=4M innodb_thread_concurrency=8 innodb_flush_method=O_DIRECT