| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 31 Jul 2025 12:24:17 GMT
content-type: text/html; charset=utf-8
cf-ray: 967d1264c86aa403-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=0af3cc6c-606e-44fc-92b9-2966c54b00d4; expires=Fri, 31 Jul 2026 12:24:17 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: a1f65d0a-05bd-459b-b3f0-c192638c9fa4
x-worker-origin-response-time: 477000000
x-dns-prefetch-control: off
set-cookie: prov=0af3cc6c-606e-44fc-92b9-2966c54b00d4; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=_fALOMzcYwhUpyXw62cdOw_SnH6lacoOprU5zrSM1vU-1753964657-1.0.1.1-q4XA_gq1uqcpomAfFeZA6DOoSBsDHV_kPtAXLp9W9zX16uHjwx97dNh.3daPzJD1zahV5BbtP5ldDQmxQi.Tl9T52NqJbyE2o1wIBWA9oWI; path=/; expires=Thu, 31-Jul-25 12:54:17 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=cCDjICk240O5hOQ5amZSyN15Yl3b3uevLHisUpGFmrs-1753964657909-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'mariadb' 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
The 2025 Developer Survey results are in. Explore insights into technology and tools, careers, community and more.
View results.
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 [mariadb]
Open source RDBMS that forked from MySQL. Add a version-specific tag like mariadb-10.5 if that context is important.
2,843 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
24
views
cluster vs replica in mariadb or mysql
I'm confused between two words of cluster and replica in mariadb.
I saw some tutorial and they explain cluster or replica.
Is replica same cluster or not?
If not , please explain their diffrences.
1
vote
1
answer
53
views
mariadb docker fails to Initialize database contents from dump file
I have a Nextcloud server set up that uses docker image mariadb:10.11. I use mysqldump to back up the database. Where I am having trouble is trying to restore that to a test system as described here ...
0
votes
1
answer
58
views
Why my MariaDB table file uses more space when PAGE_COMPRESSED is enabled?
I am exploring ways to save some disk space because some of our databases are getting larger and larger. The two ways available in MariaDB seem to be: table compression and page compression. My take ...
- 103
0
votes
1
answer
24
views
MariaDB: Engine-independent statistics are not collected for column
In the course of optimizing my MariaDB database I have tried the following query (found in this blocg post):
ANALYZE TABLE <my_table> PERSISTENT FOR ALL;
The command runs without an error, ...
0
votes
1
answer
24
views
Locking down MariaDB for local development environment from external hosts?
I recently came across this little gem of an SQL query for MariaDB:
SHOW GLOBAL VARIABLES LIKE 'log_error';
I get that there are tons of bots on the Internet and so I expected what I saw on my live ...
-1
votes
0
answers
23
views
Increase tmp_table_size/max_heap_table_size does not improve Tmp_Tables_ToDisk percentage [duplicate]
I am using MariaDB 10.6.19.
Below is my.cnf settings:
[mysqld]
performance-schema=0
max_connections=1500
max_user_connections = 1200
query_cache_size = 64M
skip-external-locking
key_buffer_size = 64M
...
0
votes
0
answers
29
views
Increase tmp_table_size/max_heap_table_size does not improve Tmp_Tables_ToDisk percentage
I am using MariaDB 10.6.19.
Below is my.cnf settings:
[mysqld]
performance-schema=0
max_connections=1500
max_user_connections = 1200
query_cache_size = 64M
skip-external-locking
key_buffer_size = 64M
...
1
vote
2
answers
77
views
How to set MariaDB to automatically kill long-running SQL queries?
I created a test query to do some counting but five minutes of execution time is ridiculous! So I figured there must be a maximum execution time setting somewhere however the two things I found and ...
1
vote
1
answer
30
views
How to prevent MariaDB from restarting service on Windows after I've manually stopped it?
I am doing resiliency tests for processes that easily take long enough that the user will just walk away and come back minutes if not hours later. I need to emulate something in my system failing so I ...
1
vote
0
answers
40
views
MariaDB: Drop database ddl-trigger in two-way replication setup
I have a database replication setup in MariaDB where the main database is replicated fully to the secondary database, and only a single table is replicated back in the opposite direction. I achieved ...
-2
votes
2
answers
87
views
Dayofweek vs weekday [closed]
Why does MariaDb use these terms differently?
#drop table dbstructA;
create table dbstructA(datum date);
insert into dbstructA values('2025-01-01');
insert into dbstructA values('2025-...
1
vote
0
answers
29
views
How to move binary logs to a new directory
In my MariaDB setup, I have two servers configured in a master-slave replication. In the my.cnf configuration file on the master, I've set log_bin = /path/to/logbin. However, I later realized that the ...
- 163
-1
votes
1
answer
61
views
Find an authoritative statement that MariaDB fully supports the SQL:2016 JSON feature set
A software vendor refuses to support MariaDB on the grounds that they need JSON support, but that "JSON is not inherently included in the basic SQL standard, but it is part of the SQL:2016 ...
3
votes
0
answers
49
views
Is it best to prepare a MariaDB backup right away, or wait until restore is needed?
Using MariaDB 11, consider a backup strategy as follows:
Monday - Full
Tuesday - Incremental
Wednesday - Incremental
Are there and advantages or disadvantages of "preparing" the backup ...
0
votes
1
answer
59
views
MariaDB installation setting lower_case_table_names
I had MySQL installed on Windows 11 with lower_case_table_names=2 to preserve mixed-case table names. To migrate to MariaDB, I backed up the database with mysqldump. When installing MariaDB using ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
mysql × 1409
innodb × 235
galera × 215
replication × 205
performance × 143
query-performance × 97
index × 94
mariadb-10.1 × 79
mariadb-10.3 × 79
mysqldump × 76
database-design × 68
mariadb-10.5 × 66
backup × 65
optimization × 65
query × 57
join × 56
linux × 56
mariadb-10.2 × 43
ubuntu × 38
myisam × 37
trigger × 37
clustering × 34
foreign-key × 33
mariadb-10.6 × 33
more related tags
Hot Network Questions
- How do I attach non-edible flowers to cake?
- Right size rim tape when converting MTB to tubeless
- How to create a Face Group from selected faces, similar to a Vertex Group
- What are these orange and green solid circles painted on a taxiway?
- What is the difference between Render Distance and Simulation Distance?
- Eleven Special Flashcards
- How Does Code Reuse Work at NASA
- Golden-section optimization with complication
- Interpretation of the lorentz-invarient transition rates (LI Fermi's Golden Rule)
- Is Samson referred to/mentioned in the siddur/liturgy?
- Why f[x___] := {x==="To be", x=!="not to be"} is both True for f[]?
- Using `find` to find a file in PATH
- When using Da Capo, does that normally include a pick up?
- General Two-dimensional Elliptical Gaussian Image Generator in C++
- Can Trump sue South Park?
- Chopin Op 66 fantaisie-Impromptu - "ed. accel." - what does it really mean?
- Is it common practice to run neutral and ground to the same bar?
- How did Gauss study mathematics?
- What are ways to prevent overly long ballots?
- "One can" in technical writing--good, bad, indifferent?
- Probability that median of 3 randomly selected numbers from {0,1,2,3} is between 1 and 2
- Was the Silk Road really a conduit of ideas?
- How to cite two part paper with different order of authors?
- Seven-dimensional cross product