Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql5.6]

The tag has no usage guidance.

0
votes
1answer
98 views

MySQL Opened_tables keeps increasing

I am running mysql-5.6.36. Parameter table_open_cache was 2000. I had a huge Opened_tables versus Open_tables ratio (ie. 67988/1950 after 326 days). So I set table_open_cache to 2500. After ...
0
votes
1answer
296 views

Promoting MYSQL Slave to MYSQL Master

I have a MySQL setup with one master (M1) and one slave(S1). Due to some unforeseen issue I need to promote my slave server to master and demote master to slave. My MySQL version is 5.6 in Linux. ...
0
votes
1answer
75 views

How do I configure postfix for Mysql 5.7

I made the appropriate changes to postfix to get mysql 5.7 working as the database instead fo Maria DB. I can run tests and all seems to work on the server. However, I cannot log into my account from ...
0
votes
0answers
119 views

Intermittend DB service error (Ec2+RDS)

I have a EC2 Ubuntu server with the database as RDS. It is connecting fine and the db connections are low but intermittently showing a DB service error. SQLSTATE[HY000] [2002] ...
-1
votes
1answer
34 views

Dropping all mysql databases using ssh

I am totally new to the ssh so pardon if I commit any mistake. Well, I have had 457 databases which i wanted to take backup and put databases in individual files. Which i got a working solution from ...
-1
votes
1answer
52 views

Can't log in MySQL with newly created user, but any username without password is accepted

