As of May 31, 2023, we have updated our Code of Conduct.

Questions tagged [mysql]

MySQL is an open-source database owned by Oracle. ServerFault topics include how to run the server. For more MySQL specific questions like backup/restore/recovery/configuration, dba.stackexchange.com is probably a better home.

Filter by
Sorted by
Tagged with
0 votes
1 answer
31 views

Synchronizing load balanced Linux servers

I want to load-balance two dedicated linux servers, I'm planning to do that using round robin DNS, but I can't find a way to synchronize the servers to be identical. The servers are running a perl ...
Tunis0101's user avatar
0 votes
1 answer
18 views

Multiple MySQL versions using Homebrew on macOS giving Error - Can't connect to local MySQL server through socket

I am trying to set up multiple MySQL versions using Homebrew. I have already been using MySQL 8.*, which is running fine. However, due to some old project requirements today, I have installed another ...
pixelngrain's user avatar
0 votes
0 answers
16 views

Which cache solution is suitable for Storing Cache data? [closed]

We are running many websites in Yii2 application. Currently we are using File Cache for Data Caching. Now we want to use load balancer and put our caching on dedicated server. We will have to store ...
Future King's user avatar
0 votes
1 answer
68 views

Frequent server downtime and suspicious server hits to access random Pdf files

Our Server hosting PHP web application is facing frequent downtime Server Information [Nginx, FreeBSD] Web application [PHP 5.6, MYsql 5.7] I have gone through the Nginx logs and below are my findings ...
Ekky's user avatar
  • 101
-1 votes
1 answer
47 views

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 ...
santhosh's user avatar
  • 101
-1 votes
1 answer
32 views

MariaDB - Emulate MySQL 5.7 version number?

I have been running MariaDB 5.5 on a linux server for several years. Yesterday, I upgraded to MariaDB 10.11.3. Now, my backup software has stopped backing up the databases, reporting an error that &...
Ryan Griggs's user avatar
0 votes
1 answer
22 views

Exporting Wordpress Database from GCP

I am trying to create a local replica of wordpress database by exporting it on gcloud console (after logged in via gcloud compute ssh) but facing this problem. Is there a way out to resolve this or ...
Atul Vaish's user avatar
1 vote
0 answers
52 views

Issues with AWS Aurora MySQL engine version "5.7.mysql_aurora.2.10.3"

Is anyone else experiencing problems after recent automated AWS Aurora MySQL database engine updates? (specifically "5.7.mysql_aurora.2.10.3") Over the weekend our web servers started ...
Michael Engelbrecht's user avatar
-1 votes
2 answers
75 views

How can I stop my MySQL server from going down?

I have a website based on a MySQL server on an Ubuntu machine. Every several weeks, one of my users complains that the site does not work, and I find out (using service mysql status) that it is ...
Erel Segal-Halevi's user avatar
2 votes
0 answers
23 views

Can I recover MySQL data if the .MYD file is missing? [migrated]

One of my databases got corrupted. All of the tables are stored using MyISAM engine. I managed to grab what's left in the server's mysql\data folder. All the ib* files are intact. As for the tables, ...
Lee's user avatar
  • 21
0 votes
0 answers
15 views

Failover configuration using two machines for Angular/Django/MySQL

Using only two physical machines, how can one establish a failover configuration using nginx for a web app that is built on angular, django and mysql. If any of the software components such front-end, ...
hyper_w's user avatar
0 votes
1 answer
42 views

PuTTY Reverse Tunnel to MySQL

I have: A local Windows 10 PC running MySQL Server 8.0.33 on port 33060. A remote Ubuntu 20.04.6 LTS VPS running MySQL Server 8.0.33 on port 3306. I want to create a reverse tunnel using PuTTY on my ...
Tyler's user avatar
  • 101
0 votes
1 answer
75 views

Connecting to MySQL on GCP CE instance (WordPress)

