MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
1answer
20 views

mysqld : multiple tmpdir & balancing

Our 1Tb tempdir can sometimes be completely used by mysqld, resulting in disk-full and query errors. This can be due to lots of mid-size queries, or couple of very big queries. We have a 5Tb raid ...
1
vote
1answer
146 views

MySQL high CPU/query time usage during concurrent inserts

I just setup a new server for a large MySQL database of about 70GB. This database is regularly written by automatic processes that must write as quickly as they can their data. Before we had a server ...
0
votes
0answers
21 views

Data usage increase although remove data in table MySQL Cluster

I try to test my MySQL cluster system. I add data to a table and use command ndb_mgm all report memoryusage. The data usage in data node increases. When I remove all data in the table and use command ...
0
votes
0answers
50 views

php-mysqli extension fails as compilation

When I am trying to build the latest php5-mysqli port I get the following errors back: cd /usr/ports/databases/php5-mysqli && make MAKE_JOBS_UNSAFE=yes install clean ...
-1
votes
2answers
57 views

repeated mysql queries change execution time

I noticed that when I execute a query more than one time consecutively on my mysql machine, the execution time drops and changes significantly (40/50%) after the first execution, and that WITHOUT ...
0
votes
1answer
80 views

PHPMyAdmin forces to use ut8mb4 as default collation

After to updated PHPMyAdmin the default collation has been set to utf8mb4_general_ci instead the old default collation utf8_general_ci. As I do not have any need to use utf8mb4_general_ci I would like ...
0
votes
1answer
21 views

MySQL: Grant permissions for `start transaction` and “surroundings”

I have created a sample user with the following request: grant select, insert, update, delete on db.* to user@localhost identified by 'pass'; but that user does also need permission to use start ...
0
votes
1answer
30 views

Logging connections in MySQL doesn't work

I am trying to log all the connection attempts in my MySQL server (don't worry, it's a low traffic one). Here is my my.cnf file: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock ...
0
votes
2answers
174 views

MySQL PID file missing [closed]

Some time ago MySQL stopped working on my server and I've only just got round to looking into it. When I try and start it with service mysqld start I get Starting MySQL.The server quit without ...
0
votes
1answer
31 views

MySQL replication slave got 2147483647 (INT32_MAX) in a column for time stamp

I have set up two replication slaves, one on CentOS(x86_64 5.1.37), the other on Ubuntu LTS(x86_64 mysql 5.5.38). Both of them seem to replicate most of the Master db (CentOS i686, mysql 5.5.37) ...
0
votes
1answer
36 views

Send e-mail upon user login for MySQL

I know that I can use ONESEC to e-mail myself if someone logs into my server but I was wondering if I could do the same thing if someone logs into a specific user for MySQL. My GoogleFu seems to be ...
-1
votes
2answers
35 views

linux MTA email forwarding with DB Lookup

I need to setup a service that will receive an email such a $uniqueID@domain.com lookup that uniqueID in a MySQL database for an email address then forward the incoming email to the email address ...
0
votes
2answers
25 views

Disallowing interactive login for specific mysql users

I want to create some mysql users for different web sites but disallow interactive connections for them. If a evil-user get the mysql login credentials of a website, creating a conexion from ...
0
votes
0answers
42 views

MariaDB mysqldump fails on tables with underscores

mysqldump -u root -pvagrant --skip-lock-tables --no-data databasename is giving me this: mysqldump: Couldn't execute 'show table status like 'view\_admin\_mu\_list\_view'': SELECT command denied to ...
1
vote
1answer
28 views

Managing multiple servers with database and apache [closed]

We are building a relatively simple setup, with multiple apache servers potentially behind a loadbalancer, with a single database server to serve a particular website that will in effect need to be ...
0
votes
1answer
81 views

MySQL CREATE command denied to user

I have a script system that refuse to be installed because of error that breaks installation. I tryied to import the data by import the data via .sql file at phpmyadmin and it still cant import. ...
1
vote
1answer
89 views

Postfix/Dovecot configuration with virtual users

I followed this tutorial for configuring Postfix + Dovecot with virtual users (in a mysql database) : ...
0
votes
1answer
45 views

Most reliable MariaDB to Postgres dump method

I am in the process of migrating an app to another server, and will need to migrate the database contents from MariaDB to Postgresql. Most documentation indicates that the following format should ...
1
vote
1answer
89 views

Keepalived load balancing MySQL. Backup server time-out

Dear beloved people at ServerFault. I'm trying (and failing) to setup a load balanced MySQL server array. Please enlighten me, show me the error in my ways. Current setup: two MySQL servers with ...
0
votes
1answer
53 views

postfix/dovecot/mysql not sending/getting emails [duplicate]

I understand that I posted this before, however I left out some very important details which apparently made a lot of people less likely to answer, here's a more detailed version. My ...
0
votes
0answers
45 views

Amazon EC2 not responding on port 80 and mysqld will not start

An EC2 instance running Apache 2.2.5 on CentOS 6.4 appeared to be fine up until September 29. That day at 7:49 the Value in CloudWatch was 42, at 7:59 it was in the low 100,000's, the last Value ...
0
votes
1answer
44 views

Mysql - best setup for 4 replication databases and another standalone

we would like to merge on one server 2 mysql instances coming from 2 different server : 4 databases on the first instance, which is a replication slave, which are replicated from a master 1 database ...
1
vote
1answer
165 views

Upgrade mysql 5.5.40 to 5.6 on centos 6.4

I can't find a repo to add to my repolist that has an update for mysql 5.6. Does anyone know how to do this? I tried this [link] but it broke everything. I was getting a mysql_connect() undefined ...
0
votes
0answers
45 views

How to link my local MySQL DB to remote MySQL on the internet

Please I need some suggestions or advice on how to how to link my local MySQL DB to remote MySQL on the internet. I developed a Conference Management System for my client and they want us to setup 2 ...
0
votes
1answer
79 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
87 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
32 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
108 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
341 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
66 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
30 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
139 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
42 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
131 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
123 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
21 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
85 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
146 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
130 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
41 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
56 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
29 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
61 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
140 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
25 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
75 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
39 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
104 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
160 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 ...