MySQL Forums
Forum List  »  Performance

Re: MyTOP - Key Efficiency 50.0% - How to improve it?
Posted by: Mahesh Kumar
Date: January 23, 2018 01:13AM


+-----------------------+----------+
| Variable_name         | Value    |
+-----------------------+----------+
| Binlog_cache_disk_use | 31       |
| Binlog_cache_use      | 16970893 |
+-----------------------+----------+

Can i run the following to make binglong cache size to 64MB?
SET global binlog_stmt_cache_size=64*1024;

[OK] InnoDB buffer pool / data size: 4.0G/2.2G

I would like to increase the innodb buffer pool size on the fly without restarting mariadb 10.1. Is that possible? I want to sent around 8GB is that good number?

              total        used        free      shared  buff/cache   available
Mem:          31998        5556       19660         116        6782       25830
Swap:             0           0           0

Options: ReplyQuote




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.