MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
29 views

DB replication using BinLog

I am using mysql-binlog-connector to listen to any binlog event and then perform replication on the slave DB. My problem is that, the binlog registers event right after the execution and before ...
2
votes
2answers
203 views

CentOS 7.2, PHP 5.4 - MySQL extension is missing [closed]

I'm trying to install a Wordpress blog on my Linux server (CentOS 7.2), using PHP 5.4 and MariaDB, but I keep running into this error: Your PHP installation appears to be missing the MySQL extension ...
0
votes
1answer
121 views

Mysql master-slave replication very slow

We're running a MySQL master-slave replication set-up and the slave is very slow at catching up. There seems to be no high network or cpu usage while the slave is going through the masters' logs. ...
0
votes
1answer
36 views

How to get the log position for a disconected mysql slave?

We have a system where our biz people have notebooks that they take on business trips. They are all mysql slaves and they plug them in every other day to sync them up but sometimes a person might not ...
0
votes
1answer
87 views

host a 500gb mysql database in RAM memory

I have a 500gb mysql database. Assuming that buying RAM is not a problem (memory is cheap), is it practical or even sane to host an entire 500gb mysql database in RAM memoery for faster accessing ...
0
votes
0answers
46 views

Unable to load dynamic library pdo.so, pdo_sqlite, pdo_mysql

After writing a huge article in my blog, I've got a blank page on the articles page, and when I checked the log, look what I found: [29-Dec-2015 19:53:20 America/Sao_Paulo] PHP Warning: PHP Startup: ...
0
votes
1answer
65 views

How to set hostname in MySQL? (OS X)

I want to do something similar to the hosts file in MySQL, where I can associate an IP address with a given hostname. So localhost has a default IP address of 127.0.0.1, and let's say I have another ...
0
votes
0answers
4 views

MySQL Galera not returning MySQL error in some cases

I am running MySQL Galera 5.6.27 on a 3 node cluster since about a few weeks now in production. Since going live I found that once in a while I do get MySQL errors that previously did not ocure and ...
-1
votes
1answer
68 views

Google Cloud SQL Not Responding [closed]

My Google Cloud SQL instance stopped responding. I changed the size from a micro instance to standard instance and then the memory just shot to the ceiling and stayed there. The restart button is ...
0
votes
1answer
59 views

Azure Web Apps With Java, MySql, Filesystem

Some background is I currently have a VM deployed on Azure. On the VM I have 3 java web applications running on a Tomcat server. Each are integrated in some way or another. They all run on the same ...
0
votes
0answers
11 views

Unable to connect RDS db using Sql Yog

I have created an RDS instance in aws for Mysql db. But I am unable to connect that server using the Sqlyog Endpoint key is used as host and all the other details are correct. Also when I go to ...
0
votes
0answers
1k views

MySQL RDS Instance full

I have a MySQL instance on Amazon RDS, with 6GB of storage. All databases installed into this instances weight 500MB. Today the server had no space available. How can I identify the problem? This is ...
0
votes
1answer
34 views

How to change MySQL user permission temporarily (Per Connection)

I do not know if it is possible at all or not. What I want is that, when a certain connection is established, the user not be able to modify data with that connection. This is the scenario: ...
0
votes
1answer
155 views

Accidentally delete ibdata1, ib_logfile1 and ib_logfile0

Actually i have problems with the database always down due to log. Usually when I restart it will work just fine. But recently the database cannot start and make me think to simply delete those ...
0
votes
0answers
65 views

nginx + php-fpm: 502 - when mysql is under load

mas :) I've got the following hardware 1 dedicated MySQL server (5.1x) 3 webservers with nginx and php-fpm (Ubuntu 12) and I'm running a small magento shop and several other low-traffic sites on ...
0
votes
1answer
63 views

VMware Host only network - Cannot connect to mysql between VMs

I've setup a virtual private network using VMware workstation 11. IPs are configured as so: Host: 192.168.129.1 Physical machine VM: 192.168.129.3 MariaDb database VM: 192.168.129.4 Web ...
1
vote
2answers
34 views

Moving mysql slave

I am trying to move MySQL slave from old pc to new. Original slave is MySQL version 5.6.12 same as new slave(MySQL is part of wamp 2.4). Replication works fine at old machine. But when I stop slave, ...
1
vote
1answer
80 views

