CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 22:50:45 GMT
content-type: text/html; charset=utf-8
cf-ray: 9646fa716aa2f313-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=db06725c-e42c-45b9-8a11-6876150a2690; expires=Fri, 24 Jul 2026 22:50:45 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: cac841f3-c41f-457a-8028-3a4c1e19e676
x-worker-origin-response-time: 384000000
x-dns-prefetch-control: off
set-cookie: prov=db06725c-e42c-45b9-8a11-6876150a2690; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=hl2yt9w25cfKwuPQK41JzAElUzTNKGtdKkzwXtCKlvw-1753397445-1.0.1.1-er.BNYsuqH9a49z1Ih_XGkR_ADOuHpLHhlxSIjh0BdYEaPlSJJPlWB.BO.x_KknkgR7ti1PAYQkyTGEWZQQUarIcBXU6hSsHSPTIZF4rvNQ; path=/; expires=Thu, 24-Jul-25 23:20:45 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=zj8Ce8PV9El6vEBEtJbyOGKZxUMn24VemDx7Oew4Dik-1753397445737-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 ExchangeTeams
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
32
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
28
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
- Did Denmark report that 64% Palestinian refugees from 1992 received serious fines or jail time?
- Which domain (time or frequency) does filtering actually occur in real-life?
- Etymology of the word skulduggery?
- What is the DC voltage during regenerative braking in a battery–inverter–induction motor system?
- How to 'scale' a square list?
- Why is Shunt Voltage Reference (LM4040DBZ-3) Not outputting a stable 3V supply
- Access denied attempting to delete file on Windows Server
- Must hospitals care for unidentifiable individuals indefinitely?
- Distance of superdense color code circuits
- Why does my laptop's display turn off when I'm away from the keyboard?
- Macro Definition Outside Current Group
- Expected Sum of Remaining Dice After Removing Complete Sets
- A complex polynomial inequality
- How would you rank these shimano hubs (-tx505, -m3050, -mt500)
- Was Hermann Ganswindt's helicopter actually the first manned heavier-than-air motor-powered flight?
- How to move points in geometry nodes like a venetian blind?
- Why is `&self` allowed in the parameters of `&mut self` methods, but not `&mut self`?
- In what sense is the double negation topology functorial?
- What is that "T" in the pattern string of the date-command?
- Lilypond to MusicXML
- Can you yaw an airplane by only using differential thrust?
- Entity Framework - Is there a safety mechanism to prevent accidentally running Update-Database?
- Expected Value of a Dice Product Game
- What does this word "ahn-shdah-heh" mean?