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

Increased TTFB in HTTP load balance

We have our own rack in Amsterdam, Leaseweb. We do HTTP load balance (via Cloudflare) with 3 Windows 2019 IIS servers: Server 1: Bare-metal supermicro server. Runs IIS, MySQL8, and Redis. Server 2: ...
1
vote
1answer
32 views

One user for all databases or different user for different databases?

I have multiple (Wordpress) websites that use different mysql databases. I would like to know if I should use different users for different databases, or just use one user (such as root) for all ...
0
votes
0answers
23 views

Best practices to troubleshoot stuck php application due to internal curl calls to unresponsive endpoints

Recently I found myself with a website (Prestashop e-commerce on a Centos PHP-FPM /Apache / MySql machine ) that was down and not responding to web requests. After investigation, issue was due to an ...
2
votes
0answers
59 views

MariaDB high %sys load on AMD compared to Intel

we have run into a issue with MariaDB and AMD Epyc 7402. We also have much less potent Intel servers that do not suffer from this problem, using exact same configuration (we are using ansible). Under ...
1
vote
1answer
36 views

Mysqldump generated file that is smaller size then database [closed]

My database is 250 MB and dump size is 82 MB. I am using latest MariaDB. running this command: mysqldump -u user -p database > t.sql
0
votes
0answers
8 views

Mysqld: status_output has automatically turned itself on, spams gigabytes into error_log files

Mysql 8.0.21-12 on linux Those two flags have automatically turned on with my database server. innodb_status_output innodb_status_output_locks That caused gigabytes of logfiles, I thought the ...
0
votes
0answers
34 views

MySQL and MariaDB are not working after installing

I am attempting to setup wordpress on my nginx server. During the installation the tutorial I was following had me install mariaDB. However after running the secure_sql... command, it reported that ...
0
votes
1answer
130 views

mysql user@% can access from localhost

I was always told that "%" means every host except localhost. However I have created a user4@"%" and I can connect to from localhost. screenshot So now I am a bit confused ...
0
votes
0answers
46 views
+50

Mariadb multi-source replication - Table doesn't exist

I'm setting up multi-source replication with Mariadb 10.6 servers. I have 2 mariadb servers with databases that have the same name "database". I want those two servers to replicate their DB ...
0
votes
1answer
27 views

Multiple Website Lampp Stack

I currently have a Xampp on my local machine(ubuntu) for web developpment, this one is for study. Then I have, before the Xampp, a lampp stack with wordpress for work. After setting up Xampp my ...
0
votes
1answer
20 views

Unable to log in remotely with mysql

I am unable to log into a mysql database remotely. Running an ancient debian system (jessie). mysql --version reports: mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (x86_64) using readline 6.3 ...
0
votes
0answers
15 views

MySQL 8.0.21 error log is cluttered with [Note] [MY-012102] [InnoDB] Open file list len in shard X is Y

Since we have upgraded our MySQL server to 8.0.21 from 5.7, our error log is cluttered with the following message (if it is even an error message?), which takes a lot of space in our log and it is ...
0
votes
2answers
63 views

Why are binlogs on by default in MySQL 8 and will they be deleted automatically?

We recently discoverd that in MySQL 8 default configurations, binlog.* files clutter up in /var/lib/mysql on Ubuntu 20.04 machines. i.e. we have a 4.2 GB database size and around 500 MB binlogs per ...
0
votes
0answers
21 views

Azure Managed Instance - Virtual Machine Whitelisting

I am having quite a few problems with setting up an Azure VM that is linked to an Azure Managed Instance SQL Server. The aim of this is to be able to setup a linked server in SSMS that can connect to ...
1
vote
2answers
52 views

Hide my password in Ansible Playbook

I would like to run mysqldump in the Ansible playbook by the shell module. Trying to find a way to hide my MySQL root password in the ansible playbook or Ubuntu. I currently have a file that was ...
0
votes
0answers
33 views

Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name

I've recently upgraded my MariaDB servers from 10.1 to 10.6 and now when I restart services for example wildfly, I get this message : sudo service wildfly restart Failed to get properties: Unit name ...
1
vote
0answers
26 views

Apache CustomLog directive failing - pipe

I have the following directive in my apache2_site.conf file: CustomLog "|/home/me/myjlog.py %h \"%r\"" common which should create a log in my MySQL server. myjlog.py ...
2
votes
1answer
45 views

