MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

4
votes
0answers
443 views

mysql client slow login strace

I am experiencing an issue with slow connections/logins to a loaded mysql server, even when connecting via the unix socket file (CentOS 6.3). Queries are completing very quickly -- (0.00 sec) in this ...
4
votes
0answers
3k views

mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect

When I'm trying to install MySQL 5.5 community edition on my Ubuntu 10.04 by compiling the source code, I met the following problem: $ fg % 1 sudo ../bin/mysqld_safe ...
3
votes
0answers
105 views

Update Mac OS X Snow Leopard Server to Yosemite

I have a Mac Pro (Model Identifier: MacPro5,1) running OS X 10.6.8. The machine serves to the web a couple of MySQL databases (v. 5.0.92) as well as a Redmine installation (with a Subversion ...
3
votes
0answers
87 views

combine two mysql replication log files

So I use a master-master replication of a mysql database and load balance traffic between the two. This results in server A with a binlog of all it's transactions and Server B with a binlog of only ...
2
votes
0answers
173 views

Benchmarking for DISK I/O Writes Per Second - ElasticSearch and MySQL

During working on our project we needed to decide should we use "ElasticSearch" or "MySQL" to record the audit/trail logs of the system. Searching speed is not an issue here, we needed to see the disk ...
2
votes
0answers
79 views

mysql service status doesn't show started when it is started by monit

I installed monit on my Ubuntu 14.04 server and configured it to monitor mysql with the below config in monitrc. check process mysqld with pidfile /var/run/mysqld/mysqld.pid start program = ...
2
votes
0answers
175 views

MySQL permission errors

It seems that on a Ubuntu 14.04 machine the user mysql cannot access anything. It is not writing logs nor reading files. Witness: - bruno():mysql$ cat /etc/passwd | grep mysql mysql:x:116:127:MySQL ...
2
votes
0answers
589 views

OpenLDAP with MySQL works but need schema advice

So, I have downloaded the latest source of OpenLDAP, compiled with —-enable-sql, messed around with the slapd.conf, configured the odbc files, added the tables to my current DB, spend a week debugging ...
2
votes
0answers
106 views

What can be done to prevent “failed to flush master info” in MySQL replication?

I have two MySQL 5.1 servers setup with master/slave replication. I was previously using 5.1.41 for several years without issue. However, since I've upgraded to 5.1.72 (and did some other tweaks ...
2
votes
0answers
870 views

Amazon RDS: Sudden increase in Read IOPS and Throughput

I am using Amazon RDS to host the databases for my website. I am using the large instances for both my master and my read replica. Everything was running smoothly until suddenly the Read IOPS, Read ...
2
votes
0answers
321 views

System.Data.Odbc.OdbcConnection.Open() takes a second for every db call

My experience is with LAMP stacks and not so much with .NET on Windows, but I've been given the task of trying to debug a slow site and I've run into a dead end after Googling everything I can think ...
2
votes
0answers
810 views

mysql client can't read query result?

So I have this machine running an XMPP server which connects to its MySQL database. When I start load-testing it, all goes fine up until after about 500s when I notice: Caused by: ...
2
votes
0answers
181 views

mysqld never gets to “ready for connections”

A fresh install of MySQL on a 1and1 Windows Server 2008 R2 virtual server cannot start. The log gives: 130304 16:09:59 [Note] Plugin 'FEDERATED' is disabled. 130304 16:09:59 InnoDB: Initializing ...
2
votes
0answers
190 views

pam_mysql / vsftpd error 'AUTHENTICATION FALURE (FIRST_PASS)'

I setup vsftpd and mysql auth via pam on Debian Squeeze. Config: auth required pam_mysql.so user=server passwd=x host=localhost db=server table=ftp usercolumn=username passwdcolumn=password ...
2
votes
0answers
201 views

what can put linux process managing connection pool into bad state, so it restarts them continously?

I have an application with pool of connections to MySQL. At some point, in production, every 1-3 seconds some socket is closed. As a result my app restarts this connection. This is pretty big pool ...
2
votes
0answers
2k views

syslog-ng and nginx logs to mysql

So couple of days ago I asked how to log php and nginx logs to centralized MySQL database, and m0ntassar gave a perfect answer :) cheer ! The problem I am facing now is that I can not seem to get it ...
2
votes
0answers
3k views

