MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

4
votes
0answers
513 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 ...
4
votes
0answers
525 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
4k 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 --basedir=/usr/local/...
3
votes
0answers
30 views

MySQL rejects login attempts when password is stored in options file

First: We're running MySQL 5.7.13. OS is Red Hat Enterprise Linux 7.2. The problem was first discovered using Python/Connector 2.1.3 System is not domain joined (yet.) All MySQL packages installed ...
3
votes
0answers
52 views

When configuring rsyslog to log to mysql DB, what is purpose of SystemEventsProperties table?

I've configured rsyslog on my servers to log to a remote mysql DB. I did this essentially by following the rsyslog wiki and it essentially creates two tables: mysql> show tables; +----------------...
3
votes
0answers
253 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
174 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 ...
3
votes
0answers
276 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 = "/etc/...
2
votes
0answers
21 views

MySQL replication broken as binlog not in chronological order

Looking at an excerpt from the binary log, it can be seen that these 2 statements are written to the log out of order chronologically: #160628 17:32:46 server id 2220 end_log_pos 64812204 Query ...
2
votes
0answers
28 views

MySQL slave index file corruption

I have a MySQL master-slave replication pair, and to take backups, I run a script that stops the slave, dumps the database, and then re-starts the slave. However, after restarting, the slave's MySQL ...
2
votes
0answers
50 views

Delay in starting Database services on Server 2012 R2

We have found in the past couple of days (unknown when this first appeared) that services for MYSQL and SQLAnywhere 16 are taking 20 minutes to start when a windows 2012 R2 server is rebooted. After ...
2
votes
0answers
108 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 / ...
2
votes
0answers
211 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 ...
2
votes
0answers
273 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
227 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
1k 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
163 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
285 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 ...
2
votes
0answers
1k 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
359 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
1k 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: com.mysql.jdbc....
2
votes
0answers
245 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
217 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
304 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
104 views

How to create a Capistrano task to import a backup from production into local development db?

I'm trying to do something with a Capistrano task that is similar to the heroku db:pull functionality if you are familiar with it. I have a remote server. On that server I have a bunch of backups in ...
2
votes
0answers
3k 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
4k 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
440 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 = /Volumes/www/public/logs/mysql-queries....
2
votes
0answers
563 views

MySQL Enterprise Backup GUI (or a live backup alternative)

I am looking into MySQL Enterprise backup solution. I am interested in a non-blocking mysql backup (live and incremental). MySQL Enterprise provides this solution (we have the subscription already). ...
2
votes
0answers
184 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
96 views

install mysql 5.7 to linux 6 - yum tries to install 5.7 el7?

I'm following the instructions here to install MySQL-Community-Server onto a linux 6 aws instance. Basic commands: wget http://dev.mysql.com/get/mysql57-community-release-el6-8.noarch.rpm sudo yum ...
1
vote
0answers
25 views

How to troubleshoot a MySQL / MariaDB error

I've imported two Wordpress databases to a system (CentOS7), and I did not have any problems. When I try to import an .sql file (obtained with mysqldump command) for a vBulleting forum (the newest ...
1
vote
0answers
18 views

Inconsistent CPU load on debian

This server runs Apache2, Tomcat6 and MySQL.(if that makes any difference you tell me :) Using htop i can see the cpu load on each of the 4 cores. What I do not understand is witch processes are ...
1
vote
0answers
57 views

MariaDB ignores root password completely

I just installed MariaDB (mysqld) on a fresh Ubuntu downloaded yesterday. Then I ran the script /usr/bin/mysql_secure_installation and set new root password and disabled passwordless login. However ...
1
vote
0answers
57 views

PHPmyadmin Login without a password is forbidden by configuration even when entering password

Basically it is all in title. I did a clean install of CentOS7.2 (needed CentOS7 for running ARK). I made a LAMP server and it is working with tests, and then I installed PHPmyadmin. Whenever I try to ...
1
vote
0answers
35 views

