Source evidence

Permissions for histograms

MariaDB Health Checks · support · 2023-05-25T14:05:00+00:00

MariaDB Health Checks plugin evidence original source source API

mixedsentiment

mediumseverity

0.78relevance

3replies

Evidence linked to opportunitycommercial context

Proof Health

Open evidence

Commercial opportunities need traceable source links before they are treated as build-worthy.

6 / 35 rows with source links

17.1% of this page's analysis has direct source links.

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

29 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

support

Steven Stern (sterndata) resolved

Assuming my db user is “user@localhost”, which tables and permissions does that user need in the “mysql” database? Seems to me it should not be able to see some of the tables (e.g., “user”). GRANT <what> on mysql.<which> to 'user'@'localhost'; This topic was modified 3 years ago by Steven Stern (sterndata) . There is a MariaDB Jira ticket for this which for some reason I can’t find right now, I’ll update when I can. For the Histograms button to work the user needs SELECT and INSERT access to the mysql.table_stats , mysql.column_stats and mysql.index_stats tables. This reply was modified 2 years, 12 months ago by Andrew Hutchings . Reason: markup typo Thanks. I’m able to run histograms now. No problem, I’ll mark this as resolved for now. But if you have any other issues please let us know.

Commercial Context

Opportunity

performance monitoring and client reporting

Performance speed regression monitoring for keeping sites fast and proving optimization work

Buyer: site owners, agencies, and maintenance teams

Wedge: detect performance slowdowns, cache conflicts, asset regressions, and client-report impact

Proof Blocked card complete market

Analysis

heuristic-v1

Summary: Permissions for histograms: users show bugs, performance, support pain that may indicate a product gap.

Evidence quote: Permissions for histograms Assuming my db user is “user@localhost”, which tables and permissions does that user need in the “mysql” database?

Affected feature: bugs

bugs performance support support

Plugin

API

MariaDB Health Checks

100 active installs · 3.2K downloads · rating 100.0

mariadb performance site health

Comments

3 shown

Andrew Hutchings 2023-05-30T10:13:00+00:00

There is a MariaDB Jira ticket for this which for some reason I can’t find right now, I’ll update when I can. For the Histograms button to work the user needs SELECT and INSERT access to the mysql.table_stats , mysql.column_stats and mysql.index_stats tables. This reply was modified 2 years, 12 months ago by Andrew Hutchings . Reason: markup typo

Steven Stern (sterndata) 2023-05-30T13:41:00+00:00

Thanks. I’m able to run histograms now.

Andrew Hutchings 2023-05-30T13:52:00+00:00

No problem, I’ll mark this as resolved for now. But if you have any other issues please let us know.