MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
40 views

MySQL via SSL on VPC private subnet

Is an SSL connection recommended when connecting to a MySQL database server via a private subnet? SSL provides encryption but SSL causes a performance hit. The MySQL database server only serves ...
0
votes
2answers
65 views

MySQLD is using 175% of the cpu

On one of the servers, I have mysqld running as slave DB. The CPU usage is 175% at the moment used by mysqld. Here are the results of SHOW PROCESSLIST; ...
0
votes
1answer
344 views

Lost connection to MySQL server during query (5.6.20)

I have a brand new install of MySQL 5.6.20 and now get these messages from my front-end when I am loading up the new database. [Err] 2013 - Lost connection to MySQL server during query [Err] Alter ...
0
votes
0answers
75 views

Querying node information from Foreman is very slow and I'd like to optimize it

I'm trying to set up Rundeck to query Foreman for node information. For example, the curl query: curl -k -u rundeckuser:rundeckpassword "https://foreman/hosts?rundeck=true&format=yaml" takes ...
2
votes
1answer
123 views

Performing root mysql operations in bash scripts

What is a good practice to execute root operations on mysql databases in bash scripts? For example, I want to create new database and grant privileges, I have to use: mysql -u $ROOT -p"$ROOTPASS" -e ...
1
vote
1answer
77 views

pure ftpd auth using crypt sha512

I've installed pure-ftpd-mysql and it works fine with md5 password hashing. This isn't very secure, so I'd like to use crypt with salted sha512, the way I'm using in dovecot. How to set up this in ...
0
votes
1answer
197 views

Wordpress and Apache crashing MySql (CLOSE_WAIT)

Last days mysql server on my vps start crashing, sometimes right after restart. I found that problem in wordpress website. After service mysql start many apache2 processes overload memory and cpu. ...
0
votes
0answers
24 views

Can an Amazon RDS instance serve as master for one schema and act as a read-only slave for another?

We have an Amazon RDS instance in production that caters to db requests for a set of tomcat servers. This is say schema1 on the RDS instance that is constantly accessed. Can we setup the same RDS ...
-1
votes
3answers
275 views

MariaDB 10.x on CentOS 7?

Why there is no MariaDB 10.x RPM for CentOS/RedHat 7? How can I install it? I'm trying to install the most recent stable version on my server, but it seems, that official repo is absent. 5.5 is ...
3
votes
1answer
34 views

MySQL keeps getting “connect” commands 100X per minute

My server was having performance issues, things loading slow, pages not loading, etc so I ran the "top" command after logging in via SSH. I noticed the CPU kept jolting up to 40%, on and off, when ...
0
votes
1answer
47 views

Insanely high mysqld write I/O on SELECT queries

I am struggling to find a reason for my mysql have this much of disk write, it just doesn't make any sense. It it doing mostly of the time SELECT queries, so the only reason I find to it write so much ...
0
votes
0answers
46 views

MySQL cluster data node restarts when its twin fails

Configuration: Server #1: 1 mgm node, 1 data node, 1 sql node Server #2: 1 mgm node, 1 data node, 1 sql node Specification: MySQL Cluster 7.3.6 x86_64 Debian 7.6 x86_64 It's been deployed by ...
0
votes
1answer
51 views

how to find cause of io spike

Everyday at around the same time, the IO usage on the server where our mysql slave goes up to 100%. I have setup a script that takes IO information every five minutes so I can find out why this ...
1
vote
1answer
883 views

MySQL error: “The partition with /var/lib/mysql is too full!” df -h shows otherwise

my rented server is currently saying that mysql is too full when trying to start it when using /etc/init.d/mysql start. However using sudo /etc/init.d/mysql start it works normally. Running df -h ...
-2
votes
1answer
28 views

Ubuntu server crashing frequently

i hope you can help me. i am running an ubuntu 12.04 server which i am using as a web/sql server. the server was running fine for month but now since two weeks the server is crashing almost every ...
1
vote
1answer
120 views

Never ending transaction problems after mysql 5.0->5.6 upgrade

I upgraded our entire backend mysql db from 5.0 to 5.6, including changing a few tables to innodb, and we've been having nothing but problems with never ending transactions since. I still have a ...
0
votes
1answer
67 views

My local MySQL server was temporary down for unknown reasons

