Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql5.6]

43 questions
3
votes
1 answer

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 upgrade all the masters to 5.7 to allow them to…
Henrik
  • 31
  • 2
3
votes
1 answer

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 not configured yet.
kghbln
  • 371
  • 1
  • 9
  • 19
2
votes
0 answers

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. Backed up the current schema using. **mysqldump -u…
Avinash Pawar
  • 21
  • 2
2
votes
1 answer

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 mariadb-libs for dependencies, and it stops with…
Mauricio Cacho
  • 121
  • 4
2
votes
0 answers

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 waiting more tan 20 minutes, the tests were not…
Alfergon
  • 121
  • 4
2
votes
1 answer

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 failed! I can say about my configuration…
turbophi
  • 71
  • 4
2
votes
1 answer

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 restart mysql replication. Can anyone tell me…
technoob
  • 132
  • 1
  • 14
2
votes
0 answers

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 (23000): Duplicate entry '740003820' for key…
DBAd
  • 21
  • 2
2
votes
2 answers

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 created a database (db_sandbox), with a single innodb…
Dentra Andres
  • 31
  • 1
  • 6
2
votes
0 answers

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 can you help us understand the reason for this?…
Edward Spencer
  • 21
  • 2
1
vote
1 answer

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 restarting the service, I monitored the ratio and I still…
Chebarbudo
  • 73
  • 1
  • 6
1
vote
1 answer

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. Please let me know the exact process as this is the…
Anand Shrestha
  • 41
  • 4
  • 12
1
vote
0 answers

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] php_network_getaddresses: getaddrinfo failed: Name or service not…
adminz
  • 397
  • 2
  • 4
  • 19
1
vote
1 answer

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 120. A subset (due to character limits on…
jnrcorp
  • 125
  • 5
1
vote
1 answer

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 mysql-server 5.5. (using sudo yum remove…
Saqib Ali
  • 529
  • 1
  • 8
  • 18
1
2 3