I installed WordPress from the Google Cloud Marketplace into a Compute Engine instance, and am trying to connect to the MySQL instance on that machine using DataGrip on my local machine (macOS). I can ...
serlingpa's user avatar
  • 109
0 votes
0 answers
11 views

Optimzing Docker Builds with docker-compose.yml when using PostGres DB's, performance, etc

I just have a general about how best to build and manage DB servers when using Docker builds with docker-compose.yml. Historically, I've sometimes bound the Postgres DB's to a bound folder on the ...
SScotti's user avatar
  • 141
0 votes
1 answer
56 views

which memory limit applies when php performs a MySQL query

If I run php as FPM, I can set my memory limit in php.ini or .user.ini. PHP can perform a MySQL query, and I can set memory limits in /etc/my.cnf for for instance the innodb buffer pool. If PHP runs ...
Guido Goluke's user avatar
1 vote
1 answer
67 views

Maximum possible memory usage

recently my MYsql CPU usage is 120% and this is the mysqltuner can you please suggest for me a solution ? [root@server1 ~]# mysqltuner >> MySQLTuner 1.8.3 - Major Hayden <major@mhtx.net&...
Misha's user avatar
  • 13
0 votes
0 answers
87 views

Why does MySQL 5.7 inside a docker container always crash?

I have a MySQL 5.7 docker container that was provisioned via a docker-compose file, the file looks like this: version: '3' # Run command: docker compose --env-file .env.local up services: # ...
Budianto IP's user avatar
0 votes
0 answers
21 views

Creating a non-public DNS alias for a database in Google Cloud Platform (GCP)

I am currently working on setting up a database in Google Cloud Platform (GCP), and I would like to create a non-public DNS alias for it. The purpose of this alias is to provide a more user-friendly ...
Isla Yoder's user avatar
0 votes
2 answers
57 views

Starting MySQL standalone works but as windows service it fails

I have an xampp-portable directory that contains mysql/mariadb. The xampp directory is located directly on d:, so path is d:\xampp and mysql is d:\xampp\mysql I want to run mysql as windows service so ...
Michael's user avatar
  • 103
0 votes
1 answer
26 views

How to add a new database on replication?

I have a mysql replication with two servers. There are actually 3 databases on it. On master : server-id = 1 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days ...
erwann le guevedec's user avatar
1 vote
0 answers
88 views

After upgrade Ubuntu 18.04 to 20.04, MySQL server is not starting

I upgraded Ubuntu 18.04 to 20.04 The process upgraded MySQL 5.7 to 8.0 It instantly started to throw errors in error logs [ERROR] [MY-013379] [Server] Server upgrade started with version 80033, but ...
Tauras's user avatar
  • 11
1 vote
1 answer
459 views

Mysql stopped working on Ubuntu 22.04. Failed to upgrade server. Error

I have a basic DigitalOcean droplet (1gb ram and 1 cpu) that has a few websites on it. There are a couple nodejs sites and a couple of Wordpress sites. All are pretty low traffic. It normally works ...
Steve K's user avatar
  • 125
0 votes
1 answer
37 views

There is no replication in a HA Cluster

I had the problem of unrelated data aborting in a HA cluster and my Mysql resource was in standalone on both nodes, I managed to solve the problem and both nodes are synchronized, the problem now is ...
Ivan Jufi's user avatar
0 votes
1 answer
65 views

Setting mysql using ansible in ubuntu remote machine

I have written one ansible playbook for installing MySQL server in ubuntu remote machine but is not working here is the yaml code --- - name: setting mysql in ubuntu hosts: web01 become: yes ...
Nikhil Chopra's user avatar
0 votes
0 answers
27 views

