OK - here it is:
    DBI::db=HASH(0x198c768) trace level set to 0x2/0 (DBI @ Ox0/0) in 
+DBI 1.42-ithread (pid 2800)
    Note: perl is running without the recommended perl -w option
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1960e34)~0x198c768 '
+select count(*) FROM Result;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198c8dc) at stat_test.pl line 21
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198c8dc)~0x188a14c) 
+thr#15d404c
    -> dbd_st_execute for 0198cfa8
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 22
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198c8dc)~0x18
+8a14c) thr#15d404c
    -> dbd_st_fetch for 0198cfa8, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '8227' ) [1 items] row1 at stat_test.pl line 
+23
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1960e34)~0x198c768 '
+select count(*) FROM Protein;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198d014) at stat_test.pl line 28
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x188a14c)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 29
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198d014)~0x198d044) 
+thr#15d404c
    -> dbd_st_execute for 018da194
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 29
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198d014)~0x19
+8d044) thr#15d404c
    -> dbd_st_fetch for 018da194, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '369276' ) [1 items] row1 at stat_test.pl lin
+e 30
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1960e34)~0x198c768 '
+select count(DISTINCT label) FROM ProSeq;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198d0ec) at stat_test.pl line 36
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198d044)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 37
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198d0ec)~0x198d11c) 
+thr#15d404c
    -> dbd_st_execute for 0198d038
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 37
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198d0ec)~0x19
+8d11c) thr#15d404c
    -> dbd_st_fetch for 0198d038, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '51909' ) [1 items] row1 at stat_test.pl line
+ 38
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1960e34)~0x198c768 '
+select count(*) FROM Peptide;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198cff0) at stat_test.pl line 46
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198d11c)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 47
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198cff0)~0x198c8e8) 
+thr#15d404c
    -> dbd_st_execute for 0198d110
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 47
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198cff0)~0x19
+8c8e8) thr#15d404c
    -> dbd_st_fetch for 0198d110, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '1860342' ) [1 items] row1 at stat_test.pl li
+ne 48
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198cff0)~0x198c8e8) 
+thr#15d404c
    -> dbd_st_execute for 0198d110
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 54
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198cff0)~0x19
+8c8e8) thr#15d404c
    -> dbd_st_fetch for 0198d110, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '1860342' ) [1 items] row1 at stat_test.pl li
+ne 55
    -> finish for DBD::mysql::st (DBI::st=HASH(0x198cff0)~0x198c8e8) t
+hr#15d404c
    <- finish= 1 at stat_test.pl line 57
    -> disconnect for DBD::mysql::db (DBI::db=HASH(0x1960e34)~0x198c76
+8) thr#15d404c
&imp_dbh->mysql: 198cc94
    <- disconnect= 1 at stat_test.pl line 76
!   -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198c8e8)~INNER) thr#
+15d404c
!   <- DESTROY= undef during global destruction
!   -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x198c768)~INNER) thr#
+15d404c
!   <- DESTROY= undef during global destruction
    DBI::db=HASH(0x198c1a0) trace level set to 0x2/0 (DBI @ Ox0/0) in 
+DBI 1.42-ithread (pid 1840)
    Note: perl is running without the recommended perl -w option
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1961304)~0x198c1a0 '
+select count(*) FROM Result;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198ce90) at stat_test.pl line 21
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198ce90)~0x188a37c) 
+thr#15d404c
    -> dbd_st_execute for 0198cf38
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 22
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198ce90)~0x18
+8a37c) thr#15d404c
    -> dbd_st_fetch for 0198cf38, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '8227' ) [1 items] row1 at stat_test.pl line 
+23
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1961304)~0x198c1a0 '
+select count(*) FROM Protein;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198cfa4) at stat_test.pl line 28
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x188a37c)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 29
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198cfa4)~0x198cfd4) 
+thr#15d404c
    -> dbd_st_execute for 018da15c
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 29
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198cfa4)~0x19
+8cfd4) thr#15d404c
    -> dbd_st_fetch for 018da15c, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '369276' ) [1 items] row1 at stat_test.pl lin
+e 30
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1961304)~0x198c1a0 '
+select count(DISTINCT label) FROM ProSeq;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198d07c) at stat_test.pl line 36
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198cfd4)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 37
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198d07c)~0x198d0ac) 
+thr#15d404c
    -> dbd_st_execute for 0198cfc8
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 37
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198d07c)~0x19
+8d0ac) thr#15d404c
    -> dbd_st_fetch for 0198cfc8, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '51909' ) [1 items] row1 at stat_test.pl line
+ 38
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1961304)~0x198c1a0 '
+select count(*) FROM Peptide;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198cf80) at stat_test.pl line 46
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198d0ac)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 47
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198cf80)~0x198ce9c) 
+thr#15d404c
    -> dbd_st_execute for 0198d0a0
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 47
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198cf80)~0x19
+8ce9c) thr#15d404c
    -> dbd_st_fetch for 0198d0a0, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '1860342' ) [1 items] row1 at stat_test.pl li
+ne 48
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1961304)~0x198c1a0 '
+select count(DISTINCT seq) FROM Peptide;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198d058) at stat_test.pl line 54
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198ce9c)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 55
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198d058)~0x198cfb0) 
+thr#15d404c
    -> dbd_st_execute for 0198d10c
Lost connection to MySQL server during query error 2013 recorded: Lost
+ connection to MySQL server during query
    <- dbd_st_execute -2 rows
    !! ERROR: 2013 'Lost connection to MySQL server during query' (err
+#0)
    <- execute= undef at stat_test.pl line 55
!   -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198cfb0)~INNER) thr#
+15d404c
       ERROR: 2013 'Lost connection to MySQL server during query' (err
+#0)
!   <- DESTROY= undef during global destruction
!   -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x198c1a0)~INNER) thr#
+15d404c
&imp_dbh->mysql: 198cc04
       ERROR: 2013 'Lost connection to MySQL server during query' (err
+#0)
!   <- DESTROY= undef during global destruction

[download]

Hmmmmm. Does this help? I guess I need to eat more sushi.
Thanks.

In reply to Re^2: DBD::MySQL timeout during query by rcraig
in thread DBD::MySQL timeout during query by rcraig

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.