MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

-1
votes
2answers
49 views

Who is responsible for performing the query EC2 or RDS?

Normally I run my own MySQL server (within EC2), but I was looking for the possibility's of RDS ( https://aws.amazon.com/rds/ ). As I understand RDS is (directly after setup) optimized for ...
0
votes
1answer
36 views

ColdFusion Server slow connection to dedicated database server?

We had our database and web server on the same box. For performance reasons, we are now off loading the database to a dedicated server. When updating the CFDSNs to the new server, the verification ...
2
votes
3answers
94 views

Innodb statistics

We're running InnoDB as a MySQL engine and using phpMyadmin to administer our database. Under Status → Query statistics, phpMyadmin gives us the following: We would like to know where these figures ...
2
votes
2answers
4k views

MySQL: how to enable Slow Query Log?

Can you give me an example on how to enable MySQL's slow query log? According to the doc: As of MySQL 5.1.29, use --slow_query_log[={0|1}] to enable or disable the slow query log, and optionally ...
3
votes
1answer
52 views

searching for the correct way to compile postfix

I am experiencing issues while compiling latest version of postfix from source code. At the moment I'm trying to compile version 3 because Debian 7 and latest Ubuntu 14,10 (version 2,9 and 2,11 for ...
6
votes
3answers
8k views

Simpler way to convert all tables from InnoDB to MyISAM

Previously, I use this: USE dbname; ALTER TABLE tablename ENGINE=MYISAM; I'm looking for simpler way to convert all tables in a database, rather than writing every table name one by one
1
vote
1answer
30 views

Best method to ensure Mysql master slave replication is consistent?

I am running a master slave replication system on AWS EC2 systems over ssh. However I came across a couple of best practice articles indicating that even this might allow inconsistencies to creep into ...
1
vote
2answers
2k views

InnoDB recovery

My MySQL server run to crash due to (page file write error). I did a disk diagnosis but no errors found. I restarted MySQL server. It scanned the bin log like for 1-2 hours and recorded log as below: ...
0
votes
2answers
5k views

MySQL server crashes InnoDB

Today we got some DB crash. The DB is InnoDB. At firstin log: 120404 10:57:40 InnoDB: ERROR: the age of the last checkpoint is 9433732, InnoDB: which exceeds the log group capacity 9433498. InnoDB: ...
0
votes
2answers
1k views

MySQL 5.5.27 crashes randomly on centOS 5

I am using godaddy's dedicate server to host my web application, it's centOS 5(I have no idea why they are still using this.), I installed mysql in that server, everything was running OK since one ...
-2
votes
2answers
58 views

How to work on 2 MySQL databases at the same time using PHPMyAdmin through Plesk? [closed]

I am trying to open 2 instances of PHPMyAdmin by clicking on the "manage database" link in Plesk. But the challenge is I seem to be only allowed to work on 1 database at a time as when I try and open ...
0
votes
1answer
42 views

MySQL spends too much time cleaning tmp tables

I'm running some Django migrations on an AWS RDS MySQL instance. My team has tested the migrations very thoroughly and they ran fine (even taking less than 30 minutes when run on our laptops against a ...
1
vote
0answers
73 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 ...
0
votes
2answers
75 views

mysqldump connects as different user from cron and from command line

I had a bug in a backup script running as a cron job which I found and corrected, but I'm still puzzled by the fact that this bug did not show up when the script was started from the command line. The ...
0
votes
1answer
56 views

mysql grant select to ONE table on ALL database

I have many tables with the same table structure. I want to create a user which can access one table in all of those databases. We are adding new databases frequently, so a wildcard would be ...
2
votes
1answer
4k views

MySQL table does not exist

I am getting following error in err file. 110803 6:51:26 InnoDB: Error: table `ims`.`temp_discoveryjobdetails` already exists in InnoDB internal InnoDB: data dictionary. Have you deleted the .frm ...
0
votes
1answer
111 views

Postfix fails to install in MySQL 5.7

I am trying to install postfix in my server with Centos7 MySQL 5.7 Unfortunately it seems to be they are incompatible. Why? Here the error message. Is there a way around this ? [root@doc ~]# ...
1
vote
1answer
411 views

Nginx + HHVM + MariaDB + WordPress install -> Error establishing a database connection

