I am running MySQL 5.7.20 in a docker container created using the official MySQL docker image. The MySQL conf file needs to be mounted on the host Ubuntu system. Currently the MySQL docker contain...

I am facing issues with json key ordering while inserting using json_insert function. I have the sorted records as below "AIR", "AIR Express" "CFR", "Cost and Freight" "FH", "Free house" "UN"...

So I am new at ST_ functions in MySql and I think that I am missing something. I am trying to save a POLYGON in MySql, the problem is that when using the function ST_GEOMFROMTEXT and giving the coo...

I need to create a user with a six character password in new MySQL on my mac. I know that the lowest setting in 5.7 will allows only eight characters. Is there any way to go around that? I type in...

I have a stored procedure that ran fine on MySQL 5.6. During a recent server migration we upgraded to MySQL 5.7.19. My stored procedure now throws the error: Expression #1 of SELECT list is not i...

I get the error ERROR 1067 (42000) at line 5459: Invalid default value for 'start_time' when running the following query DROP TABLE IF EXISTS `slow_log`; CREATE TABLE IF NOT EXISTS `slow_log` (...

I am making an application with Rails 5 rc1. Rails 5 support mysql 5.7 json datatype. add_column :organizations, :external, :json Suppose the value in this column is as follows: +--------------...

I recently upgraded to mysql 5.7 and observing frequent deadlock issue. Is there any change related to locking 5.7 because I didn't experienced this problem before. I have a simple table called r...

I have noticed a particular performance issue that I am unsure on how to deal with. I am in the process of migrating a web application from one server to another with very similar specifications. ...

In Ubuntu I had my.cnf file of MySQL 5.6 in /etc/my.cnf. But I can't find the same file of MySQL 5.7. From where can I find that? I did a find in entire / (root). But I couldn't find it anywhere....

I've recently upgraded my vagrant from ubuntu/trusty-64 to bento/ubuntu-16.04. With that MySQL was updated to 5.7. I've made several updates to my playbook, but I keep getting stuck when setting th...

I'm quite new to MySQL and learning fast. I installed WAMP on my system and have been using it for a month or so. I'm looking to upgrade MySQL to 5.7 as I will be in need of the new gis features bu...

We recently upgraded our percona 5.5 sql server to percona 5.7. Works out fine so far. unfortunately we have a huge query, which is extremly slower under 5.7. Under 5.5. it takes less than a second...

I have the following table pet in the database menagerie: +--------+-------------+---------+------+------------+------------+ | name | owner | species | sex | birth | death | +--------+-----------...

I am going to start a project where I need to generate dynamic google forms. The requirement for this project is I need to use mysql 5.7 so that I could use json datatype to store/retrieve json dat...

I am trying to change a MySQL column from varchar(9000) NULL to the new JSON data type in MySQL 5.7. The column holds valid JSON strings but some values are null. When I try the following: alter ta...

When it comes to database replication, what is the use of global transaction identifiers? Why do we need it to prevent concurrency across the servers? How is that prevention achieved exactly? I tri...

I'm using JSON object type on mysql5.7. I works well if I have a json object with one level, but if I have an object with an array of objects inside, I'm having problems to query for values in the ...

I've migrated my MySQL Database from 5.6 to version 5.7. Now I got a performance issue. Specific statement are executed in both versions and I noticed that 5.7 is significant slower. Especially wi...

I have a problem, for example in my system I have the next table: CREATE TABLE `sales` ( `id` int(11) NOT NULL AUTO_INCREMENT, `amount` FLOAT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB; -- is...