Re: High CPU usage by mysql process
I think that it's not problem with SELECT, because problem appears even when I turn off all queries in scripts.
I'll try to do soemthing with composite index.
Result of SHOW VARIABLES LIKE '%buffer%'
bulk_insert_buffer_size = 8388608
innodb_buffer_pool_dump_at_shutdown = OFF
innodb_buffer_pool_dump_now = OFF
innodb_buffer_pool_filename = ib_buffer_pool
innodb_buffer_pool_instances = 8
innodb_buffer_pool_load_abort = OFF
innodb_buffer_pool_load_at_startup = OFF
innodb_buffer_pool_load_now = OFF
innodb_buffer_pool_size = 68719476736
innodb_change_buffer_max_size = 25
innodb_change_buffering = all
innodb_log_buffer_size = 34359738368
innodb_sort_buffer_size = 1048576
join_buffer_size = 8589934592
key_buffer_size = 17179869184
myisam_sort_buffer_size = 8388608
net_buffer_length = 16384
preload_buffer_size = 32768
read_buffer_size = 131072
read_rnd_buffer_size = 2147483647
sort_buffer_size = 262144
sql_buffer_result = OFF
Subject
Views
Written By
Posted
12623
May 04, 2016 03:32PM
4095
May 05, 2016 09:51PM
Re: High CPU usage by mysql process
3324
May 06, 2016 09:33AM
3001
May 08, 2016 04:56PM
2642
May 09, 2016 08:57PM
2703
May 10, 2016 02:30PM
2406
May 10, 2016 05:56PM
2330
May 10, 2016 07:59PM
2422
May 11, 2016 11:19AM
2159
May 08, 2016 04:18AM
Sorry, you can't reply to this topic. It has been closed.
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.