Hot answers tagged

2 votes

innodb_buffer_pool_size complications

You don't need to calculate the pool size. Set innodb_buffer_pool_size to the total RAM you want to allocate to the buffer pool. Let MySQL calculate the pool instances and chunk size. MySQL does this ...
Bill Karwin's user avatar
  • 13.8k
1 vote

cpulimit/iolimit per mysql/mariadb user

As there's a pool of MariaDB threads, there's no fixed allocation to a user that could be used a cgroup limit. Internal resource limits on users can apply and achieve CPU based limits in some crude ...
danblack's user avatar
  • 7,649
1 vote

how to speed up and optimize mysql search with indexes

Possible solution: FULLTEXT(codfabrica, codoriginal, aplicacao) and MATCH(codfabrica, codoriginal, aplicacao) AGAINST("various possible values" IN BOOLEAN MODE) The reason for ...
Rick James's user avatar
  • 76.9k
1 vote

Reset root password in MySQL

ALTER USER 'root'@'%' IDENTIFIED WITH caching_sha2_password BY 'password'; This worked for me.
datascinalyst's user avatar
1 vote

MySQL query optimisation

To speed the query up a little bit you could add a where clause based on your comment Is "" always at the beginning of jid? Yes The jid column is already indexed and the following ...
Ergest Basha's user avatar
  • 3,780

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