Jox

Serbia

brakus.rs

Age: 31

I just love writing code...

Apr
1
awarded Notable Question
Nov
7
awarded Yearling
Oct
17
awarded Nice Question
Sep
27
awarded Popular Question
Aug
20
accepted Python and MySQL mysterious memory leak
Jul
25
answered Python and MySQL mysterious memory leak
Jul
25
comment Python and MySQL mysterious memory leak
@ebyrob, yup, that's it.
Jul
25
revised Python and MySQL mysterious memory leak
cleaned garbage
Jul
25
comment Python and MySQL mysterious memory leak
Give me an hour or two to reproduce, and I'll post info here.
Jul
25
accepted Simple MySQL INSERT query on simple InnoDB table takes 40+ms
Jul
25
asked Python and MySQL mysterious memory leak
Jul
7
awarded Popular Question
May
27
awarded Notable Question
Jan
25
awarded Good Question
Sep
6
awarded Great Question
Jul
17
awarded Supporter
Jul
17
comment Simple MySQL INSERT query on simple InnoDB table takes 40+ms
I've just tested with SSD and confirmed that bigger factor in query time is disk. With modest SSD, but still with much lower access latency, INSERT query time is significantly lower (~10ms).
Jul
17
comment Simple MySQL INSERT query on simple InnoDB table takes 40+ms
Makes sense. I'll try today later same thing on SSD (this was on rather slow 5k4 hdd).
Jul
16
comment Simple MySQL INSERT query on simple InnoDB table takes 40+ms
Tables are empty prior to test. Freshly created tables and given insert queries gives these timings...
Jul
16
comment Simple MySQL INSERT query on simple InnoDB table takes 40+ms
Update query (for example) "update test_table_innodb set int_column = 5 where id = 3" takes even more time (50+ms).
1 2 3 4 5