Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql8]

49 questions
1
vote
1 answer

MySql 8 crashing on loop without specific errors and with enough memory

I'm running Ubuntu 20.04.03 with Mysql 8.0.27. I have reinstalled LAMP from scratch several times and at the moment I only have 3 WordPress sites but I have tested only 1 and only 2 sites as well. Increased the RAM to 2GB and 3GB Swap. Nothing seems…
gallo2000sv
  • 11
  • 1
  • 3
1
vote
0 answers

Unable to connect to MySQL through port 3306 Windows Server 2012 R2

It looks like weird happening, I've followed and fixed all the possible things but still MySQL port 3306 is not accessible remotely. Here's my setup: Machine: Windows Server 2012 R2 MySQL Server: 8.xx Settings have been applied: In my.ini…
Code Cooker
  • 111
  • 3
1
vote
0 answers

Alternate method for caching mysql query (query_cache) on version above 8.0

On mysql version 8+ the query_cache support was removed. I know why it is not a friendly thing with InnoDB when considering the CPU. But I've some databases which really need this support where user repeat the same query in most cases. Is it…
TELA
  • 33
  • 5
1
vote
1 answer

How do I deal with MySql incompatibility (8 -> 5)

Recently, we updated one system to UBUNTU 20.04 (it has been way backlevel). The new installation includes MySQL at version 8. One of the functions we've been performing on the retiring system, is to backup a MySQL remote database, owned by a…
Dennis
  • 167
  • 1
  • 12
1
vote
0 answers

MySQL max_execution_time not working

We have a general problem with MySQL 8 running on Windows 2019. We see queries running forever and the CPU is 100%, the system becomes unresponsive. While we know this needs a better investigation to be solved, and we're looking for a database…
Alex K.
  • 41
  • 6
1
vote
0 answers

MySQL Ubuntu doesn't start anymore after disk storage was full

MySQL Version: Ver 8.0.22-0ubuntu0.20.04.2 for Linux on x86_64 ((Ubuntu)) Today I encountered that my MySQL stopped running, all my websites are offline. When I try to run manually I get the following by systemctl start mysql.service: Job for…
Tarik Hacialiogullari
  • 11
  • 7
1
vote
0 answers

how to disable SSL for samhain when connecting to a mysql database?

I have just compiled samhain from source and I added database connection credentials to the samhainrc file. For some reason, samhain will not write any entries to the mysql database. The db credentials, which connect to a remote Amazon RDS instance,…
S. Imp
  • 526
  • 1
  • 4
  • 19
1
vote
0 answers

mysql 8 only creating single log file instead of 2 (ib_logfile0)

I am having an issue with one of my mysql servers that has to do with the innodb logfiles. Even though it is configured to have 2 logfiles as normal, when I start up the server it only creates one of them. This causes a big issue as if the service…
Stephen Boyle
  • 11
  • 3
0
votes
0 answers

Not able to connect MySQL server using new administrator account

I created a new administrator account when I upgraded to MySQL server 8.0.15 in windows 10. However, I am not able to log into the server using mysql -u root -p. So, I tried using the newly created user account and attempted to start the server. …
Karen Goh
  • 1
  • 3
0
votes
1 answer

InnoDB Cluster - MySQL 8.0.13 upgrade to 8.0.14 on Ubuntu 18.04.1 LTS - Cluster creation fails

With the recent upgrade of MySQL from 8.0.13 to 8.0.14 on Ubuntu 18.04.1 LTS, I started getting an error by the time I issue the dba.createCluster('mycluster') after following the procedure to create from scratch a 3 machine InnoDB Cluster using the…
zzpdr
  • 3
  • 3
0
votes
0 answers

Windows MariaDB 10.6.5 upgrade to MariaDB 10.6.11

I am considering upgrading my MariaDB 10.6 to 10.11 -- (maintained for 5 years). I updated 10.6.5 to 10.6.15 with a simple in-place update; but found these troubling comments on doing updates form 10.6 to 10.11:…
MeSo2
  • 254
  • 1
  • 3
  • 18
0
votes
0 answers

kubernetes: URLs for Mysql operator YAML stable versions

Install mysql operator: Following https://dev.mysql.com/doc/mysql-operator/en/mysql-operator-installation-kubectl.html kubectl apply -f https://raw.githubusercontent.com/mysql/mysql-operator/trunk/deploy/deploy-crds.yaml kubectl apply -f…
eastwater
  • 111
  • 2
0
votes
0 answers

Laravel in php-fpm is not connection to new mysql pods in service of k8s in digitalocean

I have a k8s cluster running in digitalocean. Within this cluster we have several pods running php-fpm (7.4) with a laravel application (v8.18) connected to a number of mysql database replica's. When i load test the system the php and database…
Bram
  • 101
0
votes
0 answers

mysql metadata locks persist after thread is terminated

this is tested on mysql 8.0.28, but other versions show it too we get occasions where a metadata lock persists after the thread that created it has terminated. For example for these locks in performance_schema.metadata_locks | OBJECT_TYPE |…
dll
  • 1
  • 1
0
votes
1 answer

MySQL client 8.0 showing "fwrite: Broken pipe" on large query when using a pager

I have always been using a pager (--pager="less -SFX" to be more specific) for MySQL client. Previously I was on version 5.6 of MySQL client/server and it was doing great. Recently I started to use MySQL client/server version 8.0, and the client…
goodbyeera
  • 59
  • 6
1
2
3 4