MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
154 views

Auto-start MariaDB using systemd after it has crashed

I am trying to set up MariaDB in a way that it automatically recovers -- basically restarts, from a crash. Based on this article -- scroll down to Auto-starting Services with systemd, I opened /etc/...
0
votes
0answers
26 views

MySQL Cluster: Too Many Connections

We have our java application directly connected to the MySQL cluster (NDB engine) with 1 SQL Node. We also have another SQL node. We had a requirement to load balance our 2 SQL Nodes with the physical ...
0
votes
0answers
18 views

Trouble getting automysqlbackup to keep connection to mysql server

I am trying to follow the instructions from the following page to set up backups for mysql. https://www.howtoforge.com/tutorial/mysql-incremental-backup-point-in-time-recovery/ However, once I get to ...
0
votes
0answers
18 views

MariaDB replication- slave with high loadavg

We recently set a master-slave replication with MariaDB 10.1.12 on RedHat 6.7 fully patched. Master and slave are powerful Dell R730 with 2 RAID arrays- 1) 2 x 15k SAS drives for OS in RAID1 2) 4 x ...
1
vote
0answers
23 views

Recover MySQL MyISAM BAK files

I had some hard disk issue on my server and I noticed a MySQL table is missing lots of rows (5k instead of about 200M). In the MySQL directory I have a BAK file for that table : mytable-160115203241....
0
votes
2answers
105 views

How to detect slow code or plugin

I don't have much experience with WordPress and I don't know where to start. There is a website which is running very very slow. The hosting company helped me to detect that it's because some piece of ...
0
votes
0answers
15 views

Kernel killded MySQL daemon due to “Out of memory” although there is a free ram

Today about 10:45 AM my Ubuntu Linux server had killed the MySQL daemon due to "Out of memory". The following lines of Syslog shows what had happened. Mar 15 10:45:43 server1 kernel: Out of memory: ...
-4
votes
1answer
129 views

ERROR 2002 (HY000): Can't connect to local MySQL server after mysql upgrade

I was running mamp on el capitan 10.11.3. I decided to update mysql to version 5.7.11, so I ran this: tar xfvz mysql-5.7* echo "stopping mamp" sudo /Applications/MAMP/bin/stop.sh sudo killall httpd ...
0
votes
0answers
59 views

Cannot get MariaDB running after migration from MySQL

For hours I have tried all the things in the book with no success. All the solutions seems to involve magic like rebooting or apt-get purge everything related to MariaDB and MySQL and started all over ...
1
vote
1answer
211 views

Compiling PHP7 with MySQL error

I'm setting up an alt-install for PHP7 on CentOS 6.7 with the configure options that were used for the original PHP version: ./configure --disable-fileinfo --disable-opcache --disable-posix --enable-...
-1
votes
1answer
67 views

phpMyAdmin - make user which only sees databases they create

I am aware of how to grant a user access to only one database using phpMyAdmin, and I am aware of how to give a user access to create a new database using phpMyAdmin (using the Create privilege). ...
0
votes
0answers
15 views

Server auto disabling pdo

PDO mysql plugin wasn't enabled by default in my server , so i added a line extension=pdo_mysql.so to a php.ini file i created, and it works fine , but every once in a while it is ...
-2
votes
2answers
140 views

MySQL does not start anymore [closed]

unfortunately I am unable to start mysql after reboot: root@server:/etc/mysql# systemctl status mysql.service ● mysql.service - LSB: Start and stop the mysql database server daemon   Loaded: loaded ...
0
votes
1answer
111 views

Munin and mysql plugin

I've installed munin on a vps and I want to monitor mysql usage of 3 mysql servers, I have configured mysql_ plugin as follow: [mysql_*] env.mysqlconnection DBI:mysql:mysql;host=mysql1.neocrafters....
1
vote
1answer
26 views

Unable to login to MySQL locally after remote changes

After doing the following two things to setup remote access to my database, I'm not unable to access the database locally: GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pass' WITH GRANT ...
-1
votes
3answers
94 views

MySQL uses 100% CPU - Not sure to configure

I'm running a VPS on DigitalOcean on a 8GB ram 4 Core. We're on Ubuntu 32 bit. Recently been running into the issue where the mysql process is taking up 100% of the CPU load and slowing our server. ...
0
votes
0answers
25 views

TRUNCATE drops a table sometimes

