Archive for the ‘Prof’ Category

5

Jun 12

Percona Server 5.5 Troubleshooting #1

1) start import of data.sql into a dummy db when both instances are running
2) pt-stalk –collect –collect-oprofile –no-stalk for the duration of the import

  • oprofile will show where MySQL spends most of its time during the import

3) run pt-diskstats -g all –devices-regex sdb1 for the duration of the import
4) run poor-man-profiler for the duration of the import

Posted in Linux, MySQL, Prof | No Comments

4

Feb 10

JProfiler: Getting Started

JProfiler helps you find performance bottlenecks, pin down memory leaks and resolve threading issues in your Java application. JProfiler combines CPU, Memory and Thread profiling in one application and is developed by ej-technologies. The latest version at the time of this article is 6.0.

Posted in Java, Prof | No Comments