Questions tagged [mysql]

MySQL is an open-source database owned by Oracle.

Filter by
Sorted by
Tagged with
0
votes
0answers
11 views

Multiple long running mysqld processes

today i've checked our server status with htop and i saw somethig that i could not believe. Could someone please answer me the following questions? Why are there so much mysqld processes? Why they ...
-1
votes
0answers
11 views

DESC command doesn't show columns properly

enter image description hereAfter using DESC command my terminal is full of "-". My friends when they log into my sql acc see everything properly. I tried on second desktop, virtual machine ...
0
votes
1answer
21 views

MySql crashes randomly Out of memory: Kill process 24978 (mysqld) score 99 or sacrifice child

I am running a LEMP server. 2Core Processor, 4GB RAM on Hetzner Cloud. Ubuntu 18.04, PHP7.4, MySql 5.7, Nginx 1.16 But my MySql server randomly gets crashed even when traffic is negligible. It happens ...
0
votes
0answers
24 views

How do I import Unicode Data into MySQL?

I'm trying to create a dump file from an MSAccess database to import in to a MySQL database. I can create the dump file, but when I try to import it I get this error Incorrect string value: '\xA325- R....
-1
votes
0answers
11 views

Can I change the “max user connections” in MySQL DB server if I buy the hosting?

I'm working on a C# WIndows Forms project. The fact is that free hosting (remotemysql.com) has a limited number of <max_user_connections> equal to 10 connections. I have no right to change it, ...
0
votes
1answer
52 views

Original php mysql extension for php56

