MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
1answer
144 views

Amazon RDS load balancing and performance

My question is simple. Is it possible to load balance rds (master and read-replicas) using the same haproxy instance used for application load balancing? This would mean that the IP of the ...
-5
votes
1answer
93 views

MySql wont start [closed]

'Hi I have a pretty recent install of MySql on DigitalOcean. And for some reason I cannot get MySql to start. 141003 07:25:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 141003 ...
0
votes
0answers
36 views

MYD files renamed after restart - how to recover?

The disk space went full on our server. It remained like this for too long, and now mysql is completely crased. I'm getting errors like this : mysql> use mysql; Reading table information for ...
1
vote
1answer
174 views

Batch MySql script stopped with error “(104)Connection reset by peer”

On my site I start a script that executes a batch process that imports into the Mysql database a lot of products (texts and images). I'm monitoring the query process from Phpmyadmin>Status and I ...
2
votes
3answers
342 views

Linux desktop as a MySQL server?

My sysadmin created an Ubuntu Desktop VM for me to use as a MySQL database server. I am anticipating light use; approx. 10 DB connections max at any given time. We have no plans to ever need the ...
0
votes
2answers
99 views

Cannot install mysql-devel on centos

Everytime I try to run sudo yum install mysql-devel I am met with the following error: Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package ...
0
votes
2answers
32 views

Allow mysql user to be used just by specified user

Currently any system user can run: systemuser$ mysql -u mysqluser -p (assuming he knows the password). Is there a way to deny mysql (cli) to use particular mysql user? eg. systemuser$ mysql ...
0
votes
1answer
159 views

MySql Membership provider - Missing or incorrect schema

We have an ASP.NET site running on IIS 7.5 with a MySQL database using the .net connector, the membership/role providers are set in the web.config correctly and they work - but only temporarily. ...
0
votes
1answer
43 views

Password less mysql access to specified user/script only

In addition to this question: Performing root mysql operations in bash scripts I'd like to ask how to limit/allow this action (performing root administrative actions): mysql --local-path=mypath -e ...
0
votes
1answer
171 views

Apache can't connect to remote MySQL, but mysql command line from same server can

Symptoms: I am running CentOS 6. I can connect to the remote MySQL from the command line: mysql -h a.b.c.d -u user -p -D db. Laravel artisan commands run on the local command line can also connect: ...
1
vote
1answer
199 views

Postfix cannot authenticate against SASL

My system is Debian 7 aka Wheezy with postfix, courier, and mysql installed. Courier works well and if I issue testsaslauthd -u user@domain -p password -f /var/spool/postfix/var/run/saslauthd/mux -s ...
0
votes
0answers
24 views

Percona connectivity issue, user cannot connect?

I am trying to authenticate a user in percona but I am seeing the error message below each time I try... 2014-09-29 12:43:37 5028 [Warning] The plugin '0' used to authenticate user 'user@' is not ...
0
votes
0answers
102 views

How to restore a corrupted MySQL master database from a slave database?

I recently discovered that the master db in a setup I'm running became corrupted. The slave was getting all of the data correctly so I have a solid backup. What I'd like to do is use replication to ...
0
votes
0answers
187 views

OsTicket + IIS + mySQL + Extremely slow queries

Background: I am a .net developer, limited php coding knowledge Asking this question because I think it is a php/mysql/version/implementation issue, and not getting real information from the OSticket ...
0
votes
0answers
166 views

Mysql 5.6 not starting with init script (mysql pre-start process terminated with status 1), starts fine manually

I've been fighting with this all morning: On Ubuntu Utopic (same on trusty, upgraded just in case), when I run sudo service mysql start, or sudo start mysql, I get the single error: "mysql pre-start ...
-3
votes
1answer
42 views

Urgent need of help - I changed unsafe inodb_log_file_size mysql parameter and now fails to start

I made a mistake and changed the inodb_log_file_size parameter value in my.cnf without shutting down the mysql first and moving the ib_logfile0 and ib_logfile1 out of directory. Now it fails to start, ...
1
vote
1answer
67 views

MySQL server hangs without reason

