Questions tagged [mysql5.6]
The mysql5.6 tag has no usage guidance.
42
questions
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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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] ...
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 ...
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 ...
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 : ...
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
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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,...
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 - ...
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 ...
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 ...
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~)...
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://...
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
(...
-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 ...
-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 ...
-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 ...
-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....
-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 ...