After TRUNCATE table, getting this error sometimes: Uncaught exception PDOException: SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine After it, I'm missing table which I was ...
0
votes
0answers
62 views

No longer able to connect by SSH

I'm using Google cloud with a couple of instances deployed. I was trying to resolve an issue with the MySQL database on the server and I couldn't get MySQL to start so I resorted to restarting the ...
0
votes
1answer
26 views

bacula catalog backup error

I have a Bacula (mysql) server on an Ubuntu-server machine. It backs up and restore without issues except for the catalog. Every time it runs the catalog backup it shows an error. My guess is that ...
0
votes
0answers
19 views

force mysql cleint to start SSL/TLS immediately without server's plaintext handshake

I am trying to get HAProxy to do the SSL for a MySQL Proxy in front of a MySQL Server, however my problem is the mysql client is waiting for the Initial Handshake Packets from the server, and the ...
0
votes
1answer
939 views

mysql authentification plugin is not loaded

Problem: I am encountering an login problem when setting up users in mysql. Old users can login as expected, for newly created users I cannot login and get an error message. Executed SQL: CREATE ...
0
votes
0answers
16 views

How do you speed up an SQL query on a huge database? [duplicate]

I'm currently dealing with a table that has 30 million rows of 8 columns. I'm only selecting the columns that I need. SELECT column_a, column_b FROM table_name This is happening from a python script ...
1
vote
1answer
177 views

Why does this “netstat -tln” output show entries for “0.0.0.0:22” and “127.0.0.1:3306” [closed]

When I run the command netstat -tln I see the following output: Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 ...
0
votes
0answers
62 views

High RAM usage by Apache without any visitors

