MariaDB ability to work in parallel across multiple db users
Each connection is controlled by its own limits.  The limits are initialized by global settings, but run independently for each connection.

Separate connections will be accessing common resources, so there will some contention (CPU, I/O, etc), but not of the type you described.

"What you do in Vegas stays in Vegas."