Questions tagged [mysql8]
49 questions
0
votes
1 answer
Is it possible to interchange Azure Database for MySQL between general-purpose and memory-optimised?
I have one instance of Azure Database for MySQL. The current configuration of the instance is "Gen5 - General Purpose - 2 vCore - 10GBMem". I would like to scale it to "Gen5 - Memory Optimised - 2 vCore - 20GBMem". Since I am going to do this on a…
s_ruchit
- 203
- 1
- 10
0
votes
1 answer
How do I grant or alter an existing user to allow remote authentication in MySQL 8?
The ultimate goal is to have the latest Zabbix release running in container, monitoring a bunch of switches.
Zabbix wants some flavor of MySQL (or postgres) so I figured I would set use the official (Oracle) MySQL 8.0.19 MySQL FOSS image.
I have a…
mr.zog
- 923
- 3
- 20
- 39
-1
votes
1 answer
Mysql server eating all RAM (100GB) when load is running
I am using Mysql - Server version: 8.0.29 MySQL Community Server - GPL
My server has 100GB RAM.
Of it I allocated innodb_buffer_pool_size as 90 GB
SET GLOBAL innodb_buffer_pool_size = 96636764160;
I am running a load script (shell) that basically…
santhosh
- 103
- 4
-1
votes
1 answer
MySQL 8 unusual behavior
The project that I'm working on using database frequently and does heavy procedures.
I'm always monitoring the system. with 16GB of RAM and 8 CPU's system usually works fine and not reaching it's limits but MySQL goes away very frequently with…
TT13
- 99
- 1