Re: mysql 8.0.27 went crash

[y y]

Thanks a lot for your reply.
The OS I used is Windows Server,it might be no the concept of the swap file.
The RAM of the OS is 32GB.And only mysql installed in this Server.

The infomation about mysql you need are as follows:
1
innodb_ft_total_cache_size 640000000.00
innodb_additional_mem_pool_size 0
innodb_log_buffer_size 16777216
tmp_table_size 536870912
key_buffer_size 8388608
max_connections 1500
thread_stack 1048576
max_allowed_packet 67108864
net_buffer_length 16384
read_buffer_size 131072
read_rnd_buffer_size 262144
sort_buffer_size 262144
join_buffer_size 262144

And the result of the fomula is 1.01865E+11. The parameter of innodb_additional_mem_pool_size has empty result, so I make it as zero.

>>>
innodb_ft_total_cache_size +
innodb_additional_mem_pool_size +
innodb_log_buffer_size +
tmp_table_size +
key_buffer_size +
max_connections * (
thread_stack
+ max( max_allowed_packet, net_buffer_length )
+ net_buffer_length
+ read_buffer_size
+ read_rnd_buffer_size
+ sort_buffer_size
+ join_buffer_size
)

2 The result of the second query is as follows.


engine data indexes total
InnoDB 83.92 GB 58.26 GB 142.18 GB
CSV 0.00 GB 0.00 GB 0.00 GB
TOTALS 83.92 GB 58.26 GB 142.18 GB

>>>
select engine,data,indexes,total
from (
select
ifnull(engine,'TOTALS') as engine,
concat(data,' GB') as data,
concat(indexes,' GB') as indexes,
concat(tot,' GB') as total,
if(engine is null,-1,tot) as ord
from (
select
engine,
round( sum(data_length)/1024/1024/1024, 2 ) as data,
round( sum(index_length)/1024/1024/1024, 2 ) as indexes,
round( sum(data_length+index_length)/1024/1024/1024, 2 ) as tot
from information_schema.tables
where engine is not null and engine not in('information_schema','performance_schema')
group by engine with rollup
) sums
) list
order by list.ord desc


Finally, If you need any other infomation about solving this problem, please tell me.Thanks.