Re: Correctly setting mysql options for a huge DB with intense trafic

[Toni Shocker]

I will read what you pointed and try adjustments there, will probably come back in max 1-2 days with some results

In the mean time:

Key_reads 482 k
Key_write_requests 6,783 k

memory usage: usually 8GB if I recall correctly, still having ~8more free GB (probably 4-6GB cached), the rest 8GB being used by the game emulator

CPU: iowait: 0.x - 3%, normal usage: 10%-25% mostly, spikes at 40%-60% every now and then (these values are not relative to 100% but to ~300%(400%?) or whatever the total is for all those cores)

innodb_%:

Innodb_buffer_pool_pages_data	246861
Innodb_buffer_pool_pages_dirty	4095
Innodb_buffer_pool_pages_flushed	11935885
Innodb_buffer_pool_pages_free	181095
Innodb_buffer_pool_pages_misc	30796
Innodb_buffer_pool_pages_total	458752
Innodb_buffer_pool_read_ahead_rnd	36
Innodb_buffer_pool_read_ahead_seq	1581
Innodb_buffer_pool_read_requests	11147474378
Innodb_buffer_pool_reads	185733
Innodb_buffer_pool_wait_free	0
Innodb_buffer_pool_write_requests	253440359
Innodb_data_fsyncs	1644638
Innodb_data_pending_fsyncs	0
Innodb_data_pending_reads	0
Innodb_data_pending_writes	0
Innodb_data_read	3688386560
Innodb_data_reads	200971
Innodb_data_writes	10174611
Innodb_data_written	402975655424
Innodb_dblwr_pages_written	11935885
Innodb_dblwr_writes	173018
Innodb_log_waits	0
Innodb_log_write_requests	25726076
Innodb_log_writes	360454
Innodb_os_log_fsyncs	396399
Innodb_os_log_pending_fsyncs	0
Innodb_os_log_pending_writes	0
Innodb_os_log_written	11842716160
Innodb_page_size	16384
Innodb_pages_created	21873
Innodb_pages_read	224988
Innodb_pages_written	11935885
Innodb_row_lock_current_waits	0
Innodb_row_lock_time	105
Innodb_row_lock_time_avg	105
Innodb_row_lock_time_max	105
Innodb_row_lock_waits	1
Innodb_rows_deleted	38210454
Innodb_rows_inserted	39447659
Innodb_rows_read	15712426585
Innodb_rows_updated	7646838