MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

3
votes
0answers
378 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
322 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
190 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
573 views

MySQL on Amazon RDS connection handshake error reached max_connection_errors

We are using a C# web app on AWS connecting to a MySql RDS. Suddenly, connections start to fail with two different exceptions: First one (most repeated): Authentication to host 'xxx' for user 'xx' ...
2
votes
0answers
249 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
612 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
123 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
163 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
128 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

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
269 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
423 views

MySQL INSERT … SELECT renders server unresponsive

Solution: Although I haven't found a proper solution yet I'm at least sure that this is purely a disk I/O problem and has nothing to do with MySQL... I have a MySQL server (5.1.54-1ubuntu4-log) ...
2
votes
0answers
174 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
45 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
55 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
19 views

PhpMyAdmin and auth_ldap plugin

I have a need to authenticate MySQL users from an LDAP source using the community edition of MySQL Server 5.5. The auth_ldap plugin has been compiled from source ...
1
vote
0answers
24 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
89 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
85 views

mysqld shuts down every 10 minutes

I have a very odd problem: mysqld shuts down every 10 minutes, without any errors, just like some process actually calls "shutdown" on it. I already checked cron, but couldn't find anything there. ...
1
vote
0answers
24 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
36 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
16 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
150 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
108 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
188 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
136 views

After software update, why is webmin showing wrong mySQL version?

I did a full OS/package update on a server running webmin. Now when I go into webmin, it's showing the correct new version of Ubuntu, Apache, etc...but it's still showing the old version of mySQL. ...
1
vote
0answers
40 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
91 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
146 views

PhpMyAdmin Hangs On MySQL Error

I'm currently running PhpMyAdmin 4.0.10 (the latest version supporting PHP 4.2.X) on my Amazon EC2 connecting to a MySQL database on RDS. Everything works perfectly fine except actions that return a ...
1
vote
0answers
55 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
70 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
59 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
207 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
59 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
74 views

Openstack instances, routing, packets not delivered for SPECIFIC services

I am taking over management of an existing openstack system at work and I have only a little prior experience with openstack. I have about 8 instances running and all of them appear to function ...
1
vote
0answers
101 views

Transfer user data of a Tigase server

I'm trying to transfer a Tigase XMPP server from an Ubuntu VPS to a CentOS VPS. Unfortunately there isn't any official documentation available and I need to experiment in order to preserve all of the ...
1
vote
0answers
143 views

MAGMI fails while importing big chunks of records. Ideal Mysql configuration for Magmi

Configuration: Linux Centos 6, NGINX, Mysql We are trying to use MAGMI a common tool for mass importing of data in Mysql based on webbrowser. I run in an issue. As a try to import more than a small ...
1
vote
0answers
115 views

How to configure MySQL pid file permissions?

I know MySQLd will create a pid file as set up in mysqld.service: ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid However, it creates the file with a 660 permission, meaning ...
1
vote
0answers
41 views

Frequent CPU spikes on fresh install

I just reinstalled my Server (Windows Server 2008 R2) and after installing MySQL 5.6, the CPU spikes every few seconds: http://s15.postimg.org/dno7ztfjf/cpuspikes.png Even worse than the higher CPU ...
1
vote
0answers
87 views

wrong directory 'cannot change the directory'

I am working on mysql cluster. I am following the mysql manual. But when I arrive at this step ndb_mgmd -f /var/lib/mysql-cluster/config.ini` ndbd I have this error: [ndbd] WARNING -- ...
1
vote
0answers
69 views

Unexplained excessive database response times - very powerful hardware, tiny database

I've a strange problem that's repeatedly troubled me across 3 different servers now. The problem Please see the graph from NewRelic showing the huge amount of time spent in the database. The ...
1
vote
0answers
361 views

MySQL rebuild after Corrupt ibdata1

I have a MySQL server that serves a couple of databases including a Magento e-commerce store. We have been suffering with corruption in the ibdata1 file for a while, but it has now reached a critical ...
1
vote
0answers
176 views

Elastic Beanstalk w/ RDS and PHPmyAdmin

I'm trying to configure a Drupal CMS on my new Amazon EC2 server with Elastic Beanstalk PHP. I also have MySQL configured for my RDS database. I want to get PHPmyAdmin running for use with Drupal. I ...
1
vote
0answers
195 views

GitLab, error while installing Gems, libmysqlclient-dev probabily missing but unistallable

So, while I was installing GitLab following the official tutorial I got an error on the Gems installation. Gem files will remain installed in ...
1
vote
0answers
1k views

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure between Java app & database VMs

Am getting increasingly frequent JDBC Communications link failure errors between a Glassfish 3 + Java 7 server VM and a MySQL 5.6 Both VMs are hosted on the same ESXi 5.5 enterprise host (as part of a ...
1
vote
0answers
25 views

Mysql Master to Master Configuration Steps

In our project currently we are using Mysql Master to Master replication, both mysql server version is mysql 5.1. we are going to upgrade the replication then our requirement is one mysql server ...
1
vote
0answers
77 views

mysql - measure amount of write

System : Centos 6.4, PerconaDb/MySQL 5.5.31 Im running relatively small mysql database with some 30 databases, total amount of 12Gb, but heavy on reads, updates and writes (texts, posts, user data ...
1
vote
0answers
304 views

MySQL 5.5 : Cannot drop database : Lost connection to MySQL server during query

After a huge crash of my mysql database, I've made a recovery, all is ok except one schema. In phpMyAdmin, this schema doest not cotains any tables, but we i ask mysql to drop the schema (drop ...
1
vote
0answers
59 views

mysql server initialization error if I add 'log = “testfile_log.log” '

Guys I'm just trying to set my general log file set up like here http://stackoverflow.com/questions/5441972/how-to-see-log-files-in-mysql. so I added log = "testfile_log.log" as below to my.ini # ...
1
vote
0answers
331 views

mysql binlog error “ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 341, event_type: 2 **”

I am new in mysql binary log and replication .Please help me sort this issue. I am using mysql version 5.0.95 and now facing errors in binlogs. Some of querries in binary log as unknown event and ...