CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 20:00:00 GMT
content-type: text/html; charset=utf-8
cf-ray: 963dc2f0ebf395be-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=a731e183-988b-4854-b10a-4e2eed638944; expires=Thu, 23 Jul 2026 20:00:00 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: 79c78269-1b2e-4f91-9f67-b51631c99a3e
x-worker-origin-response-time: 462000000
x-dns-prefetch-control: off
set-cookie: prov=a731e183-988b-4854-b10a-4e2eed638944; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=vMSAGu.ucINlsFIrM0PFiKPBgudZWUJ4q8gCM7W3kLE-1753300800-1.0.1.1-zPUdKTVqhPOw1qncurdZsqPDUT5fV1mJ1hxjs3nRqc60f4N33xUsAalUDrF524TjDWb.sp4fnKrzniB9SWRWdEDde.P.3270ou.1_UH3g0U; path=/; expires=Wed, 23-Jul-25 20:30:00 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=S6w_yhenvSSAuuU8RO.PpS00XXqkZHcm9qcUV2DVqW0-1753300800616-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
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
- What is that "T" in the pattern string of the date-command?
- Business technical issues lead to unsuccessful payment being considered successful. Do I have any duty to notify?
- Etymology of the word skulduggery?
- Is a chemistry-first technological paradigm as plausible as one focused on physics or biology?
- In QGIS installed via OSGeo4W on Windows 11, what is the path to the command history file for the Python console?
- At Helsinki airport, connecting from Schengen to non-Schengen flight, is there exit immigration?
- How much power does the Fed chair have over interest rates?
- Did Webster's Dictionary define Fascism by its relationship to corporations until 1987?
- Why does contact with the ground make my touch-activated LED brighter?
- When you view a historical event with an incorrect modern lens
- Is there a smooth function approximating the minimum of a constant and a variable?
- What was the Russia-Germany 1996 "Defence pact" that Russia recently announced has been terminated?
- Why is my gooseberry jam so stiff?
- Console-based Casino Game in C++
- Why is this endgame winning for Black?
- Can you identify this shell case from Flanders?
- Was the double prehung exterior door on my shed installed backwards?
- Finding the value of collector resistor
- Ubuntu Server installation -- options for boot disks are grayed out
- Why “brew search” for “peertube” machtes with “freetube”? How does the search work?
- Must hospitals care for unidentifiable individuals indefinitely?
- bootstrapping for variance estimation takes too long
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- What was the source of the image of pelican in Catholic churches?