MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

1
vote
1answer
41 views

MySQL Replication Logs Filling Partition

We have MySQL replication setup from site-to-site. The slave is just a backup used for reporting etc(No write). Everything is going well as far as I can tell. However, the server is quickly running ...
1
vote
0answers
136 views

R1Soft MySQL Failed to perform discovery on database instance

I am using R1Soft (5.8.1) for file backups on a few servers and have tonight been trying to setup a MySQL backup - I installed the driver etc and am setting up the policy but am getting an error. ...
0
votes
2answers
235 views

Tunnel Connection Error with Mysql Workbench (Host key does not match)

I have an issue with Mysql Workbench which is probably a bug. I'm using EC2 with elastic IPs. I changed my server, but kept my keypair and IP the same. So it should connect as usual via SSH tunnel. ...
0
votes
3answers
944 views

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

I've developed a website on the Silverstripe framework and deployed this to a digital ocean server using centos (7.0.1406) , mariadb (10.0.14) and apache (2.4.6). I'm somewhat of a novice when it ...
0
votes
1answer
36 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 ...
-1
votes
1answer
92 views

Connecting Database Error using Pentaho Metadata Editor

Error connecting to database [SampleData2] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class ...
-1
votes
1answer
58 views

Importing mysql dump from another host, what to keep on the current one?

I will be importing a MySQL dump from another host with lots of DBs in it to the new server I just set up with VestaCP. Since that seems to overwrite everything on the current one should I keep the ...
1
vote
0answers
47 views

Rsyslog won't monitor mysql-slow.log when written to by mysql