Temporary MySQL Error: 1286 Unknown storage engine 'InnoDB'

I operate a cPanel/WHM server on CentOS 5.8 which is running MySQL 5.5.24. It seems that ever other week or so, some clients websites exhibit the following error: SQLSTATE[42000]: Syntax error or ...
2
votes
0answers
338 views

Logging mysql queries under MAMP Pro (MAC)

I am using MAMP Pro 2.0.5 (latest) and copied the my-medium.cnf file and placed it into /mamp/conf/ and renamed it to my.cnf under the [mysqld] i placed log = ...
2
votes
0answers
178 views

mysqldump trigger crashed tables

We had a database crash this morning starting at 1 minute past midnight (when the database backup runs). The exception emails I was getting said "Table './core/content' is marked as crashed and ...
1
vote
0answers
26 views

Ubuntu | Mysql Server 300-750% CPU

I have already done a lot of adjustments to the MySQL Configuration, but unfortunately I always get back to time utilization very high CPU. Multiple MySQL processes partially between 200-750% CPU / ...
1
vote
0answers
25 views

Advice on migrating RDS MySQL databases from one AWS account to another

I am currently planning a migration of AWS resources from one account to another. This includes several MySQL RDS instances. After some research it looks like a "dump and load" strategy is needed. My ...
1
vote
0answers
29 views

Connecting to MySQL - one client connection returns IP. The other clients return hostname

I have 4 servers that connect to a MySQL database. DB server running Ubuntu 12.04 client-server-1.mydomain.com 1.2.3.1 Ubuntu 14.04 client-server-2.mydomain.com 1.2.3.2 Ubuntu 14.04 etc... When ...
1
vote
0answers
13 views

Adding mysql driver to tomcat openshift

I have deployed my war file on openshift tomcat. As suggested to deploy war file directly we need to remove the src and pom.xml before coping the war file in webapps folder. pre compiled java ...
1
vote
0answers
65 views

TeamCity Connection Timeout

I set up a TeamCity server yesterday, and it was working fine until this morning when I restarted it. I didn't change any settings anywhere, but I keep getting this message in the teamcity-agent log ...
1
vote
0answers
70 views

Migrating web site from local PC to Windows 2008 R2 (IIS 7.5)

The company I work for is interested in moving a local Intranet web site I made for them from my test box to one of their servers. My testbox is running Windows 7 64x, and the server is running ...
1
vote
0answers
75 views

Advice Tuning my server

as many others I Learn many info from you in the past and now I manage to run server independently , now I am new to sql tuning and I been searching around the web a while now and tuning seems to be a ...
1
vote
0answers
24 views

libnss-mysql on freebsd 10.1

i have libnss-mysql installed on freebsd 10.1. Everything works except groups command. getent group - ok # getent group ....... froxlorlocal:*:1003:www <-- data from passwd vmail:*:2000 ...
1
vote
0answers
46 views

MySQL (InnoDB) - processes waiting on futex

Currently troubleshooting a MySQL server spending a lot of time in futex syscalls. All databases are InnoDB and seeing high load on my 16 core machine, and slightly more than half of CPU time is in ...
1
vote
0answers
254 views

Installing php-mysql on centos 6.5 fails due to conflicts when percona client 5.5 also installed

Some background: I'm writing a Chef cookbook to set up a LNMP stack for local development. It requires the php-mysql library for PHP 5.4 (using the php package). We're using the yum-remi repository ...
1
vote
0answers
87 views

Cannot install mysql server - Error in PREIN scriptlet in rpm package mysql55-mysql-server-5.5.32-3.el5.x86_64

