Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql]

MySQL is an open-source database owned by Oracle.

0
votes
0answers
5 views

Mysql 5.7.23 with InnoDB memcached plugin (daemon_memcached) crashes under load - runs our of memory

I have a ~100 gb key-value data set that I need fast access to for a webservice running on AWS. Since instances with >100 gb of RAM are quite expensive, we're trying out using MySQL 5.7.23-0ubuntu0....
-1
votes
0answers
19 views

Can someone help me understand the MySQL Dashboard [on hold]

I am being asked about the performance of a MySQL database and have Workbench installed to see the 'Dashboard', which I have read about, but I cannot seem to find anything which helps explain it. ...
0
votes
2answers
28 views

When is mysql-client needed?

I have read a number of tutorials on installing MySQL, and I've noticed that many of them only discuss installing mysql-server, whereas some also discuss installing mysql-client. My main question is: ...
0
votes
0answers
9 views

mysql - my.ini server-id variable won't change

I want to set up replication on mysql. I replaced the contents of the my.ini file in the slave with the following contents: [mysqld] log-bin = mysql-bin server_id = 2 server-id = 2 ...
-5
votes
0answers
18 views

Site down with database error [on hold]

My Wordpress Site is not accessible with Error Error establishing a database connection I am not able to access phpmyadmin with error #2002 Cannot log in to the MySQL server. Connection for ...
-1
votes
1answer
11 views

Granting privileges for a user doesn't appear to apply even after flushing

I'm working on creating a test system and need to grant a user remote database access. I'm doing this with the following: mysql> SHOW GRANTS for codingo; ERROR 1141 (42000): There is no such grant ...
0
votes
0answers
16 views

Error log flooding with aborted connections (Aurora 2.03 - MySQL 5.7.12)

Here's some contextual information: I have a multi-tenant, WordPress MU installation running on Elastic Beanstalk, scaled up to 2 instances minimum. These are connected to the RDS database and are ...
0
votes
1answer
12 views

Magento Data Migration - Host is not allowed to connect to this MySQL server

In Magento Data Migration process, Host is not allowed to connect to this MySQL server. I check Mysql connection using normal PHP file and able to connect in Mysql service. I also create a remote ...
-1
votes
1answer
14 views

sudo apt-get install mysql-server doesn't ask to set root password and also doesnt set mysqld.sock file [on hold]

I was following along this tutorial: https://inversemaha.wordpress.com/2017/11/02/install-and-configure-apache-php-mysql-and-phpmyadmin-lamp-on-linux-mint-18-2/ On a fresh install of linux mint. I ...
0
votes
3answers
42 views

Installing MySQL on Amazon EC2 Instance, backup?

To install MySQL on Amazon EC2 Instance (for example: t3.medium), is there anything I need to be aware of when doing snapshot backup of EC2 Instance? What is the right procedure to install MySQL on ...
-1
votes
0answers
11 views

In which product does Alibaba Cloud use sqlite? [on hold]

In which product does Alibaba Cloud use sqlite? Mostly, we see in Mysql. How about MariaDB? PostgreSQL
-2
votes
0answers
16 views

how optimizing mysql queries to retrieve data with pagination [closed]

I have database with 12000 records and this records will increase by 600 records every day . I think that 12000 records not much data into database but when I trying to retrieve data by php , it ...
-1
votes
0answers
21 views

Can't connect to local MySQL server through socket error 2002 [closed]

I get this error when I try to connect at database trough ssh. Same problem with filezilla I can't reach the server whiti this error ECONNREFUSED ERROR 2002 (HY000): Can't connect to local MySQL ...
0
votes
0answers
25 views

Failed to start MariaDB on centos 7

I got this error after rebooting the server mariadb-prepare-db-dir[1551]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. mysqld_safe[1581]: 181011 04:04:18 ...
0
votes
0answers
17 views

Copying over indexes with AWS DMS

I need to use AWS DMS to copy one MySQL RDS instance to the other. I've been tinkering about have set it all up and I've run a successful migration. The issue is it doesn't create indexes. I ...
0
votes
1answer
39 views

ec2 out of memory from apache random spike

Over the past year, we had consistently random spikes which caused apache to use all the memory and swap out. Server Uptime I have an example of the latest crash (5:30AM - 12:00PM UTC). OOM Kernel ...
1
vote
3answers
44 views

