{"id":316,"date":"2008-04-12T11:10:02","date_gmt":"2008-04-12T16:10:02","guid":{"rendered":"http:\/\/unitstep.net\/?p=316"},"modified":"2008-04-12T11:10:36","modified_gmt":"2008-04-12T16:10:36","slug":"threatfire-hanging-or-slowing-down-mysql","status":"publish","type":"post","link":"https:\/\/unitstep.net\/blog\/2008\/04\/12\/threatfire-hanging-or-slowing-down-mysql\/","title":{"rendered":"ThreatFire hanging or slowing down MySQL?"},"content":{"rendered":"<p class=\"image align-right\"><img decoding=\"async\" src=\"http:\/\/unitstep.net\/wordpress\/wp-content\/uploads\/2008\/04\/threatfire-xampp.jpg\" alt=\"XAMPP and ThreatFire\" title=\"threatfire-xampp\" width=\"200\" height=\"145\" \/><\/p>\n<p>After seeing <a href=\"http:\/\/www.maximumpc.com\/article\/internet_security_2_0?page=0%2C3\">glowing<\/a> <a href=\"http:\/\/lifehacker.com\/344645\/protect-your-pc-from-viruses-in-real+time-with-threatfire\">recommendations<\/a> for the heuristic-based <a href=\"http:\/\/www.threatfire.com\/\">ThreatFire<\/a> anti-malware app from PC Tools, I decided to install it to complement my antivirus scanner and other anti-spyware tools such as <a href=\"http:\/\/www.safer-networking.org\/en\/index.html\">Spybot-S&#038;D<\/a> and <a href=\"http:\/\/www.lavasoftusa.com\/\">Ad-Aware<\/a>.<\/p>\n<p>Initially, it worked fine.  While I don&#8217;t know how much protection it really added, it was intuitive, easy to configure and didn&#8217;t slow down my system like many other real-time scanners might have.  However, I ran into some trouble with my web development environment, consisting of Apache, MySQL and <acronym class=\"uttInitialism\" title=\"PHP: Hypertext Preprocessor\">PHP<\/acronym> (in the form of <a href=\"http:\/\/www.apachefriends.org\/en\/xampp.html\">XAMPP<\/a>) that I could only attribute to ThreatFire&#8217;s presence.<\/p>\n<p><!--more--><\/p>\n<h3>The symptoms<\/h3>\n<p>With ThreatFire installed and enabled, requesting any pages from Apache that would result in MySQL access took painfully long.  Accessing static pages or scripts that did not use the MySQL database did not hang. At first, I thought it was a problem with the application\/scripts I was working on, but other popular third-party scripts, such as <a href=\"http:\/\/www.phpmyadmin.net\/\">phpMyAdmin<\/a>, were also slow or unresponsive.  The server appeared to &#8220;hang&#8221; for about 10-15 seconds before producing any response.  This was on a local server.<\/p>\n<p>I tried several different courses of action, such as:<\/p>\n<ul>\n<li>Enabling logging of slow queries with the <code>--log-slow-queries<\/code> option.<\/li>\n<li>Adding the MySQL binaries (<code>mysqld.exe<\/code> and <code>mysqld-nt.exe<\/code>) to the ThreatFire exclusion\/ignore list<\/li>\n<li>Reinstalling XAMPP<\/li>\n<\/ul>\n<p>None of these worked.  In particular, logging slow queries did not produce any logs, which seemed to indicate that MySQL was hanging even before the queries were executed.  Surprisingly, logging the execution time of <acronym class=\"uttInitialism\" title=\"PHP: Hypertext Preprocessor\">PHP<\/acronym> scripts did not seem to indicate any problems either.  The queries I was executing and that datasets I was working on were also small and unlikely to be a contributing factor &#8211; any query, no matter how simple, seemed to hang.  <\/p>\n<p>When I suspended or removed ThreatFire, the problems immediately went away.  Strangely, as I noted above, adding the MySQL binaries to the exclusion list did not help.  What was more interesting is that ThreatFire did not popup any warnings.  Usually, when &#8220;suspicious behaviour&#8221; is detected, ThreatFire will prompt you for a decision.  I did not notice any of this.<\/p>\n<h3>ThreatFire is not bad<\/h3>\n<p>The purpose of this is not to bash ThreatFire; it&#8217;s clearly a good tool and has definitive advantages, but just may not be well-suited to development environments where multiple servers are running.  I also wanted to provide this information to anyone else who may have been struggling with a slow\/unresponsive server because of the same situation as mine.<\/p>","protected":false},"excerpt":{"rendered":"<p>After seeing glowing recommendations for the heuristic-based ThreatFire anti-malware app from PC Tools, I decided to install it to complement my antivirus scanner and other anti-spyware tools such as Spybot-S&#038;D and Ad-Aware. Initially, it worked fine. While I don&#8217;t know how much protection it really added, it was intuitive, easy to configure and didn&#8217;t slow [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[208,79,198,213],"tags":[],"_links":{"self":[{"href":"https:\/\/unitstep.net\/wp-json\/wp\/v2\/posts\/316"}],"collection":[{"href":"https:\/\/unitstep.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unitstep.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unitstep.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unitstep.net\/wp-json\/wp\/v2\/comments?post=316"}],"version-history":[{"count":0,"href":"https:\/\/unitstep.net\/wp-json\/wp\/v2\/posts\/316\/revisions"}],"wp:attachment":[{"href":"https:\/\/unitstep.net\/wp-json\/wp\/v2\/media?parent=316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unitstep.net\/wp-json\/wp\/v2\/categories?post=316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unitstep.net\/wp-json\/wp\/v2\/tags?post=316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}