Opened 5 months ago

Closed 5 months ago

#13433 closed Feature/Enhancement Request (fixed)

MySQL fine tuning on foucault.mayfirst.org

Reported by: https://id.mayfirst.org/joseph Owned by: https://id.mayfirst.org/joseph
Priority: Medium Component: Tech
Keywords: foucault.mayfirst.org puppet mysql my.cnf Cc: https://id.mayfirst.org/jamie
Sensitive: no

Description

TNP has been getting some error messages that max_user_connections have been reached when running some Drupal migrations (backup_migrate module). Is it possible to add foucault.cnf file to Puppet similar to colin.cnf to add similar fine tuning to MySQL?

Change History (7)

comment:1 Changed 5 months ago by https://id.mayfirst.org/joseph

And in fact, TNP is reporting that they been getting the max_user_connection errors since migrating foucault from florence to linda.

comment:2 Changed 5 months ago by https://id.mayfirst.org/jaimev

  • Owner set to https://id.mayfirst.org/jaimev
  • Status changed from new to assigned

I've copied the custom config changes for colin to./modules/mayfirst/files/mysql-server/foucault.cnf , added 'm_mysql::config { "foucault.cnf": }' to foucault's manifest, and pushed puppet changes to foucault.

comment:3 Changed 5 months ago by https://id.mayfirst.org/joseph

Thanks for this Jaime, but as per the IRC chat, it looks like this caused MySQL to fail to load. To fix the immediate problem I commented out all the lines in the new foucault.cnf file and manually started MySQL. I'm not sure what the procedure for rolling back puppet changes is. I'm also not sure which line in the configuration file is causing the problem. Can you take a look?

Last edited 5 months ago by https://id.mayfirst.org/joseph (previous) (diff)

comment:4 Changed 5 months ago by https://id.mayfirst.org/jaimev

  • Cc https://id.mayfirst.org/jamie added

Oh no, sorry about that. I misunderstood that you wanted exactly the changes that were made in colin. In hindsight it was the change to the innodb_log_file_size and innodb_buffer_pool_size that probably caused mysqld to fail on foucault. I've fixed that by doing a clean shutdown of mysql and moving /var/lib/mysql/ib_logfile* out of the way before applying the new changes. That seems to have resolved the issue now. You may want to check that everything in that new config is actually what you want. Copying jamie for more input.

comment:5 Changed 5 months ago by https://id.mayfirst.org/joseph

  • Owner changed from https://id.mayfirst.org/jaimev to https://id.mayfirst.org/joseph

Thanks, Jaime. Cheers for sorting out the underlying issues. I'll let you know if TNP continues to have issues.

comment:6 Changed 5 months ago by https://id.mayfirst.org/jaimev

  • Resolution set to fixed
  • Status changed from assigned to feedback

comment:7 Changed 5 months ago by automatic

  • Status changed from feedback to closed

No news is good news (we hope)! Given the lack of feedback, we think this ticket can be closed.

Please login to add comments to this ticket.

Note: See TracTickets for help on using tickets.