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):
As I said, I found a strange phenomenon when referring to other people’s projects,
My SQL query returns “subquery returns more than 1 row” error. To avoid “X-Y” problem I will omit what my query is, just focus on the data structure and what I want to achieve.
My json is of the format [“a”,”b”,”c”]. I want to write a sql query such that
I’ve been experimenting with EXPLAIN and noticed that the row count was big for our query so I tried adding an index to the VARCHAR column. First I added FULLTEXT but it ended up just making the query longer so I checked it with EXPLAIN and it was still showing all the rows. but when I tried to do EXPLAIN on the same table but using another indexed column which is an INT the row count was only 1.
What’s the best way to provide a MySql root password (~/.my.cnf) to cron job without root to have the home folder?
the server I’m using is centos
I am trying to optimise a query for fetching all game IDs where certain units (Archer, Cavalry, etc.) were present.
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?