MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
83 views

MySQL 5.7 under Debian Jessie with postfix-mysql

I currently have MySQL installed from the MySQL APT repository and am on the 5.6 branch. It comes with libmysqlclient18 and postfix-mysql requires it. If I want to switch to the 5.7 branch, APT will ...
0
votes
1answer
97 views

Mysqld.exe crases on startup with error 0xc000007b

I've just deployed a new VM on Microsoft Azure with Windows Server 2012 R2. It is identical to other two I have (it was created from scratch though, not duplicated or from an pre-existing image), all ...
0
votes
1answer
79 views

high mysql CPU usage more than %1500 on centos 6

I am running a high traffic websites on a Dedicated-Virtual 24GB RAM CentOS server hosted by the planet. Very often the server dies because of high CPU usage (%1500) When i check the running ...
0
votes
2answers
517 views

PHP 7 cannot connect to MySQL

I have compiled LAMP servers for hundreds of times. However I am facing issues with PHP 7. I compiled it properly, but it cannot connect to MySQL in localhost. phpinfo shows PDO and mysqli are ...
1
vote
0answers
155 views

mysql-workbench installation error

I have ubuntu 14.04 and try to install mysql-workbench. and getting an error as The following packages have unmet dependencies: mysql-workbench: Depends: libgcc1 (>= 1:4.1.1) but 1:4.9.3-0ubuntu4 ...
0
votes
1answer
205 views

Mysql innodb_buffer_pool_size in relation to innodb_buffer_pool_instances

I run a virtual server with an Owncloud installation on it. Now Owncloud has the problem that the way it's developed at the moment, each file upload causes a little MySql overhead. So is very ...
3
votes
2answers
2k views

How can I install MySQL 5.7.9 to Ubuntu 14.04?

I tried to install with these inscturctions, but installation installed version 5.5. $ sudo apt-get install software-properties-common $ sudo add-apt-repository -y ppa:ondrej/mysql-5.7 $ sudo apt-get ...
0
votes
1answer
60 views

GTID have been turned off But I have error in replication

I just upgrade from mariadb5 to mariadb10. Then I have error on my slave replication Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't ...
0
votes
0answers
62 views

MySQL replication - invalidating query cache entries (table)

We lately mved to MySQL V5.5 on CentOS release 6.7 with master and 2 slaves. Since then the replication process lags a lot behind the master with the line in the process list of: invalidating query ...
0
votes
4answers
137 views

Sometimes: Unable to connect to host 127.0.0.1, or the request timed out. MySQL through Sequel PRO

I have been struggling with this issue for over a year now, and it’s really giving me a headache. I often experience I am unable to connect to the MySQL server through SequelPRO. If I ssh into the ...
0
votes
1answer
84 views

MySQL [ERROR] Can't start server: can't create PID file: No such fie or directory

I'm having trouble starting mysql and mysqld. Output of sudo service mysql start command is mysql : Unrecognized service Same way output of sudo service mysqld start is nothing When I tried sudo ...
1
vote
1answer
30 views

MySQL Error Code: 1017 permission denied

I have downloaded the German version of the Northwind sample database. I moved the folder to /var/lib/mysql and set the rights to drwxr-x---. Here is an output of /var/lib/mysql drwxr-x--- 2 mysql ...
0
votes
2answers
78 views

CentOS 7.2 Azure VM - MariaDB/Apache killing memory

I have an Azure VM with CentOS 7.1, Apache 2.4.6, and MariaDB 5.5. The VM has 2 cores and 3.5 GB RAM. The server is only hosting a small WordPress site with almost no traffic. For the past two days, ...
4
votes
1answer
193 views

Galera cluster (MariaDB) on Docker/CoreOS: second node doesn't work on first attempt

I'm trying to create an automatic deployment of Galera Cluster with MariaDB, running inside Docker containers on CoreOS. Software used: - MariaDB official Docker image, version 10.1.10 - CoreOS ...
0
votes
2answers
289 views

MySQL Daemon Lock issue

Last night, my MySQL server went down unexpectedly. On attempting to restart (with service mysql restart - I'm root) it merely hangs. With the mysql -u root -p command, I get ERROR 2002 (HY000): Can't ...
0
votes
0answers
42 views

dovecot shared folders (acl with mysql) can't be subscribed

For some reason the folder Project Folders is not selectable. Practically every public or shared folder is not selectable. The Email client is Thunderbird. # 2.1.17: /etc/dovecot/dovecot.conf # OS: ...
0
votes
0answers
17 views

same page, different load time on different server

I am completely new to server admin. I have built a large site (for one person to code) and have to do things myself. I have a site on a shared server and another on a managed VPS. The VPS server ...
0
votes
1answer
57 views

Adding MySQL user with different hosts in SaltStack

I have two servers running the same application with a need to access a database on one specific database server running MySQL. Both servers with the application should access the MySQL DB with the ...
0
votes
0answers
24 views

InnoDB file per tablespace

I am using following syntax to create innodb table: create table InnoDB_Test(a INT) DATA DIRECTORY='/var/log/storage/MySQL' INDEX DIRECTORY='/var/log/storage/MySQL' engine=InnoDB; I want to create ...
0
votes
1answer
46 views

Why is a command in init.d script ignored?

As part of my work, I manage a mySQL cluster composed of 3 Ubuntu 14.04 machines. All 3 machines should be identical. On machines 1 and 2, when I run sudo service mysql status, I get a status report ...
0
votes
1answer
38 views

nginx + php5-fpm + mysql too many queries per second?

I have a VPS Debian running a nginx webserver and 2 node.js servers, one with socket.io for suplying data for my website and another one for a bot. The socket server runs a lot of queries but I try to ...
0
votes
0answers
35 views

Can't connect to mysql instance

I started a second instance of mysql (5.7.9) on my server and configured the service to run this command: mysqld.exe --defaults-file="C:\mysql-5.7.9\bin\my.cnf" mysql579 In my.cnf I changed the ...
0
votes
0answers
49 views

How to Diagnose Random “Error establishing a database connection” with WordPress

I maintain a Linux VM in Azure which contains one MySQL instance and 8 databases within that instance. Each database is used by a WordPress front end also hosted in Azure App Services. When using my ...
0
votes
0answers
77 views

How to calculate current IOPS usage and IOPS credit count and graph on AWS RDS

I have a running Mysql db.m3.medium RDS instance at AWS, running with 20GB SSD as in: RDS machine description Last hour write and read operations went as following: Disk operations It looks like ...
0
votes
0answers
32 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
78 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
33 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
323 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
45 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
41 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
71 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
124 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
66 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
0answers
22 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
87 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
63 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
45 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 ...
1
vote
0answers
20 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
33 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
51 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
36 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
62 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
68 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 ...
-4
votes
1answer
32 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
40 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
40 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
53 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
154 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
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 ...