All Questions
Tagged with database-tuning mysql-8.0
3 questions
0
votes
1
answer
71
views
MySQL 8.0.39 - MySqlException (0x80004005): Out of memory;
We have a Windows Server 2022 with 56Gb RAM. This server is dedicated to MySQL DB and during idle it has ~50.9Gb available memory. But while bulk inserting rows (200k rows) into a table from an ...
0
votes
0
answers
1k
views
How to correctly set wait_timeout for MySql server
I have a dedicated server to run a WordPress website.
I use Nignx + php fpm + MySql 8.0.
Php processes are set to run for a maximum of 60 seconds, and mysql is used just to run this website.
I checked ...
1
vote
1
answer
614
views
Why is the execution time on Datagrip longer on MySQL 8 than MySQL 5.7 on a new Linux Server?
I am migrating from a 4 year old setup to a brand new high performance server and am experiencing slower performance than on the old machine.
The old setup is a Ubuntu 16.04 Server on bare metal Intel ...