Releem / mysqlconfigurer

Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.
https://releem.com
GNU General Public License v3.0
255 stars 27 forks source link

Releem Agent does not complete 1st run #86

Closed windsofchange closed 2 years ago

windsofchange commented 2 years ago

I installed the agent and ran it manually in screen. The agent does not complete 1st run! MariaDB CPU usage is at 100% mysql Ver 15.1 Distrib 10.5.15-MariaDB, for Linux (x86_64) using readline 5.1 3.10.0-962.3.2.lve1.5.66.el7.x86_64

Any thoughts?

$ /bin/bash /opt/releem/mysqlconfigurer.sh -k 2e343a02-378a-4e8b-acb8-e4e33905003d

drupaladmin commented 2 years ago

How many databases are on your server?

windsofchange commented 2 years ago

150

On Thu, 14 Apr 2022 at 10:08 AM Roman Agabekov @.***> wrote:

How many databases are on your server?

— Reply to this email directly, view it on GitHub https://github.com/Releem/mysqlconfigurer/issues/86#issuecomment-1098702133, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFRT4R5JPOO52N7WOMSGRVDVE6OK3ANCNFSM5TMQVOIQ . You are receiving this because you authored the thread.Message ID: @.***>

-- Sent from Mobile

drupaladmin commented 2 years ago

Yes, Releem Agent has the performance issue when collecting metrics on servers with the same database count. We are working on it.

Metrics collection may take a long time. Can you wait until Releem Agent collects all metrics?

windsofchange commented 2 years ago

Okay letting the process complete, will update once I have more.

Would be nice if the console output updated the db name it was processing, then we could actually understand where it was stuck

windsofchange commented 2 years ago

Several hours have passed the console output is still

Message ID: @.***>

drupaladmin commented 2 years ago

Did you wait until completion?

windsofchange commented 2 years ago

Yes managed to make it work, but it didn't have any suggestions :-(

drupaladmin commented 2 years ago

We known this bug