MYSQL is at 197% CPU usage ~ not allowing site to run

Spec: 8 GB memory / 4 vCPUs / 25 GB ssd Ubuntu 20.04 My website got hit with a DDoS recently and had this continuous high CPU usage error for 4 days and the site will not load up, I take a look using ...
0
votes
0answers
78 views

MySQL errors after reinstalling

At first, I wanted to reinstall MySQL to repair ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) problem with command apt-get purge mysql-server,...
0
votes
0answers
26 views

Load balancer with Nginx [duplicate]

When implementing an application with a horizontal cluster load balancing scheme. Should the database be hosted on a single server or should there be a database on each server?
0
votes
0answers
20 views

How do you set up MySQL master-master replication for my digitalocean host and my laragon localhost?

I created a Laravel web application on my computer using Laragon, then hosted it on Digital Ocean and it works fine. Now, I am supposed to implement a Mysql master-to-master replication for my "...
1
vote
0answers
20 views

MySQL won't start randomly, can't figure out why

I have tried every Stack Overflow article I could find and I can't get this to work. I had an EC2 instance that was a little too small so I upgraded it. MySQL won't start no matter what I do. This is ...
0
votes
0answers
13 views

SQL Cookie Flagging Rule

I my scenario SQL cookie rule being triggered but the cookies do not have anything malicious in them WAF. Could anyone please let me know why this is? I've replicated the issue with false positive (...
0
votes
2answers
44 views

What is the best & safe & fastes way to backup a large mysql database?

I have a mysql server running on a Debian server. I have a mysql database wich is 150GB... What is the best way to take a backup of it? I'll say: screen then mysqldump -u user -p database > ...
1
vote
0answers
43 views

Can't access phpmyadmin and local localhost:8000 with two errors for each of them

Recently reinstalled Ubuntu 21.04 on my computer and installed php8 and Nginx. I run the server for Laravel and when I go to localhost:8000 I got this error: Illuminate\Database\QueryException could ...
0
votes
0answers
50 views

Removing a node from Galera Cluster

I have to update the os on a few servers and I need to remove a db from the cluster. wsrep_cluster_address='gcomm://192.168.2.59,192.168.2.60,192.168.2.61,192.168.2.62,192.168.2.63' Do I remove the ...
0
votes
1answer
42 views

Unable to connect to Azure MySQL from Ubuntu 20.04

mysql -h foobar.mysql.database.azure.com -u me@foobar -p From 18.04 and Windows 11, connection is successful. From 20.04, connection seems to hang, or never complete. I enter the password and get a ...
0
votes
1answer
30 views

Cannot connect to remote database from docker with java application

Why my java application cannot connect to my mysql server ? docker-compose.yml version: "3" services: chiesulu: #image: 523840521829.dkr.ecr.us-east-1.amazonaws.com/djammadev/chiesulu:...
0
votes
0answers
17 views

MySQL group replication with no downtime

Simple question - I have a server running MySQL and need to set up group replication. Can't afford downtime. How can one set up a mysql group replication on a running mysql server? (the other servers ...
0
votes
1answer
37 views

Run mysql in terminal without argument giving socket error

When I type in mysql into terminal I got the following error: ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) But if run mysql with some arguments like ...
0
votes
0answers
17 views

Crontab start/stop mysql not running

I'm trying to run simple cronjob here Line 1 0 19 * * * service mysql stop Line 2 45 19 * * * service mysql start However, nothing running so far. What did i missed here? Logs showing below : Oct 21 ...
2
votes
1answer
44 views

Using MySQL raw disk on Windows?

I'm having trouble getting MySQL 5.7 to use raw disk (a block device, bypassing the filesystem) for its data. My understanding of the documentation is that basically, first time mysqld is executed, ...
0
votes
1answer
27 views

CPanel: What's overwriting my MySQL config settings? [closed]

I have a weird problem whereby every few weeks, changes I've made to MySQL config are being reset to their defaults. I'm on Centos 7.9 and CPanel 98.0.9. I'm making my changes via PHPMyAdmin while ...
0
votes
0answers
27 views

Container exits after installing mysqli in a dockerized PHP-apache

I am new to Docker and I need a php:8.0-apache container with mysqli installed. Just mentioning mysqli on a raw image causes an error: Fatal error: Uncaught Error: Class "mysqli" not found ...
0
votes
0answers
14 views

