2
votes
Limiting and queueing the database connections
max_connections sets a limit. back_log, in theory, provides a queue of pending connections.
But, in reality, you should change your clients to be less demanding. If you let hundreds of connections ...
- 68.1k
2
votes
Accepted
Limiting and queueing the database connections
In addition to the old resource limits inherited from MySQL, MariaDB grant limits can include MAX_STATEMENT_TIME (in seconds), for each query.
There is also wait_timeout and interactive_timeout to ...
- 6,380
2
votes
Keep procedure running even connection dies?
One solution could be to use the EVENT system:
Events are named database objects containing SQL statements that are to be executed at a later stage, either once off, or at regular intervals.
They ...
- 201
1
vote
Accepted
Junction table or denormalize?
A junction table isn't going to affect your performance here, especially with a process that only runs at a frequency of every hour.
NoSQL doesn't buy you any advantage here either, and IMO should ...
- 24.1k
1
vote
mariadb: innodb_file_per_table=On and still have a huge ibdata1
Caveat: I don't use MariaDB, so I don't have in my recall which versions of MariaDB have some of the features I describe below regarding the system tablespace. MariaDB started as a fork of MySQL and ...
- 9,258
1
vote
Accepted
Create new MySql user with same grants as existing user
Rather than copying the grants over, consider creating a "role" with suitable privileges. Then GRANT a role TO a user.
MySQL:
https://dev.mysql.com/doc/refman/8.0/en/roles.html
https://dev....
- 68.1k
1
vote
Accepted
Mariadb Low transaction and query per second
I notice you have 20 CPU cores, but you're only running sysbench with 2 threads. You probably can get better results with more threads. The guideline often given is 2x the number of CPU cores, so try ...
- 9,258
1
vote
MySQL's maximum memory usage is dangerously high
Analysis of GLOBAL STATUS and VARIABLES:
Observations:
Version: 10.2.43-MariaDB-log
7.6 GB of RAM
Uptime = 00:49:57; Please rerun SHOW GLOBAL STATUS after several hours.
153 QPS
The More ...
- 68.1k
1
vote
How can I prevent mysqldump from prepending the database name in CREATE VIEW?
The user who asked on How to prevent MariaDB mysqldump from prepending database name in CREATE VIEW?, reported this issue on mariadb's jira
It seems to have been fixed on Versions 10.3.35, 10.4.25, ...
- 111
Only top scored, non community-wiki answers of a minimum length are eligible