I installed MySQL 5.6 on Windows, imported a database (as root), and created a new user with a password to access this database. Connexion with the username and password does not work (tested with ...
-3
votes
1answer
62 views

How to find the MySQL database table data directory when it's different from the global one

When creating a new table, I specified the data directory with: CREATE TABLE t2 (c1 INT PRIMARY KEY) TABLESPACE = innodb_file_per_table DATA DIRECTORY = '/alternative/directory'; How can I find ...
1
vote
0answers
170 views

Got a packet bigger than 'max_allowed_packet' bytes

MySQL Community-Server 5.6.39 RHEL7 Scenraio: Trying to process binary logs to restore the incremental backup and receive max_allowed_packet error. Turned off binary logs,restarted the database. ...
1
vote
1answer
133 views

MySQL 5.6 Deadlock Issue

I have a sporadic deadlocking issue with MySQL 5.6. This server is configured as a read only slave, which is why it is extremely odd there is a deadlock issue. I have innodb_lock_wait_timeout set to ...
0
votes
0answers
138 views

How do I determine what is causing MySQL (Percona server) to crash on Linux

I am running the Percona version of MySQL Server v5.6 and every few days the MySQL seems to crash and then automatically restart itself. How can I work out what the reason is for the crash? I've seen ...
0
votes
0answers
39 views

Can't connect to MySQL Server Remotely

I was developing an application over MySQL Server (Community Edition). I was able to access my server over local (private) IP Address 192.168.X.XXX:AAA or on localhost:AAA. Now, I want to deliver my ...
0
votes
1answer
114 views

mysql service suddenly stopped working

I am suddenly not able to start mysql service /etc/init.d/mysql start Starting MySQL...... ERROR! The server quit without updating PID file (/var/lib/mysql/mysql.pid). I have tried to do the ...
0
votes
1answer
29 views

How can I set mysql connection charset to utf8 in apache mod_dbd?

How can I set connection charset to utf8 in apache mod_dbd with mysql driver? I could not find any corresponding parameter in DBDParams, something like this: DBDParams host=localhost,dbname=my_db,...
-1
votes
2answers
99 views

Ubuntu - Some one is able to write on ubuntu/apache server [duplicate]

Someone is trying to hack my website, I have a website built on PHP (7)/MySQL in Laravel framework. The owner of the /var/www is www-data and folder permission is set 700 for all folders and file ...
0
votes
1answer
580 views

MySQL Replication failing on `mysql`.`user` changes

I have a simple master - slave setup with MySQL 5.6 that keeps failing whenever I make changes to the mysql.user table. The master is set to replicate two databases, neither of which are the mysql ...
0
votes
1answer
155 views

AWS RDS mysql upgrade 5.5 to 5.6

What is the best/easiest way to upgrade and RDS instance running mysql 5.5 to 5.6. I have seen two potential methods: modifying the instance - this seems the easiest method - have people done it - ...
0
votes
0answers
21 views

I cannot get data from the same database on different hosts with different versions of mysql-server

I have a web site that has moved to a new server. I moved the site to a web-server running apache24 and php56. It came from a server with apache24 and php55. When I use the old external (different ...
-5
votes
1answer
925 views

Mysql downgraded from 5.7 to 5.6, and now it stops immediately after startup [closed]

I have a digital Ocean droplet on CentOS 7. I had installed 5.7 in the beginning, but I wanted to use 5.6 for some reason. So I just removed 5.7 using yum remove, and then after disabling 5.7 from yum....
0
votes
1answer
184 views

Foreign Key Constraint Error 1005 erno 121

I'm racking my brain trying to get this table created. Other tables create just fine in mariadb 10 with similar constraints. I've run it through debuggers with no success. ERROR 1005 (HY000) at line ...
2
votes
1answer
652 views

Install PHP-Mysql without mariadb-libs

I'm trying to install PHP on my server, running Centos 7.3; I've installed php 5.4, and have MySQL Server 5.6.28 running there too. When I'm trying to install php-mysql, it's trying to install ...
2
votes
0answers
94 views

Performance issue with fresh install MySQL 5.616-1~exp1 (Ubuntu) on Ubuntu 16.04 LTS

I've recently started on a new company and I'm currently setting my dev environment. We're using Ubuntu 16.04 and MySQL 5.6 Everything was right until I launched the tests (using mvn test). After ...
0
votes
1answer
1k views

No Match for argument: php5-mysql and No package php5-mysqlnd available

I came across the following warning : PHP Warning: mysqli_connect(): Headers and client library minor version mismatch. Headers:50550 Library:50631 in /var/www/html/web_app/test/browser/dbconn.php ...
2
votes
0answers
279 views

mysqladmin not waiting for full shutdown (or debian init.d script broken?)

I'm running Percona MySQL server 5.6 (from packages) on debian wheezy (same behavior on jessie). Unfortunately I always get this: # service mysql stop [FAIL] Stopping MySQL (Percona Server): mysqld ...
3
votes
1answer
310 views

Mysql GTID replication stopped working

I've setup mysql gtid replication between master and slave. the interesting thing is that I found the replication stopped working after several minutes, and I have to use stop slave and start slave to ...
0
votes
1answer
70 views

mysql replication fail (no error)

I'm doing a replication on a mysql 5.6 server (master) to a slave in mixed mode. The thing is, i connect to mysql trought workbench, i execute querys and are replicated. But if another user connected ...
0
votes
0answers
385 views

broken packages when installing mysql 5.6 using apt-get

I am trying to install mySql 5.6 on my Linux machine. I tried >apt-get install mysql-server-5.6 but I am getting the following error: mysql-server-5.6 : Depends: mysql-common (>= 5.6.22-1~)...
0
votes
2answers
2k views

MySQL Wont Start with Datadir Change [duplicate]

I'm trying to change the datadir for mysql. When I try to restart the service it hangs for 10 minutes, then fails to restart. Here are the steps I took to change the dir: sudo service mysqld stop ...
0
votes
3answers
554 views

Install mysql-5.6 non interactive

I couldn't find any solutions how to install mysql-5.6 in a docker container non-interactively. I found the following commands but they need user input: # Update the repo list, execute : wget http://...
2
votes
0answers
139 views

mysql Alter table to compress data fails with “Duplicate entry”

I was trying to compress few tables, but one of them caused this error alter table MY_table row_format=compressed, algorithm=INPLACE, LOCK=NONE; Query OK, 0 rows affected (0.00 sec) ERROR 1062 ...
1
vote
1answer
2k views

Why can't I uninstall mysql-5.5 & install mysql-5.6 on Amazon Linux machine?

I'm on a 64-bit Amazon Linux machine. I had previously installed mysql-server 5.5. (using sudo yum install) However, I soon found out that my application requires MySql-serve 5.6. So I uninstalled ...
1
vote
1answer
7k views

Import MySQL 5.6 database into 5.5 using MySQL 5.6 client tools

My local dev environment currently uses MySQL Server 5.5. However, one of my clients hosts decided to upgrade their server to 5.6. I sync my clients databases remotely using mysqldump over ssh. I have ...
3
votes
1answer
425 views

MySQL Multi-source replication from 5.6 masters to 5.7 slave

In MySQL 5.7 multi-source replication is finally available. Is it possible to use several MySQL servers running version 5.6 as multiple masters for a single MySQL slave running 5.7? Or do you have to ...
0
votes
1answer
110 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
0answers
360 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 : ...
3
votes
1answer
6k 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 ...
1
vote
1answer
963 views

Extremely slow when executing multiple individual MySQL queries

I've been noticing a performance issue in one of my servers running Apache/PHP/MySQL. So I decided to investigate and test it against other servers. What did I do? In three different servers, I ...
1
vote
1answer
829 views

Mysql 5.6 client is unable show UTF8 characters

Mysql databases are hosted on AWS RDS Mysql 5.6 On one of the EC2 Cent OS 6.5 instance, I had Mysql Client 5.1. I used it to execute SELECT queries over the RDS-Mysql. There is one particular query ...
0
votes
1answer
354 views

XtraBackup restore gives duplicates on slaving?

We've recently upgraded a MySQL 5.0 master-master setup to Percona 5.6. Slaving went b0rken due to some failures on our side, but we thought we could simply fix it by using xtrabackup to create a ...