Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
11.4.4
-
None
-
almalinux 9.5
Description
Hello,
Sorry I am not expert at raising bugs here but I decided to create my one because my DB server often crashes due to simple requests, when scanned rows are significant, even after several build upgrades.
I could reduce a request to the minimum:
SELECT
|
concat(DATE_FORMAT(`b`.`contactDate`,'%Y'),'-Q',quarter(`b`.`contactDate`)) as `contactDate`, |
group_concat(distinct `state_string`) as `concat_state_strings` |
|
|
FROM
|
`jbm_adobe_campaign`.`dlv_kpi_xx` `a`,
|
`jbm_adobe_campaign`.`dlv_xx` `b`
|
|
|
WHERE
|
`a`.`id` = `b`.`id`
|
|
|
AND `b`.`contactDate` >= '2023-11-03 00:00:00' |
AND `b`.`contactDate` <= '2024-12-26 23:59:59' |
|
|
AND NOT ( `b`.`label` = 'Notification' ) |
AND `b`.`to_send` >= 1000 |
AND ( `a`.`email_domain` = 'ALL' ) |
|
|
GROUP BY |
1
|
The first table contains 4 851 406 rows
The second table contains 1 819 782 rows
If I change something then it is fine.
Ex:
when removing AND NOT ( `b`.`label` = 'Notification' )
the results : 5 rows in set (0,107 sec)