I have a server running web site with back-end database MySQL (more specific - 5.5.37-MariaDB, for debian-linux-gnu on x86_64). Sometimes it stops accepting connections and web site scripts report ...
0
votes
1answer
32 views

MySQL via SSL on VPC private subnet

Is an SSL connection recommended when connecting to a MySQL database server via a private subnet? SSL provides encryption but SSL causes a performance hit. The MySQL database server only serves ...
0
votes
2answers
63 views

MySQLD is using 175% of the cpu

On one of the servers, I have mysqld running as slave DB. The CPU usage is 175% at the moment used by mysqld. Here are the results of SHOW PROCESSLIST; ...
0
votes
1answer
177 views

Lost connection to MySQL server during query (5.6.20)

I have a brand new install of MySQL 5.6.20 and now get these messages from my front-end when I am loading up the new database. [Err] 2013 - Lost connection to MySQL server during query [Err] Alter ...
0
votes
0answers
36 views

Querying node information from Foreman is very slow and I'd like to optimize it

I'm trying to set up Rundeck to query Foreman for node information. For example, the curl query: curl -k -u rundeckuser:rundeckpassword "https://foreman/hosts?rundeck=true&format=yaml" takes ...
2
votes
1answer
86 views

Performing root mysql operations in bash scripts

What is a good practice to execute root operations on mysql databases in bash scripts? For example, I want to create new database and grant privileges, I have to use: mysql -u $ROOT -p"$ROOTPASS" -e ...
1
vote
1answer
45 views

pure ftpd auth using crypt sha512

I've installed pure-ftpd-mysql and it works fine with md5 password hashing. This isn't very secure, so I'd like to use crypt with salted sha512, the way I'm using in dovecot. How to set up this in ...
0
votes
1answer
130 views

Wordpress and Apache crashing MySql (CLOSE_WAIT)

Last days mysql server on my vps start crashing, sometimes right after restart. I found that problem in wordpress website. After service mysql start many apache2 processes overload memory and cpu. ...
0
votes
0answers
19 views

Can an Amazon RDS instance serve as master for one schema and act as a read-only slave for another?

We have an Amazon RDS instance in production that caters to db requests for a set of tomcat servers. This is say schema1 on the RDS instance that is constantly accessed. Can we setup the same RDS ...
-1
votes
2answers
201 views

MariaDB 10.x on CentOS 7?

Why there is no MariaDB 10.x RPM for CentOS/RedHat 7? How can I install it? I'm trying to install the most recent stable version on my server, but it seems, that official repo is absent. 5.5 is ...
3
votes
1answer
33 views

MySQL keeps getting “connect” commands 100X per minute

My server was having performance issues, things loading slow, pages not loading, etc so I ran the "top" command after logging in via SSH. I noticed the CPU kept jolting up to 40%, on and off, when ...
0
votes
1answer
35 views

Insanely high mysqld write I/O on SELECT queries

I am struggling to find a reason for my mysql have this much of disk write, it just doesn't make any sense. It it doing mostly of the time SELECT queries, so the only reason I find to it write so much ...
0
votes
0answers
37 views

MySQL cluster data node restarts when its twin fails

Configuration: Server #1: 1 mgm node, 1 data node, 1 sql node Server #2: 1 mgm node, 1 data node, 1 sql node Specification: MySQL Cluster 7.3.6 x86_64 Debian 7.6 x86_64 It's been deployed by ...
0
votes
1answer
38 views

how to find cause of io spike

Everyday at around the same time, the IO usage on the server where our mysql slave goes up to 100%. I have setup a script that takes IO information every five minutes so I can find out why this ...
1
vote
1answer
388 views

MySQL error: “The partition with /var/lib/mysql is too full!” df -h shows otherwise

my rented server is currently saying that mysql is too full when trying to start it when using /etc/init.d/mysql start. However using sudo /etc/init.d/mysql start it works normally. Running df -h ...
-2
votes
1answer
27 views

Ubuntu server crashing frequently

i hope you can help me. i am running an ubuntu 12.04 server which i am using as a web/sql server. the server was running fine for month but now since two weeks the server is crashing almost every ...
1
vote
1answer
77 views

