Jailer VS async-profiler

Some other tools I have also enjoyed:

DBVisualizer: https://www.dbvis.com/ (for exploring the schema)

Jailer: https://wisser.github.io/Jailer/ (for data browsing)

Aside from that, it's usually just been a mix of using specialized tools like MySQL Workbench, SQL Developer, pgAdmin and others, or something that tries to do it all like DataGrip.

Didn't actually find anything particularly amazing about DataGrip, but if I'm paying for the JetBrains Ultimate subscription, might as well use it because it's pretty okay.

I also found DBeaver to be a huge improvement over tools I used earlier.

Recently I discovered Jailer which makes it very easy to navigate complex relational structures: https://github.com/Wisser/Jailer

We'll use async-profiler and flame graphs for profiling. To simplify the process, we'll run the code using JBang.

JIT'ed code is sadly poorly supported, but LLVM has had great hooks for noting each method that is produced and its address. So you can build a simple mixed-mode unwinder, pretty easily, but mostly in process.

I think Intel's DNN things dump their info out to some common file that perf can read instead, but because the *kernels* themselves reuse rbp throughout oneDNN, it's totally useless.

Finally, can any JVM folks explain this claim about DWARF info from the article:

> Doesn't exist for JIT'd runtimes like the Java JVM

that just sounds surprising to me. Is it off by default or literally not available? (Google searches have mostly pointed to people wanting to include the JNI/C side of a JVM stack, like https://github.com/async-profiler/async-profiler/issues/215).

debugging native calls in itself is also painful. I have switched to using async-profiler (https://github.com/async-profiler/async-profiler) instead of JFR for most of my usecases.

A. it tracks native calls by default

https://github.com/async-profiler/async-profiler#flame-graph...

Ok, Windows is not supported. But IntelliJ made a fork which works on Windows.

Hi, today I used async-profiler to check the CPU usage of my Spring Boot app (just a normal backend) in production. Surprisingly, Lettuce (Redis) + Mybatis (MySQL) take up most of the CPU time. I am not talking about wall time here, but CPU time, since I know database requests need to wait for milliseconds and thus wall time will be very long. Therefore, I wonder:

You can use async-profiler to see what is happening under the hood.

I have used visual vm quite a bit. https://github.com/async-profiler/async-profiler is also amazing... Throw the binary on the system and fire it up. It also profiles down into native code as well if you do that kind of thing.