MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

3
votes
0answers
420 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 ...
3
votes
0answers
356 views

php-fpm crashing because of to many mysql processes

I have 2 frontend nginx servers going to 4 backend php-fpm servers which all run Wordpress. The php-fpm servers all connect to one MySQL server and I was checking some stats earlier each php-fpm ...
2
votes
0answers
27 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
86 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
45 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
149 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
361 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
742 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
292 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
724 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
161 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
177 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
152 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
1k 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
304 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
176 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
156 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
41 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
119 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
98 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
67 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
100 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
286 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
173 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
135 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
134 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
79 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
66 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
198 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
176 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
261 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
63 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
491 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
47 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
51 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
24 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
0answers
241 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
198 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
97 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 ...
1
vote
0answers
323 views

User Uploaded Images– Blank Post – Connection reset by peer / FastCGI: incomplete headers

To give a little background, I have a website that permits users to upload images. WordPress is used as a content management system and the posts are immediately published with the image inserted as ...
1
vote
0answers
57 views

Issue while setting up a DSN while creating a linked server

I am trying to set up a linked server to my sql from sql server. However I am encountering problems while setting up the dsn. Reffering this link for help. My MySQL database resides on Amazon ec2 ...
1
vote
0answers
134 views

Amazon EC2 Instance - m1.medium Ubuntu 12.04 - Started to crash three days ago

The environment: Amazon EC2 Instance - m1.medium Ubuntu 12.04 Apache 2.2.22 - Running a Drupal Site Using MySQL DB Server RAM info: ~$ free -gt total used free shared ...
1
vote
0answers
108 views

phpmyadmin not working after mysql update

i followed this guide to update my mysql form 5.1 to 5.5. After lots and lots of command and headache, i was able to upgrade mysql. i checked the version via terminal. But now there is another ...
1
vote
0answers
91 views

PHP-FPM slowlog and Mysql lost connection

I was having an issue with PHP-FPM and mysql. When I needed to process an input file that would generate several selects/inserts/updates for each line, it would stop after approximately 60s with ...
1
vote
0answers
89 views

Rackspace Cloud Server / DB - getaddrinfo failed

I recently migrated my MySQL instance from my debian server to a cloud database server at rackspace. A couple times of day since then, I notice in the log files that we have the following error: PHP ...
1
vote
0answers
89 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 ...
1
vote
0answers
259 views

Enable FEDERATED ENGINE error

I need to enable FEDERATED ENGINE on Mysql (version 5.5.35). I set in /etc/my.cnf file line federated. Restart my mysql server, then check in mysql using command SHOW ENGINES, and result is: ...
1
vote
0answers
72 views

MySQL SSL Problems

I need to configure SSL for a MySQL server. I've read all of the directions for doing self-signed certs but it's preferred that I sign and use the certs from a different CA running AD Certificate ...
1
vote
0answers
396 views

Mysqldump not working with SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER privileges

My system: CentOS 6.5 + MySQL 5.6 I have created a backupuser for mysqldump: CREATE USER 'usr_backup'@'localhost' IDENTIFIED BY 'XXX'; GRANT USAGE ON *.* TO 'usr_backup'@'localhost' IDENTIFIED BY ...