Optimization and Tuning
Need help tuning your MariaDB database? Ask the experts!
Contact Us
You are viewing questions related to Optimization and Tuning.
Articles on how to get the most out of MariaDB, including new features.
Open Questions
-
10.6.7 INSERT INTO (SELECT FROM....) types of queries exponentially slower since upgrading from 10.1 to 10.6
For the most part upgrading to 10.6 was relatively pain free but there are ... -
Migrated from 10.1.22 to 10.6.7 and queries get stuck unless we manually analyze table.
TLDR: Migrated from 10.1.22 to 10.6.7 and queries get stuck unless we manua... -
Transparent Huge Pages
How do we fine tune Transparent Huge Pages? Is there a guideline that someo... -
When or Why to ANALYZE TABLE ?
We have migrated a few heavy databases from some earlier version of 10.2 t...
Answered Questions
-
tuning-primer.sh for MariaDB
Hello, Is there a tuning-primer.sh script, or something similar, compatible... -
GROUP BY trick has been optimized away
Group-by trick example: Find the most populous city in each state: SELECT state, city, pop -
Local socket communication, path in my.ini
Hello, I have a question about the path specification insite the my.ini con... -
What does SELECT do in the background ?
Hi. I am new in the MariaDB (and RDBMS) world. I am writing an API layer "... -
Limits in .frm
Does MariaDB implement anything to either split the content of the .frm fil... -
MariaDB 10.3.30 to 10.6
Hi Support, Recently we done MariaDB 10.3 upgrades to 10.6. We done before ... -
What are these files written in temporary folder /tmp/MYXFhjiU
So my db freezes up and even after restart it does not smooth out (it smoot...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.