My local MySQL server 5.5.38 (on CentOS 6.5) has been temporary down and the mysql log file was filled with this kind of details: This could be because you hit a bug. It is also possible that this ...
1
vote
0answers
42 views

Postrotate “error running shared script”

Morning all, I realise this question has been answered already but the fix does not seem to work in this case so I'm hoping you guys can help. This this is the error I'm getting: error: error ...
-2
votes
1answer
6k views

Can't connect to local MySQL server through socket '/var/mysql/mysql.sock [closed]

Recently, I've started getting this error when trying to login to mysql: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I read on another ...
-1
votes
1answer
996 views

my.cnf configuration in mysql 5.6.X [closed]

Server information 64GB RAM Intel(R) Core(TM) i7-3930K CPU @ 3.20GHz Mysql Server version: 5.6.20-log - MySQL Community Server (GPL) I have 20 websites on this server like share hosting my big ...
0
votes
3answers
138 views

Exim won't start - Error loading lookup module mysql.so

I had to change the root password for MySQL on a server. Exim also uses MySQL for users etc. I didn't think Exim/Dovecot used that password, but now things are not working well and I'm pretty sure ...
-1
votes
1answer
3k views

phpMyAdmin displays blank page

I have gone through all links related to a blank page displayed by phpMyAdmin but none of them helped my solve my issue. I have installed phpMyAdmin and deployed it on the Apache server. I have also ...
0
votes
1answer
126 views

Strange CPU spikes with MySQL

On my server (ubuntu 12.04) mysqld started to show some strange CPU spikes. I've logged some of it as a sample: http://pastebin.com/4MwKUVwL The value after the triple dash '---' is the cpu usage ...
0
votes
1answer
62 views

Production server (cluster) configuration

I have a problem, that i'd like to address to you. We are creating an webapp that shows infos and statistics. And we have a problem about how to 'do right' our server configuration The thing is that ...
2
votes
1answer
80 views

MySQL replication slowing master

We are currently running MySQL 5.1 Quick Overview We use 5 web servers ( Apache ) all connected to 1 DB server ( MySQL ) hosted on the cloud. The DB server running on the cloud ( Master ) ...
0
votes
1answer
100 views

RDS very slow and storage incosistencies [closed]

A couple of hours ago one of our AWS EC2 instances spike in CPU usage to 90 - 100%. That server, along with several other production servers, use one main RDS instance for the databases. All server ...
0
votes
1answer
89 views

New nagios/cacti monitoring setup, should I use a dedicated VM?

Currently we have 4 bare metal servers and one small VM server (all running centos6) and I'm looking at setting up monitoring for the Percona MySQL db server and replication slave (bare metal), as ...
0
votes
1answer
30 views

