My server MySQL load is too high 230% mostly Please let me guide how can I optimize it.
Server OVH with 48GB RAM.
System information
Server load 16.71 (8 CPUs) (Alert)
Memory Used 4.01% (1,985,444 of 49,514,432) (Ok)
Swap Used 0% (0 of 523,260) (OK)
my.cnf
[mysqld]
innodb_file_per_table=1
bind-address=127.0.0.1
open_files_limit=4596
innodb_buffer_pool_size=134217728
max_allowed_packet=268435456
Currently Load Averages: 13.17 13.95 13.68
Thank you.
Server OVH with 48GB RAM.
System information
Server load 16.71 (8 CPUs) (Alert)
Memory Used 4.01% (1,985,444 of 49,514,432) (Ok)
Swap Used 0% (0 of 523,260) (OK)
my.cnf
[mysqld]
innodb_file_per_table=1
bind-address=127.0.0.1
open_files_limit=4596
innodb_buffer_pool_size=134217728
max_allowed_packet=268435456
Currently Load Averages: 13.17 13.95 13.68
Thank you.
Last edited: