Re: Flex MySQL 8.0 on AzUre

[Nigel Gomm]

Update for anyone else struggling on Azure....

.... although we're encouraged to stick with Azure's default server settings they aren't limiting MySQL to any realistic memory maximum.


using this
SELECT (
(
(@@innodb_buffer_pool_size) +
@@innodb_log_buffer_size +
@@key_buffer_size +
( @@max_connections *
( @@binlog_cache_size +
@@binlog_stmt_cache_size +
@@bulk_insert_buffer_size +
@@join_buffer_size +
(@@max_allowed_packet) +
@@read_buffer_size +
@@read_rnd_buffer_size +
@@sort_buffer_size +
@@thread_stack +
@@tmp_table_size
)
) +
+
( @@open_files_limit * 1024)
) / 1024 / 1024 / 1024) AS max_memory_GB;

the default settings give > 150GB of memory.

By reducing max_connections, Max_allowed_packet and innodb_buffer_pool_size i was able to set the max memory to < 32GB and things are now more stable.