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
0 answers
9 views

MySQL have_ssl and have_openssl DISABLED but certificates installed - Windows Server 2012

I want to enable an SSL certificate in MySQL Server for some users. I tried following this tutorial - the one that is below Best Answer. I installed OpenSSL, created all certificates and edited the my....
0 votes
0 answers
8 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. ...
  • 125
0 votes
1 answer
29 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 ...
  • 984
1 vote
1 answer
31 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
28 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
14 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
0 answers
9 views

Lost remote connection to MySql through DDNS addres to local server after installing IIS Windows Server 2012 R2

I have a DDNS service that I use to connect to my local MySQL server when out of the office through my desktop app, everything was working fine until I installed IIS on the Server (Win Ser 2012 R2), I ...
0 votes
3 answers
34 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 ...
0 votes
0 answers
28 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 ...
1 vote
1 answer
36 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
67 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,034
0 votes
0 answers
39 views

Problems with MySQL 8.0.29 Data Corruption, Need Upgrade Path Advice

I have a master and 3 slaves running the buggy 8.0.29 version of MySQL. Yesterday 2 of my slaves stopped synchronizing and I couldn't complete a full resync from a fresh dump because I kept getting &...
0 votes
1 answer
28 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 ...
0 votes
0 answers
7 views

mysqldump encrypted table - keep encryption

If we have a table that is encrypted at rest, like this: https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html#innodb-data-encryption-master-key-rotation How can we configure mysqldump ...
0 votes
0 answers
13 views

Installing XtraBackup on Centos 6

I’m trying to install XtraBackup on centos 6 using this guid but i get these errors: Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (C6.10-base) Requires: libmysqlclient.so.16()(64bit) Error: ...
  • 99
0 votes
0 answers
17 views

IIS FastCGI configuration for high concurrency

I am hosting, on Windows Server 2022, a web application that makes regular ajax calls to a PHP backend. The calls themselves are quite light, just pulling and pushing data from and to a MySQL db. Over ...
  • 189
0 votes
1 answer
58 views

Getting a SQLSTATE[HY000] [2002] Connection refused in PHP Apache Docker container using mariadb, if connected via Dockerfile's CMD (PHP CLI works)

I'm trying to run a Docker container based on: PHP 8.1 Apache 2.4 MariaDB (latest official docker image) It all starts up without any issue; but I'm unable to connect with the Docker Container's DB ...
  • 135
2 votes
1 answer
109 views

MariaDB - Contiunes to use more memory

We are running Maria DB 10.6.9 on CentOS and we are observing it continues to increase the usage of memory. Server Specifications: RAM - 128 GB vCPUs - 48 Swap - 100 GB We have configured ...
0 votes
0 answers
13 views

Does Fail2ban work with XAMPP on linux?

I would like to hear from you, or anyone who has already had proven experience with this feature. I use XAMPP to host my website because it's cheaper to have a Dedicated Server with reserved traffic ...
0 votes
0 answers
182 views

Warning - InnoDB: Page xxx in the doublewrite buffer is not within space bounds: page [page id: space=yyy, page number=zzz]

I keep encountering this warning when the tablespace file mytable.ibd is over 4G bytes, then get the following error: [ERROR] InnoDB: Trying to access page number xxx in space yyy, space name ...
  • 103
0 votes
0 answers
19 views

My GCP MySQL 8 CloudSQL Database, Randomly Restarts without a clue

I using a mysql instance on cloud sql. However this instances began to restart the mysqld (mysql deamon) several times per day. It was not due a change or anything, but just increasing like this. ...
0 votes
0 answers
12 views

openvpn access server cluster cannot create a unique ovpn file for all server

i install multiple openvpn access server 2.11 on ubuntu 20 and install mysql for cluster it now i have 5 openvpn server in 1 cluster openvpn_as 2.11 ubuntu 20 1.my problem is ovpn file that download ...
0 votes
2 answers
26 views

Override MySQL Variable from conf file