MySQL remote connection slow

As the traffic keeps growing on my e-commerce(PrestaShop) and the navigation starts being slow I decided to after reading many posts in here separate my web server from my DB server. I did set up a ...
1
vote
0answers
21 views

MySQL remote connection very slow [closed]

As the traffic keep growing on my ecommerce(prestashop) and the navigation starts being slow I decided to after reading many posts in here separate my web serveur from my db server. I did set up a ...
0
votes
0answers
35 views

AWS RDS {DBInstanceClassMemory*3/4} gives incorrect innodb_buffer_pool_size

Instance: db.t2.medium (2 vCPU, 4 GiB RAM) Engine: Aurora (MySQL)-5.7.12 In the parameters group, innodb_buffer_pool_size is set to {DBInstanceClassMemory*3/4}. Which should calculate to 4*3/4 = 3. ...
0
votes
1answer
19 views

Temporarily operate on different MySQL/MariaDB data directory without restarting service?

I know that MySQL/MariaDB can be configured at the system level to use a custom path rather than /var/lib/mysql. This requires restarting the service. Is there any way to just run a one-off sql ...
0
votes
4answers
156 views

Joins performed without indexes: 5568

I was trying to do mysql optimization. Yesterday the CPU usage was 100%. I am trying to optimize with mysqltuner but this time I gave a mysqltuner warning. I have a high-traffic db. 500-600 ...
-3
votes
1answer
44 views

Is OK to delete the MySQL database files directly on the server?

