Page MenuHomeDevCentral

Tweak MariaDB configuration on devserver and dbserver-mysql roles
Open, Needs TriagePublic

Description

According this entry, innodb_buffer_pool_size should be set at 2G.

Ysul
$ mysql
mysql> SELECT CEILING(Total_InnoDB_Bytes*1.6/POWER(1024,3)) RIBPS FROM
    -> (SELECT SUM(data_length+index_length) Total_InnoDB_Bytes
    -> FROM information_schema.tables WHERE engine='InnoDB') A;

+-------+
| RIBPS |
+-------+
|     2 |
+-------+
1 row in set, 17 warnings (2 min 5.24 sec)

Event Timeline

dereckson renamed this task from Tweak MySQL configuration on Ysul to Tweak MariaDB configuration on devserver and dbserver-mysql roles.Fri, Oct 10, 23:05
dereckson moved this task from Backlog to Next on the Servers board.
dereckson updated the task description. (Show Details)