First a note: Yes, I'm well aware this extension in deprecated and has a ton of security flaws, I'm duplicating a clients active server in docker for recovery and migration (after client's server was ...
0
votes
0answers
18 views

Give user access to information schema on mysql

[42000][1044] Access denied for user 'user'@'%' to database 'information_schema' I'm trying to execute a database in Ubuntu using DataGrip and I get the error of the title. I've looked into other ...
0
votes
0answers
19 views

Mariadb failover VIP- check the host behind

During MariaDB failover our VIP didn't reflect the host change in UI which caused issues. Is there a way/command to check if the VIP got assigned new master host properly by any command? So that we ...
1
vote
1answer
111 views

Strange behaviour of MySQL on Windows (CPU 100% with simple query)

We run MySQL 8 on Windows 2019 server (Dell R420, 32 cores, 64GB, SSDs on Raid10). Every now and then, our website goes completely offline, as the CPU on the MySQL server is completely bottlenecked (...
0
votes
0answers
61 views

Does NIC Teaming in Windows increase bandwidth in case of MySQL server?

I know that Windows server NIC teaming can increase the total bandwidth when used with SMB, and SMB multichannel plays a role in that. For example, by having 4 x gigabit NICs teamed, you can have ...
0
votes
1answer
27 views

Solving slave MySQL: waiting for the slave SQL thread to free enough relay log space

My slave MYSQL server has stopped syncing with the following status output. Could someone please suggest me a course of action to solve the problem? The database is around 400G so starting from zero ...
1
vote
1answer
58 views

After an upgrade to Ubuntu 20.04 LTS, why does mySQL not start?

After an upgrade to Ubuntu 20.04 LTS, my WordPress site is stuck in Maintenance mode. mySQL is trying to start with these same 10 lines repeating every couple of seconds in the /etc/log/mysql/error....
0
votes
1answer
93 views

Running MySQL 8 in Docker with Windows Host (WSL) the volumen for data directory is unusable

Im facing a problem when trying to run a MySQL 8.0 Docker in a Windows Host, using WSL2 integration. So, the enviroment: 1- Host: Windows 10 Professional. 2- Docker v19.03 The command to run the ...
1
vote
1answer
37 views

MariaDB 10.2.35 Memory Spikes

On an AWS EC2 T3.large instance I'm hosting a website built with the Cake PHP framework. It utilises the MariaDB version 10.2.35. I'm having an issue whereby the memory for the server is spiking. When ...
0
votes
1answer
28 views

Numbers of bricks is not a multiple of replica count - glusterfs

I have 10 servers and want to use all as storage so tried to create volume with following command but its throwing error gluster volume create gv0 replica 3 server1:/data/brick1/gv0 server2:/data/...
0
votes
2answers
83 views

MySQL installation on centOS fails - dependency issues

I tried to install mysql on centOS following this digital ocean guide. I ran the following commands; wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm md5sum mysql80-community-...
0
votes
1answer
71 views

Managing RDS Aurora MySQL connections per user or database

I have an RDS Aurora MySQL 5.7 and a number of independent applications connected to it. Some of them are real-time websites while others are batch services (connected mostly to the reader). A recent ...
0
votes
0answers
57 views

Database Restore ERROR 2013 (HY000) at line 68497: Lost connection to MySQL server during query mariadb

I have a Database of 150G - 300 Mio entries and i want to restore it (gz SQL Dump) on MariaDB 10.3 but the restore failed because the sql server gone away. I tried to raise max_allowed_packet to the ...
0
votes
0answers
45 views

MySQL Temporary table insert hangs and locks other queries

I have a MySQL 5.7.30 as storage for a Magento 2 shop. During the magento reindex process (a PHP process that transforms data into various tables for faster retrieval), some temporary tables are ...
0
votes
0answers
60 views

Why two TCP connections to mysql server?

When I connect to a mysql server via a client, it seems to create two new TCP connections each time, for example doing: $ netstat -a |grep mysql # tcp4 0 0 lmy.att.64710 ec2-54-00.mysql ...
0
votes
1answer
51 views

Server being overloaded by flood attack [duplicate]

I have a strong server, with 64GB Ram and amazing network and SSD for fast connections, but someone, I don't know why, is attacking my website, it seems that it is a script requesting my index.php ...
0
votes
1answer
16 views

how to stop MySQL container from initializing at start

For testing purposes I want to build a MySQL container that has a dataset bootstrapped into it. I know that mounting is possible and that you can place sql scripts into the init directory to run the ...
1
vote
1answer
163 views

Codeignitor - under login / session load MySQL CPU spike and Fatal MySQL Deadlock

Originally posted on stackoverflow, and was recommended serverfault may be better place. I have a site using: AWS RDS (MySQL Aurora) - single t3.medium instance 4 x EC2s on a Load Balancer (fixed ...
0
votes
0answers
54 views

MySQL Ubuntu doesn't start anymore after disk storage was full

MySQL Version: Ver 8.0.22-0ubuntu0.20.04.2 for Linux on x86_64 ((Ubuntu)) Today I encountered that my MySQL stopped running, all my websites are offline. When I try to run manually I get the following ...
1
vote
1answer
90 views

MaridaDB Error and Wont Start

I am unable to get MariaDB to start. systemctl status mariadb.service gives me this following: ● mariadb.service - MariaDB 10.3.25 database server Loaded: loaded (/lib/systemd/system/mariadb....
0
votes
0answers
11 views

docker-compose mysql no re-creating db

I have this simple and standard docker-compose.yml version: '3' services: dbwp: image: mysql:5.7 volumes: - db_wp:/var/lib/mysql restart: always environment: ...
0
votes
0answers
14 views

MariaDB binary logging and master-master replication

I am trying to set up MariaDB master-master replication on a Debian server. Server version: 10.3.25-MariaDB-0+deb10u1 Debian 10. I have read many tutorials and all of them says it´s necessary to edit ...
-2
votes
1answer
188 views

reducing heat on laptop running Ubuntu 18.04 by shutting down servers

I have mongodb, mysql, php's fpm, nginx installed and Docker station that also starts a server when I run it. I noticed quite a bit of heat and running top shows that a program like Docker Station ...
0
votes
0answers
43 views

ProxySql QueryCache - invalidation on Insert statement

Is there a way to invalidate ProxySql query cache after insert statements? How to reproduce: create mysql query rule like this: *************************** 1. row *************************** ...
0
votes
0answers
12 views

Mysql Error 1062 after reboot server

Accidentally I shut down one of my mysql server (8.0.20) that is in a multi master replication environment. After that, he started complaining about duplicated primary key. After some research, i come ...
0
votes
0answers
13 views

How to stop replication completely from master

I have a readReplica from RDS, from where iam having another replication to my local mysql. Now that I need to remove only the replication from read replica to my local mysql, I have removed all ...
0
votes
0answers
32 views

How to access to external db with user?

i'm a little bit lost about how to connect to an external server db. So basically I create a user with the following query: CREATE USER 'remote1'@'web-server-ip' IDENTIFIED BY 'password'; GRANT ALL ...
0
votes
0answers
15 views

Haproxy is returning 503 Service Unavaliable after benchmarking

Thank you for youre time for helping me foremost and reading this. I have been encountering an issue with haproxy where i am recieving: 503 service unavaliable error. My topology is consisting of 3 ...
0
votes
0answers
20 views

PHP memory size exhausted in drupal

FastCGI sent in stderr: "PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 137612647 bytes) Already I increase 2 times in php.ini file. But again ...
0
votes
0answers
24 views

How to know if mysql server is using sha_256 or caching_sha_256?

Seems like I am using an older version on Mysql Server which uses sha_256 plugin for Authentication (which is now deprecated) .Because of this, I am unable to connect to my server with third party ...
0
votes
0answers
38 views

MySql Slave Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.00116, end_log_pos 8631

I have Active-Passive-Master-Master replication setup in Mysql with version 5.7. I found the below error in MySql2 (passive Master server) but the status show it's in sync with Master server (mysql1). ...
0
votes
0answers
17 views

500 Gateway with EC2 m5.2xlarge

I have an EC2 m5.2xlarge with wordpress and the following server configuration: https://pasteboard.co/JwP5Ecg.png How is possible to receive a 500 Gateway Error for importing a csv with 50 users (45 ...
1
vote
1answer
72 views

Ubuntu 20.04 update destroyed Java/Mysql app performance

I'm working on a Java / MySQL app and test runs of batch processing were taking 3-4seconds on Ubuntu 18.04. I made the upgrade to Ubuntu 20.04 last night, and kept the same mysql conf file, and now ...
0
votes
0answers
23 views

MySQL Proxy with routing system

I am looking around for a solution to very specific problem. I have few years old big system. This system uses the Sphinx system to cache some data from MySQL databases. I have run the Sphinx cluster ...
0
votes
1answer
71 views

Mixing Galera and MariaDB/MySQL replication

reading about it online, it appears we can use both Galera replication and native MariaDB/MySQL replication together. Can anyone confirm that this is correct? I'm thinking of a scenario where Data ...
1
vote
1answer
52 views

MySQL instances are pointing to the database server DNS causing slow connection

We have very slow connection when accessing MySQL instances but fast when using IP address. When checked, we found out that the instances are all registered to the server hostname. So when you do an ...
0
votes
1answer
21 views

Master-Slave replication with additional selective replication

Using MySQL 5.6 Enterprise is it possible to have a normal master/slave replication between a master and slave with full replication then a second slave server to only have certain tables?
0
votes
0answers
29 views

Upgrade zabbix 4 to 5

I have a situation and I want to get your opinion about my strategy to change to Zabbix version 5, in the past few weeks, I have a database storage problem and manage it by separating my Zabbix server ...
-1
votes
1answer
48 views

What is the best mysql configuration for mysql instance with a lot of databases and lot of tables inside?

I have a mysql database instance with more than 3000 database inside. Each database contains more than 200 tables. I have more than 100 gb of data in all these database at present. I am using windows ...
0
votes
1answer
27 views

Is there “another” way of getting log information on SFTP activity?

I'm administrating a debian server since last week. It used to have another administrator. I presume it's been hacked: files might have been read via SFTP to obtain information about a site that's ...
0
votes
1answer
122 views

Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown

2020-10-01 18:30:05 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2020-10-01 18:30:05 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-01 18:30:05 0 [Note] InnoDB: ...
0
votes
1answer
336 views

Setting password for MySQL root user in CLoudSQL with private IP address

How to change the password for MySQL root user in GCP CloudSQL DB instance with private IP address . I am able to change the password using the below command from Cloud Shell with Public IP gcloud ...
1
vote
1answer
33 views

MySQL INNODB_LOCK_WAITS empty

I'm trying to investigate if blocking is to blame for a performance issue we are experiencing. MySQL version: 5.6.32-78.1 The following tables exist but are empty. INNODB_LOCKS INNODB_LOCK_WAITS The ...
0
votes
2answers
55 views

MySQL/MariaDB database migration to server

I want to migrate a MySQL/MariaDB database from my local box, where I use it for development, to the server that will actually use it in "production". I'm totally new, so please bear with me....
0
votes
0answers
65 views

website server starting to get traffic

I have a website that's a lot like Bitly, a short url site and it has started to gain a lot of traction lately. The website is about 100MB and the mysql database around 6GB. I run the server on a VPS ...

1
2 3 4 5
164