Questions tagged [mysql5.6]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
59 views

Can't start MYSQL external mount centos 7

Brand new install on a new DigitalOcean droplet. I am going to run replication into this cloud server from my local network. I was trying to install the same version etc. mysql5.6.50 and then run it ...
user avatar
2 votes
0 answers
585 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 ...
user avatar
1 vote
1 answer
276 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 ...
user avatar
0 votes
0 answers
22 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 ...
user avatar
0 votes
1 answer
54 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 ...
user avatar
0 votes
0 answers
563 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 ...
user avatar
1 vote
1 answer
791 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 ...
user avatar
1 vote
1 answer
5k 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. ...
user avatar
0 votes
1 answer
273 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 ...
user avatar
1 vote
0 answers
307 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] ...
user avatar
  • 397
-1 votes
1 answer
100 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 ...
user avatar
-1 votes
1 answer
212 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 ...
user avatar
  • 209
-3 votes
1 answer
119 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 ...
user avatar
  • 117
2 votes
0 answers
1k 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. ...
user avatar
1 vote
1 answer
657 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 ...
user avatar
  • 125
0 votes
0 answers
383 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 ...
user avatar
0 votes
1 answer
991 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 ...
user avatar
0 votes
1 answer
101 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,...
user avatar
-1 votes
2 answers
491 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 ...
user avatar
0 votes
1 answer
3k 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 ...
user avatar
  • 103
0 votes
1 answer
220 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 - ...
user avatar
  • 318
0 votes
0 answers
27 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 ...
user avatar
  • 227
-3 votes
1 answer
2k 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....
user avatar
0 votes
1 answer
1k 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 ...
user avatar
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 ...
user avatar
2 votes
0 answers
105 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 ...
user avatar
  • 121
0 votes
1 answer
3k 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 ...
user avatar
  • 129
2 votes
1 answer
547 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 ...
user avatar
2 votes
1 answer
628 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 ...
user avatar
  • 132
0 votes
1 answer
178 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 ...
user avatar
  • 11
0 votes
0 answers
460 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~)...
user avatar
0 votes
2 answers
6k 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 ...
user avatar
  • 81
0 votes
3 answers
877 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://...
user avatar
  • 109
2 votes
0 answers
297 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 ...
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 ...
user avatar
  • 509
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 ...
user avatar
3 votes
1 answer
564 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 ...
user avatar
  • 31
0 votes
1 answer
149 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 (...
user avatar
  • 101
1 vote
0 answers
485 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 : ...
user avatar
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 ...
user avatar
  • 371
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 ...
user avatar
1 vote
1 answer
979 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 ...
user avatar
  • 647
0 votes
1 answer
423 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 ...
user avatar
  • 578