danhuawang commented on issue #8089:
URL: https://github.com/apache/gravitino/issues/8089#issuecomment-3190525852

   > [@danhuawang](https://github.com/danhuawang) I'm wondering how many rows 
in `role_meta` and `user_role_rel` ?
   > 
   > And would increasing `maxEntries` help ?
   > 
   > ```
   > gravitino.cache.enableWeigher = false
   > # increase to 100k entiries
   > gravitino.cache.maxEntries = 100000
   > ```
   > 
   > Further more, if you enable cache stats,
   > 
   > ```
   > gravitino.cache.enableStats = true
   > ```
   > 
   > could you share the Gravitino server log ? It contains cache statistics, 
which helps a lot while debugging.
   
   ```
   mysql> select count(*) from role_meta;
   +----------+
   | count(*) |
   +----------+
   |        3 |
   +----------+
   1 row in set (0.00 sec)
   
   mysql> select count(*) from user_role_rel;
   +----------+
   | count(*) |
   +----------+
   |       10 |
   +----------+
   1 row in set (0.00 sec)
   ```
   I  increased to 100k entiries  , it didn't help. 
   
   ```
   # THE CONFIGURATION FOR Gravitino Entity Cache
   gravitino.cache.enabled = true
   #gravitino.cache.maxEntries = 10000
   gravitino.cache.maxEntries = 100000
   gravitino.cache.expireTimeInMs = 3600000
   gravitino.cache.enableStats = true
   gravitino.cache.enableWeigher = false
   gravitino.cache.implementation = caffeine
   ```
   FYI
   
[gravitino-server.log](https://github.com/user-attachments/files/21783572/gravitino-server.log)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to