MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
3answers
66 views

Which MySQL Replication should I use? [closed]

I have two servers consider server 1 and server 2. There are many databases on server 1 and few active databases on server 2 as well. Can I setup MySQL replication of server 1 and server 2. If yes, ...
0
votes
1answer
37 views

Which memory settings to use for this MySQL server? [duplicate]

I've been looking in a lot of places so far but I couldn't find any articles about how much memory to allocate to MySQL based on server size. I am about to deploy a website on a relatively small ...
-1
votes
1answer
58 views

mysql stopped and cannot start [closed]

I need some help here (excuse me for my bad English). mysql stopped suddenly after running for several hour. Since then I'm unable to start it. I have also restarted my computer. I get the following ...
1
vote
1answer
53 views

MySQL Access Denied error from nodejs application running on port 4567

I can connect to a mysql database from the command line on centos 6.7: mysql -u root -h 127.0.0.1 --protocol=TCP -p; also: mysql -u root -h localhost --protocol=TCP -p; But if I connect from ...
0
votes
0answers
47 views

mysql table doesn't exist, and how to fix it

2 Notes: This is for a Windows installation. I'm stupid. In the process of cleaning up some stuff that was entirely unrelated, I accidentally deleted the directory /mysql/data/[database], with all ...
0
votes
1answer
55 views

TCP connection not established: Can't Connect to MySQL Server on Remote Connection (10060)

I'm running MySQL 5.6 on a WinServer 2012 system. It works great. The server is on our office intranet, not accessible to the outside world. I normally administer MySQL remotely from my office on my ...
0
votes
0answers
17 views

Centos 6.3 MySQL bind-address error: The server quit without updating PID file

I'm new to Centos and MySQL. I managed to install MySQL 5.6 in CentOS 6.3, when I tried to config for remote server access, I added this line to my.cnf: bind-address = 117.56.166.57 #MySQL server ...
0
votes
1answer
25 views

how to prevent Innob db spiking at 97% Disk I/O Utilization

Our database(InnobDb) is spiking at 99% I/O at random times. After the spike it goes down to about 2% until it spikes agian. There are not some "super" queries that are running in these intervals. We ...
0
votes
2answers
73 views

Backup remote database using mysqldump

I am trying to achieve a quick way to do a backup and download a remote mysql database to my local machine, using just the terminal. The remote server uses ssh keys for authentication. I can do it by ...
1
vote
1answer
102 views

Zabbix: MySQL service monitor - invalid entry when restarting zabbix-agent

Take the following situation: zabbixserver: httpd, mysql-server, zabbix 2.2.11 with local database databaseserver: mysql-server zabbixserver monitors the local mysql database correctly. ...
-2
votes
1answer
67 views

MySQL server crashes at least 2 times a week

I have a client that I do web development for who has a server running Ubuntu 12.x with PHP and MySQL. MY problem is randomly it seems, about 2 times a week I get a call saying the MySQL server is ...
0
votes
1answer
140 views

Zabbix: user parameter mysql.status[*] - setting HOME

When I add the MySQL template to a host in Zabbix, it always reports an issue that the MySQL Service is down, while it is not. I've created a new item for one host (the Zabbix server itself which ...
-1
votes
4answers
118 views

How to mysqldump last 10 rows for EVERY TABLE in a database?

I have seen a lot of articles about "how to mysqldump last 'n' rows from a table in a database". For example: mysqldump --user=superman --password=batman --host=gothamcity.rds.com --where="1=1 ...
1
vote
1answer
33 views

mysql recovery process cannot proceed

I tried to restart mysql database. The database is around 400 GB. The recovery process always gets stuck when it comes to Doing recovery: scanned up to log sequence number 1102472406659. ...
0
votes
0answers
7 views

MySQL Config for 8gb Ram 4 cores Server [duplicate]

I am new to servers and I need to deploy an app. However, I don't have that much background with the needed configurations. I would like to know the advisable mysql config for server with 8 gb ram and ...
0
votes
2answers
104 views

Reduced performance in mysql after upgrade to 5.6.27

Our application was using MySql version 4.0.24 for a long time. We are trying to migrate it to version 5.6.27. But, on testing the performance on 5.6.27, even the simple selects and updates are 30-40% ...
0
votes
0answers
39 views

Error 13 when executing mysqldump to export a database into a cvs file

I would like to export my database into a .csv file but I got a problem when I execute the command to do that: mysqldump -u root -p -t -T~/tesht/ database orders --fields-terminated-by=',' ...
1
vote
1answer
28 views

