2015-02-25 13:37:13 |
Jorge Niedbalski |
bug |
|
|
added bug |
2015-02-25 13:37:19 |
Jorge Niedbalski |
percona-cluster (Juju Charms Collection): assignee |
|
Jorge Niedbalski (niedbalski) |
|
2015-02-25 13:37:22 |
Jorge Niedbalski |
percona-cluster (Juju Charms Collection): importance |
Undecided |
Medium |
|
2015-02-25 13:37:25 |
Jorge Niedbalski |
percona-cluster (Juju Charms Collection): status |
New |
In Progress |
|
2015-02-25 13:42:54 |
Jorge Niedbalski |
summary |
innodb_buffer_pool_size: Not configurable and default is not suitable for most of deployments. |
innodb_buffer_pool_size: Not configurable and default is not suitable for all the deployments. |
|
2015-02-25 13:43:58 |
Mario Splivalo |
percona-cluster (Juju Charms Collection): assignee |
Jorge Niedbalski (niedbalski) |
Mario Splivalo (mariosplivalo) |
|
2015-02-25 13:45:07 |
Mario Splivalo |
percona-cluster (Juju Charms Collection): assignee |
Mario Splivalo (mariosplivalo) |
|
|
2015-02-25 13:48:45 |
Jorge Niedbalski |
percona-cluster (Juju Charms Collection): assignee |
|
Jorge Niedbalski (niedbalski) |
|
2015-02-25 14:48:25 |
Mario Splivalo |
bug |
|
|
added subscriber Mario Splivalo |
2015-02-25 17:48:43 |
Jorge Niedbalski |
branch linked |
|
lp:~niedbalski/charm-helpers/fix-1425528 |
|
2015-02-25 17:48:46 |
Jorge Niedbalski |
percona-cluster (Juju Charms Collection): status |
In Progress |
Fix Committed |
|
2015-02-25 19:21:20 |
Jorge Niedbalski |
description |
The configuration directive innodb_buffer_pool_size is being set to the same value as the dataset-size.
The overall recommendation would be to make innodb_buffer_pool_size configurable at first and if is not
specified set it to current dataset-size + 10% ( You need buffer pool a bit (say 10%) larger than your data (total size of Innodb TableSpaces) because it does not only contain data pages – it also contain adaptive hash indexes, insert buffer, locks which also take some time) [0]
[0] http://www.percona.com/blog/2007/11/03/choosing-innodb_buffer_pool_size/ |
The configuration directive innodb_buffer_pool_size is being set to the same value as the dataset-size.
The overall recommendation would be to make innodb_buffer_pool_size configurable at first and if is not
specified set it to current dataset-size + 10% ( You need buffer pool a bit (say 10%) larger than your data (total size of Innodb TableSpaces) because it does not only contain data pages – it also contain adaptive hash indexes, insert buffer, locks which also take some time) [0]
After discussing this on this thread we concluded a few things:
- Using 50% of available memory for setting innodb buffers seems to best setting.
- Removed query cache ( not supported on percona-cluster )
- Removed the preferred engine setting because only InnoDB is supported
[0] http://www.percona.com/blog/2007/11/03/choosing-innodb_buffer_pool_size/ |
|
2015-02-26 09:59:21 |
Edward Hope-Morley |
percona-cluster (Juju Charms Collection): status |
Fix Committed |
In Progress |
|
2015-02-26 16:16:57 |
Jorge Niedbalski |
description |
The configuration directive innodb_buffer_pool_size is being set to the same value as the dataset-size.
The overall recommendation would be to make innodb_buffer_pool_size configurable at first and if is not
specified set it to current dataset-size + 10% ( You need buffer pool a bit (say 10%) larger than your data (total size of Innodb TableSpaces) because it does not only contain data pages – it also contain adaptive hash indexes, insert buffer, locks which also take some time) [0]
After discussing this on this thread we concluded a few things:
- Using 50% of available memory for setting innodb buffers seems to best setting.
- Removed query cache ( not supported on percona-cluster )
- Removed the preferred engine setting because only InnoDB is supported
[0] http://www.percona.com/blog/2007/11/03/choosing-innodb_buffer_pool_size/ |
The configuration directive innodb_buffer_pool_size is being set to the same value as the dataset-size.
After discussing this on this thread we concluded a few things:
- Using 50% of available memory for setting innodb buffers seems to best setting.
- Removed query cache ( not supported on percona-cluster )
- Removed the preferred engine setting because only InnoDB is supported
[0] http://www.percona.com/blog/2007/11/03/choosing-innodb_buffer_pool_size/ |
|
2015-02-26 16:17:08 |
Jorge Niedbalski |
branch linked |
|
lp:~niedbalski/charms/trusty/percona-cluster/fix-1425528 |
|
2015-06-04 19:32:15 |
Jorge Niedbalski |
percona-cluster (Juju Charms Collection): status |
In Progress |
Fix Released |
|