Ubuntu MariaDB容量規劃可從硬件、配置、存儲、監控等方面入手,具體如下:
innodb_buffer_pool_size
/etc/mysql/mariadb.conf.d/50-server.cnf
innodb_log_file_size
/var/lib/mysql
OPTIMIZE TABLE