I have recently bought a VPS server with the below configuration Centos 6 64bit 20GB SSD 512MB RAM 512 VSwap I have hosted around 10 websites. In that 4 of them is WordPress. Others are dynamic(...
1
vote
1answer
84 views

ERROR In Importing Mysql DB dump On AWS RDS

I took Mysql DB dump from one RDS server and trying to restore in another RDS server.While importing the complete DB i am getting below error. ERROR 1419 (HY000) at line 2447: You do not have the ...
0
votes
1answer
33 views

mysql show databases; doesnt work it gives -> again and again after script

I have a script that I run to create my database. I run this with source <file> when it finishes it shows mysql> I then type show databases; and it goes to next line and puts -&...
2
votes
0answers
28 views

MySQL slave index file corruption

I have a MySQL master-slave replication pair, and to take backups, I run a script that stops the slave, dumps the database, and then re-starts the slave. However, after restarting, the slave's MySQL ...
1
vote
3answers
126 views

mysqldump to remote mysql database using gzip

I'm trying to transfer data from one MySQL server to another with gzip compression. What I have so far is: mysqldump -u [user] -p[pwd] --no-create-db --no-create-info [db] [table] | gzip -c | mysql -...
1
vote
1answer
310 views

Import MySQL 5.6 database into 5.5 using MySQL 5.6 client tools

My local dev environment currently uses MySQL Server 5.5. However, one of my clients hosts decided to upgrade their server to 5.6. I sync my clients databases remotely using mysqldump over ssh. I have ...
0
votes
2answers
1k views

Error while installing mysql on centos 6.7

Error: Package: 2:postfix-2.6.6-6.el6_7.1.x86_64 (@updates) Requires: libmysqlclient.so.16()(64bit) Removing: mysql-libs-5.1.73-5.el6_6.x86_64 (@base) libmysqlclient.so.16()(...
0
votes
1answer
128 views

increase max_connections in mysql on ubuntu wily

I have ubuntu wily installed on my server. I'm trying to increase max_connections of mysql server to 1237 but when running mysql client and executing show variables like 'max_connections'; i get 214. ...
1
vote
1answer
110 views

Is there a way to make these two docker bash commands execute synchronously?

I am automating the setup of dev environments for my app and when I run these two commands manually from the command line I have to wait around 10 seconds after running the first one to run the second ...
1
vote
0answers
68 views

MySQL Multi-source replication from 5.6 masters to 5.7 slave

In MySQL 5.7 multi-source replication is finally available. Is it possible to use several MySQL servers running version 5.6 as multiple masters for a single MySQL slave running 5.7? Or do you have to ...
0
votes
1answer
81 views

MySQL logs different time than NOW()

MySQL server logs entries with different time than system or mysql itself: mysql> select @@global.time_zone; +--------------------+ | @@global.time_zone | +--------------------+ | SYSTEM ...
0
votes
1answer
57 views

Stop numproc exceeding the limit

We are running magento on VPS, which is facing a Numproc issue. According to our hosting provider, our server is exceeding the limit of numproc "400" & memory usage is also high. Because of this ...
-3
votes
2answers
80 views

MySQL wont start after updating

My MySQL server (Located in /mysql) refuses to start after i updated it from 5.1 to 5.6. Permissions: -rwxr-xr-x. 1 mysql mysql 10485760 Dec 29 18:20 ibdata1 drwx---rwx. 2 mysql mysql 16384 Dec ...
0
votes
0answers
10 views

Duplicate mysql datadir on Windows

I have a development server running Mysql 5.1 (together with other services). During an urgent cleanup I found, using SequoiaView, two identical mysql data folders. C:\ProgramData\MySQL\etc.... is ...
2
votes
2answers
254 views

MySQL doesn't start after upgrading to Debian Jessie

I have a server with Proxmox 3.4 with several OpenVZ-containers. Host and all guests are running Debian 7 x64. Now I want to migrate my old setup to a new server with Proxmox 4 (based on Debian 8). I ...
-1
votes
1answer
115 views

MariaDB always show SSL not in use when I start mysqld with --ssl

CentOS 7.2.1511 Linux 3.10.0-123.9.3.el7.x86_64 MariaDB: 10.1.11 /etc/my.cnf # # This group is read both both by the client and the server # use it for options that affect everything # [client-...
0
votes
0answers
13 views

MariaDB audit log empty host

I'm running MariaDB 10.0.23 with the audit plugin logging CONNECT type. The audit log is showing a failed connect with error 1042. Does the host field not show the IP address when a host cannot be ...
2
votes
3answers
50 views

Excluding/Including tables in mysqldump AWS

I'm trying to figure out how to exclude or include specific tables when doing mysqldump command on AWS via terminal. Background: I have a WordPress multisite but only need the tables with the first 3 ...
1
vote
0answers
68 views

Cannot connect to remote MySQL server (RDS)

When I am trying to connect to RDS from my vps, it says connection refused. When I tried connecting it from local or other vps, it worked fine. I figured out that it must be a firewall issue on my ...
0
votes
0answers
125 views

PHPMYADMIN Multi Server Setup Issue - Server Choice Never Displayed

I have a phpmyadmin installed in my Ubuntu-14.04 LTS server. I want to manage other MySQL databases in different servers (all Ubuntu) across my VPC. I have enabled access to the servers using the AWS ...
0
votes
0answers
45 views

DataTables warning: JSON data from server could not be parsed

This is my first post on ServerFault. I hope that this question is detailed enough for someone to help me. I have looked online for two days regarding, "DataTables warning (table id = '...
-1
votes
2answers
54 views

MySQL crashes due to memory related errors, but roughly 50% memory is unused

MySQL keeps crashing because of: InnoDB: Fatal error: cannot allocate memory for the buffer pool. This looks like a memory problem and the internet seems to confirm that. Also, my box has only 1GB of ...
0
votes
1answer
72 views

MariaDB refuse to start after VServer reboot

After I rebooted my VServer, MariaDB refuses to start. This are the error messages: # systemctl status mysql.service ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: ...
1
vote
1answer
24 views

Are both /etc/my.cnf and /etc/mysql/my.cnf needed?

I recently setup a new web server with Ubuntu 12.04. I noticed that there are two my.cnf files, and MySQL successfully reads both: /etc/my.cnf /etc/mysql/my.cnf Do I need to keep both of these ...
0
votes
1answer
30 views

Opening ports on a remote DB server

I'm running a RHEL7 box, running MySQL-5.7.11 and I'm simply trying to allow remote connections... I followed the documentation here on opening a port and have done so successfully. When I run ...
0
votes
0answers
12 views

SQL request in Bacula database

I would like to get all the files that are at least in one job which is now saved on one determined tape in the Bacula database. This could replace a tape listing. I have tried several request to ...
0
votes
0answers
104 views

MySQL Cluster: SQL node running but not connecting to cluster

I realize there are a number of questions already on this but I've done my research and couldn't find a solution that worked for me. I'm using a clean install of Ubuntu 12.04.5 with MySQL Cluster 7.4....