MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
17 views

MySQL - Error Reading Packet From Server - Adding new slave to replication environment

I have a working application, currently using MySQL, 1 master, and 1 slave. Everything appears to work fine with replication. I am using WAMP Server 2.5 (Windows) MySQL v 5.6.17 I have followed a ...
1
vote
1answer
28 views

MySQL on udp port

I have searched around on the internet but could not find any satisfying answer. Can someone please guide, here are my confusions/questions. Can we run mysql on udp port instead of default tcp port? ...
-3
votes
0answers
17 views

LAMP performance on dedicated server [duplicate]

-2 down vote favorite I am rather confused and would appreciate some help. I recently switched from a VPS to a dedicated server (core i7, 12gb ram, raid1 sata drives) but I am not happy with its ...
0
votes
0answers
5 views

PHP-FPM crashes when having too many users while doing a heavy job

I have a Server running Apache/2.2.22 (Debian), PHP 5.6.17 as FPM and MySQL 5.6.25. The project runs using a CMS called Redaxo (I don't think it's that important, but I'll tell ya anyway). In Redaxo ...
0
votes
0answers
9 views

Mysql NDB Cluster 7.4 on CentOS 7

I am trying to configure NDB Cluster with 5 nodes on CENTOS MGMD Node =1 DATANode =2 SQLNode = 2 MGMD & DataNodes are up. mysql service failing on startup ERROR! The server quit without ...
-1
votes
0answers
16 views

Mysql Server On Ubuntu Linux Stops Itself [duplicate]

I just migrated my Wordpress sites to a VPS and I'm just a little over my head in system admin problems. For some reason MySQL is stopping itself. Checking the logs it seems to be running out of ...
0
votes
1answer
19 views

MySQL Backup Cron Job

I have a cron job which backup up my MySQL database by exporting it. The script includes the root password to get the job done. I get the message: Using a password on the command line interface can ...
0
votes
0answers
17 views

Ubuntu/Apache2 - Virtual host stops my MySQL server [duplicate]

I have really strange problem. I have an Apache2 server on Ubuntu 14.04 with installed MySQL server. Everything was working fine. I have multiple domains hosted on one server and i believe i received ...
1
vote
3answers
40 views

Can't get MYSQL to be visible from outside

I know there's a lot of topics about this but i've read them all and still can't access MYSQL from outside... Any help will be apreciated I'm using Centos 6.7. This is my /etc/my.cnf: bind-address ...
-3
votes
0answers
25 views

How to write access command with credentials? [on hold]

We had a third party company setup servers and built services for us years ago. But the relationship is strained now and basically they won't reply any email to us. We could find some legal help but ...
1
vote
0answers
11 views

RTC/UTC was innacurate on MySQL (MariaDB) server. I fixed it - was that bad?

I'm pinch hitting as an admittedly green server admin. I installed a bunch of security patches on a MariaDB server that had an incorrectly configured repo (not by me) and wasn't getting patches for a ...
0
votes
0answers
6 views

Starting MySQL/TokuDB with missing recovery log

I've lost TokuDB recovery log(HDD has died) and TokuDB won't even start complaining about missing recovery log: /var/log/mysql/error.log: ... [ERROR] TokuDB: Recovery log is missing (persistent ...
0
votes
1answer
26 views

Connecting to an AWS RDS behind a NAT with an SSH tunnel

I've set up a MYSQL RDS on AWS, in a private VPC behind a NAT. With Workbench, I can connect successfully from a remote client into the RDS no problems - so all of the RDS, the NAT and the security ...
1
vote
0answers
31 views

SYN flood on mysql server

Consider this structure: DB <-TCP3306- WEB{1,2,3,4} All servers are CentOS 6/7 Web servers are running PHP (using php-fpm) that connects to the MySQL server. Occasionally, I get this error ...
0
votes
0answers
19 views

trouble with change data dir on ubuntu mysql

Install zabbix on Ubunutu server with MSQL 5.6.27. After mount new part in /var/lib/mysql and copy all db files, mysql not started. What i done: 1) stop mysql 2) copy /var/lib/mysql to partition ...
0
votes
0answers
3 views

Schedule MediaWiki database maintenance job?

We run a MediaWiki installation for a single site on a VM. We find that we have to repair the mywiki_revision table weekly. It seems to be related to the Sunday backup that runs. We were OK with a ...
0
votes
0answers
9 views

xtrabackup/innobackupex: Full/Incremental backup advice