I'm going mad. I'm trying to get rsyslog to send log files to logentries.com. This works perfectly until I try to log mysql-slow.log. The config is pretty simple module(load="imfile" ...
0
votes
0answers
195 views

Configuring SSL connection to RDS using mysql workbench

I connected to my RDS db using MySQL Workbench. However, SSL is not active on the connection. When I force SSL, it fails. Config is default. To enable SSL configuration, Mysql Workbench asks for the ...
-1
votes
1answer
126 views

How to release the physical and virtual memory used from the mysql server? [closed]

Several php scripts are executed from cron on my CentOS 6.5, every php script contain database requests. Depending on the php object size and type the database requests can allocate too much memory. ...
1
vote
1answer
20 views

WebServer - moving MySQL to another server on LAN for gaining more processing power?

I have website with high traffic hosted on dedicated machine. This machine running out of resources. Will moving MySQL database to another dedicated machine on LAN give more resources to website ...
-1
votes
1answer
42 views

Correct packages to install LAMP on ubuntu

I have read some tutorials about install LAMP and I have seen that they install differents packages for MySQL and PHP. For example to install MySQL: 1. mysql-server 2. mysql-server ...
0
votes
1answer
45 views

mySQL issue at installation

I have great trouble with mySQL installation. The error message in log (/var/log/debug) is: Nov 20 11:17:41 gotfarm1 /etc/init.d/mysql[11880]: 0 processes alive and '/usr/bin/mysqladmin ...
-4
votes
1answer
53 views

Guidance for mysql 5.6 install on Ubuntu 14.04 [closed]

I have followed the instructions at http://dev.mysql.com/doc/refman/5.6/en/linux-installation-debian.html to a T twice now and twice it appears it hasn't worked. There is no my.cnf under /etc, there ...
0
votes
1answer
14 views

Minimizing Downtime With Upgrades For 3rd Party Products

I am currently maintaining a Review Board server (https://www.reviewboard.org/) and one of the big pain points is scheduling upgrades. Currently the process is: Take the server down and send all ...
0
votes
1answer
49 views

MySQL - Why are there three root users with different hosts? [duplicate]

I'd love to know why when you first install MySQL on a server there are three root users entered into the users table each with different host addresses. One with localhost one with 127.0.0.1 and one ...
1
vote
0answers
253 views

Error missing systemd on AWS server

I cant seem to figure out how to install systemd. I am attempting to upgrade mysql server on AWS from 5.5 to 5.6. I am getting the following error when trying to install- "Requires: systemd" Any ...
0
votes
1answer
44 views

Set MySQL innodb buffer pool size on IIS7

I am using VPS, Windows 2008 r2, IIS7, MYSQL 5.1.73, Hardward Config: Ram 2GB , Hardisk 40GB On this VPS only 1 .NET application is running. Application is currently using by only 5 users. I found ...
0
votes
0answers
109 views

Installing mysqludf library on CentOS x64

I've been googling a lot about the problem that I have trying to install MySQL library. I've downloaded library files from https://github.com/mysqludf/lib_mysqludf_sys and placed it on digitalocean ...
-2
votes
2answers
45 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
41 views

Connecting to mysql with SUPER user when reached Too many connections

The documentation says that: mysqld actually permits max_connections+1 clients to connect. The extra connection is reserved for use by accounts that have the SUPER privilege ...
0
votes
0answers
51 views

Bottle neck of nginx?

I'm using nginx as a load balancer on amazon ec2 m3.large instance. This load balancer will receive loads from a load generator and distributed them to the 3 instance with mysql database serves as ...
3
votes
3answers
157 views

server's memory taken up almost to 8GB

Lately, our server face problem with the memory. Started from few weeks ago, our server was loading very slow. Accessing emails and websites were really take too long. Then we asked the server ...
0
votes
1answer
126 views

Remote Connections Mysql Ubuntu - bind address failed

I am trying to configure my server to allow remote connections. From what I understand I need to uncomment bind-address 127.0.0.1 in the my.cnf file, then restart mysql. That hasn't worked. I have ...
3
votes
1answer
127 views

High CPU on MySql Fusion-io server

I've just finished reading this old Q&A which had some really good detailed information on a similar setup to ours, though unfortunately our problem (now) is not with replication. MySQL ...
1
vote
0answers
150 views

mysqld shuts down every 10 minutes

I have a very odd problem: mysqld shuts down every 10 minutes, without any errors, just like some process actually calls "shutdown" on it. I already checked cron, but couldn't find anything there. ...
0
votes
1answer
40 views

How can I log information specific to the “Too many connections error” in mysql

When the Too many connections error is thrown does mysql log that somewhere so later I can see what caused the error? I know I can use commands like "SHOW ENGINE INNODB STATUS" and "SHOW PROCESSLIST" ...
0
votes
1answer
66 views

High Load Website. how to load balancing? [closed]

i have the following problem: i have two servers (intel xeon 3,4 GHZ with 32GB RAM and RAID 10 (4x1TB Enterprise Harddiscs). all servers are installed with vmware esxi 5.5 (free). webserver, ...
0
votes
2answers
367 views

Database password error in Owncloud migrating from SQLite to MySQL/MariaDB

In a Fedora system, I need to convert the Owncloud's SQLite database into a MySQL/MariaDB database I started installing MySQL: # systemctl enable mysqld # systemctl start mysqld $ ...
0
votes
0answers
83 views

MariaDB, ARIA, “File size bigger than expected”

On (only) my production server, whenever I wait a while and restart MariaDB, it completely crashes and burns, e.g.: 141110 16:18:26 [Note] /usr/sbin/mysqld: Shutdown complete 141110 16:18:26 [ERROR] ...
0
votes
1answer
98 views

Nginx Load Balancer Optimum Specs

I have 3 Nginx servers and each of them should handle about 2k users (concurrent connections). In front of them I have Nginx load balancer. That's 4 Virtual machines, sharing same subnet and same ...
1
vote
1answer
53 views

Mysql optimize one table in all databases

I see in the mysqlcheck manual that there's an option for --tables that overrides that databases option, but it isn't well explained. I'm trying to run mysqlcheck -o and I want it to optimize a ...
0
votes
1answer
36 views

Diagnosing where all the queries are coming from

We have an issue where a site on a shared hosting account is going over the allowed query limit per user; that is set at 100k queries/hr. The site shouldn't be generating that amount of queries TBH ...
1
vote
1answer
155 views

MySQL and SSL with -sha256

I'm trying to create some certificate to use with MySQL and everything works fine if I use the sha1 algorithm. If I add the -sha256 switch or -sha384 I can NOT connect to MySQL!. I get this error: ...
-1
votes
2answers
113 views

How to allow all clients access to remote MySQL server? [closed]

So I followed this guide to gain remote access to a MySQL server for my laptop. However, my IP changes and I want to be able to access the server outside my network. How can I allow any client IP ...
0
votes
0answers
45 views

AWS: RDS instance(s) and connecting from remote machine

I'm moving a site over to AWS. It's on the Amazon-flavored Linux distro, using MySQL. I vaguely remember setting it up a couple of months ago (been busy), and allowed access from my elastic IP. I ...
0
votes
1answer
47 views

Percona Server & MySQL server on the same server on different ports

I have MySQL installed from ports, running and listening on port 3306. On the same server I have Percona Server compiled from sources, running and listening on port 3307. Here are the process list ...
0
votes
1answer
55 views

MySQL replication shuts down after rotate of binlog

I have following issue. I had successfull setup of master-replica(row-based). It has been running for 2-3 hours. After bin-log was rotated -> mysql-bin.index file got corrupted on master. Here is ...
0
votes
0answers
47 views

can't run mysql server (Can't create/write to file '/run/mysqld/ibmW5ibS')

I am trying to run mysql and getting the following: 141107 8:48:08 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future ...
0
votes
1answer
39 views

How long should a MySQL connection take to create?

I've got some code connecting to a MySQL database and running a simple query. I have instrumented everything and my timer is showing that the first query returns after 12 milliseconds. The code does ...
0
votes
0answers
43 views

What can CPU and disk usage be at maximum, to handle visitors without causing slowness? [duplicate]

What should these rates be at maximum, to handle visitors without causing slowness? Such as 5mb/s and %20 CPU usage? I might get a lot of visitors soon and I want to be ready beforehand. My current ...
4
votes
2answers
86 views

Multiple websites on multiple servers - seperate mysql or not

I currently have 2 Debian servers (VPS with 4 GB memory) and am hosting a variety of websites of differing importance: some are production sites, while others are demo/staging/test sites. ...
0
votes
1answer
70 views

Pipe multiple files into one tar gz

I'd like to call mysqldump to create multiple backup files and then archive them in one tar.gz. I am following this tutorial on mysqldump part: ...
0
votes
1answer
46 views

Two servers, one clone of another - Port 80 problems

I have currently two servers, which goal is to have redundancy of data. My primary server has Windows Server 2008, which IP is 10.0.0.55 and it's hosting my websites..and everything is working fine. ...
2
votes
1answer
284 views

postfix-mysql package on CentOS 7

I'm following this tutorial on how to install a secure mail server. The guide is for Ubuntu 14.04LTS but I'm doing it with a few modifications for my CentOS 7 system. I am however stuck on ...
1
vote
1answer
242 views

Reset MySQL password doesn't work (can't connect without granted tables) on OSX [closed]

Let me start by saying that I've looked through tons of posts (both here and elsewere on the internet and the article on mysql.com about resetting the admin password) about resetting the mysql ...
1
vote
1answer
283 views

MySQL 5.6.21 on Debian 7.7 — nice is automatically set to 19 several seconds after starting it up; can't figure out why

I'm running MySQL 5.6.21 on an OpenVZ VPS with Debian 7.7. MySQL is installed from the DotDeb repository (full version number is 5.6.21-1~dotdeb.1). Whenever the MySQL server is started or restarted, ...
0
votes
0answers
144 views

MySQL exits without any output

Having a strange issue. Some time ago MySQL exited suddenly when I was creating a table (I think), and I shelved the issue until now. It seems to start, but nothing happens and it exits: 141031 ...
0
votes
1answer
86 views

MySQL crashed and was not able to restart until clearing a table

I have MySQL running on my Ubuntu server and suddenly the MySQL Daemon was down. When trying to restart it, the restart failed due to xxx table is marked as crashed and last (automatic ) repair ...
0
votes
2answers
90 views

Can I restore the “mysql” system database along with another from a mysqldump backup?

Basically, what I did is: mysqldump -uroot -pxxx <some_options> --result-file Backup.sql --databases mysql customappdb Is it sane to later do mysql -uroot -pxxx < Backup.sql Or do I ...