I am trying to install mysql server 5.5 (or any 5.x versions) on Redhat 5.5 and am having some trouble. I can install the other mysql components but when I try to install mysql-server (or ...
1
vote
0answers
352 views

ERROR 2003 (HY000): Can't connect to MySQL on server 'myhost.com' (101)

When trying to connect to my mysql server remotely with: ~$ mysql -u user -p -h myhost.com The result is (after asking for password): ERROR 2003 (HY000): Can't connect to MySQL server on ...
1
vote
0answers
210 views

Amazon RDS Instance slowly losing free diskspace

A while back the server running my instance had 20GB of EBS storage. It then started getting disk storage errors, so I increased it to 40GB. Then again, storage missing errors so I increased again to ...
1
vote
0answers
196 views

How to change permission of users in RDS?

We have created a MySQL RDS instance on AWS called "lolbob" and while dumping our data over port 3306 using the user that was created during instance creation (also called "lolbob") it fails because ...
1
vote
0answers
212 views

freebsd cannot start mysql for the first time

I am having the same issue as this person serverfault link but the solution completely does not work for me. I cannot start mysql5.5 for the very first time. At first start of mysql with cd ...
1
vote
0answers
574 views

Mysqldump complains about chosen databases regardless of command line

Mysqldump complains about command line options I have never specified. I don't have shell aliases nor a custom .my.cnf file set. What am I doing wrong? Using the --database long option: $ mysqldump ...
1
vote
0answers
278 views

error creating database using ansible on centos 7

I am trying to install mysql AND setup database using ANSIBLE on CentOS7(i have no idea why every documention in the world now ONLY talks about Ubuntu and NO CentOS anymore...really SAD!) here is my ...
1
vote
0answers
192 views

200 OK blank page setting up Wordpress on restore test VM

I'm testing a partial backup of a frankly rather outdated (legacy, what can you do?) CentOS/Apache/MySQL/PHP/Wordpress server by restoring to a VM with a fresh copy of the relevant packages. After ...
1
vote
0answers
201 views

Apache 2.4 prefork, MySQL 5.6 and 2GB RAM

I think I'm having problem setting up Apache24 correctly. Apache seems to taking up to much RAM, and I'm not sure how to configure it. The FreeBSD server is using 50% of it's swap space. We are ...
1
vote
0answers
112 views

MariaDB 5.5 on Slackware 14 need to change to new password format

Strangely, this worked fine for a while, but my computer rebooted recently and now my php apps won't work: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an ...
1
vote
0answers
89 views

Destination Host Unreachable and Communications link failure when I connect to MySQL database using D2RQ library

I have a question: I have a web service which runs on a virtual machine located on a remote server with Ubuntu 12.04 operating system. Now, I want to test this Web Service and I'm using this code ...
1
vote
0answers
272 views

MySQL 5.6 Community Server failed to start in CentOS 6

MySQL 5.6 Community Server failed to start on CentOS 6. Before, I have successfully installed mysql community server (file: mysql-community-release-el6-5.noarch.rpm) on my CentOS 6, the binary source ...
1
vote
0answers
220 views

2006: MySQL server has gone away

I am getting 'Lost connection to MySQL server' and '2006: MySQL server has gone away' errors so frequently that the server is unusable. There are questions related to this issue, but none that apply ...
1
vote
0answers
366 views

R1Soft MySQL Failed to perform discovery on database instance

I am using R1Soft (5.8.1) for file backups on a few servers and have tonight been trying to setup a MySQL backup - I installed the driver etc and am setting up the policy but am getting an error. ...
1
vote
0answers
89 views

Rsyslog won't monitor mysql-slow.log when written to by mysql

I'm going mad. I'm trying to get rsyslog to send log files to logentries.com. This works perfectly until I try to log mysql-slow.log. The config is pretty simple module(load="imfile" ...
1
vote
0answers
758 views

Error missing systemd on AWS server

I cant seem to figure out how to install systemd. I am attempting to upgrade mysql server on AWS from 5.5 to 5.6. I am getting the following error when trying to install- "Requires: systemd" Any ...
1
vote
0answers
55 views

Mysql with low memory on development environment

How to set mysql to run on very low memory? (preferably under 100MB and max 250MB) Currently it's running for about 400mb. I can't turn off the innodb because production using innodb. Is there any ...
1
vote
0answers
79 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 ...
1
vote
0answers
286 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 ...
1
vote
0answers
256 views

Website down… due to sleeping MySQL connections?

I've just inherited the administration of a website, and I'm finding some problems: When the traffic in the site peaks (it happens when our posts are featured in some distribution lists/RSS feed), ...
1
vote
0answers
111 views

Oracle 6.5: MySQL Daemon failed to start

I installed MySQL by following these instructions on my Oracle Linux Server release 6.5, specifically using the yum package installer command, yum install mysql mysql-server mysql-libs mysql-server ...