MySQL on Ubuntu. 10061 error on 3306

A fresh install of Ubuntu inside of a Virtualbox with LAMP option selected. I am unable to connect to the server via telnet on this port or via ODBC from my host machine. I can ping and SSH both ...
1
vote
0answers
39 views

Percona XtraDB Cluster 5.6 does not start

All the good days. I want to run for test purposes Percona XtraDb Cluster on ubuntu 14.04. The basis here took these two articles https://habrahabr.ru/post/152969/ https://www.percona.com/doc/...
1
vote
0answers
17 views

Mysql query log is empty after boot

I can't figure out why is general and slow query log empty after computer restart. After restarting the server with systemctl the logs get populated. After reboot the files are created just empty. $ ...
1
vote
0answers
110 views

have xmpp (ejabberd) server authenticate with existing user database (MySQL)

Let me start off by stating that I know very little about the XMPP protocol or real-time communication in general. I did however manage to set up an ejabberd server with TLS encryption. I have written ...
1
vote
0answers
252 views

Unable to login to MySQL on ownCloud using PHP - SQLSTATE[28000] [1045] Access Denied

I get a SQLSTATE[28000] [1045] Access Denied error every time I try to connect my ownCloud instance to my MySQL database as <user>@localhost. This is on a clean, newly installed copy of Ubuntu ...
1
vote
0answers
23 views

Recover MySQL MyISAM BAK files

I had some hard disk issue on my server and I noticed a MySQL table is missing lots of rows (5k instead of about 200M). In the MySQL directory I have a BAK file for that table : mytable-160115203241....
1
vote
0answers
68 views

MySQL Multi-source replication from 5.6 masters to 5.7 slave

In MySQL 5.7 multi-source replication is finally available. Is it possible to use several MySQL servers running version 5.6 as multiple masters for a single MySQL slave running 5.7? Or do you have to ...
1
vote
0answers
68 views

Cannot connect to remote MySQL server (RDS)

When I am trying to connect to RDS from my vps, it says connection refused. When I tried connecting it from local or other vps, it worked fine. I figured out that it must be a firewall issue on my ...
1
vote
0answers
437 views

MySQL /nonexistent home vs “No directory, logging in with HOME=/”

The preinst script in the Debian/Ubuntu packages for MySQL sets the default home directory for the MySQL server to /nonexistent, presumably as a security measure - the MySQL server has its own datadir ...
1
vote
0answers
27 views

RTC/UTC was innacurate on MySQL (MariaDB) server. I fixed it - was that bad?

I'm pinch hitting as an admittedly green server admin. I installed a bunch of security patches on a MariaDB server that had an incorrectly configured repo (not by me) and wasn't getting patches for a ...
1
vote
0answers
98 views

SYN flood on mysql server

Consider this structure: DB <-TCP3306- WEB{1,2,3,4} All servers are CentOS 6/7 Web servers are running PHP (using php-fpm) that connects to the MySQL server. Occasionally, I get this error ...
1
vote
0answers
24 views

MySQL proxy authentication options

I have a farm of production mysql servers that are currently protected by restricted passwords. I would prefer to restrict access to these systems at network level, but have to account for the fact ...
1
vote
0answers
21 views

Using a py file as an API endpoint on a hosted server

I need a bit of help and clarity involving how to set up an API service on my web server. I have written a Python script that is able to do some calculations and string parsing, and I need to make ...
1
vote
0answers
213 views

mysql-workbench installation error

I have ubuntu 14.04 and try to install mysql-workbench. and getting an error as The following packages have unmet dependencies: mysql-workbench: Depends: libgcc1 (>= 1:4.1.1) but 1:4.9.3-0ubuntu4 ...
1
vote
0answers
67 views

dovecot shared folders (acl with mysql) can't be subscribed

For some reason the folder Project Folders is not selectable. Practically every public or shared folder is not selectable. The Email client is Thunderbird. # 2.1.17: /etc/dovecot/dovecot.conf # OS: ...