Never ending transaction problems after mysql 5.0->5.6 upgrade

I upgraded our entire backend mysql db from 5.0 to 5.6, including changing a few tables to innodb, and we've been having nothing but problems with never ending transactions since. I still have a ...
0
votes
1answer
55 views

My local MySQL server was temporary down for unknown reasons

My local MySQL server 5.5.38 (on CentOS 6.5) has been temporary down and the mysql log file was filled with this kind of details: This could be because you hit a bug. It is also possible that this ...
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 ...
-2
votes
1answer
3k views

Can't connect to local MySQL server through socket '/var/mysql/mysql.sock [closed]

Recently, I've started getting this error when trying to login to mysql: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I read on another ...
-1
votes
1answer
504 views

my.cnf configuration in mysql 5.6.X [closed]

Server information 64GB RAM Intel(R) Core(TM) i7-3930K CPU @ 3.20GHz Mysql Server version: 5.6.20-log - MySQL Community Server (GPL) I have 20 websites on this server like share hosting my big ...
0
votes
3answers
110 views

Exim won't start - Error loading lookup module mysql.so

I had to change the root password for MySQL on a server. Exim also uses MySQL for users etc. I didn't think Exim/Dovecot used that password, but now things are not working well and I'm pretty sure ...
-1
votes
1answer
1k views

phpMyAdmin displays blank page

I have gone through all links related to a blank page displayed by phpMyAdmin but none of them helped my solve my issue. I have installed phpMyAdmin and deployed it on the Apache server. I have also ...
0
votes
1answer
101 views

Strange CPU spikes with MySQL

On my server (ubuntu 12.04) mysqld started to show some strange CPU spikes. I've logged some of it as a sample: http://pastebin.com/4MwKUVwL The value after the triple dash '---' is the cpu usage ...
0
votes
1answer
49 views

Production server (cluster) configuration

I have a problem, that i'd like to address to you. We are creating an webapp that shows infos and statistics. And we have a problem about how to 'do right' our server configuration The thing is that ...
2
votes
1answer
53 views

MySQL replication slowing master

We are currently running MySQL 5.1 Quick Overview We use 5 web servers ( Apache ) all connected to 1 DB server ( MySQL ) hosted on the cloud. The DB server running on the cloud ( Master ) ...
0
votes
1answer
69 views

RDS very slow and storage incosistencies [closed]

A couple of hours ago one of our AWS EC2 instances spike in CPU usage to 90 - 100%. That server, along with several other production servers, use one main RDS instance for the databases. All server ...
0
votes
1answer
70 views

New nagios/cacti monitoring setup, should I use a dedicated VM?

Currently we have 4 bare metal servers and one small VM server (all running centos6) and I'm looking at setting up monitoring for the Percona MySQL db server and replication slave (bare metal), as ...
0
votes
1answer
29 views

Is there any CLI tool to connect to MySQL server using a URL (mysql://xxx)?

I know how to use mysql -u username -pPASSWD -h hostname -P port databasename to connect but I need a tool that can use the RFC 1738 URL ...
2
votes
2answers
3k views

No mysqld or mysql.server after mariadb-server install

So... likely I'm an idiot, but I'm stuck. I just set up a CentOS 7 on Digial Ocean and I can't seem to get the MariaDB/MySQL server running. Some output [root@hostname ~]# yum list installed |grep ...
0
votes
0answers
22 views

Unable to access MySQL account on Win2008 R2 cluster

I have created a MySQL WFC service on my two-node server, the MySQL server is doing fine until I created an account using the MySQL Workbench of one of the nodes. When I try to connect to the server ...
-2
votes
2answers
166 views

Cannot start MySQL server following upgrade [closed]

Cannot start MySQL server following upgrade I've just upgraded MySQL from 5.1.59 to 5.6.20 (OSX 10.7) and now the MySQL server will not start. In MySQL Workbench (v6.1.7), in the startup/shutdown ...
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
1answer
55 views

WinServer 2008 R2 MySQL cluster service won't start

So I have a two-node failover cluster in WinServer 2008 R2, I also created a generic service which will manage my MySQL5.5 database (the database root is also in a iSCSI storage). When the cluster ...