So, I need to free up some space on our database server. On investigation it looks like lots of space is being taken up by MariaDB/MySQL databases that are no longer used (snapshots and defunct ...
-1
votes
1answer
40 views

Can't start mysql after installing mariadb

I have just installed mariadb but when I do sudo mysql the I get this error: ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded. i have looked online for fixes but I cannot find any that actually ...
0
votes
2answers
26 views

Stuck trying change mysql root password

I have looked up how to change the root password online and they always tell me to do sudo mysqld_safe --skip-grant-tables & When i run that it doesn't do anything except from outputting this: ...
-1
votes
2answers
40 views

MySQL errors when trying to start it

i have been stuck on this for days now. When i run service mysql start it returns this: matthew@matthewserver:~$ service mysql start ==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units === ...
0
votes
0answers
20 views

After upgrading MySQL 5.6 to 5.7, the database doesn't show any error message

I don't know if someone has gone through it, but after upgrading MySQL 5.6.28 to 5.7.14, when an error occurs the output only shows the error code without the error message like the example below: ...
-1
votes
0answers
30 views

What's the best MySQL configuration settings for a 15GB database? [duplicate]

This is not a duplicate question. I'm running a single website on a dedicated server, and server load averages are always too high. I went from 2 CPU's to 4 CPU's and that helped some, but the ...
1
vote
2answers
45 views

Cannot install or start MySQL

I'm attempting to move one of my projects over from another VPS, and I think I've messed up my SQL database. I'm fairly sure the problem has started because there are multiple instances of MySQL on my ...
0
votes
1answer
54 views

MySQL Replication don't run after configuring

I'm practicing mysql replication with 2 Centos 6.9 64bit virtual machine. Setting process was fine but after I insert data to master server, Anythings happens in slave. MASTER SETTING mysql.cnf ...
0
votes
0answers
29 views

MySQL won't start after forcing it to stop

I put my site on maintenance so no one can access it and no new data will come into the database. I was running a query to delete 3 month old data from a table which took almost an hour at which I ...
-1
votes
0answers
28 views

Restarting mysql from the mysql console

I have a "compose" MySQL instance running remotely. I don't have access to the machine and I have no button to restart it. On the other hand I can run the mysql console. Is it possible to restart ...
2
votes
3answers
103 views

MySQL memory usage is too high

I'm running Ubuntu 16.04 on a system with 64Gb RAM + 64Gb of swap partition. It's not a dedicated server so there're other processes running at the same time. Anyway when MySQL daemon is stopped, the ...
0
votes
0answers
17 views

Getting an error message on while installing any packages in Ubuntu 18.04

While trying to install any packages/apt in my ubuntu terminal after installing showing some error messages. for example, I'm trying to install zip sudo apt-get install zip after execution above ...
0
votes
0answers
65 views

MySQL - High CPU usage (100%)

Since few days, my web application is very slow without any updates, configuration changes or other changes. htop tells me a 100% CPU usage when I browse this web application and it queries my SQL ...
0
votes
0answers
28 views

MySQL slave status always missing

My MySQL add a instance but its status is always missing. I have try to run CHANGE MASTER TO master_host = 'node1',master_port = 3306,MASTER_USER = 'root',MASTER_PASSWORD='xxxx',master_log_file='...
1
vote
1answer
30 views

How could I connect MySQL Server (on a EC2 ) from another EC2?

I create two instances on EC2 (CentOS 7). I am trying to deploy MySQL InnoDB Cluster. When I add instance (slave) I found master cannot be connected. I can use GUI tool on my local to connect the ...
0
votes
0answers
35 views

How do you force drop a database from a corrupt MySQL?

Im using a virtual machine while I develop. I was importing data into a database on the virtual machine when my host machine suffered a Kernel panic and restarted. At first when I started the VM, I ...
0
votes
0answers
14 views

How do I track what's stopping a Google Mysql instance from restarting?

I have a 1st Gen MySQL 5.5 instance running in europe-west1-c which seem to have some sort of issue at midday today. I requested a restart of the instance about an hour ago in the hope that this would ...
-1
votes
0answers
25 views

AWS Mysql to external server data transfer very slow

I am trying to set up a data transfer between my two servers.I notice the transfer of data between both these server is very slow. I use python 3.6 as my scripting language to connect and transfer ...
1
vote
1answer
69 views

drupal and remote database

I get error "Failed to connect to your database server. The server reports the following message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '192.168.0.20' (13)." while installing drupal. ...
0
votes
0answers
32 views

Mysql high cpu usage (over 600%)

The server has 8core CPU and 22 GB of ram. Every day receives many requests from users, and recently a replication mechanism has been activated, with an implementation of a db master and a slave. Now ...
0
votes
0answers
53 views

Why is Percona CPU load so high compared to MySQL and MariaDB?

I compared Percona CPU load (left on screenshot) to Oracle MySQL (same almost default config, same DB, load, etc.) Percona vs. MySQL CPU load Tested on all my servers running Debian and Ubuntu. ...
1
vote
1answer
80 views

MySQL server (mariadb) auto shutdown without overload

With old configs, my VPS (1 CPU, 1 GB RAM, 1 GB swap) works normally for almost 2 years. I didn't change anything from beginning. But I have this issue several days ago, MySQL server automatically ...
0
votes
0answers
10 views

Huge difference in table size between 2 MySQL databases [migrated]

We have 2 MySQL databases: A MySQL 5.6 database, managed by our cloud provider (source). A MySQL 5.7 database, managed by us (target). We can download a mysqldump from the source database and then ...
-1
votes
1answer
32 views

My RDS Instance Disk is free but Billing Dashboard Showing high disk usage

I am using t2.micro instance to learn experience RDS performance. My issue is that my All databases are less than 10 mb but Billing Console is showing that i have used 8 Gigabytes of storage. How? I ...
-2
votes
0answers
22 views

Is ApsaraDB better than self-managed MySQL on an ECS Instance?

When considering a backend database for a desktop application, I realize there are two choices. One, I can go for a hosted MySQL service like ApsaraDB or I can provision an ECS instance and install a ...
0
votes
0answers
21 views

Downtime on VPS because of Memory leak?

I recently noticed that my server has a downtime for about 10 minutes and it gets up and running again. I checked the kill process logs and it was due to an OOM error which simply means it was out of ...
-2
votes
0answers
13 views

mysqltunner help in optimization

can you help me interpret the log https://pastebin.com/4V2KXjPG Variables to adjust: query_cache_size (=0) query_cache_type (=0) tmp_table_size (> 32M) max_heap_table_size (> 32M) ...
0
votes
1answer
16 views

2002 Code Error When Trying Import / Export MariaDB Databases in Bitnami's WordPress Multi-tier Stack

I'm trying to do database management via SSH for Bitnami's WordPress Multi-tier Stack/ Specifically I want to export and do an initial import (though I will probably just create a new database). When ...
1
vote
1answer
54 views

Azure Database For MySql - How to see the successful backup and restore logs?

I am using Azure Database for MySQL, vcore GpV2 and had opted for Geo-redundant backup during Database creation. According to the official documentation, Generally, full backups occur weekly, ...