Setelah install, Grant user yang ingin digunakan untuk monitoring
GRANT SUPER, REPLICATION CLIENT ON *.* TO username@'localhost';
Referensi
- innotop, https://github.com/innotop/innotop
Setelah install, Grant user yang ingin digunakan untuk monitoring
GRANT SUPER, REPLICATION CLIENT ON *.* TO username@'localhost';
SELECT TABLE_NAME,
ENGINE
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'dbname';
Mengubah Engine :
ALTER TABLE tbl_name ENGINE=InnoDB;
Jika mengalami error seperti https://gist.github.com/wildanm/c082ac468a6b9056ceeec5b0c2058c11
Coba naikkan nilai :
net_read_timeout dan net_write_timeout
...