I'm setting up a VPS for a WordPress blog. I'm using Ubuntu 14.04 LTS 64 bits and then I've installed Nginx 1.7.8, HHVM 3.6.0, MariaDB (don't remember the version). Finally I've downloaded WordPress ...
5
votes
1answer
197 views

Nagios alert based on scheduled MySQL queries results

I have installed Nagios 4.0 on my Ubuntu 14.0 and i want a plugin to alert me based on daily scheduled MySql queries .. if the result of ( select count(*) from tableName > 10 ) raise a critical ...
0
votes
0answers
48 views

CentOS 7 Cluster with load balancer

I'm trying to understand how clustering works in CentOS 7. I'm not a cluster expert!!! What I'm trying to do is to have three clustered services: httpd, mariadb (mysql) and postgresql. I've managed ...
-1
votes
2answers
32 views

How to avoid 'too many connection' error in MySQL

It often happens that when trying to load the data from the database i`m getting an exception 'To many connection'. I do not know the internal features of the database work, so i do not understand ...
-4
votes
2answers
54 views

How to avoid mysql query hang if the disk is full

The disk is full and my query hangs on the mysql query. From the mysql manual: When a disk-full condition occurs, MySQL does the following: It checks once every minute to see whether there ...
0
votes
1answer
117 views

connect to db instance in private VPC subnet with MySQL Workbench

How do I connect to an AWS (or other) instance in a private subnet in a VPC using MySQL Workbench ? My arrangement is a typical aws Scenario 2 : I can: - SSH into my NAT instance located in my VPC ...
2
votes
4answers
2k views

How to migrate from regular MySQL to Percona Server in production?

I'm running MySQL 5.0 in production on CentOS. How do I migrate to Percona Server 5.1 safely? The documentation of Percona Server doesn't include any information on migrating. Any help is greatly ...
-4
votes
1answer
40 views

mysql hot add memory

Is it possible for currently running jobs in MySQL to utilize memory that's been hot added? It looks like when memory is hot added to the VM the currently running jobs are not utilizing the additional ...
38
votes
11answers
34k views

`mysql_upgrade` is failing with no real reason given

I'm upgrading from MySQL 5.1 to 5.5, running mysql_upgrade and getting this output: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed ...
2
votes
2answers
300 views

No changes made but MySQL InnoDB overloading CPU

I haven't changed any scripts or settings what so ever. Now I have CPU load at least 4 times higher. Mysqld is taking around 360 %CPU according to TOP. It's Debian, I'm running some MyISAM tables but ...
-1
votes
1answer
23 views

Synchronize Staging Server and Live Server [closed]

We have staging and live server at our office. Where Live code and DB changes are far more advanced than staging one.This application developed under php and DB is mysql. Earlier we used to work in ...
0
votes
1answer
57 views

How to monitor MariaDB Galera cluster status from command line

I know to check the Galera cluster status, the command that should be used after login to the mysql client is: SHOW STATUS LIKE 'wsrep%'; but, how to get the output directly from the command line? ...
3
votes
4answers
184 views

Data consistency with RAID 5 and BBWC

I have a few questions about RAID 5, BBWC (Battery Backed Write Cache), filesystem (ext3) and optionally mysql. I have a hypothesis and I ask Server Fault community to validate or not this one: The ...
2
votes
1answer
663 views

What permissions do I need to do a mysqlcheck on all tables?

I'm trying to run mysqlcheck, and I want to run it on all tables, so I'm passing it the -A option. However it's silently skipping all tables that it's doesn't have permission to view. Is there some ...
0
votes
2answers
321 views

MySQL Database Problems - Growing too quick, Performance

I have some problems with my database setup: The MySQL Database is written to every few seconds and it grows in size very quickly. My disk space is limited though, so I have to work around that. ...
0
votes
2answers
847 views

ERROR 1130 (HY000): Host 'host' is not allowed to connect to this MySQL server, only on slave

So I have a master and a slave in a mysql cluster, the syntonization works as it should however I am not able to connect to the slave from any host except from the server it self. I have no problems ...
2
votes
3answers
16k views

MySQL + phpMyAdmin: The server is not responding (or the local MySQL server's socket is not correctly configured) [closed]

My phpmyadmin works only when I'm connected to the internet.(it even works if i'm just connected to Lan) otherwise, it gives below error: Error MySQL said: #2002 - The server is not responding ...
16
votes
5answers
3k views

How do you choose a MySQL database engine

In particular, how do you choose between MyISAM and InnoDB, when neither is missing a required feature (e.g. you don't need foreign keys). Does it always come down to trying both and measuring? Or ...
2
votes
4answers
2k views

Configure options MySQL server was compiled with?

I have MySQL server 5.0.67 running on a Linux machine. How can I know what configure options were used to compile it?? I'm interested in the option --with-mysqld-ldflags in order to know whether ...
1
vote
2answers
1k views

troubleshooting out of memory error messages from mysql

we have a web application (racktables) that's giving us grief on our production box. whenever users try to run a search, it gives the following error: Pdo exception: PDOException SQLSTATE[HY000]: ...
21
votes
3answers
13k views

Is there a MySQL equivalent of SHOW CREATE TABLE in postgres?

Is there a MySQL equivalent of SHOW CREATE TABLE in postgres? Is this possible? If not what is the next best solution? I need the statement because I use it to create the table on an remote server ...
2
votes
1answer
3k views

ERROR 1 (HY000): Can't create/write to file (Error code :13)

Iam trying to create a mysql table in linux with changing data directory to another location. The selected forlder having full permission. But I got an error 'Can't create/write to file'. I googled ...
1
vote
1answer
48 views

Postfix + mysql: virtual_users combined with a catch-all in virtual_aliases

I have a Postfix (and Dovecot) server running, using MySQL to define the domain names, users and aliases. This is all running fine, but now I want to add a catch-all to a domain where I already have ...
0
votes
2answers
83 views

Syntax error when setting up master-master replication in MySQL

So I've set up my initial master-slave replication pair on two different MySQL servers. That part is working great. So all I have to do is set up the first master as a slave and set up the first slave ...
2
votes
4answers
171 views

How risky is it to upgrade MySQL from version X to Y? [closed]

I've got a MySQL server running version X (X=5.0.22) and for misc. reasons the underlying hardware needs to be upgraded. Give that this is going to be done, how risky would it be to also upgrade the ...
1
vote
1answer
27 views

How to implement table security without SUPER privilege?

A MAJOR provider of cloud-based MySQL does not grant the SUPER privilege to the master user. The provider is Amazon RDS, but my question isn't about Amazon RDS specifically, it's for the general case ...
1
vote
1answer
32 views

Is it possible to safely edit mysql-bin.index file while mysql server is running

I changed location of mysql bin-log files. I copied them so mysql started fine, because they where in both locations, but then removed them from old location. I forget about correcting the path in ...
-1
votes
2answers
3k views

Can't connect to MySQL server error (61)

I use Sequel Pro as a remote MySQL client. Today I tried to connect to my server with these settings: I get this error message when I click connect: I don't understand how only a few days ago ...
9
votes
2answers
307 views

My server setup for a heavily used API

I will soon be buying a bunch of servers for an application that I am about to launch but I have concerns about my setup. I appreciate any feedback I get. I have an application which will make use of ...
1
vote
1answer
40 views

MySQL - Unable to enable binary logging

I'm trying to enable binary logging so that I can set up master-slave replication between two servers. I'm working with an existing server with lots of data and I'm trying to dump the data with the ...
0
votes
0answers
31 views

Mysql reports “unknown variable pass” after upgrading from 5.5.41 -> 5.7.5 on Debian

We have the following problem after upgrading MySQL 5.5.41 (pre-installed on our Debian Wheezy LAMP server from Hetzner) to 5.7.5 version (downloaded from mysql.com). After updgrading from the ...
1
vote
0answers
45 views

How to change permission of users in RDS?

We have created a MySQL RDS instance on AWS called "lolbob" and while dumping our data over port 3306 using the user that was created during instance creation (also called "lolbob") it fails because ...
-1
votes
1answer
78 views

MySQL gives error “SSL connection error: Unable to get private key”

I keep getting the errors "SSL connection error: Unable to get private key" when using mysql client. In order to get it to work, I have change the permission 444. However, I would like to lock it ...