Junction table or denormalize?
I’m using MariaDB.
mariadb
Mariadb Benchmarking – Low transaction and query per second
We have a MariaDB 10.3 on a Redhat Server (VM) with 90 GB Ram and 20 VCPUs. I’m trying to optimize the Database. I installed Sysbench for Benchmarking and after a 50 seconds test I got this values (with default MariaDB variables):
Create new MySql user with same grants as existing user
To create a new user usr_B with same grants as an existing user usr_A we can always SHOW GRANTS for usr_A and then GRANT those privileges to usr_B, but is there a built-in command for this purpose?
Command SHOW MASTER STATUS different in master and slave
I’m using Bitnami MariaDB. I’ve done fixing the replication and now both Slave_IO_Running and Slave_SQL_Running has value yes. This is the whole output:
Limiting and queueing the database connections
In mariaDB, is it possible to do something like this?
filter varbinary field by length
I am storing ips using VARBINARY(16) data type. I’d like to select just the ipv4 ips. Is it possible to filter column by the lenght used in VARBINARY (or VARCHAR)? Something like this
secure_file_priv and mysqlimport
Question: How can we avoid errors of the following type with mysqlimport when the data file is in the current directory?
MariaDB database has no ‘max_used_connections’
I have a running MariaDB which has no max_used_connections variable. How can I see it?
statistics on what queries were executed and how many times
I’d like to monitor how many times certain queries are executed. Take a look at the 3 queries below, the second and third are written as prepared statement.