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.
8,753
questions
0
votes
1
answer
611
views
Automysqlbackup does not use the configured password
I have automysqlbackup installed on debian. I added USERNAME and PASSWORD to /etc/default/automysqlbackup, but when automysqlbackup runs, I get the output:
/etc/cron.daily/automysqlbackup:
ERROR 1045 (...
- 1,733
1
vote
0
answers
138
views
GitLab CI Runners faild InvalidParameterCombination: Cannot find upgrade path from 5.7.38 to 5.6 , Terraform
GitLab CI Runners faild the jbo with the following error message
│ Error: Error modifying DB Instance legacy-dms: InvalidParameterCombination: Cannot find upgrade path from 5.7.38 to 5.6.
│ status ...
- 59
0
votes
1
answer
153
views
How to find usage (memory) of databases inside a Google CloudSQL instance?
I run multiple databases inside a single CloudSQL instance. My problem is that I cannot get monitoring insights at the individual database level. For example, if I want to know how much memory a ...
- 483
0
votes
1
answer
265
views
InnoDB: Assertion failure in file .../padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/btr/btr0cur.cc line 7940
Every hour one MariaDB version 10.4 database stops responding and I see this output in the log file:
Feb 9 10:00:02 maria55 mysqld: 2023-02-09 10:00:02 0x7f72547a5700 InnoDB: Assertion failure in ...
0
votes
1
answer
186
views
The process hangs in SQL: State "Writing to net"
Tell me what this problem may be related to
query: SELECT /*!40001 SQL_NO_CACHE */ * FROM tblLogs;
enter image description here
1
vote
1
answer
48
views
What data type do big applications use to store time data?
I am trying to find out which data type is better to store time data inside either MySQL or Cassandra database for a big application like Facebook or Instagram? There are a lot of similar questions ...
- 427
2
votes
1
answer
539
views
Is it better to generate "UUID" and "TIMESTAMP" within the NodeJS application or using the database built-in functions?
I am writing a TypeScript-NodeJS application and want to handle object ids and created_at TIMESTAMP within the NodeJS application, instead of using MySQL or Cassandra built-in UUID or TIMESTAMP ...
- 427
0
votes
2
answers
362
views
mysql connection failed when DNS is down
We had DNS problem in the past with one of our web application coded in php
Therefore we used IP addresses instead of the server name and we used HOST file and decided to perform a crash test
When our ...
- 1
1
vote
0
answers
199
views
Nginx - Server dead when received many requests
we have a large Woocommerce website hosted on Google VM servers (E2 4vCPU + 32 GB RAM + 100 GB SSD Storage), recently we created a mobile application using flutter and WordPress -Woocommerce- API, but ...
google-compute-engine
0
votes
1
answer
225
views
Can't connect to mysql after managing systemctl (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock')
I needed to run a program (just a compiled c++ program, not script, i.e., like /var/programname) on startup on CentOS 7.
I followed this guide https://www.howtogeek.com/687970/how-to-run-a-linux-...
- 97
0
votes
1
answer
874
views
Cannot access MySQL in container from Windows host
I am on a Windows 11 Professional workstation. I am running a containerized MySQL in Docker via the instructions at https://hub.docker.com/_/mysql. It says all I need to do is run docker run --name ...
- 101
0
votes
0
answers
588
views
Docker giving nameserver error upon docker pull
I recently setup a new linux machine, running Ubuntu 22.04.1 LTS, I installed Docker on it, and Portainer to make viewing easier.
I am attempting to install a mysql image, however when running the ...
- 31
0
votes
0
answers
197
views
MySQL service stuck in starting state after restoring database failed
I was restoring a MySQL database using the import wizard, importing from dump files. This took a while but in doing so the disk ran out of space so never finished importing.
Now, the MySQL57 service ...
0
votes
1
answer
5k
views
How to fix MySQL 8 replication error 1062 after system reboot?
after a system reboot my replication stopped suddenly. So I'm trying to bring the slave back to the most current state.
To do this I create a dump from the master's database and import it on the slave,...
- 135
0
votes
1
answer
70
views
Real time synchronization of databases with different data structure
I'm rewriting a legacy web application. At some point in time, I want old and new app, to work in parallel, on databases with different structure (both mysql). The troublesome part is that the ...
- 133
0
votes
1
answer
969
views
Can anybody explain the output of "mysql -V"?
For example,
# mysql -V
mysql Ver 15.1 Distrib 10.3.37-MariaDB, for Linux (x86_64) using readline 5.1
I think "Ver 15.1" means the version of the mysql client. But why does the client ...
- 123
0
votes
1
answer
2k
views
couldn't find key MYSQL_KEY in Secret default/mysql-secret
I have the following file that creates a mysql-secret for mysql deployment pod.
apiVersion: v1
kind: Secret
metadata:
name: mysql-secret
type: Opaque
data:
mysql-password: MTExMTEx
mysql-root-...
- 427
0
votes
1
answer
246
views
BIND MySQL / MyDNS
Good afternoon,
after successfully failing to ask that Question on Stackoverflow, I have to post it here. Problem still exists.
I need your power for another project.
I want to have a DNS-Server, wich ...
0
votes
2
answers
425
views
MySQL shuts down
Got unexpected shutdown of mysql in my VPS server (with 40GB SSD, 2GB ram and 2 vCPU's). Hosted only one website (with LAMP stack). Of course - increased some mysql limits for bigger queries which are ...
- 1
0
votes
1
answer
172
views
Zabbix DB connection support DNS SRV Records
I have Zabbix Mysql 3 node Innodb cluster, which gives 3 DNS SRV Records with Mysql Router endpoints. I need to configure Zabbix server and web DB connection as DB host (e.g _mysql._tcp.example.com), ...
- 1
0
votes
0
answers
68
views
Can't login with a unique username into mysql
I am trying to connect a existing server files with my new machine. I need to be able to connect with a username "????", but for some reason mysql is not accepting that.
Using root as ...
1
vote
0
answers
1k
views
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) docker
I have tried accessing the docker container mysql command line from outside of the docker container and from within. I am receiving the error above each time. I have also reset the docker container ...
- 11
0
votes
1
answer
860
views
"CrashLoopBackOff" while deploying mysql on multi-node cluster
This is my configmap.yaml file:
apiVersion: v1
kind: ConfigMap
metadata:
name: mysql
labels:
app: mysql
app.kubernetes.io/name: mysql
data:
primary.cnf: |
# Apply this config only ...
- 427
1
vote
1
answer
2k
views
Need to keep each binlog files to 24 hrs
We have a requirement werein we need to keep each binlog files(like mysql-bin-changelog.025249, mysql-bin-changelog.025250, mysql-bin-changelog.025251....) of MYSQL RDS to minimum 24 hrs.
However, i ...
- 13
0
votes
1
answer
120
views
When and How we should specify "clusterIP" inside the "service.yaml" file?
I tried to deploy mysql and cassandra databases using kubernetes.io/docs instructions. In both of them, within the service.yaml files, they use clusterIP: None like following:
For cassandra:
...
- 427
0
votes
0
answers
38
views
auto forward sender's email using mySQL to lookup up email address of recipient then send
Here is the scenario. Users of my web site can search for other users who live in the same vicinity. Match results display links which transfer match data to a send message page. The send msg page ...
- 1
0
votes
1
answer
119
views
Should I add a "MySQL_URI" to the MySQL Kubernetes deployment file?
This is a Kubernetes deployment file that originally was using only MongoDB database. I tried to add MySQL to it as well like below:
apiVersion: apps/v1
kind: Deployment
metadata:
name: auth-depl
...
- 427
0
votes
1
answer
74
views
How to start myslq if it fails to start due to insufficient space, and the main files eating up space are mysql binary log files
My server disk usage looks like this:
Filesystem Size Used Avail Use% Mounted on
udev 989M 0 989M 0% /dev
tmpfs 200M 21M 180M 11% /run
/dev/xda1 59G 57G ...
- 1
0
votes
2
answers
3k
views
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
EDIT: The following describes my original question, but as long as I haven't resolved the issue yet, I thought maybe I should change settings inside the created mysql POD instead of mysql config files ...
- 427
0
votes
2
answers
66
views
What database my applications will use if I have a locally installed database beside it's pod running on local Kubernetes?
I have installed mysql on my Ubuntu machine. I also have a locally running Kubernetes and deployed a mysql deployment on Kubernetes and can reach to that using kubectl exec -it mysql-b4769786-5hf4m sh ...
- 427
1
vote
1
answer
1k
views
Dump a Table from MySQL Database directly from sql server using bash
How can I dump a table from a MySQL database using a bash script?
Like we can use the below command to dump a table
mysql -u username -p database_name > file.sql
But how can I dump only a single ...
- 145
0
votes
1
answer
340
views
Is it possible to manage read/write requests on AWS RDS?
We are planning to create a read replica on our MySql Database on RDS but we want to manage this on AWS. Does AWS has a solution that manages requests and redirect them if write to the master ...
- 51
0
votes
0
answers
303
views
MariaDB I/O Limit
I have a server with MariaDB 10.6.
The mysqld process uses 100% of DSK with very high I/O.
I tried to set these values but it didn't have any affect:
innodb_io_capacity = 100
innodb_io_capacity_max = ...
- 11
1
vote
2
answers
2k
views
Reset mysql user password using hashed password
On a mysql server, I made a mistake and changed the wrong user's password, like this:
SET PASSWORD FOR username@'10.1.%' = PASSWORD('newpassword');
Before changing the password, I used "SHOW ...
- 113
0
votes
0
answers
1k
views
debian 11 + mariadb remote connections
I'm having trouble getting mariadb to accept remote connections on Debian 11 on a fresh installation.
I've changed bind address to bind-address: 0.0.0.0. From the same server, I can telnet into port ...
- 249
0
votes
0
answers
139
views
Connecting postfix to mysql with ssl
I've been trying to get the correct recipe of settings to allow postfix to connect to mysql where ssl is required. So far I have the following config that is not working:
user = mysqluser
password = ...
- 249
0
votes
0
answers
697
views
MariaDB: Problems with UTF-8 characters after migrating to a new server
I have migrated to another server many times but never had this problem. None of the possible solutions work and utf-8 characters appear incorrectly in PHP-FPM.
What I tried:
ALTER DATABASE database2 ...
0
votes
1
answer
637
views
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 ...
- 59
0
votes
1
answer
518
views
Unable to connect to server following phpMyAdmin upgrade from 5.1 to 5.2
Not sure to post on the right StackExchange forum. If not, let me know!
Working environment:
OpenSUSE Leap 15.4
MariaDB : mariadb Ver 15.1 Distrib 10.7.7-MariaDB
PHP 8.0.25 (cli) (built: Oct 31 2022 ...
- 75
1
vote
3
answers
2k
views
How do I securely connect to MySQL 8 when caching_sha2_password is in use?
I am moving from our web sites to a new host. Our database cluster (PCS) now runs MySQL 8. We have two database servers (active and failover) with a floating virtual IP that we connect to MySQL to.
We ...
0
votes
1
answer
319
views
How to tell which versions of TLS MYSQL (windows) is using?
I have another question about a pair of servers that I cannot turn off TLS 1.0/1.1. Even though IISCrypto showing them off and made right reg entries.
The servers run an IIS10/PHP7.4/MySQL8 stack. ...
- 129
0
votes
1
answer
805
views
Can I run a Select query on an SQL dump?
Here is my issue. I've a backup system, that creates an SQL Dump from a DB cluster every day. Works fine, yade yade. The cluster died one day and we realized, the sql dump were wrong for the past 1 ...
- 1,096
1
vote
1
answer
571
views
Keep MySQL strict mode disabled after server restart (Hostinger VPS with Ubuntu 18.04)
So I have a site hosted on VPS Hosting Plan 2 of Hostinger, and it uses MySQL for the database, with the OS of my Virtual Machine being Ubuntu 18.04.
I have to keep MySQL's strict mode disabled ...
- 113
2
votes
1
answer
605
views
How to MySQL replicate or cluster to setup a failover scenario?
after a massive data problem from my provider in GER, I'm now forced to deal with failover scenarios. But there are a few questions that I can't find any real answers to. So I hope someone can help me ...
- 135
0
votes
0
answers
109
views
What does fragmented table mean in MySQL?
I have a MariaDB database with an InnoDB engine and querying data take a lot of time so I search and found that it is maybe related to the tables being fragmented but I cannot understand what it means ...
0
votes
3
answers
53
views
Point domain to server without HTTPD
I have a VM on Oracle Cloud Free tier and have the dedicated IPv4. I installed MariaDB on this server.
I want to point the domain name (example.com) to that machine, in order to access the MariaDB ...
1
vote
1
answer
341
views
How to reduce MySQL Server CPU usage or load?
How to reduce MySQL Server CPU usage or load ?
Here is my.cnf :
skip-name-resolve
disable_log_bin
innodb_buffer_pool_size=200GB
innodb_log_file_size=25GB
innodb_log_buffer_size=8M
...
- 11
1
vote
1
answer
80
views
Jaguards database configured incorrectly
After following the steps given in the README of the open source tool provided by Jaguards, I always get the "Database configured incorrectly" warning icon, and can't manage to login with ...
- 21
0
votes
1
answer
2k
views
Can't stop/restart MariaDB after a server ran out of disk space?
Using CentOS Stream release 8.
I've made space, but my site still responds with Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] Connection refused in /var/www/sites/mysite/inc/DB.php
I've ...
- 1,148
0
votes
1
answer
412
views
MariaDB Master-Master replication with 3 servers, no ports open on master
I want three MariaDB database servers, one master and two "slaves". I want to be able to read and write on every server, and have this replicated on the other servers. I read on the internet ...
