Code:
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

Code:
[mysql]

Code:
# This file is automatically generated by MySQL Maintainer Scripts
[mysqld]
default-authentication-plugin = mysql_native_password

Code:
[mysqld]
pid-file    = /var/run/mysqld/mysqld.pid
socket        = /var/run/mysqld/mysqld.sock
datadir        = /var/lib/mysql
log-error    = /var/log/mysql/error.log

Code:

[mysqld]
pid-file    = /var/run/mysqld/mysqld.pid
socket        = /var/run/mysqld/mysqld.sock
datadir        = /var/lib/mysql
log-error    = /var/log/mysql/error.log

#stavi neki default-time-zone, koji god ali neki stavi
default-time-zone='+02:00'

# ovo moze a ne mora zavisi dal ti treba generalno ako ti sad radi bez toga ostavi bez toga
# https://dev.mysql.com/doc/refm..._default_authentication_plugin
#default-authentication-plugin=mysql_native_password

# ovo da te ne smara sa isteklim siframa (low security ali kontam to je neki dev koji nema externe usere)
default_password_lifetime=0
validate_password.policy=0

sql_mode=""
innodb_buffer_pool_size = 128M
innodb_buffer_pool_instances = 1
innodb_log_file_size = 8M
innodb_log_files_in_group=1
innodb_log_buffer_size = 8M
#innodb_compression_level = 6

join_buffer_size = 8M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
#open_files_limit = 650000
#innodb-open-files=550000
table_open_cache=10
table_open_cache_instances=1

#bind_address = 10.0.0.1
#max-connections = 500
#skip-name-resolve

max_allowed_packet=128M

Code:

CALL sys.ps_setup_enable_consumer('');
CALL sys.ps_setup_enable_instrument('');

Code:

SELECT * FROM sys.memory_global_by_current_bytes; 

SELECT 
       SUBSTRING_INDEX(event_name,'/',2) AS code_area, 
       sys.format_bytes(SUM(current_alloc)) AS current_alloc
FROM 
       sys.x$memory_global_by_current_bytes
GROUP BY 
       SUBSTRING_INDEX(event_name,'/',2)
ORDER BY 
       SUM(current_alloc) DESC;

SELECT  
       sys.format_bytes( SUM(high_alloc) ) AS highalloc, 
       sys.format_bytes( SUM(current_alloc) ) AS currentaloc 
FROM 
       sys.x$memory_global_by_current_bytes;

Code:
create procedure p_start(IN in_time datetime)
BEGIN

    -- Delete temp tables
    drop table if exists for_queue;
    drop table if exists telegram_tmp;

    -- Get the ones for starting
    create temporary table for_queue
    SELECT    ID_sensor
    FROM    sensor
    where    active = 1
        AND    coalesce(next_exec, from_unixtime(0)) <= in_time;
    
    -- Set last execute time and next execute time
    update    sensor
    set        last_exec = in_time
            ,next_exec = from_unixtime(floor(unix_timestamp(date_add(in_time, INTERVAL interval_s SECOND))/interval_s)*interval_s)
    where    ID_sensor in (select ID_sensor from for_queue);
    
    -- Create jobs
    insert into job
    (
        ID_sensor
        ,time_insert
        ,ID_status
    )
    select    ID_sensor            as ID_sensor
            ,CURRENT_TIMESTAMP    as time_insert
            ,100                as ID_status
    from    for_queue;
    
    -- Delete old jobs
    delete    j
    from    job as j
    join    for_queue as q
        on    j.ID_sensor = q.ID_sensor
        and    j.ID_status in (select ID_status from job_status where is_done = 1)
        and    j.time_insert < date_add(current_timestamp(), interval -24 hour);
    
    -- Check if something running timed out
    update    job as j
    join    sensor as s
        on    j.ID_sensor = s.ID_sensor
    set        ID_status = 300
    where    j.ID_status between 200 and 299
        and    timestampdiff(second, j.time_start, current_timestamp()) >= s.timeout_s;
    
    -- Check if there is queue timeout
    update    job as j
    join    sensor as s
        on    j.ID_sensor = s.ID_sensor
    set        ID_status = 302
    where    j.ID_status between 100 and 199
        and    timestampdiff(second, j.time_insert, current_timestamp()) >= s.queue_s;
    
    -- Select jobs from queue
    drop table if exists for_start;
    SET @row_number = 0;
    create temporary table for_start
    select    t.ID_job        as ID_job
            ,t.ID_sensor    as ID_sensor
            ,s.filename        as filename
            ,s.name            as name
            ,s.timeout_s    as timeout
    from
    (
        select    j.ID_job
                ,j.ID_sensor
                ,js.is_queued
                ,(@row_number:=@row_number + 1) AS num
        from    job as j
        join    job_status as js
            on    j.ID_status = js.ID_status
            and    (
                    js.is_running = 1
                or    js.is_queued = 1
                )
        order by is_running desc
            ,time_insert asc
    ) as t
    join    sensor as s
        on    t.ID_sensor = s.ID_sensor
    where t.num <= (select max(concurrent_jobs) from job_limit)
        and    t.is_queued = 1;
    
    -- Set new job status
    update    job
    set        ID_status = 100
    where    ID_job in (select ID_job from for_start);
    
    -- Output new jobs
    select    fs.ID_job
            ,fs.ID_sensor
            ,concat(fs.filename, " ", coalesce(args.args, '')) as filename
            ,fs.name
            ,fs.timeout
    from    for_start as fs
    left join    (
                select    ID_sensor
                        ,group_concat(value order by order_id asc separator ' ') as args
                from    sensor_arg
                group by    ID_sensor
            ) as args
        on fs.ID_sensor = args.ID_sensor;
    
    -- Get Telegram messages to send
    create temporary table telegram_tmp
    select    *
    from    telegram_message
    where    ID_message_status = 1;
    
    -- Set status to queued
    update    telegram_message
    set        ID_message_status = 2
            ,time_queue = current_timestamp()
    where    ID_message in (select ID_message from telegram_tmp);
    
    -- Output messages
    select    t.ID_message
            ,t.text
            ,c.bot_api_id
            ,c.chat_id
    from    telegram_tmp as t
    cross join telegram_config as c;