Dovecot error reading mailbox: Can't expand ~/ for mail root

I want to configure dovecot to use mysql as users database. This is my config: # Authentication for SQL users. Included from 10-auth.conf. # # <doc/wiki/AuthDatabase.SQL.txt> passdb { driver ...
0
votes
0answers
23 views

Way to know what source is reading the most from MySQL Server(RDS)?

I have a mysql server which is registering very large bandwidth usage. I want to know what options I have for: Knowing what source is using the MySQL server most. (server ip?) What tables or queries ...
0
votes
1answer
22 views

mysql master to master replication with one slave

I have 3 servers Server A master to Server B Server B master to Server A and Server C Server C slave to Server B When I add table to Server A, it replicated on server B but not in Server C When I ...
0
votes
0answers
67 views

Diagnosing high Network Out (Bytes) by MySQL instance

I have an EC2 instance (r3.xlarge) with only MySQL running on it. At some points in time, this machine sends a sustained amount of information (at almost a rate of 400Mbps) for about an hour or more ...
0
votes
0answers
48 views

On Cloud: [Warning] IP address '' could not be resolved: Temporary failure in name resolution

I have configured mysql on cloud (azure) and can find lot of unknown IP's which are trying to connect with my db instance. I have configure my db users and bind it with network IP's. How can i stop ...
2
votes
3answers
95 views

The curious case of high 5 min load average

Looking for some expert advice here. I'm a first time sys admin on my own server and I can't figure the bottle neck in my server. I've been receiving tons of high 5 min load average alert ranging ...
3
votes
1answer
2k views

Can't open and lock privilege tables: Table 'mysql.user' doesn't exist - Trying to run second instance of myslq

On a Win7 box. I downloaded mysql-5.7.9 and I am attempted to run it as its own self contained instance along side another instance of an old version that is already running. I installed a new ...
3
votes
0answers
21 views

MySQL user suddenly loses some permissions [closed]

On CentOS 7, I have a MySQL (actually MariaDB) database user that needs all server privileges from a remote IP (to be able to use Navicat Premium to manage the database). Somehow every once in a ...
0
votes
0answers
37 views

Kamailio 4.3 replecing opensips 1.11

We have a customized sip routing script in opensip 1.11 now for good performance and stability we are moving to kamailio 4.3. So here am facing some issues related to kamailio module and funciotns ...
0
votes
1answer
267 views

Package mysql-server-5.6 is not configured yet

I had an issue installing MySQL 5.6 on Ubuntu 15.10. Basically loading the db server failed for the mentioned reason. mysql-server depends on mysql-server-5.6; however: Package mysql-server-5.6 is ...
0
votes
0answers
155 views

mysql won't start after upgrade to 5.6 - Permission denied

I'm running Ubuntu 14. Last week I was trying out some PDF tools locally and while trying to install pdftk it mentioned something about a dependency problem and needing to upgrade my 5.5 install to ...
0
votes
0answers
43 views

Modify MySQL information_schema (specially create_time) on AWS RDS?

I am trying to modify the create_time of an entire database, tables, etc. I have found that information_schema TABLES stores the create date of the tables on the column CREATE_TIME. Unfortunately ...
-1
votes
1answer
55 views

All MySQL databases appear to have disappeared

I'm running CentOS 6.7 with MySQL 5.1.73 and it appears as if all of the MySQL databases have disappeared within the past hour. MySQL starts up without any issues, however when running show ...
1
vote
1answer
95 views

mariadb mysql parallel installation apache and php

I'm trying to install mysql and mariadb on the same server as a parallel installation, each service on a different port. I installed mysql server using apt-get on a debian-based distro and then ...
0
votes
0answers
26 views

Do I need binlogs with a Percona xtradb cluster?

If I am running an XtraDB cluster, with no replication, do I need binlogs? They're enabled and chewing up disk space. I'm aware I can restrict their number using max_binlog_files, but I'm not sure if ...
-1
votes
1answer
111 views

YUM attempt to install instead of update MySQL packages

I have a doubt about the difference between install and Upgrade message with YUM Update. I have 2 servers with MySQL 5.6.25 installed on then "Server A" and "Server B". When I run the command: YUM ...
0
votes
0answers
49 views

