All Questions
1,007
questions
-1
votes
0
answers
10
views
How to monitor wordpress websites individually deployed on an apache2 server?
Since last few weeks there are sudden downs to my EC2 machine and none of the websites become accessible and also ssh to machine stops working. please help me fix it.
I have an EC2 machine where ...
0
votes
1
answer
48
views
Mysql filling up disk space, but storage not even on this disk
Have Mysql running on a server, with data, backups and logs each on their own disk.
For 2nd time recently the root disk has filled up to 100% which gets cleared the moment that MySQL restarts. This ...
- 133
0
votes
0
answers
49
views
What causes SSD write timeout over 120 seconds?
system:CentOS Linux release 7.6.1810 (Core)
kernel:Linux l-db11.tj.cn5 3.10.0-957.10.1.el7.x86_64 #1 SMP Mon Mar 18 15:06:45 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
SSD:Dera
cpu: 24 core
memory: 128G
...
0
votes
1
answer
72
views
Is there a way to house one MySQL DB in one location and others in another?
Have any existing MySQL 8.0 server installation on a Ubuntu 22.04 machine. Existing works without issue, but looking to import a very large DB but doing so in its current data directory will max out ...
- 101
0
votes
1
answer
201
views
Not able to connect to local MySQL install after using Docker and MySQL image to connect to secondary DB on external drive
Huge appreciation for help in advance. Using Ubuntu 22.04 and MySQL 8.
I have a legacy MySQL DB on an external hard drive as well as a local install on my Ubuntu machine, both using MySQL 8.
I set up ...
- 101
1
vote
0
answers
172
views
Large WordPress E-Com Site - Very slow performance (High volume of Post Meta data and Order Data)
I have an e-com store running on WordPress (Together with using WooCommerce) - We've operated the site for around 4 years now, and in that time, our website has grown heavily in sales and customer ...
- 11
2
votes
0
answers
2k
views
Connecting to MariaDB server: ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 11
I am trying to connect to an AWS hosted (RDS) MariaDB database (engine version 10.6.14). The database is hosted on a private subnet but it's accessible through a bastion host. I use an SSH tunnel to ...
- 121
1
vote
1
answer
516
views
MariaDB randomly crashes
I've encountered a peculiar issue related to my MariaDB database instance (version 10.2) that causes my MariaDB service to stop unexpectedly. I've attempted to investigate the problem by regularly ...
- 19
0
votes
0
answers
121
views
Fluentd logs not sent to Elasticsearch on K8s
I have a cluster in VirtualBox to learn kubernetes. I have a deployment that contains MySQL and phpMyAdmin. I created a DemonSet that has the fluentd image and collects the logs to transmit them to ...
- 1
1
vote
0
answers
198
views
MYSQL use too much disk (read / write)
I have big problem with my server. I am using Ubuntu linux version 22.04. The problem is in the write / read disk (light for the disk is all the time ON) when I have turn on apache (PHP) and MYSQL. ...
- 11
0
votes
0
answers
134
views
MacOS MySQL Client Gets Stuck on Query That is a Certain Size
My MySQL client gets stuck on a query when the output is a certain size. When it's small enough, the query will successfully output. The client is connecting to a remote server (Ubuntu 18.04). When I ...
0
votes
1
answer
259
views
Unable to connect to my server
I'm unable to connect to my own server, which has a MySQL database which I want to access.
I correctly opened the 3306 port on the router and called my internet provider that confirmed so.
But when I ...
- 1
1
vote
1
answer
1k
views
mysqld[1108] [Warning] Aborted connection 7466 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1'
I am running Ubuntu Server 20.04. It is a LEMP server running Mariadb. When I run the command sudo service mariadb status I get the following warnings:
Jul 28 00:18:59 mail.example.com mysqld[1108]: ...
- 93
1
vote
1
answer
284
views
Memory consumption on virtual server too large for applications being run
I have a Linux Ubuntu virtual server at Digital Ocean with the following specs: 1 vCPU, 2GB of memory, and 25GB of SSD storage.
The server is running a single WordPress website with around 400 unique ...
- 141
0
votes
0
answers
15
views
H3C server requirement [duplicate]
I am searching for a server that can best fulfill my requirements. I need it specifically for the best DB I/O performance for a 10-million record database. I am looking for generation-specific details ...
- 1
0
votes
1
answer
332
views
Remote MySQL server returning: MySQL server has gone away / Error while sending QUERY packet
I have 2 servers (both running Ubuntu 12.04)
APP server
running apache2, PHP7.2 and a CakePHP 2.0 APP
DATABASE server
running mysql 5.7
When I'am trying to insert into the database a big blob (...
- 1
0
votes
0
answers
936
views
I am not able to install MySQL on Amazon Linux
Step #1: – Remove previous installed packages and clear cache
I did Step #1.
Step #2: – Setup Yum Repository
I did Step #2.
Step #3: – disable all repositories in mysql repo file.
I did Step #3.
Step #...
- 21
1
vote
2
answers
307
views
Bad configuration MariaDB / MySQL
I currently have a LAMP on a dedicated server but with serious problems with MariaDB (MySQL).
I have installed a website with 100k daily pageviews and due to the need for the queries it is necessary ...
0
votes
1
answer
801
views
MariaDB 11.0.2 fails to start after upgrade from 10.11.4
I am on Debian Bullseye and just upgraded (or at least attempted to upgrade) MariaDB from 10.11.4 to 11.0.2.
Unfortunately, the service fails to start now. All I'm getting through systemctl status ...
- 51
0
votes
1
answer
185
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 ...
-2
votes
1
answer
309
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: ...
0
votes
1
answer
199
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/...
- 250
1
vote
1
answer
458
views
How to reload MySQL 8 and update SSL certificates
What is the correct way to update MySQL 8 SSL certificates without having to restart the service?
With PostgreSQL, you can do a reload using "systemctl reload postgresql", for example.
- 461
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 ...
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
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
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
0
votes
0
answers
122
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 ...
-1
votes
3
answers
125
views
Connect to multiple databases with user/pass file(s) and import data
Good day,
I have about 30 empty databases all on the same host. I am trying to write a script to import all the database schemas and data, that have already been exported using mysqldump in the ...
- 1
6
votes
0
answers
292
views
firewall-cmd to drop existing connections
I want to use firewall-cmd to temporarily block mysql port 3306, including existing connections.
However after I remove MySQL service, only new connections are blocked. The existing connections are ...
- 161
2
votes
1
answer
919
views
Installing MySQL 32-bit on Ubuntu 22?
Simple question really, I'm trying to compile a 32-bit code-base on a 64-bit system (ubuntu 22).
Getting the error: /usr/bin/ld: cannot find -lmysqlclient: No such file or directory
I know it's ...
- 133
0
votes
0
answers
4k
views
mysql.service: Main process exited, code=killed, status=9/KILL
I'm running a MySql Server and a dotnet core service on a single core 1GB RAM server.
I realized that our service throws mysql connection errors. After a little bit of investigating i found that mysql ...
0
votes
0
answers
395
views
MariaDB memory much higher than innodb_buffer_pool_size
I have a backend server with 1G RAM for my HTTP server and my MariaDB.
I noticed the database keeps getting killed by OOM once or twice a day. Most of the time the OOM is triggered by the HTTP server, ...
0
votes
0
answers
70
views
Can connect one remote server to MySql, but cannot connect two servers
I am trying to finish a website creation using three servers with Linux. For simplicity, I will identify the servers as server 1, server 2 and server 3. I am using MariaDB. All three servers are ...
- 1
0
votes
1
answer
187
views
Get usernames and IP addresses via tcpdump (or another capture tool) connecting to a MySQL server
I've MySQL installed on my Ubuntu server.
Because I would like to clean up my users they're currently active in MySQL, I would like to check first which users - and from which host - are connecting to ...
- 1
0
votes
1
answer
2k
views
Error java.sql.SQLNonTransientConnectionException between Glassfish 3 and MariaDB
I have a java web application deployed in glassfish. This application interacts with Mariadb server. Suddenly, the app stops working. I'm checking the app.log and glassfish server log and I have the ...
- 175
1
vote
1
answer
2k
views
bash script – MySQL commands and variables
I have a bash script who automate a Nextcloud server installation.
To run MySQL commands I use the mysql -e command
user@hostname:~$ mysql -e "CREATE DATABASE ‘NextcloudDataBaseName’"
I ...
- 79
0
votes
1
answer
215
views
install mysql in debian 9
I need to install MySQL 7.5 on Debian 9 stretch, I tried to download it using PPA but when I try to update and complete download I get error apt-key expire.
Err:2 http://repo.mysql.com/apt/debian ...
- 101
0
votes
0
answers
294
views
mysql service crash (ubuntu server)
mysql service craches and the server becomes down everyday or every two days and I do not know the reason (I am using apache and innodb).
mysql error log:
2022-03-12 11:11:22 140142364764096 [Note] ...
- 101
3
votes
1
answer
10k
views
mysqld fails to start due to InnoDB
I did install MariaDB on MX Linux, my system info below :
System: Kernel: 5.10.0-9-amd64 x86_64 bits: 64 compiler: gcc v: 10.2.1
parameters: BOOT_IMAGE=/boot/vmlinuz-5.10.0-9-amd64
...
- 51
0
votes
1
answer
3k
views
Failed to Import MySql database from phpMyAdmin as well as Command line
Well, I have tried to import small size database, it works. However, when I am about import a large database it shows the following error from phpMyadmin.
Static analysis:
1 errors were found during ...
0
votes
0
answers
359
views
Mysql remote connect CentOS
i have problem with mysql remote connect.
In my.cnf have: bind-address = 0.0.0.0 and #skip-networking.
In users mysql have special user remote@%
And still not working.
If i try: nmap -p 3306 remote.ip....
-1
votes
1
answer
59
views
How can I interrupt the mysqld front process? [closed]
I want to ask, how is it possible to interrupt a simple mysqld command in the terminal.
By a mistake I typed in mysqld in the console and press enter.
Now I get the Note that mysqld starting as a ...
- 3
0
votes
2
answers
344
views
Connect SSH Tunnel with the Java Desktop program (.jar) to remote server
I developed a JavaFx Desktop program the employees of the company. Now, they want to use the program in their houses with their own personal computers. The program has MySQL and FTP services.
I need ...
- 3
1
vote
1
answer
2k
views
Failed to get properties: Unit name [email protected] 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 ...
- 343
0
votes
1
answer
319
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,...
- 1
0
votes
2
answers
1k
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 > ...
- 11
0
votes
1
answer
125
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 ...
- 197
0
votes
0
answers
142
views
High CPU from 1 process that's MYSQLD, but no abnormal queries while doing SHOW FULL PROCESSLIST
I have an issue where 2 processes take 99% of the CPU, but that leaves me the mysqld process that takes 600% of the CPU and a set of php-fpm processes that takes no more than 25% of the CPU according ...
- 197
0
votes
1
answer
349
views
MariaDB installation using RPM failed
I'm trying to reinstall MariaDB since unable to restart the service. Using Centos 7.6.
Previous uninstalled was using yum but this install i'm using RPM since i chose for specific older version (10.3....
- 1