search

Releem / mysqlconfigurer

Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.
https://releem.com
GNU General Public License v3.0
252 stars 26 forks source link

max_heap_table_size needs increasing due to our session table being full #309

Closed drupaladmin closed 1 month ago

drupaladmin commented 1 month ago

Hi

I love Releem and it works great but there is an oversight I believe. I'm using Xenforo as our forum based software but one issue is that max_heap_table_size needs increasing due to our session table being full. I can null the string in z_aiops_mysql.cnf and force it in my.cnf but your systems will revert it back to whatever is deemed best and thus causing my session table to become full again.

Is there anyway to have an "ignore" flag set on a certain variable?

All the best! Dan

drupaladmin commented 1 month ago

Dan, thank you for your patience.

Releem tunes this variable to descrease disk usage by temporary table. But your application uses MEMORY engine. Looks like we should set this variable manually.

Releem doesn’t have user interface to set variables manually, but platform allows it.

Send me please the manual value for this variable and we’ll set it.

Looking forward to your reply.

drupaladmin commented 1 month ago

We’ve set manual value for this variable.