Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysql-8.0]

MySQL version 8.0 - please also tag with mysql for search purposes.

MySQL 8.0 was released as stable (GA) with version 8.0.11 on 19 Apr 2018.

725 questions
39
votes
1 answer

What happened to MySQL 6 & 7?

With the recent release of MySQL 8, I can't seem to find any information about why version numbers 6 and 7 were skipped. Anyone know?
Talk Nerdy To Me
  • 505
  • 1
  • 4
  • 5
32
votes
3 answers

Why did MySQL remove the query cache feature after version 8.0?

Why did MySQL remove the query cache feature after version 8.0?
shaoyihe
  • 477
  • 1
  • 4
  • 8
26
votes
6 answers

Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

In mysqld.log I have thousands of lines like: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade So, according to virtually every post on the matter (and error msg itself): mysql_upgrade -u…
Roy Hinkley
  • 459
  • 3
  • 8
  • 15
15
votes
6 answers

Disable Binary Logs in MySQL 8.0

How can I disable binary logging on MySQL 8.0? I am needing to import a large MySQLDump file, and don't want to fill the Binary logs with many GB of data. In the past I would have set log_bin=0 in the my.cnf and restarted the database. But with…
IGGt
  • 2,266
  • 6
  • 35
  • 49
14
votes
1 answer

MySQL event scheduler waiting on empty queue since server restarted 12 days ago

I noticed a process on the server which has been running for more than 12 days, which I think coincides with the last time MySQL was restarted. mysql> SHOW FULL…
BadHorsie
  • 243
  • 1
  • 2
  • 7
12
votes
2 answers

Are enums still evil (in MySQL 8.0)?

So I have a disagreement with a coworker about using enums vs lookup tables. This very old article from 2011 and MyQL5.5 still gets referenced again and again by those not liking enums. But we are using MySQL8.0, on databases that are not that big,…
Florent Poujol
  • 223
  • 2
  • 4
12
votes
2 answers

Upgrade all MySQL columns, tables, and databases from utf8mb3 to utf8mb4

I have thousands of columns across hundreds of tables in about a hundred databases inside a MySQL instance that need to be upgraded from utf8mb3 to utf8mb4. Is there a way to generate ALTER statements for every table and column that needs to…
Stephen Ostermiller
  • 423
  • 1
  • 3
  • 10
11
votes
2 answers

Mysql 8 ST_GeomFromText giving error Latitude out of range in function st_geomfromtext. It must be within [-90.000000, 90.000000]

I am trying the following insert query on mysql 8. Insert Into fence Set fenceName='aa', radius=2, fenceGeometry=ST_GeomFromText('POINT(102.1893310546875 3.880696482497261)', 4326) It…
newbie
  • 217
  • 2
  • 7
10
votes
4 answers

What is the best alternative for MySQL Query Cache?

The Query Cache has been removed in MySQL 8. Is there any better alternative for Query Cache in MySQL?
Dipin V A
  • 109
  • 2
  • 7
10
votes
2 answers

My disk is full of binlog files

I just realized that my server is growing by 2 GB per day, which is not normal. I looked at my folder and the folder / var / lib / mysql reached 26 GB Normally it should be about 4 GB A month ago I migrated my MySQL 5.7 database to MySQL 8.0 I think…
ML61
  • 113
  • 2
  • 2
  • 7
9
votes
4 answers

How import mysqldump .sql file into MySQL 5.7 when exported from MySQL 8

I accidentally installed MySQL 8 and did a ton of work there, creating a lot of data. I then backed up all of the databases using mysqldump. Later, I realized that I needed to downgrade back to MySQL 5.7 (after not even having realized that I'd…
Ryan
  • 385
  • 1
  • 5
  • 13
9
votes
3 answers

Extreme performance loss due to moving from Mysql 5.7.23 to Mysql 8.0 (status, config included)

Been sitting on this for 12 hours straight (it's noon now, so I will read/respond when I woke up again). I have made the big fault of recommending a database upgrade of our productive environment to increase performance. We can NOT go back, it's…
John
  • 402
  • 1
  • 6
  • 16
7
votes
1 answer

I can't start mysqld.service -> status : Data Dictionary upgrade from MySQL 5.7 in progress in centos 7

I've installed mysql 8 on centos 7 and when i want to start the mysqld service , it says : Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details and…
Ali_Hr
  • 173
  • 1
  • 1
  • 6
6
votes
0 answers

Upgrade from MySQL 5.7 to MySQL 8 massive drop in performance occasionally

I have recently upgraded from MySQL 5.7 to 8 on several databases innodb engine with the same schema but different data hosted on RDS, performance was fine on all of them until the last one which was also the biggest but also has double the CPU…
Colm Canavan
  • 61
  • 1
  • 3
6
votes
1 answer

MySQL 8.0 Metadata Lock Extension for Foreign Keys causing requests to hang

We are using AWS RDS and we upgraded from MySQL 5.6.41 to MySQL 8.0.21 last December. Since mid-January, we noticed some problems causing our replica to be stuck after running migrations adding foreign keys to new tables referencing our main table…
Simon Ninon
  • 165
  • 4
1
2 3
…
48 49