OS: Centos 7 Database: Mysql/MariaDB I have written my own shell script to produce Full and Incremental backups using innobackupex. I have read through the man pages for innobackupex and tried to ...
0
votes
0answers
31 views

Exporting privileges from Mysql - Something is missing

I used a little bash function to export MySQL privileges from a server (see http://serverfault.com/a/13050/238291). Works well, used it multiple times and never had an issue (although I do have to sed ...
1
vote
1answer
21 views

Small queries wait for large queries to resolve MYSQL PHP on Centos 6.5

I have a Centos 6.5, and I'm running Vaadin on Tomcat, This application has really heavy queries for reports and stuffs. My problem is, when I'm connect to MYSQL from PHP, when I made a small query, ...
-1
votes
0answers
16 views

need to assign mysql root user to database with full permission [closed]

I have a Centos 6 box with MySQL 5.6 There's a database control panel script I bought that requires full root access to MySQL. I can't figure out via CLI how to greant the mysql root user the full ...
-1
votes
0answers
17 views

Mysql master-master node recover after hdd destruction [closed]

I want to setup MySQL master-master replication. But I can't figure out if it is possible to recover failed node from the remaining one after total hdd destruction.
1
vote
0answers
18 views

MySQL proxy authentication options

I have a farm of production mysql servers that are currently protected by restricted passwords. I would prefer to restrict access to these systems at network level, but have to account for the fact ...
0
votes
1answer
146 views

SQLSTATE[HY000] [1130] Host xx.xxx.x.xxx is not allowed to connect to this MySQL Server

I have 2 servers with digitalocean - web (nginx) and database (mysql) servers - and can't get a connection from the web to the mysql server. From what I've read in other SO posts on the topic, the ...
0
votes
0answers
18 views

InnoDB causing mysqld to crash on Amazon Linux AMI

This Amazon Linux server is running a single WordPress site that is constantly crashing. The way to resolve it seems to be to run service mysqld restart and it resumes operation until it crashes ...
-1
votes
0answers
23 views

Access mysql database on EC2

How can I connect from my computer to my mysql database on EC2? I have checked the security groups for the instance, and made sure that my public IP is allowed in the security groups for inbound ...
-4
votes
0answers
16 views

What are .frm , .myd , .myi and .opt files, and what do they contain (in MySQL)? [duplicate]

So it's clear to me that MySQL is a bit more complicated than just some CSV files and a nice tool to manipulate them. So in my Linux distro (Ubuntu MATE), I've found that that my MySQL databases are ...
1
vote
1answer
137 views

Mysql listens to wrong port on restart

I'm working on a 'local' PHP project. It's a PHP app running in a Debian VM intended for use on the user's own PC. I have a couple of python scripts running as root services from /etc/init.d which ...
0
votes
1answer
24 views

mysql replicate-* data transfer from master

I have been playing with MySQL replication for a new project of mine. I am using row based replication. I have a particular confusion with replicate_do_db which is to be written in the my.cnf of the ...
0
votes
0answers
11 views

Using a py file as an API endpoint on a hosted server

Hello all geniuses out there! I am not sure if this is the right place to post this question, but here goes nothing! I am writing to you all for a bit of help and clarity involving how to set up an ...
1
vote
1answer
42 views

Postfix can't connect to MariaDB on 127.0.0.1

(Yes, this question seems very similar, but I understand why I get the message. What I don't get, and can't find any palpable information about on my own, is what to do about it. So here I am.) I ...
0
votes
0answers
15 views

Socket.io w/ node.js + nginx +mysql + php5-fpm Memory Leak?

I have a Debian VPS running node.js socket.io server + nginx + mysql +php5-fpm and the socket server seems to freeze with no messages and no errors. I noticed that the memory usage grows over time but ...
0
votes
0answers
17 views

innobackupex: InnoDB: Log file ./ib_logfile0 size 14754304 is not a multiple of innodb_page_size

I did a backup using innobackupex: innobackupex /mnt/aws/backup It completed successfully: ... 160131 11:40:03 Executing UNLOCK TABLES 160131 11:40:03 All tables unlocked 160131 11:40:03 Backup ...
1
vote
1answer
28 views

MySQL keeps crashing at unknown intervals

Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 160130 08:29:38 mysqld_safe Number of ...
-2
votes
3answers
37 views

Linux mysql server 5.6 will not start, or restart

I have a problem with mysql server; it doesn't want to start do you have an idea thank you. janv. 29 10:51:15 clicshopping mysqld_safe[20076]: 160129 10:51:15 mysqld_safe Can't log to error log ...
0
votes
0answers
23 views

MySQL 5.7 under Debian Jessie with postfix-mysql

I currently have MySQL installed from the MySQL APT repository and am on the 5.6 branch. It comes with libmysqlclient18 and postfix-mysql requires it. If I want to switch to the 5.7 branch, APT will ...
0
votes
1answer
42 views

Mysqld.exe crases on startup with error 0xc000007b

I've just deployed a new VM on Microsoft Azure with Windows Server 2012 R2. It is identical to other two I have (it was created from scratch though, not duplicated or from an pre-existing image), all ...
0
votes
1answer
60 views

high mysql CPU usage more than %1500 on centos 6

I am running a high traffic websites on a Dedicated-Virtual 24GB RAM CentOS server hosted by the planet. Very often the server dies because of high CPU usage (%1500) When i check the running ...
0
votes
2answers
67 views

PHP 7 cannot connect to MySQL

I have compiled LAMP servers for hundreds of times. However I am facing issues with PHP 7. I compiled it properly, but it cannot connect to MySQL in localhost. phpinfo shows PDO and mysqli are ...
0
votes
0answers
38 views

mysql-workbench installation error

I have ubuntu 14.04 and try to install mysql-workbench. and getting an error as The following packages have unmet dependencies: mysql-workbench: Depends: libgcc1 (>= 1:4.1.1) but 1:4.9.3-0ubuntu4 ...
0
votes
1answer
41 views

Mysql innodb_buffer_pool_size in relation to innodb_buffer_pool_instances

I run a virtual server with an Owncloud installation on it. Now Owncloud has the problem that the way it's developed at the moment, each file upload causes a little MySql overhead. So is very ...
0
votes
2answers
123 views

How can I install MySQL 5.7.9 to Ubuntu 14.04?

I tried to install with these inscturctions, but installation installed version 5.5. $ sudo apt-get install software-properties-common $ sudo add-apt-repository -y ppa:ondrej/mysql-5.7 $ sudo apt-get ...
0
votes
1answer
18 views

GTID have been turned off But I have error in replication

I just upgrade from mariadb5 to mariadb10. Then I have error on my slave replication Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't ...
0
votes
0answers
31 views

MySQL replication - invalidating query cache entries (table)

We lately mved to MySQL V5.5 on CentOS release 6.7 with master and 2 slaves. Since then the replication process lags a lot behind the master with the line in the process list of: invalidating query ...
0
votes
4answers
67 views

Sometimes: Unable to connect to host 127.0.0.1, or the request timed out. MySQL through Sequel PRO

I have been struggling with this issue for over a year now, and it’s really giving me a headache. I often experience I am unable to connect to the MySQL server through SequelPRO. If I ssh into the ...
0
votes
1answer
28 views

MySQL [ERROR] Can't start server: can't create PID file: No such fie or directory

I'm having trouble starting mysql and mysqld. Output of sudo service mysql start command is mysql : Unrecognized service Same way output of sudo service mysqld start is nothing When I tried sudo ...
1
vote
0answers
12 views

Minimizing downtime during MariaDB Replication Setup [migrated]

I have the task of setting up MariaDB (10.0) replication from a master running in a datacenter to a slave running out in an AWS VPC. Reading up on the instructions on Setting Up Replication - MariaDB ...
1
vote
1answer
20 views

MySQL Error Code: 1017 permission denied

I have downloaded the German version of the Northwind sample database. I moved the folder to /var/lib/mysql and set the rights to drwxr-x---. Here is an output of /var/lib/mysql drwxr-x--- 2 mysql ...
0
votes
2answers
47 views

CentOS 7.2 Azure VM - MariaDB/Apache killing memory

I have an Azure VM with CentOS 7.1, Apache 2.4.6, and MariaDB 5.5. The VM has 2 cores and 3.5 GB RAM. The server is only hosting a small WordPress site with almost no traffic. For the past two days, ...
4
votes
1answer
74 views

Galera cluster (MariaDB) on Docker/CoreOS: second node doesn't work on first attempt

I'm trying to create an automatic deployment of Galera Cluster with MariaDB, running inside Docker containers on CoreOS. Software used: - MariaDB official Docker image, version 10.1.10 - CoreOS ...
0
votes
1answer
52 views

MySQL Daemon Lock issue

Last night, my MySQL server went down unexpectedly. On attempting to restart (with service mysql restart - I'm root) it merely hangs. With the mysql -u root -p command, I get ERROR 2002 (HY000): Can't ...