teyeheimans commented on issue #9899: URL: https://github.com/apache/druid/issues/9899#issuecomment-1727138739
We have exactly the same issue. We see that the max length of the payload is around 6000 characters. Maybe it's a good improvement to change the column type of the `payload` column from `longblob` to `varchar(10000)`? As I understand from the MySQL manual, BLOB columns are not kept in memory. We have also begun to re-index our segments. We have changed the segment granularity from hour to day or even month, which decreased the number of segments. For other people who find this topic, this is something which is a good solution for it. And kill unused segments as the topic starter also suggested. -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
