MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

1
vote
0answers
5 views

ERROR 2003 (HY000): Can't connect to MySQL on server 'myhost.com' (101)

When trying to connect to my mysql server remotely with: ~$ mysql -u user -p -h myhost.com The result is (after asking for password): ERROR 2003 (HY000): Can't connect to MySQL server on ...
0
votes
0answers
11 views

Automate backing up of MySQL DB on Godaddy Windows account [migrated]

Does anyone know of a good way to set up an automated backup of our MySQL DB on a Godaddy Windows account? Most articles I have found talk about using mysqldump. But I can't figure out how to do ...
2
votes
0answers
10 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 ...
0
votes
0answers
11 views

Percona cluster signal 11

We have a percona cluster that is randomly getting signal 11's on different cluster nodes. I've exhausted everthing I know. Here's the .err file with the signal 11. We're running Server version: ...
0
votes
0answers
4 views

mariadb / mysql wont change table_cache / open_table_cache [migrated]

I've configured my i7 64gb ssd server with centos7 with the following my.cnf [mysqld] key_buffer = 12M max_allowed_packet = 16M table_cache = 4096 table_open_cache = 4096 table_definition_cache = ...
0
votes
0answers
29 views

Blocking Low-bandwith layer 7 attack [on hold]

Lately I have been experencing Layer 7 bandwith attacks on my server running centos 6.6 16 gigs of ram. These attacks cause mysql tro skyrocket to 500-600% The requests are as followed. ...
0
votes
0answers
15 views

Path to mysqldump on Azure VM?

I've set up a VM running MySQL Server (Community Edition) on Azure. My CMS (Perch) has a backup module, which uses mysqldump to back up the database. However, the default options don't seem to be ...
0
votes
1answer
28 views

Server with multiple replicate=do-db entries

I have a server that someone has setup which are acting as a master-master on both servers. Since they have been configured as both master on the same database, changes in one end has caused all sorts ...
0
votes
1answer
21 views

Provisioning MySQL remote users

Seeking advise on optimal way to provision remote MySQL user permissions, when the source of connections is a large network block. Since the MySQL server may have DNS lookups disabled for performance ...
-1
votes
2answers
35 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
25 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 ...
3
votes
1answer
30 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 ...
1
vote
1answer
23 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
votes
1answer
36 views

How restore mysql database? [closed]

How can we restore mysql database with different name from mysqldump file. I dont't want to open dump file and edit it. Any other better methods?How restore mysql database?
0
votes
2answers
57 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
37 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
0answers
46 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 ...
5
votes
1answer
169 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
27 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 ...
0
votes
1answer
155 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 ...
0
votes
1answer
45 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
0answers
24 views

Hardware requirements for 500 - 2000 concurrent connections to LAMP+ [duplicate]

A hint where to look, where to start... Software used for real time auction web project Apache 2.4.6 (forked) +(mod_pagespeed) PHP FastCGI v5.4.16 PHP-APC cache MemcacheD +shared sessions with PHP ...
-4
votes
2answers
47 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 ...
-1
votes
1answer
20 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
14 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? ...
1
vote
0answers
10 views

Leave only the Server and Client files in a mysql installed manually on windows

I am a php developer and I'm setting up a portable development environment on windows 7. I downloaded the version of mysql "NonInstall Zip Archive" and is working properly. However, I see that ...
-4
votes
1answer
31 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 ...
-1
votes
0answers
31 views

After moving mysqld from /var/lib/mysql I can't connect to the .sock file

I wanted to move my mysqld (installed via rpm) to a different volume to make server recovery easier in case of failure. After 1) stopping mysqld 2) copying all the files over to the new location ...
1
vote
1answer
24 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
0answers
28 views

MySQL replication ignoring BINLOG statements for certain table

I'm trying to make MySQL Replication work, but my slave is constantly stopping because of constraint fails. This errors occurs because the replication of one particular table is not working. If I ...
0
votes
2answers
37 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 ...
1
vote
1answer
22 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
26 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 ...
0
votes
0answers
18 views

Grant All privileges on all databases to a Mysql user [migrated]

I try to give a user all the privileges on all the databases : mysql> GRANT ALL ON "." TO 'AppBD'@'192.168.1.5' IDENTIFIED BY 'admin'; ERROR 1064 (42000): You have an error in your SQL syntax; ...
1
vote
0answers
22 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
30 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 ...
-1
votes
0answers
10 views

mysql server 6 + xampp [duplicate]

At work the computer I'm using was set with Mysql Server 6, now I need to use XAMPP, but XAMPP's MySQL service it's not executed, in the log tells me that there is a conflict with the MySQL Server's ...
-1
votes
2answers
23 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 ...
0
votes
0answers
9 views

Can’t load file into MySQL, even though local_infile is set

I’m trying to import a file into a MySQL database. I’ve added local_infile to my my.cnf file, and restarted the mysql service. In my PHP script, if I run phpinfo() then I can see ...
1
vote
1answer
24 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 ...
0
votes
2answers
40 views

Dedicated server stalls at 80 req/s - is MaxRequestWorkers the cause?

I have a physical Ubuntu server (see some of the specs here), with Apache 2.4.7, PHP 5.5.9, mysql 14.14, mysqlite and Yii framework 1.16 installed. The server performs amazingly at first, but ...
0
votes
0answers
19 views

Cannot start mysql on vagrant CentOS machine

I am getting the following problem doing "vagrant up" ==> default: [2015-03-10T16:31:03-04:00] INFO: template[default :start /etc/init.d/mysql-default] mode changed to 755 ==> default: ...
0
votes
2answers
44 views

elasticsearch-river-jdbc inserting duplicate record in mysql db

Sorry I am newbie to Elasticsearch and I am using elasticsearch-river-jdbc to connect to myql database,everything is working fine except for the fact that everytime it run as per schedule its ...
1
vote
1answer
69 views

Server crashes with “huge task timeout”

First things first, I've read a lot about the "huge task timeout" kernel panic and know that this often happens if the server is out of resources. Error messages which appear only in the VNC console ...
-1
votes
1answer
42 views

Using multiple IPs on one machine for web and game server

We are looking to host a game server. The game we are going to be setting up a server for is subject to DDoS from other servers, players, etc. Many other server and administrators have pointed out ...
1
vote
1answer
26 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
0answers
58 views

freebsd cannot start mysql for the first time

I am having the same issue as this person serverfault link but the solution completely does not work for me. I cannot start mysql5.5 for the very first time. At first start of mysql with cd ...
0
votes
1answer
12 views

innodb files in wrong directory

I have created a database called TEST with innodb tables. When I look in the /var/lib/mysql/TEST directory I see a .frm file for each table. However, there are no .ibd files in that directory. The ...
0
votes
0answers
30 views

Can't connect Windows Azure VM with MySQL On-premise

I have a VM on Windows Azure with Windows 2008 R2, and I'm trying to open a connection to an on-premise MySQL database hosted on another network. We cleared the VM's public IP (the one displayed on ...
-1
votes
2answers
22 views

MySQL configurations are not saved after restarting windows server machine

I have a PHP application hosted on a windows server 2008 R2 machine. I had a problem with strict mode in MySQL and solved it by disabling the strict mode using the following command set ...