What is twoamp process in mysql? [duplicate]

My mini server installed mariadb 10. somedays, my server is very slowly so I checked command ps-ef and top I checked and there is a suspicious process. Its name is twoamp. The problem is that the ...
0
votes
1answer
52 views

OPTIMIZE TABLE innodb file per table while system is running

I had an 800 GB Moodle mdl_logstore_standard_log.ibd database file. I deleted around 900 million rows in 10-15 days. The .idb file was around 800GB and still the same size after deletion. I want to ...
0
votes
1answer
45 views

WordPress MYSQL DB BINARY LOG - Droplet/SERVER Volume Increasing rapidly

My WordPress website uses Nginx. Recently I have noticed that server volume has increased from 8GB to 40GB. I have found that the WordPress MYSQL Binary Log is taking more space. Each second, database ...
0
votes
0answers
117 views

Mysql server not starting error 13 Ubuntu 20.04

My mysql server doesn't start it gives an error 13 (Permission denied) i just changed the mysql data directory (to be honest I am not sure if I did that correctly) I have made sure the new directory ...
1
vote
1answer
396 views

Server crash caused by MySQL CPU usage

Premise: I'm not a DBA and i'm not in to servers, but i'm the only person in the company that is able to use a little that stuff. We have a Windows VPS with the following specs: CPU: Intel Xeon E5-...
0
votes
0answers
25 views

MySQL not saving to separate data directories

Lately I've been struggling with MySQL and it's data directory a lot. At first, I've tried docker for multiple instances but our company doesn't prefer docker no one knows why. So I come up with a ...
1
vote
0answers
47 views

Mysqldump really slow when dumping to network drive

I'm facing an issue when dumping a mysql database to the network drive. The thing is I'm getting really slow speeds (around 3-7mb/s). Dumping locally, the speed is fine. I've coded my own program that ...
0
votes
0answers
22 views

cacti container mysql service unable to start

I tried to run this cacti container but MySQL failed to start, any idea, I have tried all sorts of answers from the site. https://hub.docker.com/r/quantumobject/docker-cacti [cacti@rhelvm3 ~]$ podman ...
1
vote
1answer
84 views

web page shows me timeout gateway error FastCGI

I proceed to explain the problem and scenario a bit complex for my limited knowledge. initially I thought it was some problem associated with the performance of my scripts and queries, so I created ...
1
vote
1answer
251 views

MySQL ERROR 1045 Access denied for 'nova'@'controller'

Description I installed Openstack Wallaby using OpenStack Installation Guide, all command and configuration is on my Github. This LAB is running on VirtualBox and I have another LAB with the same ...
0
votes
1answer
78 views

Monitoring Byte Usage of Large MySQL InnoDB Buffer Pools?

I am trying to monitor the total number of used bytes in a MySQL 5.7 InnoDB Buffer Pool, that can go up to 100GB, using Innodb_buffer_pool_bytes_data but it seems that this status variable is a 32-bit ...
0
votes
2answers
73 views

MySQL performance issue due to caching

perl mysqltuner.pl --host 127.0.0.1 [--] Skipped version check for MySQLTuner script [--] Performing tests on 127.0.0.1:3306 [!!] Successfully authenticated with no password - SECURITY RISK! [!!] ...
0
votes
1answer
38 views

MySQL CPU usage difference between my local server and Linode server

I have 2 similar servers, one on my local computer, the other on Linode. OS is Ubuntu 20.04 LTS on both. When I import a large database into MySQL, my local computer uses less than 10% of CPU while ...
0
votes
0answers
37 views

Apache crashing because of high memory usage

CPU[|||| 3.3%] Tasks: 71, 155 thr; 1 running Mem[|||||||||||||||||||||||||||||||||||||||||||||||||1261/1875MB] Load average: 0.00 0.02 0.01 ...
0
votes
1answer
53 views

Is the slow down due to traffic every day near 12 pm

I checked the slow logs and I got only 4 queries in 2 hours and all of them were similar to this: "SELECT HEX(uhash) AS uhash, vehid, IF(deleted = 0 AND follow_price_drop = 1, 1, 0) AS ...
0
votes
0answers
59 views

Requesting access token through OpenStack Keystone very slow

I have been trying to figure out why requesting an access token through OpenStack Keystone is relatively slow (lowest is about 400 ms to in some cases more than a second). To get down to the cause I ...

1
2 3 4 5
168