Bug #74224 | On Windows, thread pool plugin + Zone Alarm firewall is unacceptably slow | ||
---|---|---|---|
Submitted: | 4 Oct 2014 13:04 | Modified: | 5 Oct 2014 9:33 |
Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Connection Handling | Severity: | S2 (Serious) |
Version: | 5.6.20 | OS: | Windows |
Assigned to: | CPU Architecture: | Any |
[4 Oct 2014 13:04]
Shane Bester
[4 Oct 2014 13:23]
MySQL Verification Team
xperf, wpa showing a likely cause of the problem
Attachment: bug74224_stack_trace_windows7_5.6.21_thread_pool.jpg (image/jpeg, text), 356.56 KiB.
[4 Oct 2014 13:29]
MySQL Verification Team
Okay, so I uninstalled ZoneAlarm and the shocking performance is fixed. Now with shared memory connections I can 100K QPS with TP enabled, but 300K QPS with TP disabled. So, there is still a room for improvement. I'll profile the kernel again.
[4 Oct 2014 17:06]
MySQL Verification Team
On 5.6.21, a third of time is spent in WSAPoll(). Much tcp/ip driver activity even when using shared memory connections. On testing 5.7.6 now with 127.0.0.1 tcp/ip connection, we have also about a third of time in WSAPoll. Profiling using: xperf -on SysProf -f shd.etl -Pids 2700 -stackwalk profile -BufferSize 1024 -MaxBuffers 1024 -MaxFile 1024 -FileMode Circular <run tests> xperf -d Xperftp1.etl wpa Xperftp1.etl