| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 14:15:48 GMT
content-type: text/html; charset=utf-8
cf-ray: 9644081a3c5e75e9-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=b99e3a1e-7bad-4565-856c-e73d373288cc; expires=Fri, 24 Jul 2026 14:15:47 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: bd90a305-ee38-405e-a18a-4cb87c99f49d
x-worker-origin-response-time: 562000000
x-dns-prefetch-control: off
set-cookie: prov=b99e3a1e-7bad-4565-856c-e73d373288cc; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=3v3HZ20fTFPpUbt9Y0wPce6a2eXLgwn4BpuYkVFDj7w-1753366548-1.0.1.1-by0HRDsKT3W.Eqmh6xIcDLvE4rr6XNx0iTzfmFr1VRMQfGwSfX.Y799cJU8to9oXUwowSPJq0muZMcWLj.6nKySJ.2pFfyuGcQ65AhntkIw; path=/; expires=Thu, 24-Jul-25 14:45:48 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=OL47gUsDGPepjCfMQFN6.WsTXDNiNKHD1RTWNPegm4Q-1753366548137-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'mysql-8.0' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [mysql-8.0]
MySQL version 8.0 - please also tag with mysql for search purposes.
724 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
31
views
LIKE Operator optimization String % customer % [duplicate]
In MYSQL, I have a select query which is usually fetch the data from 4M records. There I'm using like operator with % and % this is not using indexing filter and reading total 4M records to fetch 2 ...
0
votes
1
answer
36
views
Editing in MySQL Views
In the project I am working on, there is a Booking table.
There are 8 types of Bookings.
I have elected to have just one table
There are 12 common fields
If I store the rest of the fields as columns,...
2
votes
0
answers
29
views
Usage of JSON in mySQL [duplicate]
In the project I am working on, there is a Booking table.
There are 8 types of Bookings.
I have elected to have just one table
There are 12 common fields
I could store the rest of the fields as ...
0
votes
1
answer
27
views
How to run MySql and MariaDB on same server
Background
I am using XAMPP, which has MariaDB on my Windows development machine. I cant remove this as I have a number of projects that depend and use this.
On my new project on AWS EC2, Windows ...
1
vote
2
answers
37
views
Can't update mysql users authentication plugin in Google Cloud SQL because root does not have SYSTEM_USER permission
I'm working on upgrading my Google Cloud SQL mysql instance from 8.0 to 8.4. I just upgraded it from 5.7 to 8.0 and now I'm trying to convert my user authentication plugins for my existing users from ...
3
votes
2
answers
145
views
MariaDB 10.5 Migration Questions
I have a question, and I've found one similar addressed, which I was going to respond to with my own questions (Live database migration MariaDB 10.5 to MySQL 8.0), however, as that post/question is ...
1
vote
1
answer
35
views
working of index in join query
My question is regarding the Explain output. Please refer the below query and its Explain command output
Explain
update
test.table1 t1
join test.table2 t2
on t1.field1=t2.field1
and t1.field2=t2....
1
vote
0
answers
25
views
Cloud SQL: gcloud sql export sql does not include procedures/triggers — alternatives?
How to export stored procedures and triggers from Cloud SQL without hitting production?
I'm using Google Cloud SQL (MySQL) and want to automate a nightly/weekly clone of the production database into ...
1
vote
2
answers
42
views
Unexpected occasional DEADLOCK when re-recreating database from split MySQL dump
To replace the content of a test database from a production database mysqldump output the following command was used:
cat mysqldump-db-thisdate.sql | mysql -p ... mydb
There has never been any issue ...
-1
votes
1
answer
136
views
MySQL 8.0.41 - 83 % Waiting for row lock on AO_319474_QUEUE
Environment
We run three Jira Service Management DC clusters that all share the same topology:
MySQL 8.0.36 on Ubuntu 22.04 – 32 vCPU, 100 GB RAM, buffer-pool now 80 GB (only ~33 GB in use), NVMe ...
1
vote
0
answers
55
views
ALTER TABLE ... REORGANIZE PARTITION on huge table takes longer after upgrading to MySQL 8.0
After upgrading from MySQL 5.7 to MySQL 8.0.33, I’ve observed a dramatic slowdown in partition management operations, particularly:
ALTER TABLE ... REORGANIZE PARTITION
ALTER TABLE ... DROP PARTITION
...
2
votes
1
answer
48
views
MySQL became slow overnight
I have a dedicated server running multiple website accounts via WHM/cpanel.
The server has 64GB of RAM and 20 cores. It has been running well for years. I can't think of anything that changed recently....
3
votes
1
answer
133
views
500 million is becoming a horrible negative number on replicas
I need some assistance understanding what looks like a corrupted value in replicas.
Here's the scenario: 1 primary database, 8 read replicas. Database is MySQL, deployed with Amazon RDS. There is a ...
0
votes
1
answer
68
views
Fluent Bit: Collect and parse MySQL slow query logs with Fluent Bit and send to Loki
I'm setting up a log pipeline to collect MySQL slow query logs using Fluent Bit and send them to Loki, where they can be visualized in Grafana.
Stack:
Fluent Bit: v4
Loki: v3.4.3
MySQL: v8.0
Sample ...
5
votes
3
answers
758
views
MySQL: Why doesn't the "use" command require ";" to be executed?
In MySQL 8 server community edition, here are examples of a SQL query and command in the MySQL Shell:
SELECT * FROM planet;
DESC planet;
SHOW DATABASES;
SHOW tables;
As you can see is mandatory to ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
mysql × 550
innodb × 63
mysql-5.7 × 51
query-performance × 40
performance × 32
index × 30
amazon-rds × 27
replication × 24
optimization × 22
mysqldump × 18
join × 17
mysql-workbench × 17
query × 15
ubuntu × 15
spatial × 14
aws-aurora × 13
mysql-innodb-cluster × 13
performance-tuning × 13
database-design × 12
mariadb × 12
stored-procedures × 12
linux × 11
mysql-5.6 × 11
alter-table × 10
more related tags
Hot Network Questions
- Distance Between Subspaces
- Ubuntu Server installation -- options for boot disks are grayed out
- Processing All Files [0-9]*tex
- Mars colony book I read in the 80's. The name?
- Console-based Casino Game in C++
- Axioms of quantum mechanics - intuitive explanation
- Did Germany declare the Donetsk People’s Republic to be a terrorist organization, at some point?
- Write two very different programs with the same characters
- Can you yaw an airplane by only using differential thrust?
- List Based Off Another List
- Why were two 2x6 boards installed on top of a window rough sill?
- How to expand an algebraic function like √R(x) into a continued fraction in Mathematica?
- Guitar Intonation - Flat On Certain Frets
- Is the surface of Mars or the Moon mostly (or relatively) homogeneous, unlike the Earth?
- A soviet sci-fi novel (novelette?) with frogs?
- Access denied attempting to delete file on Windows Server
- How to model This Twisted Torus?
- Expected Value of a Dice Product Game
- Why does “brew search” for “peertube” match with “freetube”? How does the search work?
- Can one engage with physics (or science) without touching philosophy?
- A word that describes some people
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- Is there a formal threshold for when a variable is considered 'random' in statistics? What is it?
- How to \input file as arguments?