| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 13:26:44 GMT
content-type: text/html; charset=utf-8
cf-ray: 963b82dfbda7c1b5-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=4c097764-4081-4320-b13a-dd0836a71152; expires=Thu, 23 Jul 2026 13:26:44 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: 81870ae6-c0f8-40f8-bcbb-9c1803f8fd28
x-worker-origin-response-time: 519000000
x-dns-prefetch-control: off
set-cookie: prov=4c097764-4081-4320-b13a-dd0836a71152; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=Odj9mtX9V7fb.du0yQvvVktsVS1i8W_BfdPPsVsLxV8-1753277204-1.0.1.1-q9dTjM2hJZwc.YQ2yfBnJtOt0mTasvLKrZe8h6THZNd8U2ikw2Qa9BefOew0cGrAuTJASGjvYknpTfuenBIQqfSdtDWTJbEh77hx4Rq7eX8; path=/; expires=Wed, 23-Jul-25 13:56:44 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=BXhKLaYG16Z85PFE_1qjrvuhYh4KuEa4jXl.ncrLxxo-1753277204993-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
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,842 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
1
answer
31
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
38
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 ...
- 101
0
votes
1
answer
20
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
23
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
22
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
27
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
64
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
29
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
39
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
82
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
59
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
46
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
52
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 ...
3
votes
1
answer
55
views
How to verify a clean MariaDB shutdown in logs before a major version upgrade?
I'm preparing for a major version upgrade on a fleet of MariaDB databases from 10.11 and 11.4 to 11.8. A clean shutdown is critical for data integrity in MariaDB as the new major version will refuse ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
mysql × 1408
innodb × 235
galera × 215
replication × 204
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 × 33
foreign-key × 33
mariadb-10.6 × 33
more related tags
Hot Network Questions
- Ubuntu Server installation -- options for boot disks are grayed out
- TeX development in C instead of Pascal
- What are these pastries pictured in the "Austria" article in the World Book Encyclopedia?
- a stray не in this sentence?
- What does this "lightbulb-ish" symbol mean in figure 1 of the Diffie Hellmann paper?
- Business technical issues lead to unsuccessful payment being considered successful. Do I have any duty to notify?
- When you view a historical event with an incorrect modern lens
- How does Rav Kotler assign final letters in 5 cases in Vayikra-Bamidbar?
- Not sure which test statistic to look at with regression with interaction term
- How to expand an algebraic function like √R(x) into a continued fraction in Mathematica?
- Which domain (time or frequency) does filtering actually occur in real-life?
- Is buying random stocks and then selling off the ones that go down a good way to reduce capital gains tax?
- Is it better to nest figure environments inside proof environments, or leave them separate?
- A soviet sci-fi novel (novelette?) with frogs?
- What was the Russia-Germany 1996 "Defence pact" that Russia recently announced has been terminated?
- Etymology of the word skulduggery?
- In QGIS installed via OSGeo4W on Windows 11, what is the path to the command history file for the Python console?
- Fit text on TWO pages by varying font size automatically
- Write two very different programs with the same characters
- What fiction genres do literary agents recognize?
- Prevent equation label from shifting down
- Is there a way to retrieve my inventory from the void in Minecraft Java Edition?
- Repository with SQLite in Python
- What is that "T" in the pattern string of the date-command?