Is there any CLI tool to connect to MySQL server using a URL (mysql://xxx)?

I know how to use mysql -u username -pPASSWD -h hostname -P port databasename to connect but I need a tool that can use the RFC 1738 URL ...
4
votes
3answers
7k views

No mysqld or mysql.server after mariadb-server install

So... likely I'm an idiot, but I'm stuck. I just set up a CentOS 7 on Digial Ocean and I can't seem to get the MariaDB/MySQL server running. Some output [root@hostname ~]# yum list installed |grep ...
0
votes
0answers
25 views

Unable to access MySQL account on Win2008 R2 cluster

I have created a MySQL WFC service on my two-node server, the MySQL server is doing fine until I created an account using the MySQL Workbench of one of the nodes. When I try to connect to the server ...
-2
votes
2answers
219 views

Cannot start MySQL server following upgrade [closed]

Cannot start MySQL server following upgrade I've just upgraded MySQL from 5.1.59 to 5.6.20 (OSX 10.7) and now the MySQL server will not start. In MySQL Workbench (v6.1.7), in the startup/shutdown ...
1
vote
0answers
20 views

Auditing connections using certificates

We would like to have clients connect using client certificates from a trusted (internal) issuer and then log which user connected. Unfortunately, the following limitations are preventing success: ...
1
vote
1answer
77 views

WinServer 2008 R2 MySQL cluster service won't start

So I have a two-node failover cluster in WinServer 2008 R2, I also created a generic service which will manage my MySQL5.5 database (the database root is also in a iSCSI storage). When the cluster ...
1
vote
1answer
593 views

Creating a stable, auto-scaling app server cluster

I have two servers, each running anywhere from 50-100 different legacy webapps, written in languages ranging from PHP to Python to Ruby-on-rails to NodeJS. We're wanting to kill off these machines ...
-2
votes
2answers
93 views

One database for two websites [closed]

I'm starting a project where I need two different websites to interact with one database. They have different domains and different source codes. My servers providers are Hostgator and Linode. ...
0
votes
2answers
285 views

Centos 6.5 DB MySQL server, default install, resize or move DB location - disk-usage issue

I did a standard install of Centos 6.5 in a 1TB SSD (MLC) not realizing that only 50G is allocated to / and approximately 816G to /home: [gskidmor@mrserver ~]$ df -h Filesystem ...
-5
votes
1answer
38 views

MySQL : How dump is works? [closed]

I have a 10GB database and the dump takes just a few minutes. I want to know how the system of dump works ? Someone can tell me ?
0
votes
1answer
138 views

Percona slave crashes with “unexpected PLT reloc type”

I have 2 data centers each with a master/slave database running Percona server 5.5.23. For some reason, one of the slave databases crashed with this error: 03:00:40 UTC - mysqld got signal 11 ; ...
-3
votes
3answers
73 views

Is it safe to use mysql 5.1? [closed]

I've contacted 3 different hosts lately, to talk about Apache server, one of them is my current host, two of them have mysql 5.1 (One is mine), one has mysql 5.4, but none of them seems to give me a ...
0
votes
1answer
62 views

how to use mysql database replication to backup a single database

Suppose I want to replicate a single database in mysql on my slave, the master might be creating and writing to multiple databases. is this possoible? or does the replication slave have to replicate ...
0
votes
1answer
262 views

MySQL installation with Ansible on Debian Wheezy

As the title suggests, I am trying to install MySQL Server 5.5 on Debian with Ansible. Since this needs to be a silent installation, I provide the root password before the installation with debconf ...
-1
votes
1answer
26 views

Moving MYSQL database Cache issue?

I moved a mysql (myisam) database using rsync to aother server, I realized after doing this that I forgot to run 'flush tables' before moving the files so not all changes were written to disk I guess. ...
0
votes
0answers
312 views

mysql-server : Depends: mysql-server-5.1 but it is not going to be installed

I want to install MySQL on Squeeze (Debian), but I get this error message from apt: mysql-server : Depends: mysql-server-5.1 but it is not going to be installed I have tried to use a different ...
-4
votes
2answers
2k views

Error MySQL CentOS - Starting MySQLCouldn't find MySQL server

I can not make any operation in mysql: root@server2 [/]# /etc/init.d/mysql status MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED] root@server2 [/]# /etc/init.d/mysql start ...
1
vote
0answers
199 views

MySQL on Amazon RDS db.m3.medium performing slowly

I'm moving a rails application from heroku to AWS in order to increase reliability and control over the stack architecture. I was planning to use amazon RDS as I will need several app servers, and a ...
2
votes
1answer
43 views

Drop outgoing mail to previously unavailable mailboxes in exim using mysql database

we have a larger community portal which became bigger and bigger over the years but also has some dead accounts. Recently the ip of the server was blacklisted because many mail adresses of the users ...
0
votes
2answers
217 views

MariaDB RHEL Fresh Install Root Login Issue

I just installed MariaDB on a RHEL system and this is my first time using MariaDB. I can start/stop the service only using the following commands: sudo systemctl start mariadb.service sudo systemctl ...
0
votes
1answer
41 views

TOP processes by system time

I have a system running 2 processes - MySQL and Java I'm seeing 20-30% of the time spent in %system. I've looked around to try and find a way to identify which what the balance of the system time is ...
1
vote
1answer
68 views

import rescued cacti database into newer version

I have an older cacti database with critical data I am trying to recover. The old database has many less fields than the new current stable. Doing a manual import produces wild errors. How do you ...
0
votes
1answer
149 views

Postfix intermittent lookup failures

i have intermittent lookup error on my postfix/mysql/dovecot/debian when looking to virtual aliases ... it happens on 10% of outgoing emails Revelant log of a failed request : Aug 28 12:17:43 ...