I try to override the variable optimizer_switch and change rowid_filter=on to rowid_filter=off. The official documentation does not provide an example. Attempt #1: /etc/mysql/mariadb.conf.d/70-...
  • 451
0 votes
1 answer
25 views

mysql -V shows a different version than mysqld -V

I'm running centos 7 with mySQL 5.7.xxx. mysql -V shows Ver 14.14 Distrib 5.7.26-29, but mysqld -V shows Ver 5.7.11-4. systemctl status mysql and systemctl status mysqld both show the same running ...
0 votes
0 answers
30 views

MySql losing connection after few minutes while waiting [migrated]

I have an annoying problem. I think the connection is lost when there is no operation in mysql for a while. I've added a video to make it more explanatory. I tried the solutions on the internet but ...
0 votes
0 answers
17 views

Xampp not starting MySQL Database nor Apache Web Server

Neither MySQL Database nor my Apache Web Server is able to start. I have XAMPP 7.3.0-0 installed and I'm getting this huge error: Error message Plus another one that shows a syntax error: Syntax error ...
0 votes
0 answers
13 views

phpmyadmin Mysql frozen in time

i got a remote mysql database connection to work on my on ubuntu 22.04. I see on the website that i setup that data gets into the database as users are active in the website but when i check ...
0 votes
0 answers
43 views

Unable to Recover MySQL Database [Missing FILE_CHECKPOINT]

Using MariaDB 10.7.3 via Homebrew on MacOS Monterey 12.6.1 While trying to recover the database after a system crash, I am stuck with the following situation. [Note] mysqld (server 10.7.3-MariaDB) ...
  • 11
1 vote
1 answer
64 views

MySQL Corrupted After System Crash

I'm using MacOS Monterey 12.6.1 with Homebrew 3.6.6 and MariaDB 10.8.3 The OS crashed out of nowhere and rebooted itself. After the reboot I was unable to connect to the database: Can't connect to ...
  • 11
0 votes
0 answers
15 views

What CLI tool helps rotate my mysqldump files on cloud storage: daily backups, weekly, and monthly backups with deletion?

I need to backup my mysqldump files from my database server, daily. I need to retain: daily backups for a week weekly backups for a month monthly backups for a year yearly backups after that My ...
  • 101
0 votes
0 answers
30 views

mysql server failed when I run mysql.server start

I use macOS Big Sur(11.5.1) and MariaDB(10.8.3_1) with Brew. After some manipulations with Docker(my guess) my mysql.server stopped working. I cannot run my local MySQL server. These lines I have in ...
1 vote
1 answer
30 views

Why can I use mysql even when entering a wrong password when using sudo?

If I try to login to mysql with mysql -u root -p and enter the wrong password, then I get "access denied". However, if I use sudo mysql -u root -p and enter the wrong mysql password, then I ...
  • 451
0 votes
0 answers
32 views

MariaDB 10.5 refusing remote connections

I've gone through a lot of tutorials and questions and I still can't get it to work. I installed MariaDB 10.5 on a Debian 11 server. We changed its IP address yesterday and since then we cannot do a ...
0 votes
1 answer
124 views

socket doesn't exist; Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I know the problem isn't new. But I have tried lots of thing. What I couldn't figure out is, socket wasn't available since I downloaded mysql. /etc/my.cnf /etc/mysql/my.cnf /var/lib/mysql/my.cnf None ...
0 votes
1 answer
50 views

cannot find mysql folder in /var/lib/mysql in rescue mode

I have I have a server fault. So I have boot to rescue mode and logged in using ssh as root. I have mounted all the disk and in fact I can see files, users etc. (I was using Vestacp as Control Panel). ...
  • 9
0 votes
0 answers
10 views

performance_schema.setup_objects not work?

According to the documentation, built-in databases are ignored by Performance Schema. The effect of the default object configuration is to instrument all objects except those in the mysql, ...
0 votes
1 answer
49 views