change file system from ext3 to ext4 effict on MySQL

I have a situation where MySQL was installed in Linux with a ext3 file system. One table (InnoDB) reached the maximum size allowed for ext3 (2 TB) , insert statement gave "The table 'foo' is full". I ...
0
votes
1answer
19 views

service mysql restart with default options

I have Ubuntu 14.04 with MariaDB Galera cluster installed. My cluster has just one node now, so I restart the mysql service using: sudo service mysql restart --wsrep-new-cluster How can I set this ...
-2
votes
1answer
21 views

Rotate Old Files

I have a cron to backup 3 files every Hour, they are SQL backups - in the format name-name-bak-2015-12-1919:30:01.sql I need a way to rotate and delete the older ones say every 7 days? Thought of ...
0
votes
1answer
29 views

Get password for all failed MySQL logins

Im having issues trying to figure out what is the cause of a failing SQL login. The password seems correct to me, but it still isnt working. I want to see what exactly the user login is sending when ...
0
votes
0answers
13 views

Access denied error connecting to SQL DB with Postfix

I have no idea how to go about debugging this. I have created an SQL user called postfix and i have verified that i can log into the DB with this user and edit tables. I have configured postfix to use ...
-1
votes
1answer
39 views

Syncing MySQL backup with GIT tags

We have a large Yii2 / PHP application using MySQL database and versioned by GIT. The application is under continuous development as customer require new features. The database gets changed quite ...
0
votes
1answer
169 views

PHPMyAdmin “#2006 - MySQL server has gone away” during login

First: I've searched all over Google and although this looks like an infamous error, none is actually my case and hence no fix is available. OK so today I encountered this something weird: PHPMyAdmin ...
0
votes
0answers
17 views

Need to determine why my VPS rebooted - every few days, a sudden spike

Can anyone give some advice as to why my LAMP VPS server (running centos) reboots every few days? Well I know why - it's because the CPU and load suddenly spikes, but what causes the spike and what ...
0
votes
1answer
23 views

How do I install mysqli_ for PHP on Linux without affecting anything else?

I have root access to a server and it is currently running a live e-commerce site with lots of sales. The site currently uses mysql_ for everything. mysqli_ is not installed at all. I need to keep ...
0
votes
0answers
31 views

Migrating MySQL 5.1 to MariaDB 10

I plan on migrating my data from MySQL 5.1 to MariaDB 10. At the same time I will be upgrading hardware so I will have a completely new server. Is it possible to simply mysqldump from MySQL 5.1 and ...
0
votes
1answer
78 views

mysql won't start on FreeBSD

We recently picked up a client that has a site hosted on a FreeBSD box. The stack is FAMP. Things were chugging along just fine until recently mysql seems to have stopped running. There is no mysql ...
-2
votes
1answer
41 views

How can I reduce the Cache usage of MySQL and raise the free memory?

I currently have a virtual server with 12 GB of RAM and 8 CPU running many websites with Apache and MySQL. When looking in PhpMyAdmin monitor, I see the following resource usage graph: image -> ...
0
votes
0answers
28 views

High CPU due to MySQL after killing processes

On my linux server I ran into a problem this morning. I realized that after I killed all background tasks that were making ~200k database entries (1gb in size) throughout the night, my CPU usage was ...
-1
votes
1answer
23 views

Cacti and MySQL Queries

I am new to Cacti and am interested in using it to perform some queries against a MySQL database. I have a software which logs an error counter into a MySQL table, and I'd like to be able to graph ...
1
vote
0answers
172 views

Unable to start MySQL on CentOS

I've just installed a fresh version of MySQL on my CentOS machine. The problem I'm facing is that when I run this command: # service mysqld start I get in the console this error message: ...
0
votes
0answers
19 views

Mysql Server 5.5 is looping on start

Yesterday i had sadly to recover my server, that included all Databases in /var/lib/mysql . The huge issue is now that mysql wont startup and is some kind of looping,- it crashes and is getting ...
0
votes
1answer
49 views

Unable to install a fresh version of MySQL on CentOS

These are the steps, that I followed: cd /etc/yum.repos.d # go to repositories rpm -qf mysql-community.repo # get the name of old repositories to delete yum remove mysql57-community-release # it is ...