Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36252

RocksDB => MariaDB Blocked (100% of cases)

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.11.11
    • None
    • Server
    • None

    Description

      An other trouble there :

      (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 730 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 735 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 737 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 739 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 741 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 743 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 748 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 751 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 752 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 753 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 756 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 757 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 759 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 760 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 761 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 763 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 766 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 769 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 770 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 771 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 772 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 775 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 776 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 777 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 778 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 779 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 780 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 781 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 782 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 783 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 784 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 785 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 786 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 789 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 790 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 791 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 792 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 794 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 795 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 796 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 797 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 802 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 804 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 806 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 810 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 812 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 813 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 814 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 816 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 819 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 822 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 824 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 825 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 829 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 830 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 831 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 835 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 836 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 837 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 838 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 839 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 840 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 841 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 842 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 843 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 844 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 845 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 846 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 848 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 850 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 854 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 856 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 858 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 864 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 865 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 867 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 868 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 869 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 870 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 873 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 874 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 875 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 876 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 877 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 881 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 882 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 883 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 885 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 886 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 892 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 893 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 894 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
      ....
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_int`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 1871 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_int`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 1872 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_int`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 1873 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  );

      this query got a table lock with herself ??

      +------+-------------+-------+-------+----------------------------+-----------------+---------+-------------------+------+-------------+
      		 
      | id   | select_type | table | type  | possible_keys              | key             | key_len | ref               | rows | Extra       |
      		 
      +------+-------------+-------+-------+----------------------------+-----------------+---------+-------------------+------+-------------+
      		 
      |    1 | PRIMARY     | c     | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |    1 | PRIMARY     | b     | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |    1 | PRIMARY     | a     | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      |    2 | UNION       | c     | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |    2 | UNION       | b     | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |    2 | UNION       | a     | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      |    3 | UNION       | c     | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |    3 | UNION       | b     | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |    3 | UNION       | a     | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      ....
      		 
      |  877 | UNION       | c     | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |  877 | UNION       | b     | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |  877 | UNION       | a     | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      +------+-------------+-------+-------+----------------------------+-----------------+---------+-------------------+------+-------------+
      		 
      2631 rows in set *(1 min 46,643 sec)*

      this query got in "table lock" (only that one is running), and around 1m46, and the partition is good, i got no idea where the engine losing time.

      |   87 | UNION       | b     | p739686    | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |   87 | UNION       | a     | p739686    | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      |   88 | UNION       | c     | NULL       | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |   88 | UNION       | b     | p739686    | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |   88 | UNION       | a     | p739686    | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      |   89 | UNION       | c     | NULL       | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |   89 | UNION       | b     | p739686    | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |   89 | UNION       | a     | p739686    | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      |   90 | UNION       | c     | NULL       | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |   90 | UNION       | b     | p739686    | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |   90 | UNION       | a     | p739686    | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      ....

      If we run sub query one by one it's more fast :

      MariaDB [pmacontrol]> SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
          ->   FROM `ts_value_general_text`  a  
          ->   INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
          ->   INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
          ->   WHERE id_ts_variable = 840 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now();
      		 
      +-----------------+----------------+-----------------+---------------------+-------+
      		 
      | id_mysql_server | id_ts_variable | connection_name | date                | value |
      		 
      +-----------------+----------------+-----------------+---------------------+-------+
      		 
      |              58 |            840 |                 | 2025-03-10 00:05:02 | YES   |
      		 
      +-----------------+----------------+-----------------+---------------------+-------+
      		 
      1 row in set (0,003 sec)

      583*0.003 = 1.749sec

      We are far from 1m36, we have something working wrong for sure there. UNION ALL was to prevent go and back with many query (about 600 there)

      PS : the table like ts_value_general_% are really big (about many billions of rows)
      ts_variable => ~4000 rows
      ts_date_by_server => ~100 million rows

      I can provide test data, just let me know where to send

      Attachments

        1. screenshot-1.png
          screenshot-1.png
          336 kB
        2. Capture d’écran du 2025-03-24 16-22-24.png
          Capture d’écran du 2025-03-24 16-22-24.png
          735 kB
        3. Capture d’écran du 2025-03-24 16-33-44.png
          Capture d’écran du 2025-03-24 16-33-44.png
          736 kB
        4. lsof_mariadb
          9.03 MB
        5. screenshot-2.png
          screenshot-2.png
          216 kB
        6. screenshot-3.png
          screenshot-3.png
          283 kB

        Issue Links

          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36368 RocksDB + Swapoff -a => compilation of crash

          • Major - Major loss of function.
          • Open

          Activity

            No workflow transitions have been executed yet.

            People

              Unassigned Unassigned
              Aurelien_LEQUOY Aurélien LEQUOY
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.