Hot answers tagged

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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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....
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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, ...
user avatar
  • 111

Only top scored, non community-wiki answers of a minimum length are eligible