Questions tagged [MariaDB] (185)

3
answers

Which way is the configuration file of mariadb on CentOS?

Which way is the configuration file of mariadb on CentOS ?
melody.Heathcote asked April 19th 20 at 12:41
3
answers

To restrict the connection to database?

Hello friends. Question : how to limit number of connections to the database (please don't kick me) Have VPS -центос7 control panel Vesta-Apache-nginx-MariaDB In control panel there is a fad SERVER configuration MARIARI but here is empty, and setting and maintaining the fields are empty here is the screenshots what do I ...
Nya.Considi asked April 19th 20 at 12:26
1
answer

How many concurrent transactions you can perform to the same tables?

Hi all. I have a question about transaction performance. Suppose there is a script which takes a sample of 6 tables and then does inserts in 4 other tables. The whole scenario (including SELECT queries) is wrapped in a transaction. This scenario is parallel to execute 500 threads. START TRANSACTION; SELECT f FROM t1; SEL...
kane.Kub48 asked April 19th 20 at 11:54
1
answer

How to fix warning mariadb?

After changing the password on root started to appear this warning in the error file mariadb * [Warning] Access denied for user 'root'@'localhost' (using password: NO) * [Warning] Aborted connection * to db: 'unconnected' user: 'root' host: 'localhost' (CLOSE_CONNECTION) In the server settings is disabled the reverse resolv...
susanna.Walter asked April 16th 20 at 11:06
0
answer

How to use plugins in adminer?

I need to log in to the database without a password, with version 4.6.3 adminer has disabled the ability log in to the database without a password (on the database password is not set) https://www.adminer.org/en/password/ There are two options, to use the plugin login is password-less or login-ip But I don't understan...
granville.Dibbert asked April 16th 20 at 10:53
2
answers

How to change the max_connections setting when configuring it in my.cnf is ignored?

Bring your the value of the parameter max_connections in my.cnf, but after restarting the service setting is "default" - ~200. OS: CentOS 7. my.cnf lies in /etc/my.cnf Server is VestaCP, even changing via the editor - details are ignored. Config editor MariaDB in Vesta If you change using the SQL command - is working, bu...
gilbert.Ondricka50 asked April 8th 20 at 18:17
0
answer

How to organize the storage of such structures in a database?

I need to create a match table 64мерный vector<--->varchar. How to create a suitable for this table. And how to search for such a table if it will be around half a billion values. For 64-mergau space.
maynard_Grah asked April 8th 20 at 17:51
4
answers

How to organize your pagination if a database and a search engine is a separate services?

Good all the time. How can we arrange pagination query, filtered simultaneously on the full-text query and some arguments, if a search machine for full-text search and the database is separate services? The emphasis is not notice of the decision, although the feeling that it's right. Details: MySQL server (MariaDB 10.3+) ...
leslie.Shiel asked April 8th 20 at 17:15
2
answers

Whether to move to Percona server with MariaDB/MySQL?

Good day! On the centos7 server turns a couple of small projects on mariadb 5.5.60-1.el7_5. Up for: 109d 21h 37m 7s (1B q [176.802 qps], 36M conn, TX: 7257G, RX: 139G) Reads / Writes: 99% / 1% Physical Memory : 3.7 G Data in MyISAM tables: 343.9 M (Tables: 19) Data in InnoDB tables: 1.6 G (Tables: 620) Everything seems to...
eleonore asked April 8th 20 at 10:36
0
answer

How to remove validation for password in MariaDB on a Synology?

Working with a local server MariaDB on a Synology problem. not a practical feature - zamedlennoi validation password not only for root, and for all new users. Password requirements - a minimum of 10 characters, uppercase and lower case + numbers + special characters. I will create your own password of 8 letters and numbers ...
kennith.Mitchell asked April 8th 20 at 10:02