| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 12:26:57 GMT
content-type: text/html; charset=utf-8
cf-ray: 963b2b4d5b0bc19f-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=2ba74b9e-d9af-453e-9435-10cd74dfe6cd; expires=Thu, 23 Jul 2026 12:26:57 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-frame-options: SAMEORIGIN
x-request-guid: 0dca5bd4-8dfa-42a2-a901-f06396c93d0b
x-worker-origin-response-time: 442000000
x-dns-prefetch-control: off
set-cookie: prov=2ba74b9e-d9af-453e-9435-10cd74dfe6cd; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=FK857w5Gjn0sI1RBndL9K7somMIyC.ROtvFZ4I1XNmg-1753273617-1.0.1.1-Vt3LlE.mRSpKqEUH4pbECbcqr6omrskWcc7qpxJMeGK.eP9Yz_TKaUq_.fpRNdnzo0k_LSm35sCaU2v32ru0DZ.S5i09EOBpEyABmtExKfc; path=/; expires=Wed, 23-Jul-25 12:56:57 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=wKpu4a9TWYa5iuIWS3QL5OPdtuE.54mNZD0.LATeIT0-1753273617961-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'mysql' 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]
All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.
22,448 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-1
votes
1
answer
26
views
Not able to start Mysql located into many places
How can i start mysql in Ubuntu? i run whereis and more than one place where mysql is located :
(base) myuser@mypc:~/Documents/mysql-tutorial$ whereis mysql
mysql: /usr/bin/mysql /usr/lib/mysql /etc/...
0
votes
0
answers
46
views
0
votes
1
answer
18
views
mysqlbinlog not applying updates for PITR
I'm running Percona MySQL 8.0.42-33 on RHEL 9.6.
I have a problem when attempting point-in-time-recovery, where I can restore the database from the mysqldump backup, but the application of the binlog ...
0
votes
0
answers
29
views
mySQL fails to configure itself
ALL,
My problem lies somewhere between here and Linux admin. I want to start here and if I'm wrong I will gladly move to Linux server.
I'm trying to install/configure mySQL server on Gentoo Linux.
...
0
votes
2
answers
34
views
MySQL 8.0.35 mixed GTID replica/primary node: how to make primary tables replicate not just replica tables to downstream replica
LATER ADDITION: I resolved with a reset master on surface which I had been hesitant to execute because it might negatively impact replication to offsite which it did. Hopefully that simpler ...
0
votes
0
answers
30
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 ...
2
votes
1
answer
142
views
Get minute of the day in MySQL
I'm using this to get the minute of the day from a datetime field:
(HOUR(datetime) * 60) + MINUTE(datetime)
It works but I am concerned there may be edge cases where it returns the wrong value. Is ...
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
20
views
Create a script for changes from one database to another on same server
I had been using the Tracking feature in MariaDB to collect the changes I have made to the database on my PC and then applying the script to a database on the production server.
Now I have MySQL on my ...
2
votes
1
answer
355
views
Best data type for checking “created_at + 30 minutes” in high-frequency MySQL range scans
I’m working on designing a MySQL table to handle time-based processing logic. The main use case is:
Use case:
Each row has a created_at timestamp.
I run a background job (cronjob or worker) every 1 ...
- 23
1
vote
1
answer
28
views
Active Transactions holding locks, but no active thread or process - Azure MySQL
I'm having an issue with some MySQL transactions that are holding locks but apparently are not an active session and don't have an active thread.
I can see the locks being held using ...
2
votes
1
answer
138
views
How do I select standard password in Adding a User
Using MySQL 8.4.5 and MySQL Workbench 8.4.0
I am trying to create a user and I want to use standard password for now. But the Authentication Type only shows caching_sha2_password.
How do I get it to ...
5
votes
1
answer
515
views
`ALGORITHM=INSTANT` doesn't fail even for non instant operation
According to Performance and Space Requirements - ALTER TABLE, ALGORITHM=INSTANT is described as (emphasis mine):
INSTANT: Operations only modify metadata in the data dictionary. An exclusive ...
0
votes
0
answers
19
views
Why do I seem to get only some of the data loaded into the table using LOAD LOCAL INFILE command from a text file?
Full List of Sample Data
"Laptop Pro","Electronics",1299.99,50,"TechCorp"
"Wireless Mouse","Electronics",29.99,200,"TechCorp"
"Office ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
innodb × 1999
performance × 1729
database-design × 1453
mariadb × 1408
replication × 1360
query-performance × 946
mysql-5.5 × 942
mysql-5.7 × 829
mysql-5.6 × 826
index × 815
join × 750
optimization × 715
mysqldump × 663
mysql-8.0 × 550
php × 545
backup × 506
myisam × 473
select × 456
query × 435
trigger × 422
mysql-workbench × 414
amazon-rds × 406
stored-procedures × 377
linux × 348
phpmyadmin × 330
more related tags
Hot Network Questions
- Etymology of the word skulduggery?
- Did Germany declare the Donetsk People’s Republic to be a terrorist organization, at some point?
- Not sure which test statistic to look at with regression with interaction term
- In QGIS installed via OSGeo4W on Windows 11, what is the path to the command history file for the Python console?
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- Why Schrodinger wave equation is totally different from classical wave equation?
- Define command valid only for a specific environment in expl3
- I wonder whether there exists a book of "Formal power series" and "Formal infinite products"?
- Is it better to nest figure environments inside proof environments, or leave them separate?
- Is buying random stocks and then selling off the ones that go down a good way to reduce capital gains tax?
- Story about a room on Mars that contains God
- TeX development in C instead of Pascal
- A word that describes some people
- How to 'scale' a square list?
- Prevent equation label from shifting down
- Is there a way to retrieve my inventory from the void in Minecraft Java Edition?
- How can I grow kelp or seaweed at home in a small container?
- Is there a smooth function approximating the min of a constant and a variable
- What was the Russia-Germany 1996 "Defence pact" that Russia recently announced has been terminated?
- a stray не in this sentence?
- Why is my gooseberry jam so stiff?
- What is the consistency strength of Russell & Whitehead's ‘Principia Mathematica’?
- Make a Mulenère encryption program
- Where did the baby AT motherboard format come from?