My colleague who is a Windows guru taught me how to do very basic things with the Windows profiler. While this stuff is primitive, the sad truth is that many people don’t know even this little about Windows, me including. I’ll keep the hints here, and hopefully will learn more with time.
- Use RelWithDebInfo builds, Debug build will screw the picture, it will tell you _db_enter is the most expensive function;
- Start mysqld;
- Use x64 VS command prompt:
Start => All Programs => MS Visual Studio 2010 =>
Visual Studio Tools => Visual Studio x64 Win64 command
prompt
- Set _NT_SYMBOL_PATH to the package bin directory, so mysqld.pdb can be found, and start the IDE:
set _NT_SYMBOL_PATH=... && devenv.exe
- In the VS command prompt, run
vsperfcmd /start:sample …