MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
42 views

MariaDB query cache not being used with prepared statements

We are seeing a problem with our MariaDB setup where our queries executed as prepared statements are not being cached, however, queries executed locally through mysql command (i.e. text protocol) do ...
0
votes
1answer
169 views

Binlog format - RDS default

By default in MySQL 5.6 default binary logging format is "STATEMENT". (https://dev.mysql.com/doc/refman/5.6/en/replication-formats.html) MySQL 5.6 running on RDS has by default format set to "MIXED" ...
0
votes
1answer
47 views

MySql ignores memory settings

I'm using MySql community server 5.6 on Ubuntu 15.04, I have /etc/mysql/my.cnf (no other config files). I've made changes to it and restarted MySql. When I use such query SELECT @@key_buffer_size (...
1
vote
1answer
32 views

MySQL - Statistics per ip

I'm unable to found a way to get some statistics per IP since the server started. I would like to get a count of queries executed by IP address. The goal is to check if a server is abnormally using ...
1
vote
1answer
604 views

Adding multiple 'Limit to hosts matching' for user in Workbench

I want to add two IP addresses to limit a user account in Workbench. I can't figure out the syntax. I've scanned the help and online. 123.456.789.123, 127.0.0.1 doesn't work. It says Hosts so I'm ...
0
votes
1answer
67 views

Dovecot dict: Can't open configuration file, Permission denied

I'm trying to set up a dovecot mysql dict for quota in a FreeBSD jail. This is the log I'm getting: an 13 10:03:23 mail dovecot: dict(71120): Error: Failed to initialize dictionary 'sqlquota': dict ...
0
votes
1answer
46 views

Dovecot quota clone

I'm trying to use dovecot's quotas and share them via mysql with modoboa. I'm using the count module for that: http://wiki2.dovecot.org/Quota/Count To share the quota I'm trying to implement the new ...
1
vote
0answers
91 views

How I can reduce disk IO in MySQL 5.6.26?

I was using MySQL version 5.1.52 for my application but recently I have updated it to 5.6.26, but now I am facing very high disk IO. Following are system configuration: OS : Linux 2.6.39.4 RAM : ...
0
votes
1answer
316 views

How should I go about upgrading mysql server from 5.0.67 to latest?

The current version of mysql I have on my server is 5.0.67. I would like to upgrade to the latest version. Based on what I have read here: https://dev.mysql.com/doc/refman/5.5/en/upgrading.html, this ...
0
votes
0answers
93 views

What is the best strategy to automatically sync a Filemaker table on a local server with a remote MySQL table?

I'm trying to figure out the best way to keep a Filemaker 12 database on a local Windows 2012 server machine in sync with a MySQL 5 database on a remote server which runs the shop of a website. In ...
0
votes
1answer
34 views

How to avoid MySQL replication corruption while executing flush-logs command

I have three servers running MySQL, let's say A, B and C. Server A is the master, and server B is the slave. I want to do mysql replication between server A and B, at the same time, I also want to use ...
0
votes
0answers
133 views

phpmyadmin can't login with non-root users

I just started learning to manage Linux web hosting. After installed webmin/virtualmin on Ubunto 14.04, I used the install script of virtualmin to install phpmyadmin. The problem is, I can only use ...
0
votes
1answer
106 views

MariaDB galera cluster fail when dumping or optimizing database

It seems that a Galera cluster deadlocks every time when I run a mysqldump or table optimize. I've ran a "mysqlcheck" and a "mysqldump" on my MariaDB 10.1 database server several times. (which runs ...
-2
votes
1answer
55 views

best configuration for database server [duplicate]

Okay I have a VPS (DO 512 MB) and AWS RDS free tier . I wanna get the maximum performance , please help me cause I'm a little confused . I run a nginx server on the VPS and it can handle 1K traffic/...
1
vote
0answers
24 views

Alias with all users in mysql table for postfix/dovecot

I have a table with users for my mail server. This table for imap authenfication in dovecot: +-------------+------------------+-------------------+------------------+------+------+--------------------...
0
votes
0answers
44 views

Create alias with all users from mysql table in postfix/dovecot

I have a table with users for my mail server. This table for imap authenfication in dovecot +-------------+------------------+-------------------+------------------+------+------+---------------------...
4
votes
1answer
57 views

TKLBAM backup stalling causing MySQL issues

I'm having a strange issue that I've never encountered before. I'm running a Turnkey Linux LAMP server (Debian) and it seems that my MySQL server becomes inaccessible at least once a day. I'm not sure ...
0
votes
0answers
57 views

Mysql “freeing items” in states

Please help me ... I have mysql 5.6 machine , with following info: Centos 2.6.32-431.el6.x86_64 Ram : 64 GB innodb_buffer_pool_size=48GB Bit: 64 bit +------------------------------+----------------...
-6
votes
1answer
72 views

How fast should a web server be? and why StackExchange uses all that hardware? [closed]

Okay so I have been making my very first website, I am using Apache server on Windows 10 Pro I can see my website is loading very fast, however, when I browse my website like anyone would do, I can ...
1
vote
1answer
93 views

MySQL Host / Host Table

So for better security, our website / network has been looking to lock down all of our SQL to IPs. What we originally were looking for was somewhere where I could whitelist all our ips, say 104.151....
-4
votes
1answer
33 views

RHEL 6.5 iso issue

the company Im currently working was able to installed redhat 6.5 in their VM and they uploaded the Rhel 6.5 iso in the redhat server. I was able to install the apache and the php but when I tried to ...
0
votes
1answer
49 views

Postfix - MySQL - noreply custom response not working

I'm trying to get a custom response working for no.reply@example.com and I keep getting "User doesn't exist" errors. I have an alias of no.reply@example.com which has a 'goto' of the same value, then ...
0
votes
1answer
45 views

Memory problems in a Wordpress Multisite Ubuntu Server

I have a server with 512MB RAM and 512MB swap file hosting a Wordpress multisite (8 websites). Not many visitors per day (about 50-100 per site per day). Right now, everything is working fine, and ...
0
votes
1answer
64 views

How can I securely access a Rackspace Cloud Database in AWS?

Rackspace limits access for Cloud Databases to their ServiceNet. How can I securely and efficiently connect to a database instance there from AWS (over the public internet)?
0
votes
1answer
212 views

IMAP authentication issue with roundcube + postfix + mysql + ubuntu mailserver

This problem is driving me insane and I'm now stumped. Need some help please ;) I'm setting up a mail server on an Ubuntu 14 AWS EC2 instance using mysql backend, postfix MTA and roundcube webmail ...
0
votes
1answer
31 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 commit,...
2
votes
2answers
309 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
231 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
45 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
100 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
82 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
79 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
83 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
78 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 ...
1
vote
0answers
19 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
41 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
329 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
82 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
117 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
36 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
113 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
24 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
83 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
76 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
98 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 ...
5
votes
1answer
4k 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
24 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 ...