MARIADB-STRESS-TEST(1)

💖 MARIADB-STRESS-TEST 💖

okay bestie, so you know that one page in the MariaDB Database System manual? the mariadb-stress-test.pl one? yeah. we're doing that. sit down, hydrate, let's go 🫶

---

✨ NAME ✨

mariadb-stress-test.pl — the server stress test program. she's here to put your MariaDB server through it. lovingly. on purpose. 🦋

---

🌸 SYNOPSIS 🌸

mariadb-stress-test.pl [options]

---

👑 DESCRIPTION 👑

so mariadb-stress-test.pl is this Perl script and her whole job is stress-testing the MariaDB server. she shows up, she runs a ton of stuff at your server, and your server either thrives or tells on itself. either way you learn something. no cap. 💅

heads up tho: mariadb-stress-test.pl needs a version of Perl that was built with threads support. no threads, no vibes. that's just the deal.

you invoke her like this:

shell> mariadb-stress-test.pl [options]

and here's every single option she supports, no gatekeeping, we're going through all of them together. 🌈

---

🎀 OPTIONS 🎀

• --help — she prints a help message and dips. that's it, that's the whole thing. 😌
• --abort-on-error=N — this makes the program bail if it runs into an error whose severity is less than or equal to N. so if you set it to 1, she aborts on literally any error. zero chill mode, honestly iconic. 💀
• --check-tests-file — she'll periodically peek at the file that lists the tests to run, and if somebody changed it, she rereads it. super useful if you're updating the list of tests mid-stress-test and you don't wanna restart everything. main character behavior fr. ✨
• --cleanup — force a cleanup of the working directory. tidy queen. 🧚
• --log-error-details — logs the error details into the global error log file. receipts. she keeps receipts. 📝
• --loop-count=N — in sequential test mode, this is how many loops she runs before exiting.
• --mariadb-test=path — the path name to the mariadb-test program.
• --server-database=db_name — the database to use for the tests. default is test. classic.
• --server-host=host_name — the host name of the local host, used for making a TCP/IP connection to the local server. by default tho, the connection is made to localhost using a Unix socket file. so like, if you don't say anything, she's going the socket route. 🔌
• --server-logs-dir=path — this option is required. 😤 path is the directory where all client session logs get stored. usually it's the shared directory associated with the server you're testing. don't skip her, she will not run without her.
• --server-password=password — the password used when connecting to the server. 🤫
• --server-port=port_num — the TCP/IP port number for connecting to the server. default is 3306. you knew that. i knew that. we all knew that.
• --server-socket=file_name — for connections to localhost, this is the Unix socket file to use. or, on Windows, the name of the named pipe to use. default is /tmp/mariadb.sock. 🐧
• --server-user=user_name — the MariaDB user name to use when connecting to the server. default is root. yes, root. we're being bold today. 👑
• --sleep-time=N — the delay, in seconds, between test executions. lil breather. 😮‍💨
• --stress-basedir=path — also required. path is the working directory for the test run, and it gets used as the temporary location for result tracking during testing.
• --stress-datadir=path — the directory of data files used during testing. the default location is the data directory under the location given by the --stress-suite-basedir option. 📁
• --stress-init-file[=path] — file_name is the location of the file containing the list of tests that get run once, to initialize the database for the testing. if it's missing, the default file is stress_init.txt in the test suite directory. 🌱
• --stress-mode=mode — this one tells you the test order in stress-test mode. mode is either random, which selects tests in random order, or seq, which runs tests in each thread in the order specified in the test list file. default mode is random. chaos but scheduled. 🎲
• --stress-suite-basedir=path — required, bestie. path is the directory that holds the t and r subdirectories, which contain the test case and result files. this directory is also the default location of the stress-test.txt file that contains the list of tests. (you can point somewhere else with the --stress-tests-file option, if you're feeling spicy.) 🌶️
• --stress-tests-file[=file_name] — use this to run the stress tests. file_name is the location of the file containing the list of tests. if file_name is omitted, the default file is stress-test.txt in the stress suite directory. (see --stress-suite-basedir.) 🔗
• --suite=suite_name — run the named test suite. the default name is main, which is the regular test suite located in the mariadb-test directory.
• --test-count=N — the number of tests to execute before exiting. 🔢
• --test-duration=N — the duration of stress testing, in seconds. ⏱️
• --threads=N — the number of threads. default is 1. one. single. thread. pump those numbers up if you want the real chaos. 🧵
• --verbose — verbose mode! she prints more information about what the program is doing. she's an open book, an oversharer, and honestly? we love that for her. 💬

---

📜 COPYRIGHT 📜

Copyright © 2007, 2010, Oracle and/or its affiliates, 2010-2025 MariaDB Foundation

This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.

This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA or see http://www.gnu.org/licenses/.

not me putting the legal stuff in here too — but bestie, every word stays. that's the rule. 💛

---

👀 SEE ALSO 👀

For more information, please refer to the MariaDB Documentation, available online at https://mariadb.com/docs/

---

💜 AUTHOR 💜

MariaDB Foundation (http://www.mariadb.org/). the whole foundation. the legends. 🫡

---

okay that's the whole page, you're officially unstoppable 💅✨

MariaDB 11.8 · 5 March 2025 · MARIADB-STRESS-TEST(1) — mwah, go stress-test responsibly bestie, ily, byeeee 🎀🦋💖