MySQL Forums
Forum List  »  InnoDB

Re: mysql 8.0.27 went crash
Posted by: y y
Date: April 20, 2022 01:41AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
205
y y
April 19, 2022 07:09PM
65
April 19, 2022 10:58PM
Re: mysql 8.0.27 went crash
43
y y
April 20, 2022 01:41AM
44
y y
April 20, 2022 01:50AM
56
April 20, 2022 10:19AM
42
y y
April 20, 2022 06:20PM
69
April 20, 2022 06:53PM
32
y y
April 23, 2022 06:52PM
45
April 25, 2022 12:22AM
40
April 25, 2022 05:50AM
39
April 25, 2022 09:48AM
35
y y
April 25, 2022 08:36PM


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.