Questions tagged [mysql5.6]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3 votes
1 answer
7k 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 ...
kghbln's user avatar
  • 441
3 votes
0 answers
2k 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. ...
Avinash Pawar's user avatar
3 votes
1 answer
608 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 ...
Henrik's user avatar
  • 31
2 votes
1 answer
1k 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 ...
Mauricio Cacho's user avatar
2 votes
1 answer
794 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 ...
technoob's user avatar
  • 142
2 votes
2 answers
2k 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 ...
Dentra Andres's user avatar
2 votes
0 answers
931 views

High CPU since upgrading to MySQL 5.7 from 5.6

We are using an AWS RDS managed MySQL db.m4.2xlarge instance with db engine 5.7.30, we upgraded from 5.6 two days ago and have high CPU since - generally 10-15% higher reaching 100% at peek. Please ...
Edward Spencer's user avatar
2 votes
0 answers
107 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 ...
Alfergon's user avatar
  • 121
2 votes
1 answer
645 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 ...
turbophi's user avatar
2 votes
0 answers
374 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 ...
DBAd's user avatar
  • 21
1 vote
1 answer
3k 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 ...
Saqib Ali's user avatar
  • 589
1 vote
1 answer
7k 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. ...
Anand Shrestha's user avatar
1 vote
1 answer
2k 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 ...
user417568's user avatar
1 vote
1 answer
1k 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 ...
Chebarbudo's user avatar
1 vote
1 answer
4k 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 ...
Tom's user avatar
  • 113
1 vote
1 answer
1k 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 ...
anup's user avatar
  • 727
1 vote
1 answer
563 views

AWS RDS mysql.rds_set_external_master remains disabled after setting autocommit to 1

The goal is to create a master-master replication consisting of two RDS MySQL 5.6 instances, db0 and db1. I orientate myself by this article. So far, I have created db1 as a read-replica of db0 and ...
user540468's user avatar
1 vote
0 answers
375 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] ...
adminz's user avatar
  • 397
1 vote
1 answer
776 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 ...
jnrcorp's user avatar
  • 135
1 vote
1 answer
8k 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 ...
Daniel Klose's user avatar
1 vote
0 answers
502 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 : ...
purvesh pardeshi's user avatar
0 votes
2 answers
7k 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 ...
chris85's user avatar
  • 81
0 votes
1 answer
339 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 ...
Doug Wolfgram's user avatar
0 votes
1 answer
1k 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 ...
all_techie's user avatar
0 votes
1 answer
204 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 ...
user362986's user avatar
0 votes
1 answer
503 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 ...
Tim Stoop's user avatar
  • 598
0 votes
0 answers
25 views

MySQL server has gone away: Two APIs, single database, One API throws the error while other doesn't

I have two flask restful API's. Both are working fine. API1 is only for reading the database, API2 deals with update/insert. Both access the same database. Problem: API1 stops working every morning ...
Mr.President's user avatar
0 votes
1 answer
93 views

How to upgrade mysql5.5 to 5.7

I have a MYSQL Server 5.6 on ubuntu 14.04, having more than 2000 databses. Now we have to upgrade it to MYSQL version 5.7. Kindly let me know how can i take backup of this huge data & upgrade ...
03amittrivedi's user avatar
0 votes
0 answers
825 views

An specific timezone is not available on a RDS Aurora MySQL cluster

I have a database in RDS MySQL 5.7 instance and within the Parameters Groups I have defined the parameter "time_zone" as "America / Santiago", but now I want to migrate the database to an Aurora MySQL ...
FrancoVP's user avatar
  • 101
0 votes
0 answers
462 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 ...
Andy Castles's user avatar
0 votes
1 answer
150 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,...
Ehsan Khodarahmi's user avatar
0 votes
1 answer
225 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 - ...
matpol's user avatar
  • 318
0 votes
0 answers
34 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 ...
Lexib0y's user avatar
  • 227
0 votes
1 answer
4k 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 ...
Tan's user avatar
  • 139
0 votes
0 answers
477 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~)...
special0ne's user avatar
0 votes
3 answers
997 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://...
tester's user avatar
  • 109
0 votes
1 answer
167 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 (...
heroin's user avatar
  • 101
-1 votes
1 answer
247 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 ...
Aitazaz Khan's user avatar
-1 votes
2 answers
722 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 ...
Krishna's user avatar
-1 votes
1 answer
331 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 ...
youen's user avatar
  • 209
-3 votes
1 answer
3k 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....
vishal dharankar's user avatar
-3 votes
1 answer
176 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 ...
asvignesh's user avatar
  • 127