does it benefit if split multiple sites into multiple database in shared hosting env?

I have been wondering this for long time let's say I run a server where I hosted 2 PHP sites , they are both heavy on database query server is multi-core , let's say 4 core 8 thread with bunch of RAM ...
  • 176
1 vote
0 answers
20 views

How do I install latest iRedMail with existing Nginx

How to keep the current Nginx websites running intact when installing iRedMail?
  • 1,441
0 votes
1 answer
47 views

Why only a few TCP packets arrive at destination on port 3306 through an IPsec VPN tunnel?

This question was off-topic on Networkengineering and the recommendation was to post it here. So, here we go... When connected to a network via a VPN tunnel (IPsec/L2TP), I can normally access a MySQL ...
  • 101
0 votes
1 answer
30 views

Promote to Master a MySQL slave that has its own slaves

MySQL standby & chained replication Having the current setup (not using GTID) (see link to image): PRODUCTION NODES: MASTER (A) -> SLAVE (A1) + SLAVE (A2) STANDBY NODES: -> SLAVE (B) (with ...
  • 1
2 votes
2 answers
80 views

Improving mysqltuner recommendations

Problem with mysql under Ubuntu 20.04.0 in a CPU optimized droplet of 32GB RAM with 16 cores. I have 25 sites installed on this server. I have around 100k pages views daily and during peaks around 300 ...
2 votes
0 answers
76 views

Digital Ocean MysQL with high load average but no queries

My website is down because it cannot communicate with my MySQL database. My database is inside the Digital Ocean server. My CPU, Load Average and memory is in the highest values right now: Despite ...
  • 121
0 votes
0 answers
33 views

Big performance gap between two similar servers in mysql-percona 5.6 ubuntu

I cannot figure out reason of performance difference between two (three?) similar percona 5.6 instances. I prepared some tpcc-like benchmarking using sysbench and among 3 similar servers, one is ...
0 votes
0 answers
43 views

Error in Processing Request Error code: 403 Error text: Forbidden Apache2

Error in Processing Request Error code: 403 Error text: Forbidden This kind of error pops up when i am trying to do anything that requires ajax in phpmyadmin.[enter image description here][1]
1 vote
1 answer
76 views

Unable to login to my mySql server as root, and unable to reset root password

I'm trying to access and backup a mySql Database but without success. I know the root password, but if I try to login to the DB using it I get a ERROR 1045 (28000): Access denied for user 'root'@'...
0 votes
0 answers
17 views

LOAD BLOB COLUMN INSTEAD OF FILE

Is there a way to load data from blob column instead of file like LOAD DATA FROM (SELECT A.B FROM A) INTO TABLE TEMP FIELDS TERMINATED BY ' ' ENCLOSED BY '"' LINES TERMINATED BY '\n' instead of ...
  • 11
1 vote
0 answers
42 views

Swap space extensively used while enough RAM is available on Ubuntu 20.04.01

On a new dedicated root server with Ubuntu 20.04.01, running only MySQL 8.x the system starts to swap extensively while enough RAM is available. System: RAM 230GB Swap space 64GB InoDB_Buffer set to ...
  • 2,053
0 votes
1 answer
37 views

Running MySQL server as slave for one DB and master for another

I have two MySQL server having master-slave replication for DB1. The slave server holds DB2. Because the slave server is not so powerfull I want to run analytics upon DB2 on the third server. Is it ...
  • 121
0 votes
0 answers
17 views

mysqli_sql_exception: Malformed packet

Summarize the problem The error log on my app reports a mysqli_sql_exception: Malformed packet exception. I would like to know what might cause the issue. The error is triggered on mysqli_select_db ...
  • 111
1 vote
1 answer
29 views

What might cause a PDO MySQL connection to be terminated?

Summarize the problem My PDO (MySQL) connection is disconnected during execution of the code. The connection is created successfully, but around 0.05% of the time the Error log reports a disconnection....
  • 111

1
2 3 4 5
172