Can you help me speed up the selection when searching by square with latitude and longitude?
There is a request like this:
Can you help me speed up the selection when searching by square with latitude and longitude?
There is a request like this:
How can I group results where string has the same 6 characters from a total of 7 in MySQL/MariaDB?
I have a table that consists of vehicle plates, where all the plates have always 7 characters.
Sometimes a plate was miswritten and so my SELECT query must be able to consider that “AAU1234″ and “AAV1234″ must be the same vehicle.
I don’t want to create rules between specific characters, like “U” and “V” or “I” and “1”, but a rule able to group plates where 6 of the 7 characters are equal and in the same position.
Columns to rows in one scan and one query
With an example table (> 20M rows) like this :
Query not executing when I press enter in XAMPP
enter image description here
MariaDB Query takes longer than same DB in Mysql
I am migrating a Db from Mysql 8.0.23 to MariaDB 11.3.2 and I realize that some queries needs longer in MariaDB than in Mysql. It is the same query and same DB structure. In MariaDB I need to get a response o this quera 3.5 seconds and in the mysql server only 0.8 seconds. I perform a Explain and Analyze command and I saw that the run procedure are different. Because I would proceed to see how many rows are evaluated, and create some indexes but I dont the rows evaluated are similar. How can I optimize the mariaDB db? Have you any hints how to proceed to optimize the db? Thank you in advance!
GRANT SELECT ON needs IDENTIFIED BY
https://glpi-install.readthedocs.io/en/latest/timezones.html#grant-access
Why is MariaDB default configuration has slow queries but cpanel mariadb is so much faster?
I’ve always used cPanel on all my systems, but I decided to make my own server and install everything from scratch and I noticed that some select queries were MUCH slower, and that didn’t happen on cPanel MariaDB, is there any configuration I have to make to speed up my MariaDB SELECT queries speed? I think it is not using all cpu or memory to execute queries
I tested both with the same RAM/CPU amazon server
MariaDB SELECT only user cannot connect
I have created a SELECT-only login for a MariaDB database hosted on AWS RDS, named data with a password, and permission to connect from any host. The login should be able to connect to the server and SELECT only from all tables & views in a database named erp. The login should also be able to read view definitions.
MARIADB How to transponse rows to columns without prepared stataments
I am trying, in MariaDB, to transponse a unknow number of rows from a query to columns in order to get a single row.