Changeset 34576

Timestamp:

07/23/09 15:57:42 (4 years ago)

Author:

nowelium

Message:

 

Location:

platform/mysql/mprofile.php/trunk

Files:

• mpdump.php (modified) (2 diffs)
• mpfilter.php (modified) (2 diffs)
• mpreport.php (modified) (1 diff)

platform/mysql/mprofile.php/trunk/mpdump.php

@@ -17 +17 @@
     'samples' => 1000,
 ));
+
 if($options['help']){
     $file = basename(__FILE__);
@@ -46 +47 @@
     $rows = array();
     while($row = $stmt->fetch(PDO::FETCH_OBJ)){
+        if((0 !== strcasecmp('Query', $row->Command)) && (0 === strcasecmp('SHOW FULL PROCESSLIST', $row->Info))){
+            continue;
+        }
         $rows[] = $row;
     }

platform/mysql/mprofile.php/trunk/mpfilter.php

@@ -4 +4 @@
 $replacement = array(
     '/\r?\n/' => ' ',
+    '/(\"([^\"]+)\")/' => '?',
+    '/(\'([^\']+)\')/' => '?',
+    '/\s{2,}/' => ' '
+
 );
 $replacepattern = array_keys($replacement);
@@ -14 +18 @@
     $returnValue = array();
     foreach($rows as $row){
-        $info = preg_replace($replacepattern, $replace, $row->Info);
-        if(empty($info)){
-            continue;
-        }
-        $returnValue[] = $info;
+        $returnValue[] = preg_replace($replacepattern, $replace, $row->Info);
     }
     echo json_encode($returnValue), PHP_EOL;

platform/mysql/mprofile.php/trunk/mpreport.php

@@ -11 +11 @@
     $line = stream_get_line($stdin, 4096, "\n");
     $rows = json_decode($line);
+    if(empty($rows)){
+        continue;
+    }
     foreach($rows as $row){
+        if(empty($row)){
+            continue;
+        }
         $hash = md5($row);
         $sql_hash[$hash] = $row;