secret
Created

  • Download Gist
gistfile1.txt
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788
*************************** 1. row ***************************
Status:
=====================================
120220 18:58:43 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 42 seconds
----------
BACKGROUND THREAD
----------
fsync callers: 1277717 buffer pool, 623 other, 1766 checkpoint, 38036 log aio, 202064647 log sync, 0 archive
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 21470490, signal count 592290219
Mutex spin waits 787619198, rounds 613707232, OS waits 2557966
RW-shared spins 120937642, OS waits 11514355; RW-excl spins 39459402, OS waits 6008079
Spin rounds per wait: 0.78 mutex, 4.17 RW-shared, 32.65 RW-excl
--------
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 (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (read thread)
I/O thread 7 state: waiting for i/o request (read thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
I/O thread 10 state: waiting for i/o request (write thread)
I/O thread 11 state: waiting for i/o request (write thread)
I/O thread 12 state: waiting for i/o request (write thread)
I/O thread 13 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
10679606 OS file reads, 262862495 OS file writes, 203382367 OS fsyncs
32.62 reads/s, 18608 avg bytes/read, 561.27 writes/s, 345.99 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7,
1243307 inserts, 1307401 merged recs, 701785 merges
Hash table size 250747333, used cells 181399962, node heap has 475348 buffer(s)
381470.08 hash searches/s, 246901.57 non-hash searches/s
---
LOG
---
Log sequence number 424 1910844241
Log flushed up to 424 1910843877
Last checkpoint at 424 1909998195
Max checkpoint age 868547913
Modified age 846046
Checkpoint age 846046
0 pending log writes, 0 pending chkp writes
202103077 log i/o's done, 340.66 log i/o's/second, 202064768 syncs, 38081 checkpoints
log sync callers: 68271267 buffer pool, background 555191 sync and 0 async, 0 internal, checkpoint 38081 sync and 0 async, 0 archive, commit 201894365 sync and 0 async
log sync syncers: 55293 buffer pool, background 117178 sync and 0 async, 0 internal, checkpoint 1 sync and 0 async, 0 archive, commit 201892296 sync and 0 async
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 0; in additional pool allocated 0
Internal hash tables (constant factor + variable factor)
Adaptive hash index 9794084504 (2005978664 + 7788105840)
Page hash 125374552
Dictionary cache 1505458512 (1504486008 + 972504)
File system 83520 (82672 + 848)
Lock system 313539128 (313434872 + 104256)
Recovery system 0 (0 + 0)
Threads 431736 (406936 + 24800)
innodb_io_pattern 0 (0 + 0)
Buffer pool size 7733248
Buffer pool size, bytes 126701535232
Free buffers 1
Database pages 7257899
Modified db pages 1253
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 12174857, created 420573, written 68271267
36.88 reads/s, 0.76 creates/s, 231.99 writes/s
Buffer pool hit rate 1000 / 1000
--------------
ROW OPERATIONS
--------------
1 queries inside InnoDB, 0 queries in queue
4 read views open inside InnoDB
Main thread process no. 9484, id 1291336000, state: sleeping
Number of rows inserted 49928036, updated 23727056, deleted 39745427, read 772367614382
87.66 inserts/s, 32.12 updates/s, 68.00 deletes/s, 5782706.72 reads/s
------------------------
LATEST DETECTED DEADLOCK
------------------------
120220 3:04:33
*** (1) TRANSACTION:
TRANSACTION 42 2026296844, ACTIVE 22 sec, process no 9484, OS thread id 1316612416 inserting
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1216, undo log entries 1
MySQL thread id 35799, query id 1284321375 app3.dal.fetlife 10.18.5.74 fetlife update
INSERT INTO `friends` (`user_id`, `friend_id`, `created_at`, `updated_at`) VALUES (1193135, 319931, '2012-02-20 09:04:11', '2012-02-20 09:04:11')
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 10869218 n bits 1000 index `index_friends_on_user_id_and_friend_id` of table `fetlife_production/friends` trx id 42 2026296844 lock mode S waiting
*** (2) TRANSACTION:
TRANSACTION 42 2026293062, ACTIVE 22 sec, process no 9484, OS thread id 1312692544 setting auto-inc lock
mysql tables in use 1, locked 1
8 lock struct(s), heap size 3024, undo log entries 2
MySQL thread id 35813, query id 1284482230 app3.dal.fetlife 10.18.5.74 fetlife update
INSERT INTO `friends` (`user_id`, `friend_id`, `created_at`, `updated_at`) VALUES (319931, 1193135, '2012-02-20 09:04:33', '2012-02-20 09:04:33')
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 10869218 n bits 1000 index `index_friends_on_user_id_and_friend_id` of table `fetlife_production/friends` trx id 42 2026293062 lock_mode X locks rec but not gap
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `fetlife_production/friends` trx id 42 2026293062 lock mode AUTO-INC waiting
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 42 2569535996
Purge done for trx's n:o < 42 2569244884 undo n:o < 0 0
History list length 2006
Total number of lock structs in row lock hash table 1
... truncated...
* FROM `activity_feed_mutings` WHERE (`activity_feed_mutings`.muter_id = 962704)
---TRANSACTION 42 2569535727, not started, process no 9484, OS thread id 1322289472 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42847, query id 1969924263 support1.dal.fetlife 10.18.5.76 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 42179 LIMIT 1
---TRANSACTION 42 2569535972, not started, process no 9484, OS thread id 1313098048 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42846, query id 1969924242 support1.dal.fetlife 10.18.5.76 fetlife statistics
SELECT `activity_feed_feeds`.* FROM `activity_feed_feeds` WHERE `activity_feed_feeds`.`feed` = 'pictures' AND (`activity_feed_feeds`.user_id = 462232) LIMIT 1
---TRANSACTION 42 2569534577, not started, process no 9484, OS thread id 1298499904 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42845, query id 1969924285 support1.dal.fetlife 10.18.5.76 fetlife statistics
SELECT `activity_feed_feeds`.* FROM `activity_feed_feeds` WHERE `activity_feed_feeds`.`feed` = 'group' AND (`activity_feed_feeds`.user_id = 796328) LIMIT 1
---TRANSACTION 42 2569532302, not started, process no 9484, OS thread id 1298364736
MySQL thread id 42843, query id 1969919352 support1.dal.fetlife 10.18.5.76 fetlife
---TRANSACTION 42 2569535960, not started, process no 9484, OS thread id 1303501120 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42844, query id 1969924252 support1.dal.fetlife 10.18.5.76 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 71784 LIMIT 1
---TRANSACTION 42 2569515989, not started, process no 9484, OS thread id 1331480896
MySQL thread id 42841, query id 1969898300 support1.dal.fetlife 10.18.5.76 fetlife
---TRANSACTION 42 2569335612, not started, process no 9484, OS thread id 1314044224
MySQL thread id 42840, query id 1969673282 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569444960, not started, process no 9484, OS thread id 1339050304
MySQL thread id 42839, query id 1969805461 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569533340, not started, process no 9484, OS thread id 1327696192
MySQL thread id 42838, query id 1969920759 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 0 0, not started, process no 9484, OS thread id 1294444864
MySQL thread id 42837, query id 1968267471 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2446933946, not started, process no 9484, OS thread id 1316342080
MySQL thread id 42836, query id 1968263902 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569476409, not started, process no 9484, OS thread id 1321072960
MySQL thread id 42835, query id 1969845295 support1.dal.fetlife 10.18.5.76 fetlife
---TRANSACTION 42 2569534731, not started, process no 9484, OS thread id 1313503552 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42834, query id 1969924258 support1.dal.fetlife 10.18.5.76 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 27968 LIMIT 1
---TRANSACTION 42 2569469139, not started, process no 9484, OS thread id 1330399552 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42833, query id 1969924287 support1.dal.fetlife 10.18.5.76 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 1195366 LIMIT 1
---TRANSACTION 42 2569533810, not started, process no 9484, OS thread id 1292147008
MySQL thread id 42832, query id 1969921376 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569521757, not started, process no 9484, OS thread id 1331751232
MySQL thread id 42831, query id 1969905559 support1.dal.fetlife 10.18.5.76 fetlife
---TRANSACTION 42 2569520716, not started, process no 9484, OS thread id 1333643584
MySQL thread id 42830, query id 1969904653 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569515393, not started, process no 9484, OS thread id 1330129216
MySQL thread id 42829, query id 1969897573 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569534893, not started, process no 9484, OS thread id 1324181824 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42828, query id 1969924316 support2.dal.fetlife 10.12.159.66 fetlife Sending data
SELECT `messages`.* FROM `messages` WHERE (`messages`.side_id = 47986307) ORDER BY created_at DESC LIMIT 1
---TRANSACTION 42 2569474607, not started, process no 9484, OS thread id 1334589760
MySQL thread id 42827, query id 1969842464 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569535241, not started, process no 9484, OS thread id 1296066880
MySQL thread id 42826, query id 1969923195 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569478080, not started, process no 9484, OS thread id 1327020352
MySQL thread id 42825, query id 1969847347 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569534720, not started, process no 9484, OS thread id 1333778752 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42824, query id 1969924296 support2.dal.fetlife 10.12.159.66 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 948225 LIMIT 1
---TRANSACTION 42 2569534882, not started, process no 9484, OS thread id 1311746368 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42823, query id 1969924301 support2.dal.fetlife 10.12.159.66 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 104728 LIMIT 1
---TRANSACTION 42 2569527318, not started, process no 9484, OS thread id 1335671104
MySQL thread id 42822, query id 1969918723 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569533385, not started, process no 9484, OS thread id 1337157952
MySQL thread id 42820, query id 1969920818 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569243684, not started, process no 9484, OS thread id 1321208128
MySQL thread id 42818, query id 1969817116 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569535824, not started, process no 9484, OS thread id 1330805056 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42817, query id 1969924235 support2.dal.fetlife 10.12.159.66 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 214838 LIMIT 1
---TRANSACTION 42 2569535982, not started, process no 9484, OS thread id 1297418560 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42816, query id 1969924248 support2.dal.fetlife 10.12.159.66 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 211375 LIMIT 1
---TRANSACTION 42 2569471793, not started, process no 9484, OS thread id 1292282176
MySQL thread id 42815, query id 1969839223 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569262633, not started, process no 9484, OS thread id 1296337216
MySQL thread id 42814, query id 1969577238 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569535748, not started, process no 9484, OS thread id 1330534720 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42812, query id 1969924269 support2.dal.fetlife 10.12.159.66 fetlife Sending data
SELECT `activity_feed_mutings`.* FROM `activity_feed_mutings` WHERE (`activity_feed_mutings`.muter_id = 441357)
---TRANSACTION 42 2569533927, not started, process no 9484, OS thread id 1307826496 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42813, query id 1969924271 support2.dal.fetlife 10.12.159.66 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 123602 LIMIT 1
---TRANSACTION 42 2569535971, not started, process no 9484, OS thread id 1302825280 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42811, query id 1969924251 support2.dal.fetlife 10.12.159.66 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 603928 LIMIT 1
---TRANSACTION 42 2569535970, not started, process no 9484, OS thread id 1298905408
mysql tables in use 1, locked 0
MySQL thread id 42810, query id 1969924237 support2.dal.fetlife 10.12.159.66 fetlife
SELECT `users`.* FROM `users` WHERE `users`.`id` = 6441 LIMIT 1
---TRANSACTION 42 2569115164, not started, process no 9484, OS thread id 1329858880
MySQL thread id 42809, query id 1969903714 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569535975, not started, process no 9484, OS thread id 1319450944 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42808, query id 1969924240 support2.dal.fetlife 10.12.159.66 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 440979 LIMIT 1
---TRANSACTION 42 2569532459, not started, process no 9484, OS thread id 1299851584
MySQL thread id 42807, query id 1969919720 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569535551, not started, process no 9484, OS thread id 1309854016 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42806, query id 1969924266 support2.dal.fetlife 10.12.159.66 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 3178 LIMIT 1
---TRANSACTION 42 2569409090, not started, process no 9484, OS thread id 1333102912
MySQL thread id 42805, query id 1969759570 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569535958, not started, process no 9484, OS thread id 1295661376
MySQL thread id 42804, query id 1969924182 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569535796, not started, process no 9484, OS thread id 1298229568 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42803, query id 1969924270 support2.dal.fetlife 10.12.159.66 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 27394 LIMIT 1
---TRANSACTION 42 2569535861, not started, process no 9484, OS thread id 1306609984 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42802, query id 1969924265 support2.dal.fetlife 10.12.159.66 fetlife Sending data
SELECT `activity_feed_mutings`.* FROM `activity_feed_mutings` WHERE (`activity_feed_mutings`.muter_id = 447191)
---TRANSACTION 42 2569501093, not started, process no 9484, OS thread id 1323370816
MySQL thread id 42801, query id 1969878232 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569535968, not started, process no 9484, OS thread id 1296877888 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42800, query id 1969924243 support2.dal.fetlife 10.12.159.66 fetlife Sending data
SELECT `activity_feed_mutings`.* FROM `activity_feed_mutings` WHERE (`activity_feed_mutings`.muter_id = 529393)
---TRANSACTION 42 2569535879, not started, process no 9484, OS thread id 1298770240 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42799, query id 1969924291 support2.dal.fetlife 10.12.159.66 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 1126898 LIMIT 1
---TRANSACTION 42 2569534419, not started, process no 9484, OS thread id 1306204480
MySQL thread id 42798, query id 1969922147 support2.dal.fetlife 10.12.159.66 fetlife
---TRANSACTION 42 2569533722, not started, process no 9484, OS thread id 1294985536
MySQL thread id 42795, query id 1969921260 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569523867, not started, process no 9484, OS thread id 1293904192
MySQL thread id 42790, query id 1969908338 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569535413, not started, process no 9484, OS thread id 1302690112
MySQL thread id 42788, query id 1969923421 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569534918, not started, process no 9484, OS thread id 1305393472
MySQL thread id 42787, query id 1969922781 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569531304, not started, process no 9484, OS thread id 1326074176
MySQL thread id 42786, query id 1969917915 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569530684, not started, process no 9484, OS thread id 1335941440 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42784, query id 1969924268 app6.dal.fetlife 10.36.99.148 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569531233, not started, process no 9484, OS thread id 1301068096
MySQL thread id 42783, query id 1969917817 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569534751, not started, process no 9484, OS thread id 1310935360
MySQL thread id 42782, query id 1969922572 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569535952, not started, process no 9484, OS thread id 1307015488 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42781, query id 1969924259 app6.dal.fetlife 10.36.99.148 fetlife Sending data
SELECT COUNT(*) FROM `friendship_requests` WHERE (`friendship_requests`.user_id = 526281)
---TRANSACTION 42 2569533702, not started, process no 9484, OS thread id 1326614848 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42780, query id 1969924306 app6.dal.fetlife 10.36.99.148 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569530560, not started, process no 9484, OS thread id 1302960448
MySQL thread id 42779, query id 1969916929 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569535724, not started, process no 9484, OS thread id 1312151872
MySQL thread id 42778, query id 1969923840 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569535927, not started, process no 9484, OS thread id 1322965312 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42777, query id 1969924261 app6.dal.fetlife 10.36.99.148 fetlife Sending data
SELECT `permissions`.* FROM `permissions` WHERE (`permissions`.user_id = 994991)
---TRANSACTION 42 2569535552, not started, process no 9484, OS thread id 1295391040
MySQL thread id 42776, query id 1969923620 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569534423, not started, process no 9484, OS thread id 1336752448 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42775, query id 1969924289 app6.dal.fetlife 10.36.99.148 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569534693, not started, process no 9484, OS thread id 1299310912
MySQL thread id 42774, query id 1969922501 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569530700, not started, process no 9484, OS thread id 1304312128
MySQL thread id 42773, query id 1969917109 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569533453, not started, process no 9484, OS thread id 1309989184
MySQL thread id 42771, query id 1969920912 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569533798, not started, process no 9484, OS thread id 1323641152
MySQL thread id 42770, query id 1969921362 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569535394, not started, process no 9484, OS thread id 1318369600
MySQL thread id 42769, query id 1969923397 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569531482, not started, process no 9484, OS thread id 1308232000 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42768, query id 1969924321 app6.dal.fetlife 10.36.99.148 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569534629, not started, process no 9484, OS thread id 1332427072 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42766, query id 1969924312 app6.dal.fetlife 10.36.99.148 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569535134, not started, process no 9484, OS thread id 1307150656
MySQL thread id 42765, query id 1969923047 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2568479226, not started, process no 9484, OS thread id 1307691328
MySQL thread id 42763, query id 1968576764 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569535962, not started, process no 9484, OS thread id 1324992832 starting index read, thread declared inside InnoDB 500
mysql tables in use 3, locked 0
MySQL thread id 42762, query id 1969924280 app6.dal.fetlife 10.36.99.148 fetlife Sending data
SELECT COUNT(DISTINCT `users`.`id`) FROM `users` LEFT OUTER JOIN `pictures` ON `pictures`.`user_id` = `users`.`id` AND is_avatar = 1 INNER JOIN `rsvps` ON `users`.id = `rsvps`.user_id WHERE ((`rsvps`.event_id = 82585) AND ((rsvps.status = 'yes'))) LIMIT 16
---TRANSACTION 42 2569535985, not started, process no 9484, OS thread id 1330940224 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42760, query id 1969924241 app6.dal.fetlife 10.36.99.148 fetlife statistics
SELECT `comments`.* FROM `comments` WHERE `comments`.`id` = 26111660 LIMIT 1
---TRANSACTION 42 2569533644, not started, process no 9484, OS thread id 1336211776 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42759, query id 1969924317 app6.dal.fetlife 10.36.99.148 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569530749, not started, process no 9484, OS thread id 1332156736
MySQL thread id 42758, query id 1969917187 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569534726, not started, process no 9484, OS thread id 1303771456
MySQL thread id 42756, query id 1969922543 app6.dal.fetlife 10.36.99.148 fetlife
---TRANSACTION 42 2569533254, not started, process no 9484, OS thread id 1322154304 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42755, query id 1969924304 app5.dal.fetlife 10.18.5.81 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569534623, not started, process no 9484, OS thread id 1336346944 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42754, query id 1969924276 app6.dal.fetlife 10.36.99.148 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569534775, not started, process no 9484, OS thread id 1325128000
MySQL thread id 42753, query id 1969924322 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569535890, not started, process no 9484, OS thread id 1332967744 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42752, query id 1969924264 app5.dal.fetlife 10.18.5.81 fetlife Sending data
SELECT COUNT(*) FROM `events` WHERE (`events`.created_by_user_id = 260980) AND (end_date_time >= '2012-02-19 00:58:44')
---TRANSACTION 42 2569533740, not started, process no 9484, OS thread id 1322694976 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42750, query id 1969924297 app5.dal.fetlife 10.18.5.81 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569533770, not started, process no 9484, OS thread id 1322559808
MySQL thread id 42748, query id 1969921325 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569534527, not started, process no 9484, OS thread id 1335130432 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42747, query id 1969924305 app5.dal.fetlife 10.18.5.81 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569535744, not started, process no 9484, OS thread id 1307556160
MySQL thread id 42745, query id 1969923868 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569535355, not started, process no 9484, OS thread id 1331345728
MySQL thread id 42744, query id 1969923340 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569523604, not started, process no 9484, OS thread id 1309583680
MySQL thread id 42742, query id 1969920745 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569530822, not started, process no 9484, OS thread id 1307285824
MySQL thread id 42741, query id 1969917260 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569535939, not started, process no 9484, OS thread id 1302284608 starting index read, thread declared inside InnoDB 500
mysql tables in use 8, locked 0
MySQL thread id 42739, query id 1969924274 app5.dal.fetlife 10.18.5.81 fetlife Sending data
SELECT `sides`.`id` AS t0_r0, `sides`.`conversation_id` AS t0_r1, `sides`.`user_id` AS t0_r2, `sides`.`with_user_id` AS t0_r3, `sides`.`archived` AS t0_r4, `sides`.`new_messages` AS t0_r5, `sides`.`created_at` AS t0_r6, `sides`.`updated_at` AS t0_r7, `conversations`.`id` AS t1_r0, `conversations`.`subject` AS t1_r1, `conversations`.`created_at` AS t1_r2, `conversations`.`updated_at` AS t1_r3, `users`.`id` AS t2_r0, `users`.`nickname` AS t2_r1, `users`.`email` AS t2_r2, `users`.`created_at` AS t2_r3, `users`.`updated_at` AS t2_r4, `users`.`sex` AS t2_r5, `users`.`role` AS t2_r6, `users`.`sexua
---TRANSACTION 42 2569535984, not started, process no 9484, OS thread id 1319856448 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42738, query id 1969924246 app4.dal.fetlife 10.18.5.79 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 45615 LIMIT 1
---TRANSACTION 42 2569535852, not started, process no 9484, OS thread id 1308772672
MySQL thread id 42736, query id 1969924025 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569535762, not started, process no 9484, OS thread id 1323100480 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
MySQL thread id 42735, query id 1969924290 app5.dal.fetlife 10.18.5.81 fetlife Updating
UPDATE `messages` SET `new_message` = 0 WHERE `messages`.`id` = 196555952
---TRANSACTION 42 2569535979, not started, process no 9484, OS thread id 1324316992 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42734, query id 1969924236 app4.dal.fetlife 10.18.5.79 fetlife statistics
SELECT `pictures`.* FROM `pictures` WHERE `pictures`.`id` = 9483227 AND (`pictures`.user_id = 223497) LIMIT 1
---TRANSACTION 42 2569533190, not started, process no 9484, OS thread id 1318910272 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42733, query id 1969924319 app5.dal.fetlife 10.18.5.81 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569533017, not started, process no 9484, OS thread id 1337293120 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42732, query id 1969924295 app5.dal.fetlife 10.18.5.81 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569535410, not started, process no 9484, OS thread id 1337968960
MySQL thread id 42730, query id 1969923417 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569535404, not started, process no 9484, OS thread id 1323505984
MySQL thread id 42728, query id 1969923411 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569533119, not started, process no 9484, OS thread id 1304447296 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42727, query id 1969924308 app4.dal.fetlife 10.18.5.79 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569535981, not started, process no 9484, OS thread id 1338779968 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42726, query id 1969924255 app5.dal.fetlife 10.18.5.81 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 672805 LIMIT 1
---TRANSACTION 42 2569531914, not started, process no 9484, OS thread id 1297148224 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42725, query id 1969924300 app4.dal.fetlife 10.18.5.79 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569535277, not started, process no 9484, OS thread id 1301743936
MySQL thread id 42724, query id 1969923243 app5.dal.fetlife 10.18.5.81 fetlife
---TRANSACTION 42 2569535275, not started, process no 9484, OS thread id 1306880320
MySQL thread id 42722, query id 1969923238 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569531939, not started, process no 9484, OS thread id 1297013056
MySQL thread id 42719, query id 1969918816 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569534691, not started, process no 9484, OS thread id 1311611200
MySQL thread id 42717, query id 1969922496 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569533974, not started, process no 9484, OS thread id 1331886400 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42715, query id 1969924309 app4.dal.fetlife 10.18.5.79 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569534046, not started, process no 9484, OS thread id 1329318208
MySQL thread id 42713, query id 1969921683 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569534870, not started, process no 9484, OS thread id 1306339648
MySQL thread id 42711, query id 1969922727 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569535411, not started, process no 9484, OS thread id 1314720064
MySQL thread id 42710, query id 1969923418 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569535654, not started, process no 9484, OS thread id 1327290688
MySQL thread id 42708, query id 1969923742 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569534546, not started, process no 9484, OS thread id 1335535936
MySQL thread id 42706, query id 1969922322 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569535454, not started, process no 9484, OS thread id 1327561024
MySQL thread id 42705, query id 1969923475 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569531172, not started, process no 9484, OS thread id 1320126784 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42704, query id 1969924320 app3.dal.fetlife 10.18.5.74 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569535941, not started, process no 9484, OS thread id 1308502336
MySQL thread id 42703, query id 1969924173 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569531082, not started, process no 9484, OS thread id 1294309696 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42702, query id 1969924286 app4.dal.fetlife 10.18.5.79 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569532573, not started, process no 9484, OS thread id 1310529856 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42701, query id 1969924315 app3.dal.fetlife 10.18.5.74 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569531179, not started, process no 9484, OS thread id 1333508416
MySQL thread id 42698, query id 1969917737 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569530660, not started, process no 9484, OS thread id 1301338432 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42697, query id 1969924313 app4.dal.fetlife 10.18.5.79 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569534327, not started, process no 9484, OS thread id 1305528640
MySQL thread id 42696, query id 1969922043 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569534915, not started, process no 9484, OS thread id 1331075392
MySQL thread id 42695, query id 1969922793 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569532993, not started, process no 9484, OS thread id 1306069312
MySQL thread id 42694, query id 1969920296 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569535983, not started, process no 9484, OS thread id 1316612416 starting index read, thread declared inside InnoDB 500
mysql tables in use 3, locked 0
MySQL thread id 42693, query id 1969924262 app3.dal.fetlife 10.18.5.74 fetlife Sending data
SELECT COUNT(DISTINCT `friends`.`id`) FROM `friends` LEFT OUTER JOIN `users` ON `users`.`id` = `friends`.`friend_id` WHERE (user_id = 853813 AND
(select count(*) from
friends frs where user_id = 1263581
and friend_id = friends.friend_id) > 0) LIMIT 10
---TRANSACTION 42 2569535692, not started, process no 9484, OS thread id 1328642368
MySQL thread id 42690, query id 1969923797 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569535608, not started, process no 9484, OS thread id 1292011840
MySQL thread id 42689, query id 1969923683 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569535928, not started, process no 9484, OS thread id 1334860096 starting index read, thread declared inside InnoDB 500
mysql tables in use 2, locked 0
MySQL thread id 42688, query id 1969924244 app3.dal.fetlife 10.18.5.74 fetlife Sending data
SELECT COUNT(DISTINCT `group_memberships`.`id`) FROM `group_memberships` LEFT OUTER JOIN `groups` ON `groups`.`id` = `group_memberships`.`group_id` WHERE `group_memberships`.`role` IN ('owner', 'leader') AND (`group_memberships`.group_id = 174)
---TRANSACTION 42 2569535365, not started, process no 9484, OS thread id 1320397120
MySQL thread id 42687, query id 1969923355 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569533735, not started, process no 9484, OS thread id 1312692544
MySQL thread id 42686, query id 1969921273 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569531447, not started, process no 9484, OS thread id 1334724928
MySQL thread id 42684, query id 1969918140 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569534885, not started, process no 9484, OS thread id 1328236864
MySQL thread id 42682, query id 1969922743 app4.dal.fetlife 10.18.5.79 fetlife
---TRANSACTION 42 2569531246, not started, process no 9484, OS thread id 1300662592
MySQL thread id 42681, query id 1969917838 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569533669, not started, process no 9484, OS thread id 1322019136
MySQL thread id 42680, query id 1969921191 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569535172, not started, process no 9484, OS thread id 1321613632 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42676, query id 1969924303 app3.dal.fetlife 10.18.5.74 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569528213, not started, process no 9484, OS thread id 1318234432 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42672, query id 1969924284 app3.dal.fetlife 10.18.5.74 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569534139, not started, process no 9484, OS thread id 1312557376
MySQL thread id 42671, query id 1969921804 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569535349, not started, process no 9484, OS thread id 1337022784
MySQL thread id 42670, query id 1969923334 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569532894, not started, process no 9484, OS thread id 1325803840
MySQL thread id 42662, query id 1969920158 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569532735, not started, process no 9484, OS thread id 1322424640
MySQL thread id 42661, query id 1969919938 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569534852, not started, process no 9484, OS thread id 1324452160
MySQL thread id 42658, query id 1969922706 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569535989, not started, process no 9484, OS thread id 1293228352 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42657, query id 1969924247 app3.dal.fetlife 10.18.5.74 fetlife Sending data
SELECT COUNT(*) FROM `pictures` WHERE `pictures`.`only_friends` = 0 AND (`pictures`.user_id = 1160997)
---TRANSACTION 42 2569535464, not started, process no 9484, OS thread id 1319045440
MySQL thread id 42653, query id 1969923489 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569533566, not started, process no 9484, OS thread id 1301473600
MySQL thread id 42652, query id 1969921062 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569535718, not started, process no 9484, OS thread id 1314314560
MySQL thread id 42651, query id 1969923833 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569525814, not started, process no 9484, OS thread id 1312287040
MySQL thread id 42650, query id 1969917674 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569534356, not started, process no 9484, OS thread id 1327966528
MySQL thread id 42649, query id 1969922076 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569535028, not started, process no 9484, OS thread id 1298094400
MySQL thread id 42647, query id 1969922939 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569535872, not started, process no 9484, OS thread id 1293093184 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42646, query id 1969924322 app3.dal.fetlife 10.18.5.74 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569533768, not started, process no 9484, OS thread id 1337698624 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42644, query id 1969924314 app2.dal.fetlife 10.18.5.72 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569535078, not started, process no 9484, OS thread id 1313233216
MySQL thread id 42642, query id 1969922975 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569534237, not started, process no 9484, OS thread id 1294850368
MySQL thread id 42641, query id 1969921924 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569531801, not started, process no 9484, OS thread id 1338915136
MySQL thread id 42639, query id 1969918610 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569534968, not started, process no 9484, OS thread id 1321883968
MySQL thread id 42638, query id 1969922840 app3.dal.fetlife 10.18.5.74 fetlife
---TRANSACTION 42 2569535818, not started, process no 9484, OS thread id 1329994048 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42635, query id 1969924302 app2.dal.fetlife 10.18.5.72 fetlife Sending data
SELECT `pictures`.* FROM `pictures` WHERE (`pictures`.user_id = 1246812 AND (is_avatar = 1)) LIMIT 1
---TRANSACTION 42 2569534704, not started, process no 9484, OS thread id 1325533504
MySQL thread id 42634, query id 1969922515 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569533574, not started, process no 9484, OS thread id 1324587328
MySQL thread id 42633, query id 1969921071 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569535707, not started, process no 9484, OS thread id 1323911488
MySQL thread id 42629, query id 1969923834 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569526680, not started, process no 9484, OS thread id 1335265600
MySQL thread id 42628, query id 1969911942 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569535800, not started, process no 9484, OS thread id 1332291904
MySQL thread id 42626, query id 1969924323 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569535992, not started, process no 9484, OS thread id 1327425856 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42625, query id 1969924267 app2.dal.fetlife 10.18.5.72 fetlife Sending data
SELECT COUNT(*) FROM `group_memberships` WHERE `group_memberships`.`banned` = 0 AND `group_memberships`.`group_id` = 14159
---TRANSACTION 42 2569532428, not started, process no 9484, OS thread id 1335400768
MySQL thread id 42623, query id 1969919535 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569534604, not started, process no 9484, OS thread id 1293363520
MySQL thread id 42621, query id 1969922393 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569535988, not started, process no 9484, OS thread id 1304176960 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42617, query id 1969924245 app2.dal.fetlife 10.18.5.72 fetlife statistics
SELECT `pictures`.* FROM `pictures` WHERE `pictures`.`id` = 7758686 LIMIT 1
---TRANSACTION 42 2569531520, not started, process no 9484, OS thread id 1310665024
MySQL thread id 42615, query id 1969918231 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569534165, not started, process no 9484, OS thread id 1299175744
MySQL thread id 42614, query id 1969921839 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569534571, not started, process no 9484, OS thread id 1310800192
MySQL thread id 42613, query id 1969922368 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569534284, not started, process no 9484, OS thread id 1294174528
MySQL thread id 42612, query id 1969921976 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569535610, not started, process no 9484, OS thread id 1304041792
MySQL thread id 42611, query id 1969923707 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569535993, not started, process no 9484, OS thread id 1297824064 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42610, query id 1969924250 app1.dal.fetlife 10.18.5.70 fetlife Sending data
SELECT `credits`.* FROM `credits` WHERE (`credits`.user_id = 460375) LIMIT 1
---TRANSACTION 42 2569535919, not started, process no 9484, OS thread id 1328101696
MySQL thread id 42609, query id 1969924125 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569534718, not started, process no 9484, OS thread id 1308907840 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42608, query id 1969924318 app2.dal.fetlife 10.18.5.72 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569533503, not started, process no 9484, OS thread id 1311340864
MySQL thread id 42607, query id 1969920984 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569535122, not started, process no 9484, OS thread id 1326750016
MySQL thread id 42606, query id 1969923031 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569535533, not started, process no 9484, OS thread id 1326479680 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42605, query id 1969924307 app2.dal.fetlife 10.18.5.72 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569535244, not started, process no 9484, OS thread id 1327831360 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42604, query id 1969924282 app1.dal.fetlife 10.18.5.70 fetlife Sending data
SELECT `pictures`.* FROM `pictures` WHERE (`pictures`.user_id = 225490 AND (is_avatar = 1)) LIMIT 1
---TRANSACTION 42 2569535991, not started, process no 9484, OS thread id 1295526208 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42603, query id 1969924249 app2.dal.fetlife 10.18.5.72 fetlife statistics
SELECT `users`.* FROM `users` WHERE `users`.`id` = 24322 LIMIT 1
---TRANSACTION 42 2569531453, not started, process no 9484, OS thread id 1293633856
MySQL thread id 42602, query id 1969918145 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569535149, not started, process no 9484, OS thread id 1293769024
MySQL thread id 42601, query id 1969923068 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569535959, not started, process no 9484, OS thread id 1309043008
MySQL thread id 42599, query id 1969924183 app2.dal.fetlife 10.18.5.72 fetlife
---TRANSACTION 42 2569527476, not started, process no 9484, OS thread id 1311205696
MySQL thread id 42598, query id 1969912997 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569535955, not started, process no 9484, OS thread id 1333913920 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42597, query id 1969924293 app1.dal.fetlife 10.18.5.70 fetlife Sending data
SELECT COUNT(*) FROM `websites` WHERE (`websites`.user_id = 728204)
---TRANSACTION 42 2569530699, not started, process no 9484, OS thread id 1322830144
MySQL thread id 42594, query id 1969917107 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569532765, not started, process no 9484, OS thread id 1307420992 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42592, query id 1969924311 app1.dal.fetlife 10.18.5.70 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569535954, not started, process no 9484, OS thread id 1300257088
MySQL thread id 42591, query id 1969924177 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569533466, not started, process no 9484, OS thread id 1296607552 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42588, query id 1969924292 app1.dal.fetlife 10.18.5.70 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569529001, not started, process no 9484, OS thread id 1325668672 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42587, query id 1969924310 app1.dal.fetlife 10.18.5.70 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569535042, not started, process no 9484, OS thread id 1309178176
MySQL thread id 42584, query id 1969922933 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569535736, not started, process no 9484, OS thread id 1336482112 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42583, query id 1969924294 app1.dal.fetlife 10.18.5.70 fetlife Sending data
SELECT COUNT(*) FROM `websites` WHERE (`websites`.user_id = 147478)
---TRANSACTION 42 2569534359, not started, process no 9484, OS thread id 1336076608
MySQL thread id 42581, query id 1969922073 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569535986, not started, process no 9484, OS thread id 1300797760
MySQL thread id 42579, query id 1969924221 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569535980, not started, process no 9484, OS thread id 1334049088
mysql tables in use 1, locked 0
MySQL thread id 42578, query id 1969924238 app1.dal.fetlife 10.18.5.70 fetlife
SELECT `group_comments`.* FROM `group_comments` WHERE `group_comments`.`id` = 25175108 LIMIT 1
---TRANSACTION 42 2569532620, not started, process no 9484, OS thread id 1329588544 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42577, query id 1969924272 app1.dal.fetlife 10.18.5.70 fetlife statistics
SELECT `sites`.* FROM `sites` WHERE `sites`.`domain` = 'fetlife.com' LIMIT 1
---TRANSACTION 42 2569535990, not started, process no 9484, OS thread id 1292958016 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42576, query id 1969924288 app1.dal.fetlife 10.18.5.70 fetlife statistics
SELECT `friends`.* FROM `friends` WHERE `friends`.`id` = 20074145 LIMIT 1
---TRANSACTION 42 2569535895, not started, process no 9484, OS thread id 1299716416
MySQL thread id 42575, query id 1969924105 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569535917, not started, process no 9484, OS thread id 1321478464 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 42572, query id 1969924257 app1.dal.fetlife 10.18.5.70 fetlife Sending data
SELECT `pictures`.* FROM `pictures` WHERE (`pictures`.user_id = 122147 AND (is_avatar = 1)) LIMIT 1
---TRANSACTION 42 2569534570, not started, process no 9484, OS thread id 1328912704
MySQL thread id 42571, query id 1969922350 app1.dal.fetlife 10.18.5.70 fetlife query end
SELECT `bookmarks`.`id` AS t0_r0, `bookmarks`.`user_id` AS t0_r1, `bookmarks`.`group_post_id` AS t0_r2, `bookmarks`.`created_at` AS t0_r3, `bookmarks`.`updated_at` AS t0_r4, `group_posts`.`id` AS t1_r0, `group_posts`.`user_id` AS t1_r1, `group_posts`.`group_id` AS t1_r2, `group_posts`.`title` AS t1_r3, `group_posts`.`body` AS t1_r4, `group_posts`.`created_at` AS t1_r5, `group_posts`.`updated_at` AS t1_r6, `group_posts`.`group_comments_last_made_by_id` AS t1_r7, `group_posts`.`group_comments_last_made_when` AS t1_r8, `group_posts`.`sticky` AS t1_r9, `group_posts`.`closed` AS t1_r10, `group_pos
---TRANSACTION 42 2569534669, not started, process no 9484, OS thread id 1333373248
MySQL thread id 42570, query id 1969922472 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569534303, not started, process no 9484, OS thread id 1307961664
MySQL thread id 42569, query id 1969921999 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569535657, not started, process no 9484, OS thread id 1300392256
MySQL thread id 42568, query id 1969923745 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569534650, not started, process no 9484, OS thread id 1308367168
MySQL thread id 42567, query id 1969922478 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2569525071, not started, process no 9484, OS thread id 1300121920
MySQL thread id 42565, query id 1969909817 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2567524253, not started, process no 9484, OS thread id 1334995264
MySQL thread id 41589, query id 1967360223 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2569517941, not started, process no 9484, OS thread id 1329723712
MySQL thread id 41588, query id 1969900951 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2569524402, not started, process no 9484, OS thread id 1318775104
MySQL thread id 41295, query id 1969908982 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2569535571, not started, process no 9484, OS thread id 1306474816
MySQL thread id 40869, query id 1969923634 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2552932703, not started, process no 9484, OS thread id 1305663808
MySQL thread id 40262, query id 1948948766 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2569535725, not started, process no 9484, OS thread id 1336617280
MySQL thread id 39855, query id 1969923843 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2569530400, not started, process no 9484, OS thread id 1330669888
MySQL thread id 39853, query id 1969916707 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2271410286, not started, process no 9484, OS thread id 1326344512
MySQL thread id 38988, query id 1598188891 app1.dal.fetlife 10.18.5.70 fetlife
---TRANSACTION 42 2567796265, not started, process no 9484, OS thread id 1296202048
MySQL thread id 29840, query id 1967703645 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2569446566, not started, process no 9484, OS thread id 1297688896
MySQL thread id 26613, query id 1969807465 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2542578184, not started, process no 9484, OS thread id 1326209344
MySQL thread id 25816, query id 1935925239 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2569533428, not started, process no 9484, OS thread id 1319180608
MySQL thread id 24815, query id 1969920879 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2567621938, not started, process no 9484, OS thread id 1327155520
MySQL thread id 24274, query id 1967481854 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2567608285, not started, process no 9484, OS thread id 1320532288
MySQL thread id 24273, query id 1967464539 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2566256624, not started, process no 9484, OS thread id 1316206912
MySQL thread id 23324, query id 1965757684 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2552932698, not started, process no 9484, OS thread id 1315936576
MySQL thread id 23321, query id 1948948761 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2554897019, not started, process no 9484, OS thread id 1300527424
MySQL thread id 19466, query id 1951411671 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2568318254, not started, process no 9484, OS thread id 1329183040
MySQL thread id 14956, query id 1968367865 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2563305908, not started, process no 9484, OS thread id 1328507200
MySQL thread id 13228, query id 1962031236 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2569524091, not started, process no 9484, OS thread id 1328372032
MySQL thread id 13227, query id 1969908583 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2569518373, not started, process no 9484, OS thread id 1316882752
MySQL thread id 12949, query id 1969901467 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2560796644, not started, process no 9484, OS thread id 1317288256
MySQL thread id 12948, query id 1958847298 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2568367034, not started, process no 9484, OS thread id 1317017920
MySQL thread id 12915, query id 1968428795 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2569098608, not started, process no 9484, OS thread id 1317693760
MySQL thread id 12848, query id 1969366489 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2569535530, not started, process no 9484, OS thread id 1317558592
MySQL thread id 12827, query id 1969923580 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2569272518, not started, process no 9484, OS thread id 1317423424
MySQL thread id 12798, query id 1969589071 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2560448163, not started, process no 9484, OS thread id 1316747584
MySQL thread id 12781, query id 1958417416 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2569474426, not started, process no 9484, OS thread id 1316477248
MySQL thread id 12779, query id 1969842250 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2569441662, not started, process no 9484, OS thread id 1315801408
MySQL thread id 12776, query id 1969801475 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2569535203, not started, process no 9484, OS thread id 1316071744
MySQL thread id 12774, query id 1969923142 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2569534999, not started, process no 9484, OS thread id 1315531072 setting auto-inc lock
mysql tables in use 1, locked 1
MySQL thread id 12769, query id 1969924281 feed01.dal.fetlife 10.12.159.68 fetlife update
INSERT INTO events (uuid, actor_id, action, target_type, target_id, title, title_without_user_link, body, secondary_target_type, secondary_target_id) VALUES (x'0004B96EE9980CF971FF53F7DFC28E31', 873942, 'like_created', 'Like', '0004b96e-e998-0211-71ff-53f7dfc28e31', '<a href="/users/873942">siiren1975</a> <span class=\'mini_feed_title\'>\n loved one of <a href="/users/381329">Brazilian_Cutie</a>\'s pictures:\n </span>', 'siiren1975 <span class=\'mini_feed_title\'>\n loved one of <a href="/users/381329">Brazilian_Cutie</a>\'s pictures:\n </span>', ' <div class=\'clearfix\'>\n
---TRANSACTION 42 2541989617, not started, process no 9484, OS thread id 1315666240
MySQL thread id 12770, query id 1935210428 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2569517712, not started, process no 9484, OS thread id 1315395904
MySQL thread id 12768, query id 1969900655 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2562237756, not started, process no 9484, OS thread id 1315260736
MySQL thread id 12767, query id 1960658953 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2563305911, not started, process no 9484, OS thread id 1315125568
MySQL thread id 12766, query id 1962031240 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2412774536, not started, process no 9484, OS thread id 1314855232
MySQL thread id 12764, query id 1775336621 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2569534638, not started, process no 9484, OS thread id 1314449728
MySQL thread id 12762, query id 1969922436 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2552932704, not started, process no 9484, OS thread id 1292417344
MySQL thread id 12760, query id 1948948769 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2569420083, not started, process no 9484, OS thread id 1314584896
MySQL thread id 12757, query id 1969773837 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2569441696, not started, process no 9484, OS thread id 1302419776
MySQL thread id 12637, query id 1969801510 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2562237710, not started, process no 9484, OS thread id 1313638720
MySQL thread id 12750, query id 1960658895 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2569272532, not started, process no 9484, OS thread id 1291876672
MySQL thread id 12748, query id 1969589085 feed02.dal.fetlife 10.36.99.139 fetlife
---TRANSACTION 42 2569535770, not started, process no 9484, OS thread id 1303230784 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 12647, query id 1969924279 feed02.dal.fetlife 10.36.99.139 fetlife Sending data
SELECT COUNT(*) AS count FROM trends
WHERE deleted_at IS NULL AND uuid > x'0004B939973F5820B6C63B752621AA36'
ORDER BY uuid DESC
---TRANSACTION 42 2552932700, not started, process no 9484, OS thread id 1296742720
MySQL thread id 12584, query id 1948948763 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2508755631, not started, process no 9484, OS thread id 1294580032
MySQL thread id 12562, query id 1893966490 feed01.dal.fetlife 10.12.159.68 fetlife
---TRANSACTION 42 2569535995, ACTIVE 0 sec, process no 9484, OS thread id 1332697408 committing
MySQL thread id 42761, query id 1969924234 app5.dal.fetlife 10.18.5.81 fetlife Sending data
SELECT COUNT(*) FROM `events` WHERE (`events`.created_by_user_id = 447131) AND (end_date_time < '2012-02-19 00:58:44' and end_date_time > '2012-02-17 00:58:44')
Trx read view will not see trx with id >= 42 2569535996, sees < 42 2569351820
---TRANSACTION 42 2569535994, ACTIVE 0 sec, process no 9484, OS thread id 1317964096 committing
MySQL thread id 42640, query id 1969924233 app2.dal.fetlife 10.18.5.72 fetlife preparing
SELECT `users`.* FROM `users` WHERE `users`.`id` = 277142 LIMIT 1
Trx read view will not see trx with id >= 42 2569535995, sees < 42 2569351820
---TRANSACTION 42 2569534781, ACTIVE 1 sec, process no 9484, OS thread id 1292687680, thread declared inside InnoDB 231
mysql tables in use 3, locked 0
MySQL thread id 42731, query id 1969922614 app4.dal.fetlife 10.18.5.79 fetlife Sending data
SELECT COUNT(DISTINCT `videos`.`id`) FROM `videos` LEFT OUTER JOIN `users` ON `users`.`id` = `videos`.`creator_id` WHERE `videos`.`state` = 'encoded' AND (`videos`.site_id = 1) AND ((videos.creator_id IN (SELECT friends.friend_id FROM friends WHERE friends.user_id = 247908)) OR (videos.only_friends = false) OR (videos.creator_id = 247908))
Trx read view will not see trx with id >= 42 2569534782, sees < 42 2569351820
---TRANSACTION 42 2569351820, ACTIVE 14 sec, process no 9484, OS thread id 1312827712
4 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 42785, query id 1969833688 app6.dal.fetlife 10.36.99.148 fetlife
Trx read view will not see trx with id >= 42 2569352189, sees < 42 2569244654
TABLE LOCK table `fetlife_production/pictures` trx id 42 2569351820 lock mode IX
TABLE LOCK table `fetlife_production/conversion_statuses` trx id 42 2569351820 lock mode IX
RECORD LOCKS space id 0 page no 13726800 n bits 136 index `PRIMARY` of table `fetlife_production/pictures` trx id 42 2569351820 lock_mode X locks rec but not gap
TABLE LOCK table `fetlife_production/versions` trx id 42 2569351820 lock mode IX
----------------------------
END OF INNODB MONITOR OUTPUT
============================

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.