Finding source of rapid concurrent mysql connections

So we have a large number of scripts running on our server that periodically open up mysql connections and we are generally good about closing the connections as soon as they are done being used. ...
0
votes
0answers
6 views

Unable to enable Barracuda in MySQL 5.5 [duplicate]

How do you enable Barracuda on MySQL 5.5 running on Ubuntu 14? I recently did a fresh install of Ubuntu 14, and after I install mysql-server I tried to enable Barracuda. In Ubuntu 12, all I had to ...
0
votes
1answer
234 views

DBD: Can't load driver file apr_dbd_mysql.so

I am using Apache 2 on a virtual machine running a LAMP stack (mysql version 5.6). When I try to restart the server I am getting this error; DBD: Can't load driver file apr_dbd_mysql.so I have made ...
0
votes
1answer
44 views

Demystifying MySQL Read/Write Ratio on RDS

I am in the process of upgrading/selecting resources for an application powered by a MySQL database running on Amazon RDS. I am considering introducing read replicas and some other strategies to ...
1
vote
2answers
74 views

Installing MySQL on Azure VM (Windows) with attached Data Disk

The Azure docs say: It's a best practice to use one or more separate disks to store a virtual machine's data. It's my understanding that using an attached disk is recommended (at least in ...
1
vote
1answer
48 views

Timeout error on MariaDB in Docker container

I have an ArchLinux installation with Docker and MariaDB running in a container. Now when I try to connect to the database, I get the following euro: MySQL said: Can't connect to MySQL server on ...
0
votes
1answer
39 views

Mysql can't create socket in /tmp but everywhere else

I've setup mysql to create its socket in /tmp/mysql.sock via /etc/mysql/my.conf but after restarting mysql server, the socket file doesn't show up. If I change the socket location to ...
1
vote
0answers
94 views

MySQL overloading CPU at 100%+

My site appears to be getting over 1 million visits today, usually about 20,000 and for me it seems to be near-unresponsive. I've done some sleuthing and optimised Apache, fixed a bug with PHP ...
0
votes
1answer
38 views

Azure Load Balance Virtual Machines in a Subnetwork

If I have 2 subnetworks, 10.0.0.0 for my processes and 11.0.0.0 for databases, how can I load balance the databases internally within the subnetwork such that any of the processes in 10.0.0.0 network ...
1
vote
1answer
52 views

unable to connect to ubuntu on port 3306 (mysql) on rackspace instance

I'm trying to connect to port 3306 on an Ubuntu box and am unable to do so. When I do iptables -L -n | grep 3306 I see this: ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:3306 ...
2
votes
2answers
47 views

HAProxy MySQL check failes permanently and unexpected

I am running HAProxy to spred the load between 3 mysql galera nodes. Unfortunatelly HAProxy shows that node2 is permanently offline while the other nodes work perfectly fine. The config looks just ...
1
vote
3answers
150 views

Cannot connect to mysql server ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

i try to connect to mysql server but it gives me socket issue i have edited my.cnf from /var/lib/mysql/mysql.sock to /home/mysql/mysql.sock Nb: the issue exist before moving mysql db file to the new ...
0
votes
0answers
10 views

MySQL 5.5 performance settings [duplicate]

We are using server this theses parameters: 8 cores CPU 18GB RAM MySQL version 5.5 We would like to get the best performance. The DB is InnoDB type. I would like to know your experience and maybe you ...
1
vote
1answer
27 views

Correct MaxClients config

I have this server: 4 Xeon CPU 4G Ram Centos5+Apache+php+Mysql+Redis+directadmin Right now i have a problem. because of my high range of users, Apache can't handle all of them and puts them in ...
0
votes
0answers
21 views

pymysql connect attemp raises exception

I am trying to connect to a Mysql server on a Ubuntu machine from a Windows machine. The ubuntu machine's mysql server is listening on 0.0.0.0, port 3306, for connection. I have allowed the Windows ...
1
vote
1answer
56 views

MySql on Azure Throwing Pool Connection Timeout Errors

I have 2 Virtual Machines on Azure in the same Virtual Network. One virtual machine runs a NodeJs process which is responsible for MySQL operations. Other virtual machine runs a MySQL instance. I ...
0
votes
1answer
21 views

How to run script with diffrent frequency within a specified time frame?

I have python script which I need to run with diffrent frequency within a specified time frame. I tried to do this through crontab but I do not know how to bite it :/ My time intervals and ...
1
vote
1answer
31 views

MySQL system account unable to write to logs on CentOS 6.7

I have a CentOS 6.7 server with MySQL 5.1.73 installed. I am trying to enable replication which fails because "mysqld_safe" cannot write to "/var/log/mysql/mysql-bin.index"; even though the directory ...
0
votes
1answer
41 views

Rails + MySQL: How to decrease sleep process's time out?

When I run 'show processlist;', then I get so many sleep processes. result of 'show processlists' I set wait_timeout and interactive_timeout to 60 in my.cnf. But, sleep process is not died when time ...
-3
votes
1answer
52 views

Can't login into phpmyadmin but password is correct

I'm trying to login into my phpmyadmin but it keeps redirecting me back to the login page. My username password should still be correct becuase my website is still functioning and I can even login to ...
-1
votes
1answer
36 views

Wifi with multiple password [closed]

I'd like to allow every user have their own specific wifi password that generated from database. It just like star-buck system, customer purchased their food they able to get they specific password. ...
1
vote
2answers
26 views

Using NAS Server as a Database Server, a good option?

Introdution: I have six dedicaded servers with localhost dababases, additional I have rented a NAS server (NFS HA Hybrid) mounted in each dedicaded server under /mnt directory, I want to use this as a ...
0
votes
2answers
241 views

Can't load driver file apr_dbd_mysql.so when restarting Apache

I have an Apache 2.2 version running on a Centos 7.1 machine running a LAMP stack (MySql version 5.6). Apache has been configured to enable the DBD modules, and running a DUMP_MODULES using httpd ...
1
vote
1answer
37 views

Find source of sleeping mysql connections

We have a very large number of PHP scripts running on our server that do a variety of things. Lately I've noticed that when looking in PHPMyAdmin there are a large number of connections to our MySQL ...
0
votes
1answer
41 views

Bottleneck PHP/MySQL server

The server is getting slow on peak hours, and I don't really know how to find out the bottleneck. I can upgrade ram and cpu. Currently 2gb and 2x2.4ghz Linux CENTOS Around 60.000 pageviews per day ...
0
votes
0answers
48 views

RDS MySQL 50% CPU usage spike

We have a big RDS multi-az instance in prod (probably too big for its purpose atm), but it showed 2 spikes for ~50%. rds mysql 50% spikes screenshot Never seen that instance rise above 5% since we ...
0
votes
1answer
30 views

Good optimization for Mysql [duplicate]

i have 24gb RAM and 4 core LEMP server for run one application with Websocket PHP/Mysql but the problem is cpu going over 10-18% for just one user I dont know if server can crash with many users ...
1
vote
2answers
59 views

MySQL is denying access to a legitimate remote user

I have created a user and given that user full access, but MySQL is still denying access to that user - why? Create user: create user 'myUser'@'Mikes-MacBook-Air.local' identified by ...
0
votes
0answers
17 views

If I put two Mysql instances in init.d Centos7 . will both start at boot?

I have two mysql instances in (init.d) all on (rc2.d) (rc3.d) (rc4.d) and (rc5.d). Before, one instance will start on boot but now that I have two instances in (init.d) all configured with different ...
0
votes
1answer
172 views

Postfix & Dovecot: Mailbox Quota Configurations

I'm running Postfix 2.11, Dovecot 2.2.9 and MySQL 5.6.27 under Ubuntu 14.04.3. I've configured Postfix to support virtual mailboxes but it seems that there're some problems with the quota settings. ...
0
votes
0answers
23 views

I have two Mysql servers running on Centos7 . both using different ports. have to manually boot on start.

I need help . mysql on port 3306 and mysql2 on port 3307. I copied my.cnf to my2.cnf I added the following in my2.cnf: datadir=/var/lib/mysql2 port=3307 cp /etc/init.d/mysql /etc/init.d/mysql2 ...
2
votes
3answers
71 views

Can't stop mysql, even after killing the process

On doing /etc/init.d/mysql stop I see the message * Stopping MySQL database server mysqld ...done. ....which seems mysql has stopped. But when i run ps aux | grep -i mysql , i still see ...
2
votes
1answer
133 views

PHP and MYSQL on Amazon EC2 server

I am trying to set up an amazon server to display my php files for a final for one of my classes. I followed this tutorial for setting it up and when I try to run my code I get "Fatal error: Class ...