MySQL Forums
Forum List  »  PHP

More CPU Usage
Posted by: Srinivas Pokala
Date: February 28, 2024 02:39AM

HI
I am getting more cpu usage at heavy traffic.

Online users 600 requests per sec
Max. concurrent connections 2400
Almost 8000 select queries per seconds

Configuration values:

innodb buffer pool size: 85GB
thread_cache_size=500;
read_buffer_size=6291456;
max_connections=2500;
innodb_print_all_deadlocks=ON;
innodb_io_capacity=1000;
innodb_lru_scan_depth=100;
innodb_flush_neighbors=2;
innodb_max_dirty_pages_pct_lwm=1;
innodb_max_dirty_pages_pct=1;
innodb_change_buffer_max_size=50;
sort_buffer_size=8388608;
range_optimizer_max_mem_size=16777216;
innodb_flush_log_at_trx_commit=2;
key_cache_age_threshold=7200;
key_cache_block_size=16384;
key_cache_division_limit=50;
join_buffer_size=3145728;
table_open_cache=9216;
binlog_expire_logs_seconds=259200;
log_queries_not_using_indexes=OFF;
slow_query_log =OFF;
key_buffer_size=268435456;
log_error_verbosity=1;
read_rnd_buffer_size=1048576;

Whatever queries we are using with index and joins executed in 0.005 seconds maximum, but the same queries take over 20 seconds when more users are online.

Please suggest to need any changes in MySQL values

Thanks
Srinivas

Options: ReplyQuote


Subject
Written By
Posted
More CPU Usage
February 28, 2024 02:39AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.