Temporary internal error / Dovecot: Initialization failed status=deferred (host domainname.com

Postfix working properly on port 25. Getting error while sending mail from outlook 2016. Tried to use Port 110 & 993 & 995. Mail Log:- Error:- status=deferred (host domainname.com[private/...
dhanu gulati's user avatar
0 votes
0 answers
35 views

vsftpd with MySQL 8 - login not working

I try to set up vsftpd using MySQL database for login users via pam.d I have this config in /etc/pam.d/vsftpd: # Standard behaviour for ftpd(8). auth required pam_listfile.so item=user sense=...
netdjw's user avatar
  • 121
-2 votes
0 answers
27 views

How to install Postfix admin & Poastfix on CentOS 7 with Nginx and MySQL 5.5

Anyone could you please help me to install Postfix Admin & Poastfix on CentOS 7 with Nginx and MySQL 5.5 and multiple domains? Senario:- I want to send & receive mail from multiple domains.
dhanu gulati's user avatar
0 votes
2 answers
69 views

CPU Usage 98% /usr/sbin/mysqld and server down

How to solve this issue. php codeigniter framwork Everyday our server goes down because of these issue. CPU usage 98 % Ram used 21 083 MB /usr/sbin/mysqld
majid lateef's user avatar
0 votes
0 answers
41 views

How to set individual mysqld parameters using the bitnami/mysql Helm chart?

We're using the bitnami/mysql Helm chart. We'd like to upgrade max_allowed_packet from the default 16M value to 64M. From what I can read in the README, it looks like the only way to pass custom [...
BenMorel's user avatar
  • 4,447
6 votes
3 answers
119 views

DRBD Cluster nodes not configured (StandAlone)

I have a HA cluster with two nodes, node one is the primary and node 2 is its mirror. I have a problem in the mysql resource since my nodes are not synchronized drbd-overview Node Principal: 0:home ...
Ivan Jufi's user avatar
0 votes
1 answer
49 views

why mysql bin logs are not expiring even though expiry was set

I am using 5.7.37-log MySQL Community Server. my mysqld.cnf looks below: server_id = 11 log_bin = bin.log log-bin-index = bin-log.index binlog_format = row max_binlog_size = 100M socket = mysql.sock ...
santhosh's user avatar
  • 101
0 votes
1 answer
121 views

Diagnosing mySQL Random CPU Spikes

Our organization has a fairly advanced (as in many moving pieces) web application that's been working great up until recently, yet no noticeable changes have been made. There is the Apache Web Server, ...
Johnathan Martin's user avatar
1 vote
0 answers
49 views

MySql Service Not Starting in cluster with DRBD

I have a high availability cluster with two nodes configured, after a maintenance carried out by an external company when restarting the system my mysql resource stopped working. when executing the ...
Ivan Jufi's user avatar
0 votes
0 answers
45 views

Slow MySQL 5.7 on Windows Server 2019

MySQL 5.7 standard install with standard my.cnf (server) one table 20mb size Dell R210II Windows Server 2019 Xeon 1230 v2 16gb ram 1 queries executed, 1 success, 0 errors, 0 warnings Query: CALL ...
Olaman's user avatar
  • 1
0 votes
0 answers
34 views

My website running on an ubuntu server went down after reboot

I was going to add something to my php.ini file so I added it and rebooted the server. My site went down after the reboot citing that it could not connect to the database so I reversed the changes ...
brothman01's user avatar
0 votes
0 answers
39 views

Replicate mysql database when target server is MariaDB 10.5 (where mysql.user is a view)

I have a sync script that does a mysqldump on the mysql database on a source server, then imports that dump on the target server, followed by privelege flush. Systems are CentOS 7. In MariaDB 10.5, ...
elyograg's user avatar
  • 229
2 votes
1 answer
118 views

Extremely slow MySQL writes in Ubuntu (ext4) guest on Promox 7.3-3 (ZFS) host

I'm trying out Proxmox 7.3-3 as a hypervisor and managed to install it using ZFS on my NVMe (Samsung_SSD_970_EVO_Plus_2TB_S6S2NS0T505403V) I also installed a Ubuntu 22.04 VM and its filesystem is ext4 ...
bilogic's user avatar
  • 155
1 vote
1 answer
65 views

PHP-FPM static max_children amount doesn't seem to matter much during stress tests

I've been stress testing PHP-FPM set up as static using wrk, with NGINX running on Ubuntu Server 22.04 for the past few days, writing down results for every scenario. When I look at them, it seems to ...
Medito Di Terra's user avatar
2 votes
2 answers
66 views

How should I automate replication of a production MySQL db onto a read/write dev server for testing while also scrubbing the data first?

I know there are lots of variables here, and they're highly dependent upon the applications in the environment as well as the needs of the org. I read this post first, as the question was similar. [...
EdwinJ's user avatar
  • 23
0 votes
1 answer
89 views

Mariadb creates a subprocess after crash

We recently had a crash on our Mariadb server (10.6.5) on a Debian 9 VM. The process was restarted without error but now there's a second mariadb process like so : mysql 26718 5.1 42.4 15062644 ...
Ror's user avatar
  • 321
-2 votes
1 answer
66 views

How to fix MySQL installation in Ubuntu:20.04 Docker container

invoke-rc.d: could not determine current runlevel invoke-rc.d: policy-rc.d denied execution of start. ... Cannot stat file /proc/3352/fd/0: Permission denied Cannot stat file /proc/3352/fd/1: ...
ouya olivier's user avatar
1 vote
1 answer
57 views

Hardening the security of a backup shell script of a web-server with mysql database

In the case of a simple web-server with a MySQL database, the script has to dump the database, copy the web-server files and tar everything together. Then a NAS server Rsync the tar file via a "...
Danilo Steps's user avatar
1 vote
0 answers
36 views

mysql NDB backup fail

I'm trying to abort a backup on a NDB cluster like this: ndb_mgm> abort backup 2304081512 Abort of backup 2304081512 ordered But there is no change, the backup seems to be stalled : ndb_mgm> ...
Julien's user avatar
  • 133
0 votes
0 answers
61 views

Errors importing JSON file to MySQL using mysqlsh Util.import_json

I am having errors in attempting to import a file into MySQL (8.0.32-0ubuntu0.22.04.2) using: mysqlsh mysqluser@localhost/jsondb --import /path/to/file.json If the file is in, say, my home directory, ...
Werewolf Lord's user avatar
0 votes
1 answer
49 views

Is it possible that MariaDB caches the host depending on user and password?

I have a weird issue with my MariaDB in my application. I use Prisma NodeJS library to connect to MariaDB. The problem looks like this: I have localhost and a remote server with the same username/...
jcubic's user avatar
  • 230
-1 votes
1 answer
31 views

Anybody familiar with the Shoretel database?

I have a copy of the local db from our old shoretel voip system... which is no longer in service. I've been tasked with trying to locate information pertaining to calls to and from specific numbers ...
boog's user avatar
  • 212
0 votes
0 answers
46 views

How to parse MariaDB version banner?

I encountered this form of MariaDB DB version via banner: 5.5.5-10.3.38-MariaDB-log What is the version of the MariaDB? Is it 5.5.5 or 10.3.38? If one of them, what is the meaning of the other? (I ...
Gari BN's user avatar
  • 101
0 votes
2 answers
54 views

EC2 instance randomly crash

My EC2 instance kept crashing, here is the syslog, can server admin expert share some insight? https://pastebin.com/jfP8qhZX
Shawn's user avatar
  • 217
0 votes
0 answers
65 views

Not able to start mysql after upgrade from 5,7 to 8 (ubuntu upgrade)

After upgrading ubuntu to 22.04 from 18.04 (was planning on upgrading to 20.04 but somehow I ended up with 22.04) I'm not able to start mysql server. The error is as follows: [ERROR] [MY-000077] [...
Arjan Meijer's user avatar
1 vote
1 answer
69 views

Azure App Service to Azure MySQL Flexible Server Latency

I have an old ASP.NET MVC website I've moved to Azure that runs super slow on there. I've set up: App Service (Standard S1 plan) Azure Database for MySQL flexible server (Burstable, Standard B1ms - ...
scgough's user avatar
  • 155

1
2 3 4 5
174