Skip to content

Update MySQL configuration suggestions#1157

Merged
jtpalmer merged 3 commits intoubccr:xdmod9.0from
jtpalmer:update-mysql-optimizations
Nov 14, 2019
Merged

Update MySQL configuration suggestions#1157
jtpalmer merged 3 commits intoubccr:xdmod9.0from
jtpalmer:update-mysql-optimizations

Conversation

@jtpalmer
Copy link
Copy Markdown
Contributor

@jtpalmer jtpalmer commented Nov 7, 2019

Description

Update MySQL configuration suggestions.

Motivation and Context

Received at least one error that was solved by setting innodb_stats_on_metadata = off. The notes about max_allowed_packet may also be outdated.

Tests performed

Types of changes

  • Bug fix (non-breaking change which fixes an issue)
  • New feature (non-breaking change which adds functionality)
  • Breaking change (fix or feature that would cause existing functionality to change)

Checklist:

  • My code follows the code style of this project as found in the CONTRIBUTING document.
  • I have added tests to cover my changes.
  • All new and existing tests passed.

@jtpalmer jtpalmer added the documentation Documentation updates label Nov 7, 2019
@jtpalmer jtpalmer added this to the 9.0.0 milestone Nov 7, 2019
@jtpalmer
Copy link
Copy Markdown
Contributor Author

jtpalmer commented Nov 7, 2019

If anyone has any other suggestions please comment. We may also want to add something about innodb_buffer_pool_size.

plessbd
plessbd previously approved these changes Nov 12, 2019
@jtpalmer
Copy link
Copy Markdown
Contributor Author

@plessbd I increased more of the numbers. Some were less than the MySQL 5.5 default values...

@jtpalmer jtpalmer merged commit b5ff045 into ubccr:xdmod9.0 Nov 14, 2019
@jtpalmer jtpalmer deleted the update-mysql-optimizations branch November 14, 2019 14:55
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

documentation Documentation updates

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants