MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

2
votes
2answers
58 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
267 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
67 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
113 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
23 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
39 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
66 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
82 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
37 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
41 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
536 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
55 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
49 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
64 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
32 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
65 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
21 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
229 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
1answer
42 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
105 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
2answers
267 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 ...
0
votes
1answer
87 views

MariaDB won't start - fails to check integrity

I have a MariaDB installed with brew in my macbook. Worked fine till today. All of a sudden it wound not start: -> mysql.server start Starting MySQL ERROR! also, if I issue mysql -uroot or any ...
0
votes
0answers
28 views

mysqlfailover automatic failover is not enabled

i use mysqlfailover mysqlfailover --master=root@132.232.142.73:3306 --discover-slaves-login=root --slaves=root@12.32.53.2:3306 --report-values=health --verbose --failover-mode=auto ...
0
votes
1answer
42 views

Lock a specific mysql database in shared mysql database

I am trying to migrate a database from one cluster to another cluster. In order to avoid any data loss during the migration, I am trying to lock my database with the WRITE operations. But the lock ...
1
vote
3answers
113 views

mysql stops responding periodically

I run a site (Magento) on a Ubuntu 14.04.3 server running on a 32xCPU VMWare VPS. When it is under heavy load, it typically receives 20-25 requests/second. In magento there is a specific UPDATE query ...
1
vote
2answers
74 views

Configure MySQL server to minimize disk usage

I have a Raspberry PI computer with some measurement device and a script that takes a measurement every five minutes and stores the result in MySQL database. I have configured MySQL server to keep the ...
0
votes
2answers
34 views

mysql client connect to nginx error 10060

i use nginx for mysql the http { include /etc/nginx/mime.types; default_type application/octet-stream; log_format main '$remote_addr - $remote_user [$time_local] "$request" ' ...
1
vote
1answer
49 views

mysqlimport file not found error in Windows but exists a file

I have a problem with (Oh, I am using Windows 7, MariaDB 10.1.7) mysqlimport -u root -p --fields-terminated-by="," --local db_name textfile.csv; which founds an ERROR 29, FILE ...
2
votes
1answer
56 views

Empty space in MySql database

Forgive me if I'm not using the appropriate vocabulary. I'm planning on implementing a MySQL database with a PHP front end so I can enter work order details and files (screengrabs, ZIPs, etc.) into ...
1
vote
0answers
61 views

MySQL persistent tmpdir on slave: use tmpdir or slave_load_tmpdir only?

While setting up a replicated MySQL database I looked at the manual about tmpdir and was somewhat confused about the two variables tmpdir and slave_load_tmpdir. I know the slave needs some data to be ...
1
vote
0answers
204 views

MYSQL DB not starting

I have VPS where I run apache and mysql and since yesterday I can't launch the mysql server anymore: sudo service mysql start start: Job failed to start output of error.log at ...
-2
votes
1answer
40 views

mysql repair myisam table give a error 127

My server have an hdd fault. Due to this one table of DB was corrupted. I've tried to use myisamchk -r /path/to/table_name.MYI to repair it. After executing i have a message myisamchk: error: 127 for ...
0
votes
1answer
55 views

mysql GTID replication

i try to use GTID and backdump mysql -u root -h xx.xxx.xxx.xx -p < 2015-10-30_all_database.sql Enter password: ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when ...
-1
votes
1answer
67 views

CentOS7 mysqlserver download error

[root@localhost bin]# rpm -qa httpd httpd-2.4.6-31.el7.centos.x86_64 [root@localhost bin]# rpm -qa php php-5.4.16-36.el7_1.x86_64 [root@localhost bin]# rpm -qa mysql [root@localhost bin]# I am a ...
1
vote
2answers
59 views

Unable to Locate MySQL Server

So there is this ancient legacy server running MySQL somewhere in our office. I can connect remotely using: # mysql -u someuser -p -h ancientserver.domain.com I see the tables I expect. However, ...
0
votes
1answer
61 views

we have MySQL Enterprise Server - Advanced Edition (Commercial) installed on Centos7

I always have to start it manually on boot everything the server is down and boots up. Someone help me set it to start on boot with systemctl enable [root@localhost ~]# systemctl enable mysqld ...
0
votes
0answers
89 views

Setting up phpMyAdmin on a 1&1 Managed Dedicated Server

I'm trying to set up phpMyAdmin on my Managed Dedi Server from 1&1 so that I don't have to log into my 1&1 Account to access the databases / so that my developers don't have to know my account ...
2
votes
3answers
417 views

CentOS installing MySQL 5.6.26

My server is CentOS 6.7 x86_64. I installed mysql by yum -y install mysql-server. But this install v5.1.73. Installed: mysql-server.x86_64 0:5.1.73-5.el6_6 Dependency Installed: mysql.x86_64 ...
0
votes
1answer
121 views

MySQL creates huge files every night, bringing down the server

I have an Ubuntu 12.04 LEMP server with shop app ontop, running MySQL 5.5 as DB (currently since this problem started I've already switched to Percona with no success). So, current facts: every night ...
-2
votes
2answers
156 views

Is it safe to reboot Linux every night? [Being attacked] [closed]

Is it safe to use reboot command to reboot VPS every night? I'm under attack everyday for ~30 mins and I'm pretty sure if they could attack, they would do it non-stop. I contacted hosting provider, ...
0
votes
0answers
68 views

Mysql table keeps crashing. How to debug the cause and prevent it?

My wordpress wp_users table keeps crashing and when I get up on the morning is : wp_users' is marked as crashed and last (automatic?) repair failed So all my users can't access the site. If I do a ...
0
votes
1answer
20 views

How to find the latest binlog of MariaDB by shell script?

I want to find the latest mysql binary log in /var/log/mysql/, but I found the name of binlog is mariadb-bin.0000*, and we also have mysql-bin.index, so it's really hard for me to use shell script to ...
2
votes
1answer
31 views

split filename in loop and reference each part

I have a directory with a list of files in it, e.g. file.name.aaaaaa.111111 file.name.bbbbbb.222222 file.name.cccccc.333333 I need a way to take each file, split it at the "." and then using each ...
2
votes
2answers
130 views

How is server replication implemented when setting up a reverse proxy environment?

I've been reading and having a go at setting up some different server cluster environments. I have it working correctly using various Linux distributions. The basic set-up goes as follows: ...
-1
votes
1answer
58 views

Migrate my mysql database to AWS RDS

I have my MYSQL server running in my google instance. My server have vesta control panel where I'm currently managing servers.. I would like to migrate my database to Amazon RDS. How I can do it ...
1
vote
2answers
258 views

MySQL and high jdb2 io/wait

I am running MySQL 5.5 with InnoDB tables. There are about 200 queries per second. There are also tables with 500 000 or more rows. But I have big issues with server load and io/wait especially with ...
0
votes
2answers
60 views

Connect by mysqldump to a mysql server only allowing one ip

I have a cloud server with MySQL in it. In this moment, i can't connect from my pc to the server using any of the users. What it want is allow to use mysqldump with an specific user and only allow ...
0
votes
2answers
37 views

Script to connect Mysql from EC2 to AWS RDS [closed]

I'm writing a script to connect mysql server on an EC2 to RDS, normally I do this: mysql -h $RDS_ENDPOINT -P 3306 --user=$RDS_MYSQL_USERNAME --password=$RDS_MYSQL_PASSWORD and then exit I just want ...