Bumped by Community user

occurred May 9, 2017 at 17:12

replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/

Source Link

edited Apr 13, 2017 at 12:42

1

I have the following metrics from mysql workbench

After I have set innodb-buffer-pool-size to 6G, according to this answer's this answer's query on how to determine the recommended size.

While the used buffer usage was between 87% and 93% before I did the change in my.cnf (running with default values) it dramatically decreased now, so I'm wondering if 6G was too much. Especially because the key efficiency was between 97% and 99% before the change, which has lost some percents now.

Should I bother more about key efficiency or buffer usage? Should I decrease the buffer usage again?

The server specs are

Intel® Xeon® E5-1650 v3 
Hexa-Core Haswell Hyper-Threading-Technologie
128 GB DDR4 ECC RAM
2 x 480 GB SATA 6 Gb/s Data Center Series SSD

I have the following metrics from mysql workbench

After I have set innodb-buffer-pool-size to 6G, according to this answer's query on how to determine the recommended size.

While the used buffer usage was between 87% and 93% before I did the change in my.cnf (running with default values) it dramatically decreased now, so I'm wondering if 6G was too much. Especially because the key efficiency was between 97% and 99% before the change, which has lost some percents now.

Should I bother more about key efficiency or buffer usage? Should I decrease the buffer usage again?

The server specs are

Intel® Xeon® E5-1650 v3 
Hexa-Core Haswell Hyper-Threading-Technologie
128 GB DDR4 ECC RAM
2 x 480 GB SATA 6 Gb/s Data Center Series SSD

I have the following metrics from mysql workbench

After I have set innodb-buffer-pool-size to 6G, according to this answer's query on how to determine the recommended size.

While the used buffer usage was between 87% and 93% before I did the change in my.cnf (running with default values) it dramatically decreased now, so I'm wondering if 6G was too much. Especially because the key efficiency was between 97% and 99% before the change, which has lost some percents now.

Should I bother more about key efficiency or buffer usage? Should I decrease the buffer usage again?

The server specs are

Intel® Xeon® E5-1650 v3 
Hexa-Core Haswell Hyper-Threading-Technologie
128 GB DDR4 ECC RAM
2 x 480 GB SATA 6 Gb/s Data Center Series SSD

Bumped by Community user

occurred Apr 2, 2017 at 8:57

Bumped by Community user

occurred Mar 1, 2017 at 2:20

Bumped by Community user

occurred Jan 25, 2017 at 23:24

Bumped by Community user

occurred Dec 14, 2016 at 8:45

Bumped by Community user

occurred Nov 12, 2016 at 16:17

Bumped by Community user

occurred Oct 2, 2016 at 14:04

Bumped by Community user

occurred Aug 31, 2016 at 8:15

Bumped by Community user

occurred Jul 30, 2016 at 8:27

Bumped by Community user

occurred Jun 29, 2016 at 14:23

Bumped by Community user

occurred May 28, 2016 at 4:08

edited tags

Link

edited Oct 2, 2015 at 14:03

baao

111
1
4

Source Link

asked Oct 2, 2015 at 13:54

baao

111
1
4

inno_db_buffer_pool_size and key efficiency

I have the following metrics from mysql workbench

After I have set innodb-buffer-pool-size to 6G, according to this answer's query on how to determine the recommended size.

While the used buffer usage was between 87% and 93% before I did the change in my.cnf (running with default values) it dramatically decreased now, so I'm wondering if 6G was too much. Especially because the key efficiency was between 97% and 99% before the change, which has lost some percents now.

Should I bother more about key efficiency or buffer usage? Should I decrease the buffer usage again?

The server specs are

Intel® Xeon® E5-1650 v3 
Hexa-Core Haswell Hyper-Threading-Technologie
128 GB DDR4 ECC RAM
2 x 480 GB SATA 6 Gb/s Data Center Series SSD

mysql innodb bufferpool

Stack Exchange Network

Return to Question

inno_db_buffer_pool_size and key efficiency