Je l' se adekvatno zatvara konekcija ka bazi posle queryja?
Potpis
THE ONLY EASY DAY WAS YESTERDAY
MySQL v 8.0 trosi RAM
Zaključano
Zakačeno
Citat:
Zlatni_bg: Je l' se adekvatno zatvara konekcija ka bazi posle queryja?
Ne pazis na casu :) Konekcija se nikad ne zatvara i uvek se koristi ista.
Citat:
bogdan.kecman:select * from memory_by_thread_by_current_bytes ;
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 |
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 |
wtf???
wtf indeed ...
povuci iz x$memory_by_thread_by_current_bytes ona se ne bavi
"formatiranjem" vec su unutra samo brojevi
povuci iz x$memory_by_thread_by_current_bytes ona se ne bavi
"formatiranjem" vec su unutra samo brojevi
Potpis
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 |
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 |
I onda sam zaustavio servis i pokrenuo ga ponovo:
Total_allocated se povecava sumanuto brzo. Nesto tipa 10MiB/s...
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 |
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 |
Total_allocated se povecava sumanuto brzo. Nesto tipa 10MiB/s...
Jako glup predlog, ovo ce definitivno Bogdan pre da zna od mene, ali da probam: Da nije do Linux-a, tj. fragmentacije memorije ipak? Ima li smisla da proba tmalloc?
Potpis
Please do not feed the Trolls!
Blasphemy? How can I blaspheme? I'm a god!'
Blasphemy? How can I blaspheme? I'm a god!'
izmenjeno 1 put, poslednji put bogdan.kecman 06.02.2019. u 23:07
Izmene poruke
- bogdan.kecman06.02.2019. u 23:07zapis iz teksta poruke
meni mrdi da je do kreiranja i brisanja temp tabele u jednom tasku ali
nemam kad da porobam..
nemam kad da porobam..
Potpis
Citat:
bogdan.kecman: meni mrdi da je do kreiranja i brisanja temp tabele u jednom tasku ali
nemam kad da porobam..
[Ovu poruku je menjao bogdan.kecman dana 06.02.2019. u 23:07 GMT+1]
nemam kad da porobam..
[Ovu poruku je menjao bogdan.kecman dana 06.02.2019. u 23:07 GMT+1]
Ja imam vremena, samo kazi sta da probam?
osakati stored proceduru , npr za pocetak samo drop pa create table from
select i to vrti u krug i vidi dal to gomila ram
posto moguce da ima neki bug oko tog create/delete jer na v8 nema vise
frm nego imamo data directory pravi transakcioni
takodje probaj taj svoj program da radis begin/commit i tako da ga vrtis
u krug da vidis dal ce da tako prestane da trosi ram
select i to vrti u krug i vidi dal to gomila ram
posto moguce da ima neki bug oko tog create/delete jer na v8 nema vise
frm nego imamo data directory pravi transakcioni
takodje probaj taj svoj program da radis begin/commit i tako da ga vrtis
u krug da vidis dal ce da tako prestane da trosi ram
Potpis
Ok, sad cu da probam pa javim :)