MySQL Forums
Forum List  »  General

Re: mysql stops working
Posted by: Peter Brawley
Date: December 31, 2019 10:40AM

465M isn't enough, MySQL wants more, innodb_buffer_pool_size should be about 70% of available RAM.

For an idea of how much more, what is the result of ...

select engine,data,indexes,total
from (
    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 (
      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;

Options: ReplyQuote

Written By
December 28, 2019 10:17AM
December 28, 2019 11:06AM
December 28, 2019 11:26AM
December 28, 2019 12:04PM
December 28, 2019 12:18PM
December 29, 2019 11:59AM
December 31, 2019 08:12AM
Re: mysql stops working
December 31, 2019 10:40AM
January 01, 2020 09:13AM
January 01, 2020 11:34AM
January 01, 2020 04:35PM
January 01, 2020 07:46PM

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.