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

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 Swift 5.2, please visit: https://developer.apple.com/documentation/foundation/nsregularexpression