END

Code:
mysql> select * from memory_by_thread_by_current_bytes ;
+-----------+--------------------------------------+--------------------+-------------------+-------------------+-------------------+-----------------+
| thread_id | user                                 | current_count_used | current_allocated | current_avg_alloc | current_max_alloc | total_allocated |
+-----------+--------------------------------------+--------------------+-------------------+-------------------+-------------------+-----------------+
|     45671 | root@localhost                       |             -63209 | 310.76 MiB        | -5155 bytes       | 302.15 MiB        | 5.03 TiB        |
|     61086 | root@localhost                       |               -144 | 688.85 KiB        | -4899 bytes       | 868.96 KiB        | 95.81 MiB       |
|        43 | sql/event_scheduler                  |                  3 | 16.18 KiB         | 5.39 KiB          | 16.01 KiB         | 16.18 KiB       |

Code:
mysql> select * from x$memory_by_thread_by_current_bytes;
+-----------+--------------------------------------+--------------------+-------------------+-------------------+-------------------+-----------------+
| thread_id | user                                 | current_count_used | current_allocated | current_avg_alloc | current_max_alloc | total_allocated |
+-----------+--------------------------------------+--------------------+-------------------+-------------------+-------------------+-----------------+
|     45671 | root@localhost                       |             -68746 |         331728699 |        -4825.4255 |         320947132 |   6253750306818 |
|     62541 | root@localhost                       |                 82 |           1158325 |        14125.9146 |           1055640 |        35933914 |
|        43 | sql/event_scheduler                  |                  3 |             16569 |         5523.0000 |             16391 |           16569 |

Code:
mysql> select * from memory_by_thread_by_current_bytes;
+-----------+--------------------------------------+--------------------+-------------------+-------------------+-------------------+-----------------+
| thread_id | user                                 | current_count_used | current_allocated | current_avg_alloc | current_max_alloc | total_allocated |
+-----------+--------------------------------------+--------------------+-------------------+-------------------+-------------------+-----------------+
|     62564 | root@localhost                       |                230 | 1.20 MiB          | 5.32 KiB          | 1.01 MiB          | 603.19 MiB      |
|     62563 | root@localhost                       |                 16 | 991.54 KiB        | 61.97 KiB         | 1010.66 KiB       | 142.04 MiB      |
|        43 | sql/event_scheduler                  |                  3 | 16.18 KiB         | 5.39 KiB          | 16.01 KiB         | 16.18 KiB       |