MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

4
votes
0answers
167 views

Spamassassin: store bayes per user in mysql (with amavis)

I use postfix (mysql virtual users) + amavis + spamassassin and configured spamassassin to use mysql for storing the bayes data: use_bayes 1 bayes_auto_learn 1 ...
3
votes
0answers
164 views

MySQL memory usage - Periodically need to run FLUSH TABLES or memory usage keeps growing with large-pages turned on

After switching our rather memory + physical core rich database server to large-pages, we have noticed a small issue. The memory usage almost looks like there is some sort of memory leak. But ...
3
votes
0answers
262 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
260 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
50 views

SSH port forwarding to a host that needs to contact a third named host to access MySQL

We customize and support standard web applications that our customers host on managed servers from different web hosters. Usually, the application consists of a web application in PHP and a database ...
2
votes
0answers
179 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
441 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
86 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
142 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
102 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
1k views

Trying to connect phpMyAdmin to remote mySQL server ( 2002: can't connect )

Trying to get phpMyAdmin to talk to a remote mySQL server. The config is below and there is already a user set up in mySQL DB to be able to log in from the specified host that PMA sits on. Hosting is ...
2
votes
0answers
220 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
389 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
167 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 ...
2
votes
0answers
676 views

HAProxy + MySQL Slaves, random lost connections

The Setup Right now I've got set up 3 MySQL Servers (5.1.x, on RHEL5), one Master and two Slaves. Last week I added a load balancer (HAProxy) for some services, and thought I'd experiment with using ...
1
vote
0answers
18 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
38 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
68 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
20 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
45 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
31 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
55 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
45 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
41 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
35 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
43 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
49 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
28 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
41 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
58 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
164 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
91 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
114 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
457 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
22 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
64 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
39 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
207 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 ...
1
vote
0answers
71 views

LVS-DR and OpenVPN: returning packets not being routed into the vpn

i've set up a load balancer with ldirectord, and an active-passive mysql service managed by it, on two additional real servers. LVS is running in Direct Routing mode, so the client requests are ...
1
vote
0answers
62 views

How to compile MySQL (Percona) with jemalloc installed under custom prefix?

My jemalloc is installed under /opt/jemalloc, how to compile MySQL/Percona with the support of jemalloc? The standard option is cmake . -DCMAKE_EXE_LINKER_FLAGS='-ljemalloc' -DWITH_SAFEMALLOC=OFF ...
1
vote
0answers
59 views

MySQL Cluster data node in memory limits

What is the maximum amount of RAM per data node I can allocate to MySQL Cluster "in memory" database? I found some info about total size can not be more then 3 TB (48 data nodes) or 64 GB allocated ...
1
vote
0answers
90 views

Scientific Linux - mysql and apache fail to start on reboot

Both mysqld and httpd fail to restart following a reboot of the server, although chkconfig --list shows both daemons set to on for run levels 2,3,4 & 5 All control is being exectuted via Webmin ...
1
vote
0answers
224 views

how to enable remote access to a MySQL server on an AZURE virtual machine

I have an AZURE virtual machine with a MySQL server installed on it running ubuntu 13.04. I am trying to remote connect to the MySQL server however get the simple error "Can't connect to MySQL server ...
1
vote
0answers
154 views

error on installing mytop : Requires: libmysqlclient.so.16

my mysql cpu usage has been high lately so i'm trying to installl mytop to monitor the database when i try to install it with yum i get this : yum -y install mytop --> Finished ...
1
vote
0answers
327 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 ...
1
vote
0answers
94 views

How to use client certificates with mysql

This concerns my attempt to use a client side certificate on an SSL encrypted connection to a mysql server. Some basics: Server is ubuntu 12.04 running mysql 14.14 Distrib 5.1.69. Client is MacOS ...
1
vote
0answers
141 views

Problems with MySQL/Apache-based symfony website

in the company where I started working on 1. July, I inherited, among others, a webserver that runs a MySQL/Apache stack on which a Website built in Symfony is running. The server runs openSuSE 12.1, ...
1
vote
0answers
91 views

MySQL syntax error unexpected '-'

I just noticed an error in my MySQL logs: syntax error, unexpected '-', expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '(' As far as I can tell this doesn't relate to a query and doesn't have a ...
1
vote
0answers
641 views

mysqld space header page error (InnoDB)

After formatting C and not having my original ini file I copied my templated mysql file which tells mysql to use a file per table and other things. I set the path and port appropriately and I get this ...