Regular Expressions 101

Save & Share

Flavor

  • PCRE2 (PHP >=7.3)
  • PCRE (PHP <7.3)
  • ECMAScript (JavaScript)
  • Python
  • Golang
  • Java 8
  • .NET 7.0 (C#)
  • Rust
  • Regex Flavor Guide

Function

  • Match
  • Substitution
  • List
  • Unit Tests

Tools

Sponsors
There are currently no sponsors. Become a sponsor today!
An explanation of your regex will be automatically generated as you type.
Detailed match information will be displayed here automatically.
  • All Tokens
  • Common Tokens
  • General Tokens
  • Anchors
  • Meta Sequences
  • Quantifiers
  • Group Constructs
  • Character Classes
  • Flags/Modifiers
  • Substitution
  • A single character of: a, b or c
    [abc]
  • A character except: a, b or c
    [^abc]
  • A character in the range: a-z
    [a-z]
  • A character not in the range: a-z
    [^a-z]
  • A character in the range: a-z or A-Z
    [a-zA-Z]
  • Any single character
    .
  • Alternate - match either a or b
    a|b
  • Any whitespace character
    \s
  • Any non-whitespace character
    \S
  • Any digit
    \d
  • Any non-digit
    \D
  • Any word character
    \w
  • Any non-word character
    \W
  • Non-capturing group
    (?:...)
  • Capturing group
    (...)
  • Zero or one of a
    a?
  • Zero or more of a
    a*
  • One or more of a
    a+
  • Exactly 3 of a
    a{3}
  • 3 or more of a
    a{3,}
  • Between 3 and 6 of a
    a{3,6}
  • Start of string
    ^
  • End of string
    $
  • A word boundary
    \b
  • Non-word boundary
    \B

Regular Expression
No Match

/
/
gim

Test String

Code Generator

Language

Generated Code

import java.util.regex.Matcher; import java.util.regex.Pattern; public class Example { public static void main(String[] args) { final String regex = "\\,\\ ACTIVE\\ (\\d+).+$"; final String string = "\n" + " =====================================\n" + " 160113 14:10:28 INNODB MONITOR OUTPUT\n" + " =====================================\n" + " Per second averages calculated from the last 10 seconds\n" + " ----------\n" + " SEMAPHORES\n" + " ----------\n" + " OS WAIT ARRAY INFO: reservation count 6086565, signal count 5442924\n" + " Mutex spin waits 0, rounds 878556566, OS waits 1634339\n" + " RW-shared spins 25912664, OS waits 1356771; RW-excl spins 81805823, OS waits 2922470\n" + " ------------------------\n" + " LATEST FOREIGN KEY ERROR\n" + " ------------------------\n" + " 160112 17:12:52 Transaction:\n" + " TRANSACTION 0 21484244, ACTIVE 0 sec, process no 26242, OS thread id 140577619658496 inserting, thread declared inside InnoDB 500\n" + " mysql tables in use 1, locked 1\n" + " 3 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1\n" + " MySQL thread id 101026, query id 42680285 10.11.11.23 megauser update\n" + " INSERT INTO `net_schedule` SET\n" + " `net_schedule`.datum = NAME_CONST('due_date',_binary'2016-01-14 09:00:00' COLLATE 'binary'),\n" + " `net_schedule`.time_id = NAME_CONST('time_id',3),\n" + " `net_schedule`.group_id = NAME_CONST('group_id',35),\n" + " `net_schedule`.net_schedule_type_id = NAME_CONST('net_schedule_type_id',0),\n" + " `net_schedule`.duration = NAME_CONST('duration',70),\n" + " `net_schedule`.CreatedBy = NAME_CONST('user_id',5958),\n" + " `net_schedule`.CreatedOn = now(),\n" + " `net_schedule`.`net_standby_id` = NAME_CONST('standby_id',591037),\n" + " `net_schedule`.tools = NAM\n" + " Foreign key constraint fails for table `megalan_network`.`net_schedule`:\n" + " ,\n" + " CONSTRAINT `fkNetScheduleType` FOREIGN KEY (`net_schedule_type_id`) REFERENCES `net_schedule_types` (`id`)\n" + " Trying to add in child table, in index `net_schedule_type_id` tuple:\n" + " DATA TUPLE: 2 fields;\n" + " 0: len 4; hex 00000000; asc ;; 1: len 4; hex 8016b9c1; asc ;;\n" + " \n" + " But in parent table `megalan_network`.`net_schedule_types`, in index `PRIMARY`,\n" + " the closest match we can find is record:\n" + " PHYSICAL RECORD: n_fields 10; compact format; info bits 0\n" + " 0: len 4; hex 00000001; asc ;; 1: len 6; hex 0000000205e9; asc ;; 2: len 7; hex 800000002d0110; asc - ;; 3: len 14; hex cdeee2ee20e2eaebfef7e2e0ede5; asc ;; 4: len 6; hex 464646464646; asc FFFFFF;; 5: len 1; hex 00; asc ;; 6: len 1; hex 80; asc ;; 7: SQL NULL; 8: SQL NULL; 9: SQL NULL;\n" + " \n" + " ------------\n" + " TRANSACTIONS\n" + " ------------\n" + " Trx id counter 0 36175932\n" + " Purge done for trx's n:o < 0 36172053 undo n:o < 0 0\n" + " History list length 190\n" + " ... truncated...\n" + " 5552\n" + " MySQL thread id 202911, query id 78489046 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35179743, not started, process no 26242, OS thread id 140577622320896\n" + " MySQL thread id 202745, query id 78440067 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36157725, not started, process no 26242, OS thread id 140577623119616\n" + " MySQL thread id 202727, query id 82292363 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35179764, not started, process no 26242, OS thread id 140577613002496\n" + " MySQL thread id 202720, query id 82284890 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35178389, not started, process no 26242, OS thread id 140577630840576\n" + " MySQL thread id 202718, query id 78424605 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173889, not started, process no 26242, OS thread id 140588253554432\n" + " MySQL thread id 202708, query id 82287051 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35818567, not started, process no 26242, OS thread id 140577611405056\n" + " MySQL thread id 202402, query id 80952301 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35137576, not started, process no 26242, OS thread id 140588261541632\n" + " MySQL thread id 202400, query id 78265470 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35137556, not started, process no 26242, OS thread id 140577585579776\n" + " MySQL thread id 202360, query id 82287394 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577613801216\n" + " MySQL thread id 202028, query id 78131713 10.11.11.4 webuser\n" + " ---TRANSACTION 0 35083655, not started, process no 26242, OS thread id 140577615931136\n" + " MySQL thread id 201849, query id 78082405 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35093187, not started, process no 26242, OS thread id 140577616197376\n" + " MySQL thread id 201835, query id 82285047 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35058513, not started, process no 26242, OS thread id 140577637496576\n" + " MySQL thread id 201630, query id 77988685 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175915, not started, process no 26242, OS thread id 140577619658496\n" + " MySQL thread id 201537, query id 82292625 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35018340, not started, process no 26242, OS thread id 140577615132416\n" + " MySQL thread id 201230, query id 77843017 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35179926, not started, process no 26242, OS thread id 140577620190976\n" + " MySQL thread id 201166, query id 82283459 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35072718, not started, process no 26242, OS thread id 140577615398656\n" + " MySQL thread id 200188, query id 78069928 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34905564, not started, process no 26242, OS thread id 140577583982336\n" + " MySQL thread id 200173, query id 77408529 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34906846, not started, process no 26242, OS thread id 140577620723456\n" + " MySQL thread id 200153, query id 82275978 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34777396, not started, process no 26242, OS thread id 140577620989696\n" + " MySQL thread id 199124, query id 77017507 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175903, not started, process no 26242, OS thread id 140577625515776\n" + " MySQL thread id 199094, query id 82292491 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34772182, not started, process no 26242, OS thread id 140577622587136\n" + " MySQL thread id 199022, query id 76983066 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35983477, not started, process no 26242, OS thread id 140577621522176\n" + " MySQL thread id 199010, query id 82282131 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34765122, not started, process no 26242, OS thread id 140577625782016\n" + " MySQL thread id 198991, query id 76966255 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35768837, not started, process no 26242, OS thread id 140577627379456\n" + " MySQL thread id 198960, query id 82289520 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34764258, not started, process no 26242, OS thread id 140577635899136\n" + " MySQL thread id 198959, query id 76951959 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34763976, not started, process no 26242, OS thread id 140577478223616\n" + " MySQL thread id 198948, query id 76945643 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175705, not started, process no 26242, OS thread id 140577622853376\n" + " MySQL thread id 198933, query id 82292118 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34728777, not started, process no 26242, OS thread id 140577587975936\n" + " MySQL thread id 198668, query id 76832015 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35097328, not started, process no 26242, OS thread id 140577623385856\n" + " MySQL thread id 198647, query id 82292387 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34716253, not started, process no 26242, OS thread id 140577629243136\n" + " MySQL thread id 198567, query id 76786679 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34716325, not started, process no 26242, OS thread id 140577623918336\n" + " MySQL thread id 198528, query id 80563364 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34701062, not started, process no 26242, OS thread id 140588243437312\n" + " MySQL thread id 198428, query id 76743227 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34696630, not started, process no 26242, OS thread id 140577627113216\n" + " MySQL thread id 198378, query id 76729307 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35997746, not started, process no 26242, OS thread id 140577621788416\n" + " MySQL thread id 198367, query id 82279909 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34704174, not started, process no 26242, OS thread id 140577468905216\n" + " MySQL thread id 198353, query id 82281819 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36073414, not started, process no 26242, OS thread id 140577624983296\n" + " MySQL thread id 197959, query id 82281506 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34649401, not started, process no 26242, OS thread id 140577639094016\n" + " MySQL thread id 197861, query id 76570224 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34950740, not started, process no 26242, OS thread id 140577626314496\n" + " MySQL thread id 197759, query id 82279880 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577629775616\n" + " MySQL thread id 197758, query id 76529787 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34623643, not started, process no 26242, OS thread id 140577541633792\n" + " MySQL thread id 197716, query id 76506893 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36075573, not started, process no 26242, OS thread id 140577634035456\n" + " MySQL thread id 197623, query id 82282353 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140588240774912\n" + " MySQL thread id 197594, query id 76499618 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577583449856\n" + " MySQL thread id 197459, query id 76450446 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34597142, not started, process no 26242, OS thread id 140577629509376\n" + " MySQL thread id 197426, query id 76388701 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34583322, not started, process no 26242, OS thread id 140577552283392\n" + " MySQL thread id 197302, query id 76340461 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34978769, not started, process no 26242, OS thread id 140577494730496\n" + " MySQL thread id 197278, query id 82287713 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34582455, not started, process no 26242, OS thread id 140577635632896\n" + " MySQL thread id 197254, query id 76327833 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36174263, not started, process no 26242, OS thread id 140577631373056\n" + " MySQL thread id 197237, query id 82287914 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140588255950592\n" + " MySQL thread id 197042, query id 76240677 10.11.11.4 webuser\n" + " ---TRANSACTION 0 34553473, not started, process no 26242, OS thread id 140577599690496\n" + " MySQL thread id 197020, query id 76238655 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34649290, not started, process no 26242, OS thread id 140577630041856\n" + " MySQL thread id 196952, query id 82287208 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34470545, not started, process no 26242, OS thread id 140577628178176\n" + " MySQL thread id 196285, query id 75960696 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34457543, not started, process no 26242, OS thread id 140577578923776\n" + " MySQL thread id 196207, query id 75932745 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34471151, not started, process no 26242, OS thread id 140577632970496\n" + " MySQL thread id 196189, query id 82287802 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34463242, not started, process no 26242, OS thread id 140577634301696\n" + " MySQL thread id 196176, query id 81293644 10.250.74.24 megauser\n" + " ---TRANSACTION 0 34446526, not started, process no 26242, OS thread id 140577637230336\n" + " MySQL thread id 196120, query id 75897012 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34419226, not started, process no 26242, OS thread id 140588252223232\n" + " MySQL thread id 195739, query id 75778220 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34366190, not started, process no 26242, OS thread id 140577636165376\n" + " MySQL thread id 195114, query id 75582253 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577638029056\n" + " MySQL thread id 195105, query id 75570884 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34364445, not started, process no 26242, OS thread id 140588243703552\n" + " MySQL thread id 195075, query id 75559633 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34458379, not started, process no 26242, OS thread id 140577638295296\n" + " MySQL thread id 195000, query id 82283678 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34337424, not started, process no 26242, OS thread id 140588245034752\n" + " MySQL thread id 194788, query id 75463923 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34337178, not started, process no 26242, OS thread id 140577496860416\n" + " MySQL thread id 194778, query id 75459016 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34334919, not started, process no 26242, OS thread id 140577604749056\n" + " MySQL thread id 194735, query id 75448211 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34377295, not started, process no 26242, OS thread id 140577606612736\n" + " MySQL thread id 194710, query id 82284755 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34324136, not started, process no 26242, OS thread id 140577488606976\n" + " MySQL thread id 194670, query id 75420676 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34334992, not started, process no 26242, OS thread id 140577616996096\n" + " MySQL thread id 194657, query id 82289496 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577589839616\n" + " MySQL thread id 194054, query id 75192096 10.11.11.4 webuser\n" + " ---TRANSACTION 0 34224749, not started, process no 26242, OS thread id 140577560270592\n" + " MySQL thread id 193626, query id 74995089 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34221893, not started, process no 26242, OS thread id 140577639626496\n" + " MySQL thread id 193567, query id 74979690 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35351298, not started, process no 26242, OS thread id 140577639892736\n" + " MySQL thread id 193565, query id 82266052 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34224575, not started, process no 26242, OS thread id 140588238911232\n" + " MySQL thread id 193544, query id 82282865 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35943952, not started, process no 26242, OS thread id 140577622054656\n" + " MySQL thread id 193371, query id 82287889 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34147872, not started, process no 26242, OS thread id 140588239709952\n" + " MySQL thread id 193303, query id 74380583 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34687424, not started, process no 26242, OS thread id 140577467574016\n" + " MySQL thread id 193281, query id 81325768 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140588241839872\n" + " MySQL thread id 192763, query id 74109047 10.11.11.4 webuser\n" + " ---TRANSACTION 0 34588426, not started, process no 26242, OS thread id 140588239443712\n" + " MySQL thread id 192533, query id 80549589 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35897921, not started, process no 26242, OS thread id 140577561069312\n" + " MySQL thread id 192228, query id 81249585 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33973849, not started, process no 26242, OS thread id 140588242372352\n" + " MySQL thread id 191339, query id 73488241 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33984185, not started, process no 26242, OS thread id 140577572534016\n" + " MySQL thread id 191200, query id 82290620 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577637762816\n" + " MySQL thread id 191044, query id 73399294 10.11.11.4 webuser\n" + " ---TRANSACTION 0 33934990, not started, process no 26242, OS thread id 140577470236416\n" + " MySQL thread id 190812, query id 73304937 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33972674, not started, process no 26242, OS thread id 140588248229632\n" + " MySQL thread id 190736, query id 82292092 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35935722, not started, process no 26242, OS thread id 140588242904832\n" + " MySQL thread id 190490, query id 82286557 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33901536, not started, process no 26242, OS thread id 140588242106112\n" + " MySQL thread id 190378, query id 73159294 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33916411, not started, process no 26242, OS thread id 140577550419712\n" + " MySQL thread id 190337, query id 82275444 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33895372, not started, process no 26242, OS thread id 140577486477056\n" + " MySQL thread id 190316, query id 73131817 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35577285, not started, process no 26242, OS thread id 140588243171072\n" + " MySQL thread id 190275, query id 82275796 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33883435, not started, process no 26242, OS thread id 140588244768512\n" + " MySQL thread id 190207, query id 73083420 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35528603, not started, process no 26242, OS thread id 140577472898816\n" + " MySQL thread id 190183, query id 82289585 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33849502, not started, process no 26242, OS thread id 140588249028352\n" + " MySQL thread id 189834, query id 72920958 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36171579, not started, process no 26242, OS thread id 140588245833472\n" + " MySQL thread id 189815, query id 82281535 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140588247430912\n" + " MySQL thread id 189503, query id 72769475 10.11.11.4 webuser\n" + " ---TRANSACTION 0 33801886, not started, process no 26242, OS thread id 140588249827072\n" + " MySQL thread id 188925, query id 82089032 10.250.68.253 mdobrichev\n" + " ---TRANSACTION 0 33788243, not started, process no 26242, OS thread id 140588246099712\n" + " MySQL thread id 189246, query id 72653722 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173673, not started, process no 26242, OS thread id 140588246898432\n" + " MySQL thread id 189222, query id 82286379 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33778526, not started, process no 26242, OS thread id 140588249560832\n" + " MySQL thread id 189195, query id 72628492 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35526129, not started, process no 26242, OS thread id 140588238644992\n" + " MySQL thread id 189180, query id 82280009 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33749120, not started, process no 26242, OS thread id 140577560536832\n" + " MySQL thread id 188908, query id 72506534 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33759343, not started, process no 26242, OS thread id 140577559471872\n" + " MySQL thread id 188855, query id 82292592 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33673633, not started, process no 26242, OS thread id 140588250625792\n" + " MySQL thread id 188114, query id 72188012 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33680620, not started, process no 26242, OS thread id 140588255151872\n" + " MySQL thread id 187829, query id 82291123 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33646097, not started, process no 26242, OS thread id 140577634834176\n" + " MySQL thread id 187752, query id 72053340 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36174156, not started, process no 26242, OS thread id 140577588508416\n" + " MySQL thread id 187734, query id 82287624 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33630687, not started, process no 26242, OS thread id 140577485145856\n" + " MySQL thread id 187481, query id 82288060 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33589234, not started, process no 26242, OS thread id 140588253820672\n" + " MySQL thread id 187249, query id 71728464 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34610613, not started, process no 26242, OS thread id 140588256749312\n" + " MySQL thread id 187226, query id 82279980 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33492992, not started, process no 26242, OS thread id 140588249294592\n" + " MySQL thread id 186330, query id 71350235 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36129517, not started, process no 26242, OS thread id 140588256483072\n" + " MySQL thread id 186286, query id 82288706 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33412511, not started, process no 26242, OS thread id 140577610073856\n" + " MySQL thread id 185283, query id 71004713 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173821, not started, process no 26242, OS thread id 140588257814272\n" + " MySQL thread id 185263, query id 82286928 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33397183, not started, process no 26242, OS thread id 140588258879232\n" + " MySQL thread id 185188, query id 70965776 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35972642, not started, process no 26242, OS thread id 140588258080512\n" + " MySQL thread id 185126, query id 82275784 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36040024, not started, process no 26242, OS thread id 140588259145472\n" + " MySQL thread id 185049, query id 81756707 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33369717, not started, process no 26242, OS thread id 140574145378048\n" + " MySQL thread id 184989, query id 70863884 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36143897, not started, process no 26242, OS thread id 140588261009152\n" + " MySQL thread id 184958, query id 82289807 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33360269, not started, process no 26242, OS thread id 140588262074112\n" + " MySQL thread id 184905, query id 70828398 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33912863, not started, process no 26242, OS thread id 140588326917888\n" + " MySQL thread id 184852, query id 82283404 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33276366, not started, process no 26242, OS thread id 140577476359936\n" + " MySQL thread id 184032, query id 70484463 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33300819, not started, process no 26242, OS thread id 140577636431616\n" + " MySQL thread id 183997, query id 82280129 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35863310, not started, process no 26242, OS thread id 140577601021696\n" + " MySQL thread id 183986, query id 82279304 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33249569, not started, process no 26242, OS thread id 140577590372096\n" + " MySQL thread id 183661, query id 70340511 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175913, not started, process no 26242, OS thread id 140577489671936\n" + " MySQL thread id 183639, query id 82292618 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33248208, not started, process no 26242, OS thread id 140577480353536\n" + " MySQL thread id 183618, query id 70324167 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35946379, not started, process no 26242, OS thread id 140577632704256\n" + " MySQL thread id 183574, query id 82290012 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33234009, not started, process no 26242, OS thread id 140588326119168\n" + " MySQL thread id 183468, query id 70271959 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33233837, not started, process no 26242, OS thread id 140588326385408\n" + " MySQL thread id 183462, query id 70269857 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33233666, not started, process no 26242, OS thread id 140588254885632\n" + " MySQL thread id 183453, query id 70268266 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36174881, not started, process no 26242, OS thread id 140577579988736\n" + " MySQL thread id 183380, query id 82289539 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173029, not started, process no 26242, OS thread id 140577481152256\n" + " MySQL thread id 183379, query id 82284844 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33845470, not started, process no 26242, OS thread id 140577493133056\n" + " MySQL thread id 183378, query id 82289224 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35441217, not started, process no 26242, OS thread id 140577551484672\n" + " MySQL thread id 181926, query id 82280051 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33091089, not started, process no 26242, OS thread id 140577571735296\n" + " MySQL thread id 181823, query id 69583365 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33195472, not started, process no 26242, OS thread id 140577549620992\n" + " MySQL thread id 181632, query id 82288346 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33041548, not started, process no 26242, OS thread id 140577588774656\n" + " MySQL thread id 181305, query id 69366811 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34860602, not started, process no 26242, OS thread id 140577581319936\n" + " MySQL thread id 181273, query id 80597641 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33027339, not started, process no 26242, OS thread id 140577476626176\n" + " MySQL thread id 181128, query id 69290781 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172789, not started, process no 26242, OS thread id 140577474496256\n" + " MySQL thread id 181105, query id 82284944 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33001772, not started, process no 26242, OS thread id 140577497126656\n" + " MySQL thread id 180908, query id 69184820 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172493, not started, process no 26242, OS thread id 140577593300736\n" + " MySQL thread id 180879, query id 82287301 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32973355, not started, process no 26242, OS thread id 140577614067456\n" + " MySQL thread id 180629, query id 69037711 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35261267, not started, process no 26242, OS thread id 140577469437696\n" + " MySQL thread id 180598, query id 82281395 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32932648, not started, process no 26242, OS thread id 140588247963392\n" + " MySQL thread id 180255, query id 68852001 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32922868, not started, process no 26242, OS thread id 140577539237632\n" + " MySQL thread id 180242, query id 68833974 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175912, not started, process no 26242, OS thread id 140577482483456\n" + " MySQL thread id 180241, query id 82292599 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35032888, not started, process no 26242, OS thread id 140577633236736\n" + " MySQL thread id 180215, query id 82281641 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32908383, not started, process no 26242, OS thread id 140577583183616\n" + " MySQL thread id 180069, query id 68762878 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172534, not started, process no 26242, OS thread id 140577585846016\n" + " MySQL thread id 180044, query id 82290756 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32897822, not started, process no 26242, OS thread id 140577567475456\n" + " MySQL thread id 180021, query id 68730984 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35946397, not started, process no 26242, OS thread id 140577468638976\n" + " MySQL thread id 179925, query id 82281379 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32885175, not started, process no 26242, OS thread id 140577469970176\n" + " MySQL thread id 179886, query id 68667031 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175893, not started, process no 26242, OS thread id 140577488873216\n" + " MySQL thread id 179658, query id 82292444 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32843921, not started, process no 26242, OS thread id 140577560803072\n" + " MySQL thread id 179452, query id 68516678 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173656, not started, process no 26242, OS thread id 140577566676736\n" + " MySQL thread id 179436, query id 82286333 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140588250093312\n" + " MySQL thread id 178291, query id 76706223 10.11.11.4 webuser\n" + " ---TRANSACTION 0 35728809, not started, process no 26242, OS thread id 140577471301376\n" + " MySQL thread id 177847, query id 80633372 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32658317, not started, process no 26242, OS thread id 140577539770112\n" + " MySQL thread id 177600, query id 67716751 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34520136, not started, process no 26242, OS thread id 140577566144256\n" + " MySQL thread id 177572, query id 82292577 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35525156, not started, process no 26242, OS thread id 140577542166272\n" + " MySQL thread id 176920, query id 79869659 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32551712, not started, process no 26242, OS thread id 140577483548416\n" + " MySQL thread id 176686, query id 67225437 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34336989, not started, process no 26242, OS thread id 140577475028736\n" + " MySQL thread id 176631, query id 82281228 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32550028, not started, process no 26242, OS thread id 140588239177472\n" + " MySQL thread id 176602, query id 67211328 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36144434, not started, process no 26242, OS thread id 140577489938176\n" + " MySQL thread id 176517, query id 82290784 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32507646, not started, process no 26242, OS thread id 140577640425216\n" + " MySQL thread id 176034, query id 67036699 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35219209, not started, process no 26242, OS thread id 140588240508672\n" + " MySQL thread id 175955, query id 82292573 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577542964992\n" + " MySQL thread id 175511, query id 69759968 10.11.11.4 webuser\n" + " ---TRANSACTION 0 35749937, not started, process no 26242, OS thread id 140577623652096\n" + " MySQL thread id 175349, query id 80714439 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33066292, not started, process no 26242, OS thread id 140577556809472\n" + " MySQL thread id 174932, query id 69474316 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577627911936\n" + " MySQL thread id 174107, query id 66282372 10.11.11.4 webuser\n" + " ---TRANSACTION 0 32336259, not started, process no 26242, OS thread id 140588326651648\n" + " MySQL thread id 174057, query id 66253927 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175923, not started, process no 26242, OS thread id 140577553880832\n" + " MySQL thread id 174041, query id 82292683 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32326301, not started, process no 26242, OS thread id 140577582118656\n" + " MySQL thread id 174033, query id 66225828 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34364061, not started, process no 26242, OS thread id 140577479288576\n" + " MySQL thread id 173995, query id 82288469 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34514072, not started, process no 26242, OS thread id 140577596761856\n" + " MySQL thread id 173982, query id 76498544 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36174278, not started, process no 26242, OS thread id 140588248762112\n" + " MySQL thread id 173730, query id 82287947 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36147135, not started, process no 26242, OS thread id 140577551750912\n" + " MySQL thread id 173720, query id 82167967 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175909, not started, process no 26242, OS thread id 140577599158016\n" + " MySQL thread id 173522, query id 82292569 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36112696, not started, process no 26242, OS thread id 140577626846976\n" + " MySQL thread id 173048, query id 82287500 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32203434, not started, process no 26242, OS thread id 140577562949376\n" + " MySQL thread id 173022, query id 65783544 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32225234, not started, process no 26242, OS thread id 140577595164416\n" + " MySQL thread id 172981, query id 82292375 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36174425, not started, process no 26242, OS thread id 140577589307136\n" + " MySQL thread id 172828, query id 82291936 10.250.68.48 megauser\n" + " ---TRANSACTION 0 32152112, not started, process no 26242, OS thread id 140577578391296\n" + " MySQL thread id 172521, query id 65585592 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32149318, not started, process no 26242, OS thread id 140577570137856\n" + " MySQL thread id 172499, query id 65575817 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34501752, not started, process no 26242, OS thread id 140577564014336\n" + " MySQL thread id 172477, query id 82279290 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32141706, not started, process no 26242, OS thread id 140577569072896\n" + " MySQL thread id 172461, query id 65556661 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32152113, not started, process no 26242, OS thread id 140577563215616\n" + " MySQL thread id 172024, query id 82289048 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36128393, not started, process no 26242, OS thread id 140577587177216\n" + " MySQL thread id 171959, query id 82288505 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32060967, not started, process no 26242, OS thread id 140588240242432\n" + " MySQL thread id 171661, query id 65280921 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32056905, not started, process no 26242, OS thread id 140577549887232\n" + " MySQL thread id 171629, query id 65266767 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36169815, not started, process no 26242, OS thread id 140577563748096\n" + " MySQL thread id 171592, query id 82279039 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172226, not started, process no 26242, OS thread id 140577492068096\n" + " MySQL thread id 171591, query id 82286404 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32051942, not started, process no 26242, OS thread id 140577472100096\n" + " MySQL thread id 171499, query id 65228901 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32045330, not started, process no 26242, OS thread id 140577618061056\n" + " MySQL thread id 171449, query id 65215512 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36045476, not started, process no 26242, OS thread id 140577495262976\n" + " MySQL thread id 171381, query id 82292484 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36174203, not started, process no 26242, OS thread id 140577611671296\n" + " MySQL thread id 171357, query id 82287729 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36141579, not started, process no 26242, OS thread id 140577540568832\n" + " MySQL thread id 171271, query id 82141011 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32032643, not started, process no 26242, OS thread id 140577624717056\n" + " MySQL thread id 171228, query id 65158015 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36063609, not started, process no 26242, OS thread id 140577545361152\n" + " MySQL thread id 171212, query id 82281746 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32032031, not started, process no 26242, OS thread id 140577542698752\n" + " MySQL thread id 171208, query id 65150785 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35101463, not started, process no 26242, OS thread id 140588251158272\n" + " MySQL thread id 171197, query id 82292434 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32021463, not started, process no 26242, OS thread id 140577609008896\n" + " MySQL thread id 171156, query id 65124472 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32020918, not started, process no 26242, OS thread id 140588261275392\n" + " MySQL thread id 171133, query id 65118261 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32020398, not started, process no 26242, OS thread id 140577605547776\n" + " MySQL thread id 171118, query id 65112690 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32012565, not started, process no 26242, OS thread id 140577586378496\n" + " MySQL thread id 171079, query id 65099405 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32010005, not started, process no 26242, OS thread id 140577568540416\n" + " MySQL thread id 171049, query id 65091877 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35110157, not started, process no 26242, OS thread id 140577573865216\n" + " MySQL thread id 171023, query id 82281058 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175619, not started, process no 26242, OS thread id 140577488340736\n" + " MySQL thread id 171018, query id 82290912 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36174774, not started, process no 26242, OS thread id 140577604482816\n" + " MySQL thread id 171013, query id 82289154 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36170805, not started, process no 26242, OS thread id 140577487009536\n" + " MySQL thread id 171011, query id 82279774 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173558, not started, process no 26242, OS thread id 140577624184576\n" + " MySQL thread id 170902, query id 82286156 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32425349, not started, process no 26242, OS thread id 140588260210432\n" + " MySQL thread id 170870, query id 80195575 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35332634, not started, process no 26242, OS thread id 140577493931776\n" + " MySQL thread id 170784, query id 80195182 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31964186, not started, process no 26242, OS thread id 140577628710656\n" + " MySQL thread id 170648, query id 64931667 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175899, not started, process no 26242, OS thread id 140577491535616\n" + " MySQL thread id 170634, query id 82292469 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31932505, not started, process no 26242, OS thread id 140577559205632\n" + " MySQL thread id 170449, query id 64847759 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31932197, not started, process no 26242, OS thread id 140588254619392\n" + " MySQL thread id 170437, query id 64844143 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31931887, not started, process no 26242, OS thread id 140577485412096\n" + " MySQL thread id 170421, query id 64840475 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172452, not started, process no 26242, OS thread id 140577628444416\n" + " MySQL thread id 170408, query id 82282173 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175613, not started, process no 26242, OS thread id 140577618859776\n" + " MySQL thread id 170406, query id 82290896 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31931514, not started, process no 26242, OS thread id 140577475827456\n" + " MySQL thread id 170395, query id 64836081 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35972745, not started, process no 26242, OS thread id 140577493665536\n" + " MySQL thread id 170391, query id 82278931 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31931042, not started, process no 26242, OS thread id 140577495529216\n" + " MySQL thread id 170370, query id 64830331 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36076434, not started, process no 26242, OS thread id 140588251956992\n" + " MySQL thread id 170366, query id 82291921 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175911, not started, process no 26242, OS thread id 140577628976896\n" + " MySQL thread id 170363, query id 82292572 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36113221, not started, process no 26242, OS thread id 140577551218432\n" + " MySQL thread id 170357, query id 82048930 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31927799, not started, process no 26242, OS thread id 140577471567616\n" + " MySQL thread id 170353, query id 64821750 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31920788, not started, process no 26242, OS thread id 140577544828672\n" + " MySQL thread id 170333, query id 64808874 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36051667, not started, process no 26242, OS thread id 140577547224832\n" + " MySQL thread id 170302, query id 82289937 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34348898, not started, process no 26242, OS thread id 140577541101312\n" + " MySQL thread id 170287, query id 82288948 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31883401, not started, process no 26242, OS thread id 140588259677952\n" + " MySQL thread id 170055, query id 64693497 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32002827, not started, process no 26242, OS thread id 140577471035136\n" + " MySQL thread id 170036, query id 82279765 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31871958, not started, process no 26242, OS thread id 140577607145216\n" + " MySQL thread id 169965, query id 64649665 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172787, not started, process no 26242, OS thread id 140577563481856\n" + " MySQL thread id 169953, query id 82284327 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31866033, not started, process no 26242, OS thread id 140577493399296\n" + " MySQL thread id 169922, query id 64623413 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577621255936\n" + " MySQL thread id 169879, query id 64603229 10.11.11.4 webuser\n" + " ---TRANSACTION 0 36158210, not started, process no 26242, OS thread id 140588247164672\n" + " MySQL thread id 169874, query id 82289810 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577567209216\n" + " MySQL thread id 169864, query id 82279280 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31827308, not started, process no 26242, OS thread id 140577543763712\n" + " MySQL thread id 169647, query id 64503042 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31826979, not started, process no 26242, OS thread id 140588250359552\n" + " MySQL thread id 169634, query id 64499412 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36128219, not started, process no 26242, OS thread id 140588257281792\n" + " MySQL thread id 169607, query id 82282514 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173618, not started, process no 26242, OS thread id 140577616729856\n" + " MySQL thread id 169603, query id 82286271 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31821355, not started, process no 26242, OS thread id 140577588242176\n" + " MySQL thread id 169591, query id 64481095 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175931, not started, process no 26242, OS thread id 140577636964096\n" + " MySQL thread id 169564, query id 82292740 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36142781, not started, process no 26242, OS thread id 140577477957376\n" + " MySQL thread id 169378, query id 82152909 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34935051, not started, process no 26242, OS thread id 140577566942976\n" + " MySQL thread id 169227, query id 82287338 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172188, not started, process no 26242, OS thread id 140588243969792\n" + " MySQL thread id 169226, query id 82287207 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175918, not started, process no 26242, OS thread id 140577594365696\n" + " MySQL thread id 169225, query id 82292661 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31769952, not started, process no 26242, OS thread id 140577613268736\n" + " MySQL thread id 169212, query id 64324140 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34373712, not started, process no 26242, OS thread id 140577546159872\n" + " MySQL thread id 169206, query id 82275959 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31769841, not started, process no 26242, OS thread id 140577547491072\n" + " MySQL thread id 169205, query id 64321707 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31769840, not started, process no 26242, OS thread id 140577467041536\n" + " MySQL thread id 169204, query id 64321697 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36171338, not started, process no 26242, OS thread id 140577625249536\n" + " MySQL thread id 169190, query id 82292111 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35332622, not started, process no 26242, OS thread id 140588247697152\n" + " MySQL thread id 169189, query id 82282535 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31705611, not started, process no 26242, OS thread id 140577494464256\n" + " MySQL thread id 168831, query id 76372368 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31671890, not started, process no 26242, OS thread id 140577478756096\n" + " MySQL thread id 168624, query id 64046769 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36039645, not started, process no 26242, OS thread id 140577545893632\n" + " MySQL thread id 168608, query id 82284741 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31661551, not started, process no 26242, OS thread id 140588255418112\n" + " MySQL thread id 168555, query id 64024176 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36153534, not started, process no 26242, OS thread id 140577489405696\n" + " MySQL thread id 168522, query id 82281559 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172591, not started, process no 26242, OS thread id 140577636697856\n" + " MySQL thread id 168231, query id 82283052 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36174938, not started, process no 26242, OS thread id 140577483814656\n" + " MySQL thread id 168203, query id 82290750 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32569568, not started, process no 26242, OS thread id 140577472366336\n" + " MySQL thread id 168190, query id 82288709 212.50.0.4 megauser\n" + " ---TRANSACTION 0 31598330, not started, process no 26242, OS thread id 140577589040896\n" + " MySQL thread id 168165, query id 63851567 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35957641, not started, process no 26242, OS thread id 140573205853952\n" + " MySQL thread id 168138, query id 82286720 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31587754, not started, process no 26242, OS thread id 140577580521216\n" + " MySQL thread id 168088, query id 63806302 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175209, not started, process no 26242, OS thread id 140577601554176\n" + " MySQL thread id 168056, query id 82292532 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31573276, not started, process no 26242, OS thread id 140577605281536\n" + " MySQL thread id 168005, query id 63762636 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35058068, not started, process no 26242, OS thread id 140577613534976\n" + " MySQL thread id 167987, query id 82292694 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31565993, not started, process no 26242, OS thread id 140577587443456\n" + " MySQL thread id 167978, query id 63749235 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34291452, not started, process no 26242, OS thread id 140577560004352\n" + " MySQL thread id 167951, query id 82287272 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36127851, not started, process no 26242, OS thread id 140588254353152\n" + " MySQL thread id 167900, query id 82279758 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31534651, not started, process no 26242, OS thread id 140588250892032\n" + " MySQL thread id 167837, query id 63649819 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173351, not started, process no 26242, OS thread id 140588254086912\n" + " MySQL thread id 167793, query id 82285653 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31520239, not started, process no 26242, OS thread id 140577484347136\n" + " MySQL thread id 167695, query id 63605168 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35176701, not started, process no 26242, OS thread id 140577633769216\n" + " MySQL thread id 167681, query id 82292500 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31512591, not started, process no 26242, OS thread id 140588248495872\n" + " MySQL thread id 167679, query id 63590853 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36143707, not started, process no 26242, OS thread id 140577608742656\n" + " MySQL thread id 167661, query id 82281836 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31510148, not started, process no 26242, OS thread id 140577541900032\n" + " MySQL thread id 167654, query id 63583178 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36174836, not started, process no 26242, OS thread id 140588251424512\n" + " MySQL thread id 167633, query id 82292501 10.250.68.253 megauser\n" + " ---TRANSACTION 0 33222931, not started, process no 26242, OS thread id 140577585047296\n" + " MySQL thread id 167466, query id 82283846 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577540036352\n" + " MySQL thread id 167148, query id 63331836 10.11.11.4 webuser\n" + " ---TRANSACTION 0 31422763, not started, process no 26242, OS thread id 140577486743296\n" + " MySQL thread id 167127, query id 63321105 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172738, not started, process no 26242, OS thread id 140588246365952\n" + " MySQL thread id 167122, query id 82292524 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31414679, not started, process no 26242, OS thread id 140577626580736\n" + " MySQL thread id 167093, query id 63299357 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175599, not started, process no 26242, OS thread id 140577567741696\n" + " MySQL thread id 167081, query id 82292250 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31498390, not started, process no 26242, OS thread id 140577485678336\n" + " MySQL thread id 166938, query id 63532658 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31373131, not started, process no 26242, OS thread id 140588259411712\n" + " MySQL thread id 166866, query id 63199835 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175277, not started, process no 26242, OS thread id 140577614333696\n" + " MySQL thread id 166788, query id 82292335 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31309957, not started, process no 26242, OS thread id 140577638827776\n" + " MySQL thread id 166569, query id 63072729 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31306761, not started, process no 26242, OS thread id 140577482217216\n" + " MySQL thread id 166549, query id 63064655 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172637, not started, process no 26242, OS thread id 140577618327296\n" + " MySQL thread id 166536, query id 82283240 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31290601, not started, process no 26242, OS thread id 140577617794816\n" + " MySQL thread id 166506, query id 63041357 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34303525, not started, process no 26242, OS thread id 140577591170816\n" + " MySQL thread id 166477, query id 82287684 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31280127, not started, process no 26242, OS thread id 140577564280576\n" + " MySQL thread id 166442, query id 63019045 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172099, not started, process no 26242, OS thread id 140588253288192\n" + " MySQL thread id 166420, query id 82286933 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31270165, not started, process no 26242, OS thread id 140577592768256\n" + " MySQL thread id 166401, query id 63002879 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173006, not started, process no 26242, OS thread id 140577599424256\n" + " MySQL thread id 166384, query id 82284779 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31180032, not started, process no 26242, OS thread id 140588245300992\n" + " MySQL thread id 166001, query id 62842473 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173445, not started, process no 26242, OS thread id 140577558939392\n" + " MySQL thread id 165957, query id 82285840 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31167449, not started, process no 26242, OS thread id 140577595430656\n" + " MySQL thread id 165910, query id 62812669 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31166908, not started, process no 26242, OS thread id 140588241041152\n" + " MySQL thread id 165909, query id 62811941 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173947, not started, process no 26242, OS thread id 140577578125056\n" + " MySQL thread id 165905, query id 82287165 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35900052, not started, process no 26242, OS thread id 140577557075712\n" + " MySQL thread id 165901, query id 82290611 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31159367, not started, process no 26242, OS thread id 140577631905536\n" + " MySQL thread id 165881, query id 62800194 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175916, not started, process no 26242, OS thread id 140577480087296\n" + " MySQL thread id 165872, query id 82292638 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173165, not started, process no 26242, OS thread id 140577640158976\n" + " MySQL thread id 165787, query id 82292535 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35859267, not started, process no 26242, OS thread id 140577472632576\n" + " MySQL thread id 165660, query id 82290455 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31071455, not started, process no 26242, OS thread id 140577490204416\n" + " MySQL thread id 165595, query id 62657127 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31071372, not started, process no 26242, OS thread id 140577549088512\n" + " MySQL thread id 165589, query id 62655790 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172494, not started, process no 26242, OS thread id 140588260476672\n" + " MySQL thread id 165581, query id 82292105 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36142066, not started, process no 26242, OS thread id 140577570670336\n" + " MySQL thread id 165579, query id 82277950 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31061367, not started, process no 26242, OS thread id 140577576527616\n" + " MySQL thread id 165539, query id 62639170 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36135684, not started, process no 26242, OS thread id 140577601820416\n" + " MySQL thread id 165525, query id 82292669 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31051659, not started, process no 26242, OS thread id 140577639360256\n" + " MySQL thread id 165513, query id 62624827 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173764, not started, process no 26242, OS thread id 140577568806656\n" + " MySQL thread id 165498, query id 82286606 10.250.68.253 megauser\n" + " ---TRANSACTION 0 30964088, not started, process no 26242, OS thread id 140577494996736\n" + " MySQL thread id 165239, query id 62498856 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36174494, not started, process no 26242, OS thread id 140577640691456\n" + " MySQL thread id 165230, query id 82290334 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577550685952\n" + " MySQL thread id 164812, query id 70960520 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577579456256\n" + " MySQL thread id 164404, query id 62164472 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577564813056\n" + " MySQL thread id 162569, query id 62910713 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140588258612992\n" + " MySQL thread id 162368, query id 77637837 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577565345536\n" + " MySQL thread id 161994, query id 62441794 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577616463616\n" + " MySQL thread id 160485, query id 64246051 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577635366656\n" + " MySQL thread id 159812, query id 77129684 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140588261807872\n" + " MySQL thread id 159578, query id 67442106 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577619126016\n" + " MySQL thread id 158851, query id 61894086 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577604216576\n" + " MySQL thread id 157019, query id 69165924 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577475294976\n" + " MySQL thread id 152507, query id 79214679 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140588259944192\n" + " MySQL thread id 147781, query id 81755047 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577571469056\n" + " MySQL thread id 146653, query id 75777268 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577610872576\n" + " MySQL thread id 145964, query id 63642321 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140588241307392\n" + " MySQL thread id 143800, query id 82265313 10.11.11.4 webuser\n" + " ---TRANSACTION 0 36040738, not started, process no 26242, OS thread id 140577570936576\n" + " MySQL thread id 142038, query id 82292406 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577538438912\n" + " MySQL thread id 138046, query id 65812789 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577602352896\n" + " MySQL thread id 125595, query id 72227140 10.11.11.4 webuser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577592235776\n" + " MySQL thread id 124000, query id 71569194 10.11.11.4 webuser\n" + " ---TRANSACTION 0 34432877, not started, process no 26242, OS thread id 140588246632192\n" + " MySQL thread id 121447, query id 82279873 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34458372, not started, process no 26242, OS thread id 140577552815872\n" + " MySQL thread id 109678, query id 82279480 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172747, not started, process no 26242, OS thread id 140577631639296\n" + " MySQL thread id 104192, query id 82284270 10.250.68.58 megauser\n" + " ---TRANSACTION 0 36172707, not started, process no 26242, OS thread id 140577633502976\n" + " MySQL thread id 103895, query id 82283514 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34936845, not started, process no 26242, OS thread id 140577585313536\n" + " MySQL thread id 101076, query id 82292362 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31839708, not started, process no 26242, OS thread id 140577488074496\n" + " MySQL thread id 80868, query id 82292540 10.250.84.98 megauser\n" + " ---TRANSACTION 0 34458382, not started, process no 26242, OS thread id 140577486210816\n" + " MySQL thread id 78523, query id 82279756 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36135688, not started, process no 26242, OS thread id 140577617528576\n" + " MySQL thread id 78418, query id 82292723 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175455, not started, process no 26242, OS thread id 140577631106816\n" + " MySQL thread id 76682, query id 82290563 10.250.68.253 megauser\n" + " ---TRANSACTION 0 29899644, not started, process no 26242, OS thread id 140577548289792\n" + " MySQL thread id 75221, query id 82288750 10.250.68.253 megauser\n" + " ---TRANSACTION 0 21696346, not started, process no 26242, OS thread id 140577600755456\n" + " MySQL thread id 75021, query id 82283439 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172023, not started, process no 26242, OS thread id 140577611937536\n" + " MySQL thread id 67965, query id 82286662 10.250.68.253 megauser\n" + " ---TRANSACTION 0 31467962, not started, process no 26242, OS thread id 140577581053696\n" + " MySQL thread id 66098, query id 82276014 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172561, not started, process no 26242, OS thread id 140577603684096\n" + " MySQL thread id 66042, query id 82282777 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36162784, not started, process no 26242, OS thread id 140577546426112\n" + " MySQL thread id 50951, query id 82282168 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577584248576\n" + " MySQL thread id 50738, query id 64966678 10.11.11.4 webuser\n" + " ---TRANSACTION 0 36175904, not started, process no 26242, OS thread id 140577608476416\n" + " MySQL thread id 45562, query id 82292523 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175664, not started, process no 26242, OS thread id 140577557608192\n" + " MySQL thread id 44065, query id 82291147 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172681, not started, process no 26242, OS thread id 140577553348352\n" + " MySQL thread id 44064, query id 82283403 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175663, not started, process no 26242, OS thread id 140577553614592\n" + " MySQL thread id 44060, query id 82291146 10.250.68.253 megauser\n" + " ---TRANSACTION 0 22749145, not started, process no 26242, OS thread id 140577556276992\n" + " MySQL thread id 42517, query id 81964998 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140577554945792\n" + " MySQL thread id 42516, query id 81964997 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175922, not started, process no 26242, OS thread id 140577572001536\n" + " MySQL thread id 41782, query id 82292665 10.250.68.253 megauser\n" + " ---TRANSACTION 0 16942191, not started, process no 26242, OS thread id 140577556543232\n" + " MySQL thread id 41127, query id 82279632 10.250.68.253 megauser\n" + " ---TRANSACTION 0 20522255, not started, process no 26242, OS thread id 140577575196416\n" + " MySQL thread id 33032, query id 82284251 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36174829, not started, process no 26242, OS thread id 140577595963136\n" + " MySQL thread id 32736, query id 82292470 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172502, not started, process no 26242, OS thread id 140577575462656\n" + " MySQL thread id 31003, query id 82290926 10.250.68.253 megauser\n" + " ---TRANSACTION 0 0, not started, process no 26242, OS thread id 140573205587712\n" + " MySQL thread id 30700, query id 63969695 10.11.11.4 webuser\n" + " ---TRANSACTION 0 36175032, not started, process no 26242, OS thread id 140577581852416\n" + " MySQL thread id 29745, query id 82289944 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35986775, not started, process no 26242, OS thread id 140588258346752\n" + " MySQL thread id 29735, query id 82286561 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36174824, not started, process no 26242, OS thread id 140588252755712\n" + " MySQL thread id 29728, query id 82289471 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35332611, not started, process no 26242, OS thread id 140577575728896\n" + " MySQL thread id 29726, query id 82286093 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172735, not started, process no 26242, OS thread id 140577579722496\n" + " MySQL thread id 28478, query id 82283645 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173062, not started, process no 26242, OS thread id 140577579190016\n" + " MySQL thread id 28162, query id 82284914 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172453, not started, process no 26242, OS thread id 140588244502272\n" + " MySQL thread id 28129, query id 82292744 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175695, not started, process no 26242, OS thread id 140577586644736\n" + " MySQL thread id 28024, query id 82292417 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36099420, not started, process no 26242, OS thread id 140577584781056\n" + " MySQL thread id 26063, query id 82282029 10.250.68.253 megauser\n" + " ---TRANSACTION 0 34608541, not started, process no 26242, OS thread id 140577597294336\n" + " MySQL thread id 21663, query id 82290763 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173404, not started, process no 26242, OS thread id 140577612736256\n" + " MySQL thread id 21295, query id 82289031 10.250.68.253 megauser\n" + " ---TRANSACTION 0 35955277, not started, process no 26242, OS thread id 140577598891776\n" + " MySQL thread id 20299, query id 82284852 10.250.68.253 megauser\n" + " ---TRANSACTION 0 32833546, not started, process no 26242, OS thread id 140577600489216\n" + " MySQL thread id 20274, query id 82289049 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36075568, not started, process no 26242, OS thread id 140577599956736\n" + " MySQL thread id 20236, query id 82282700 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36158411, not started, process no 26242, OS thread id 140577606346496\n" + " MySQL thread id 20211, query id 82282996 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172489, not started, process no 26242, OS thread id 140577619392256\n" + " MySQL thread id 18940, query id 82282296 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172742, not started, process no 26242, OS thread id 140577610606336\n" + " MySQL thread id 18784, query id 82283710 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36173944, not started, process no 26242, OS thread id 140577630574336\n" + " MySQL thread id 17722, query id 82287158 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172636, not started, process no 26242, OS thread id 140577624450816\n" + " MySQL thread id 17152, query id 82287077 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175590, not started, process no 26242, OS thread id 140588257548032\n" + " MySQL thread id 17148, query id 82292104 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175905, not started, process no 26242, OS thread id 140577562134272\n" + " MySQL thread id 16370, query id 82292534 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172454, not started, process no 26242, OS thread id 140577638561536\n" + " MySQL thread id 16208, query id 82284681 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36175505, not started, process no 26242, OS thread id 140577632171776\n" + " MySQL thread id 16147, query id 82290650 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172901, not started, process no 26242, OS thread id 140588260742912\n" + " MySQL thread id 23, query id 82284583 10.250.68.253 megauser\n" + " ---TRANSACTION 0 36172092, ACTIVE 15 sec, process no 26242, OS thread id 140577580787456 fetching rows, thread declared inside InnoDB 295\n" + " mysql tables in use 4, locked 0\n" + " MySQL thread id 213293, query id 82275700 10.11.11.23 megauser Sending data\n" + " SELECT \n" + " t.*,\n" + " concat(LPAD(t.time_spent div (60*60), 2, \"0\"), \":\", LPAD((t.time_spent - (t.time_spent div (60*60))*60*60) div 60, 2, \"0\")) as time_spent\n" + " FROM (\n" + " SELECT\n" + " nce.id as eventId,\n" + " nce.client_id as clientId,\n" + " u.user_id as createdById,\n" + " u.name as createdBy,\n" + " nce.createdon as createdOn,\n" + " nce.due_date as dueDate,\n" + " nce.SolutionDate as solutionDate,\n" + " utg.name as escalationTo,\n" + " ncei.createdOn as escalationOn,\n" + " ifnull(ncei.time_spent, nce.SolutionDate) as time_spent\n" + " FROM net_client_events nce\n" + " INNER JOIN users u ON (u.user_id = nce.createdby)\n" + " I\n" + " Trx read view will not see trx with id >= 0 36172093, sees < 0 36172035\n" + " ---TRANSACTION 0 36172051, ACTIVE 15 sec, process no 26242, OS thread id 140577596495616\n" + " MySQL thread id 206403, query id 82292743 10.250.74.24 megauser\n" + " show innodb status\n" + " Trx read view will not see trx with id >= 0 36172052, sees < 0 36148753\n" + " --------\n" + " FILE I/O\n" + " --------\n" + " I/O thread 0 state: waiting for i/o request (insert buffer thread)\n" + " I/O thread 1 state: waiting for i/o request (log thread)\n" + " I/O thread 2 state: waiting for i/o request (read thread)\n" + " I/O thread 3 state: waiting for i/o request (write thread)\n" + " Pending normal aio reads: 0, aio writes: 0,\n" + " ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0\n" + " Pending flushes (fsync) log: 0; buffer pool: 0\n" + " 782323 OS file reads, 45000910 OS file writes, 249071 OS fsyncs\n" + " 2.10 reads/s, 16384 avg bytes/read, 36.90 writes/s, 1.70 fsyncs/s\n" + " -------------------------------------\n" + " INSERT BUFFER AND ADAPTIVE HASH INDEX\n" + " -------------------------------------\n" + " Ibuf: size 1, free list len 80, seg size 82,\n" + " 80435 inserts, 80432 merged recs, 29620 merges\n" + " Hash table size 19124899, node heap has 61013 buffer(s)\n" + " 637148.89 hash searches/s, 7918.61 non-hash searches/s\n" + " ---\n" + " LOG\n" + " ---\n" + " Log sequence number 46 1992021845\n" + " Log flushed up to 46 1992020670\n" + " Last checkpoint at 46 1936943800\n" + " 0 pending log writes, 0 pending chkp writes\n" + " 44636752 log i/o's done, 35.80 log i/o's/second\n" + " ----------------------\n" + " BUFFER POOL AND MEMORY\n" + " ----------------------\n" + " Total memory allocated 10613712218; in additional pool allocated 20971520\n" + " Dictionary memory allocated 2406488\n" + " Buffer pool size 589824\n" + " Free buffers 35\n" + " Database pages 528776\n" + " Modified db pages 3828\n" + " Pending reads 0\n" + " Pending writes: LRU 0, flush list 0, single page 0\n" + " Pages read 4269977, created 16521, written 614163\n" + " 2.10 reads/s, 0.40 creates/s, 1.00 writes/s\n" + " Buffer pool hit rate 1000 / 1000\n" + " --------------\n" + " ROW OPERATIONS\n" + " --------------\n" + " 1 queries inside InnoDB, 0 queries in queue\n" + " 3 read views open inside InnoDB\n" + " Main thread process no. 26242, id 140577651181312, state: sleeping\n" + " Number of rows inserted 23211477, updated 3947615, deleted 1726747, read 58696157471\n" + " 5.70 inserts/s, 12.80 updates/s, 0.00 deletes/s, 2526852.61 reads/s\n" + " ----------------------------\n" + " END OF INNODB MONITOR OUTPUT\n" + " ============================\n" + " "; final Pattern pattern = Pattern.compile(regex, Pattern.CASE_INSENSITIVE | Pattern.MULTILINE); final Matcher matcher = pattern.matcher(string); while (matcher.find()) { System.out.println("Full match: " + matcher.group(0)); for (int i = 1; i <= matcher.groupCount(); i++) { System.out.println("Group " + i + ": " + matcher.group(i)); } } } }

Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for Java, please visit: https://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html