GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Mysql - Lost connection with server ?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql - Lost connection with server ?

    Hi,

    As i write on tittle, i have problem when executing stats request during 15/20min.
    I tested with cli mysql, or with php, same thing.
    I tested on "direct" or via loadblancer, same thing.

    This message doesn't appear at same time, and not all the time ( some request work great... )

    wait_timeout is ok :
    mysql> show variables like '%timeout%';
    +----------------------------+-------+
    | Variable_name | Value |
    +----------------------------+-------+
    | connect_timeout | 10 |
    | delayed_insert_timeout | 300 |
    | innodb_lock_wait_timeout | 50 |
    | innodb_rollback_on_timeout | OFF |
    | interactive_timeout | 28800 |
    | net_read_timeout | 30 |
    | net_write_timeout | 60 |
    | slave_net_timeout | 3600 |
    | table_lock_wait_timeout | 50 |
    | wait_timeout | 28800 |
    +----------------------------+-------+

    I have read everything on it on mysqldoc and i didn't see any problem...

    anyone have an idea ?

    Thanks )

  • #2
    I think there can be a few different causes for this error including... network problems faulty hardware, unreliable link),

    DNS problems (faiing to reverse dns the client if you have hostname based logins)

    Mismatched client and server libraries (in some certain situations this can cause a connection to drop)

    The first place to check would be in your mysql error log, since if a connection is actually established, there should be an error there when it drops

    Also check your php error log which might give some clues

    Comment

    Working...
    X