SitePoint Sponsor

User Tag List

Page 2 of 2 FirstFirst 12
Results 26 to 48 of 48
  1. #26
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    4,904
    Mentioned
    93 Post(s)
    Tagged
    0 Thread(s)
    When MySQL is restarting do you know if it's when the db.Java listener is updating and inserting data or when php is viewing the data and generating reports?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  2. #27
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Space,
    The problem is too many connection coming at random. I also wish to know where exactly is the cause either the php or java? Is there any other log I can set to catch this? I know the queries for java and php is different.

  3. #28
    SitePoint Zealot
    Join Date
    Apr 2005
    Location
    London
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you can

    'show full processlist'
    This will show you connections and what they are running at a particular point in time.

    'show status' is also useful but requires more understanding.

    You could script these to run every minute while you diagnose the issue.

    if you have too many connections you might want to set a suitable max for your database, and set a limit for the connections from your application(s) using a connection pool.

    mysqld itself won't usually crash without a hint in the logs.. is there really nothing in there? did the server itself restart or just mysqld?

  4. #29
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Jurn,
    I have been doing show processlist all this while but even at peak time it never showed me more than 50 connection. So must I swap to show full processlist is it? How to use show status? Can you guide me how to script it to run on every minute? From php can I do connection pooling? Normally only the mysqld will crash not the server but happened last week even the server crash too.
    Below is some extract from .err log file.

    110218 1:29:00 [Note] /usr/libexec/mysqld: Shutdown complete

    110218 1:29:11 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
    110218 1:35:00 [Warning] Aborted connection 5830 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 1:41:48 [Warning] Aborted connection 11817 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 1:47:41 [Warning] Aborted connection 22459 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 1:47:55 [Note] /usr/libexec/mysqld: Normal shutdown

    110218 1:47:57 [Note] /usr/libexec/mysqld: Shutdown complete

    110218 1:48:00 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
    110218 1:53:00 [Warning] Aborted connection 4248 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 1:59:57 [Warning] Aborted connection 11682 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 2:09:36 [Warning] Aborted connection 16465 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 2:11:45 [Warning] Aborted connection 11615 to db: 'fms' user: 'fms' host: '192.168.1.20' (Got an error reading communication packets)
    110218 2:15:05 [Warning] Aborted connection 24014 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 2:17:01 [Warning] Aborted connection 40076 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 2:24:33 [Warning] Aborted connection 55309 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 2:26:07 [Warning] Aborted connection 25521 to db: 'fms' user: 'fms' host: '192.168.1.20' (Got an error reading communication packets)
    110218 2:29:00 [Warning] Aborted connection 59223 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 2:37:07 [Warning] Aborted connection 77766 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 2:42:07 [Warning] Aborted connection 59122 to db: 'fms' user: 'fms' host: '192.168.1.20' (Got an error reading communication packets)
    110218 2:45:27 [Warning] Aborted connection 99019 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 2:47:01 [Warning] Aborted connection 101088 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 2:55:12 [Warning] Aborted connection 113821 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 2:59:01 [Warning] Aborted connection 130526 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 3:05:00 [Warning] Aborted connection 146594 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 3:11:00 [Warning] Aborted connection 163319 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 3:17:01 [Warning] Aborted connection 178018 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 3:23:00 [Warning] Aborted connection 193885 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 3:29:01 [Warning] Aborted connection 210341 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 3:35:00 [Warning] Aborted connection 226261 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 3:41:00 [Warning] Aborted connection 241942 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 3:47:01 [Warning] Aborted connection 255609 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 3:53:01 [Warning] Aborted connection 268421 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 3:59:01 [Warning] Aborted connection 281268 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 4:05:00 [Warning] Aborted connection 293598 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 4:11:00 [Warning] Aborted connection 306753 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 4:17:01 [Warning] Aborted connection 319621 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 4:23:00 [Warning] Aborted connection 331767 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 4:29:00 [Warning] Aborted connection 342432 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 4:35:00 [Warning] Aborted connection 352832 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 4:41:00 [Warning] Aborted connection 364540 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 4:47:01 [Warning] Aborted connection 377321 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 4:53:01 [Warning] Aborted connection 390112 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 4:59:01 [Warning] Aborted connection 401359 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 5:05:01 [Warning] Aborted connection 412745 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 5:11:01 [Warning] Aborted connection 425180 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 5:17:00 [Warning] Aborted connection 436797 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 5:23:00 [Warning] Aborted connection 447593 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 5:29:01 [Warning] Aborted connection 459089 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 5:35:01 [Warning] Aborted connection 470590 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 5:41:01 [Warning] Aborted connection 482081 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 5:47:01 [Warning] Aborted connection 493872 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 5:53:00 [Warning] Aborted connection 505585 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 5:59:01 [Warning] Aborted connection 517603 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 6:05:01 [Warning] Aborted connection 530295 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 6:11:01 [Warning] Aborted connection 541636 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 6:17:00 [Warning] Aborted connection 553425 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 6:23:01 [Warning] Aborted connection 565954 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 6:29:01 [Warning] Aborted connection 578282 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 6:35:01 [Warning] Aborted connection 591109 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 6:41:00 [Warning] Aborted connection 603184 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 6:47:00 [Warning] Aborted connection 615703 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 6:53:01 [Warning] Aborted connection 628641 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 6:59:01 [Warning] Aborted connection 641217 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 7:05:01 [Warning] Aborted connection 654699 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 7:11:00 [Warning] Aborted connection 667142 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 7:17:01 [Warning] Aborted connection 678297 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 7:23:00 [Warning] Aborted connection 689837 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 7:29:01 [Warning] Aborted connection 704901 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 7:35:01 [Warning] Aborted connection 719528 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 7:41:01 [Warning] Aborted connection 735856 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 7:47:01 [Warning] Aborted connection 753327 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 7:53:00 [Warning] Aborted connection 771641 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 7:59:01 [Warning] Aborted connection 792399 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 8:05:01 [Warning] Aborted connection 816129 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 8:11:01 [Warning] Aborted connection 839748 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 8:17:01 [Warning] Aborted connection 863362 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 8:23:01 [Warning] Aborted connection 886111 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 8:29:01 [Warning] Aborted connection 910959 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 8:35:01 [Warning] Aborted connection 938405 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 8:41:01 [Warning] Aborted connection 972085 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 8:47:01 [Warning] Aborted connection 1012311 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 8:53:01 [Warning] Aborted connection 1057898 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 8:59:01 [Warning] Aborted connection 1108142 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 9:05:01 [Warning] Aborted connection 1155095 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 9:11:01 [Warning] Aborted connection 1204276 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 9:17:01 [Warning] Aborted connection 1253455 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 9:19:25 [Note] /usr/libexec/mysqld: Normal shutdown

    110218 9:19:28 [Note] /usr/libexec/mysqld: Shutdown complete

    110218 9:19:38 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
    110218 9:23:01 [Warning] Aborted connection 212 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 9:29:01 [Warning] Aborted connection 47648 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 9:35:01 [Warning] Aborted connection 100228 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 9:41:01 [Warning] Aborted connection 154210 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 9:47:01 [Warning] Aborted connection 212181 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 9:53:01 [Warning] Aborted connection 277019 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 9:59:01 [Warning] Aborted connection 342944 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 10:05:03 [Warning] Aborted connection 423392 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 10:11:04 [Warning] Aborted connection 506698 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 10:19:46 [Warning] Aborted connection 560230 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 10:23:04 [Warning] Aborted connection 618814 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110218 10:24:05 [Warning] Aborted connection 539318 to db: 'fms' user: 'fms' host: '192.168.1.20' (Got an error reading communication packets)

  5. #30
    SitePoint Zealot
    Join Date
    Apr 2005
    Location
    London
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you can use 'show processlist' instead (it just truncates the sql command to the first 100 chars instead of showing all of it).
    can you confirm you can see connections from ALL users (and not just the user you logged in with?)
    and does the number of connections creep up over time?

    You can run 'show status' in the same way you run 'show processlist'... its just issuing a command.

    first write a script that can log the info to disk.
    e.g.
    mysql -u root -pRootPassword --execute='show status' >> log.txt
    then you can use cron to schedule it.

    hmm I did some reading on PHP.. you can use mysql_pconnect instead of mysql_connect so it will reuse existing connections where possible. I'm not sure if you can set a max limit here.

    by the looks of it you're doing up to 10000 new connections per minute which is a lot.

    what is the max number of connections set to for your mysql server?

    if you keep running

    show status like 'Threads_connected';

    you should get an idea of how erratic the number of connections is, and whether you're hitting that maximum as part of normal operation.

    what is bouncing the database when the max connection limit is reached?

    what is the connection from fms@192.168.1.27 doing?

    sorry, I have more questions than answers :P

  6. #31
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Jurn,
    No problem I want you to ask more question though because that is part of learning process too. Ok I have done now show full processlist the connection does not keep growing but infact it goes up and down. The best part I dont see the number of connection cross even 100 so how did you know that it makes 10000 connection per minute I would like to learn that too. Earlier I set the maximum connection at 1000 then now I increase it to 1250. I have done show status like 'Threads_connected'; and below is a sample results and it never go more than 40.

    show status like 'Threads_connected';
    +-------------------+-------+
    | Variable_name | Value |
    +-------------------+-------+
    | Threads_connected | 29 |
    +-------------------+-------+
    1 row in set (0.00 sec)


    In addition I have capture one of the show full processlist. Why it shows unauthenticated user ? The 192.168.1.27 is running a cron job which keep sending data to another server. But I dont understand why it show 192.168.1.27 and sometimes the global ip 116.0.102.197.
    show full processlist;
    +--------+----------------------+---------------------+------+---------+------+------------------+-----------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +--------+----------------------+---------------------+------+---------+------+------------------+-----------------------+
    | 150334 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
    | 151213 | fms | localhost | NULL | Sleep | 308 | | NULL |
    | 157319 | fms | 192.168.1.20:43409 | fms | Sleep | 1 | | NULL |
    | 158867 | fms | 192.168.1.27:39758 | fms | Sleep | 93 | | NULL |
    | 160864 | fms | 116.0.102.197:38983 | fms | Sleep | 32 | | NULL |
    | 161030 | fms | 116.0.102.197:39002 | fms | Sleep | 28 | | NULL |
    | 161496 | fms | 116.0.102.197:39083 | fms | Sleep | 16 | | NULL |
    | 161823 | fms | 192.168.1.2:58201 | fms | Sleep | 0 | | NULL |
    | 161952 | fms | 116.0.102.197:39163 | fms | Sleep | 4 | | NULL |
    | 162187 | fms | 192.168.1.2:58455 | fms | Sleep | 0 | | NULL |
    | 162189 | fms | 192.168.1.2:58456 | fms | Sleep | 0 | | NULL |
    | 162190 | fms | 116.0.102.219:41987 | fms | Sleep | 0 | | NULL |
    | 162192 | fms | 116.0.102.197:39229 | fms | Sleep | 0 | | NULL |
    | 162193 | fms | 116.0.102.219:41989 | fms | Sleep | 0 | | NULL |
    | 162195 | fms | 116.0.102.219:41991 | fms | Sleep | 0 | | NULL |
    | 162196 | fms | 116.0.102.197:39230 | NULL | Connect | NULL | Reading from net | NULL |
    | 162197 | unauthenticated user | 116.0.102.197:39231 | NULL | Connect | NULL | login | NULL |
    | 162198 | unauthenticated user | 116.0.102.219:41992 | NULL | Connect | NULL | login | NULL |
    | 162199 | unauthenticated user | 192.168.1.2:58463 | NULL | Connect | NULL | login | NULL |
    | 162200 | unauthenticated user | 192.168.1.2:58464 | NULL | Connect | NULL | login | NULL |
    | 162201 | unauthenticated user | 116.0.102.197:39232 | NULL | Connect | NULL | login | NULL |
    | 162202 | unauthenticated user | 192.168.1.2:58465 | NULL | Connect | NULL | login | NULL |
    | 162203 | unauthenticated user | 192.168.1.2:58466 | NULL | Connect | NULL | login | NULL |
    | 162204 | unauthenticated user | 192.168.1.2:58467 | NULL | Connect | NULL | login | NULL |
    +--------+----------------------+---------------------+------+---------+------+------------------+-----------------------+
    24 rows in set (0.00 sec)

    Below is the show status results.


    Variable_name Value
    Aborted_clients 15
    Aborted_connects 5
    Binlog_cache_disk_use 0
    Binlog_cache_use 0
    Bytes_received 115
    Bytes_sent 161
    Com_admin_commands 0
    Com_alter_db 0
    Com_alter_table 0
    Com_analyze 0
    Com_backup_table 0
    Com_begin 0
    Com_call_procedure 0
    Com_change_db 0
    Com_change_master 0
    Com_check 0
    Com_checksum 0
    Com_commit 0
    Com_create_db 0
    Com_create_function 0
    Com_create_index 0
    Com_create_table 0
    Com_create_user 0
    Com_dealloc_sql 0
    Com_delete 0
    Com_delete_multi 0
    Com_do 0
    Com_drop_db 0
    Com_drop_function 0
    Com_drop_index 0
    Com_drop_table 0
    Com_drop_user 0
    Com_execute_sql 0
    Com_flush 0
    Com_grant 0
    Com_ha_close 0
    Com_ha_open 0
    Com_ha_read 0
    Com_help 0
    Com_insert 0
    Com_insert_select 0
    Com_kill 0
    Com_load 0
    Com_load_master_data 0
    Com_load_master_table 0
    Com_lock_tables 0
    Com_optimize 0
    Com_preload_keys 0
    Com_prepare_sql 0
    Com_purge 0
    Com_purge_before_date 0
    Com_rename_table 0
    Com_repair 0
    Com_replace 0
    Com_replace_select 0
    Com_reset 0
    Com_restore_table 0
    Com_revoke 0
    Com_revoke_all 0
    Com_rollback 0
    Com_savepoint 0
    Com_select 1
    Com_set_option 0
    Com_show_binlog_events 0
    Com_show_binlogs 0
    Com_show_charsets 0
    Com_show_collations 0
    Com_show_column_types 0
    Com_show_create_db 0
    Com_show_create_table 0
    Com_show_databases 0
    Com_show_errors 0
    Com_show_fields 0
    Com_show_grants 0
    Com_show_innodb_status 0
    Com_show_keys 0
    Com_show_logs 0
    Com_show_master_status 0
    Com_show_ndb_status 0
    Com_show_new_master 0
    Com_show_open_tables 0
    Com_show_privileges 0
    Com_show_processlist 0
    Com_show_slave_hosts 0
    Com_show_slave_status 0
    Com_show_status 1
    Com_show_storage_engines 0
    Com_show_tables 0
    Com_show_triggers 0
    Com_show_variables 0
    Com_show_warnings 0
    Com_slave_start 0
    Com_slave_stop 0
    Com_stmt_close 0
    Com_stmt_execute 0
    Com_stmt_fetch 0
    Com_stmt_prepare 0
    Com_stmt_reset 0
    Com_stmt_send_long_data 0
    Com_truncate 0
    Com_unlock_tables 0
    Com_update 0
    Com_update_multi 0
    Com_xa_commit 0
    Com_xa_end 0
    Com_xa_prepare 0
    Com_xa_recover 0
    Com_xa_rollback 0
    Com_xa_start 0
    Compression OFF
    Connections 176175
    Created_tmp_disk_tables 0
    Created_tmp_files 638
    Created_tmp_tables 1
    Delayed_errors 0
    Delayed_insert_threads 0
    Delayed_writes 0
    Flush_commands 1
    Handler_commit 0
    Handler_delete 0
    Handler_discover 0
    Handler_prepare 0
    Handler_read_first 0
    Handler_read_key 0
    Handler_read_next 0
    Handler_read_prev 0
    Handler_read_rnd 0
    Handler_read_rnd_next 0
    Handler_rollback 0
    Handler_savepoint 0
    Handler_savepoint_rollback 0
    Handler_update 0
    Handler_write 132
    Innodb_buffer_pool_pages_data 0
    Innodb_buffer_pool_pages_dirty 0
    Innodb_buffer_pool_pages_flushed 0
    Innodb_buffer_pool_pages_free 0
    Innodb_buffer_pool_pages_latched 0
    Innodb_buffer_pool_pages_misc 0
    Innodb_buffer_pool_pages_total 0
    Innodb_buffer_pool_read_ahead_rnd 0
    Innodb_buffer_pool_read_ahead_seq 0
    Innodb_buffer_pool_read_requests 0
    Innodb_buffer_pool_reads 0
    Innodb_buffer_pool_wait_free 0
    Innodb_buffer_pool_write_requests 0
    Innodb_data_fsyncs 0
    Innodb_data_pending_fsyncs 0
    Innodb_data_pending_reads 0
    Innodb_data_pending_writes 0
    Innodb_data_read 0
    Innodb_data_reads 0
    Innodb_data_writes 0
    Innodb_data_written 0
    Innodb_dblwr_pages_written 0
    Innodb_dblwr_writes 0
    Innodb_log_waits 0
    Innodb_log_write_requests 0
    Innodb_log_writes 0
    Innodb_os_log_fsyncs 0
    Innodb_os_log_pending_fsyncs 0
    Innodb_os_log_pending_writes 0
    Innodb_os_log_written 0
    Innodb_page_size 0
    Innodb_pages_created 0
    Innodb_pages_read 0
    Innodb_pages_written 0
    Innodb_row_lock_current_waits 0
    Innodb_row_lock_time 0
    Innodb_row_lock_time_avg 0
    Innodb_row_lock_time_max 0
    Innodb_row_lock_waits 0
    Innodb_rows_deleted 0
    Innodb_rows_inserted 0
    Innodb_rows_read 0
    Innodb_rows_updated 0
    Key_blocks_not_flushed 13289
    Key_blocks_unused 6758194
    Key_blocks_used 100750
    Key_read_requests 17786490
    Key_reads 100750
    Key_write_requests 190428
    Key_writes 16
    Last_query_cost 0.000000
    Max_used_connections 86
    Ndb_cluster_node_id 0
    Ndb_config_from_host
    Ndb_config_from_port 0
    Ndb_number_of_data_nodes 0
    Not_flushed_delayed_rows 0
    Open_files 173
    Open_streams 0
    Open_tables 137
    Opened_tables 0
    Prepared_stmt_count 0
    Qcache_free_blocks 1676
    Qcache_free_memory 122449224
    Qcache_hits 1851514
    Qcache_inserts 37687
    Qcache_lowmem_prunes 0
    Qcache_not_cached 143642
    Qcache_queries_in_cache 6626
    Qcache_total_blocks 14984
    Questions 2781393
    Rpl_status NULL
    Select_full_join 0
    Select_full_range_join 0
    Select_range 0
    Select_range_check 0
    Select_scan 1
    Slave_open_temp_tables 0
    Slave_retried_transactions 0
    Slave_running OFF
    Slow_launch_threads 0
    Slow_queries 0
    Sort_merge_passes 0
    Sort_range 0
    Sort_rows 0
    Sort_scan 0
    Ssl_accept_renegotiates 0
    Ssl_accepts 0
    Ssl_callback_cache_hits 0
    Ssl_cipher
    Ssl_cipher_list
    Ssl_client_connects 0
    Ssl_connect_renegotiates 0
    Ssl_ctx_verify_depth 0
    Ssl_ctx_verify_mode 0
    Ssl_default_timeout 0
    Ssl_finished_accepts 0
    Ssl_finished_connects 0
    Ssl_session_cache_hits 0
    Ssl_session_cache_misses 0
    Ssl_session_cache_mode NONE
    Ssl_session_cache_overflows 0
    Ssl_session_cache_size 0
    Ssl_session_cache_timeouts 0
    Ssl_sessions_reused 0
    Ssl_used_session_cache_entries 0
    Ssl_verify_depth 0
    Ssl_verify_mode 0
    Ssl_version
    Table_locks_immediate 107932
    Table_locks_waited 10632
    Tc_log_max_pages_used 0
    Tc_log_page_size 0
    Tc_log_page_waits 0
    Threads_cached 29
    Threads_connected 18
    Threads_created 597
    Threads_running 2
    Uptime 5085
    Uptime_since_flush_status 5085
    Variable_name Value
    Aborted_clients 15
    Aborted_connects 5
    Binlog_cache_disk_use 0
    Binlog_cache_use 0
    Bytes_received 115
    Bytes_sent 161
    Com_admin_commands 0
    Com_alter_db 0
    Com_alter_table 0
    Com_analyze 0
    Com_backup_table 0
    Com_begin 0
    Com_call_procedure 0
    Com_change_db 0
    Com_change_master 0
    Com_check 0
    Com_checksum 0
    Com_commit 0
    Com_create_db 0
    Com_create_function 0
    Com_create_index 0
    Com_create_table 0
    Com_create_user 0
    Com_dealloc_sql 0
    Com_delete 0
    Com_delete_multi 0
    Com_do 0
    Com_drop_db 0
    Com_drop_function 0
    Com_drop_index 0
    Com_drop_table 0
    Com_drop_user 0
    Com_execute_sql 0
    Com_flush 0
    Com_grant 0
    Com_ha_close 0
    Com_ha_open 0
    Com_ha_read 0
    Com_help 0
    Com_insert 0
    Com_insert_select 0
    Com_kill 0
    Com_load 0
    Com_load_master_data 0
    Com_load_master_table 0
    Com_lock_tables 0
    Com_optimize 0
    Com_preload_keys 0
    Com_prepare_sql 0
    Com_purge 0
    Com_purge_before_date 0
    Com_rename_table 0
    Com_repair 0
    Com_replace 0
    Com_replace_select 0
    Com_reset 0
    Com_restore_table 0
    Com_revoke 0
    Com_revoke_all 0
    Com_rollback 0
    Com_savepoint 0
    Com_select 1
    Com_set_option 0
    Com_show_binlog_events 0
    Com_show_binlogs 0
    Com_show_charsets 0
    Com_show_collations 0
    Com_show_column_types 0
    Com_show_create_db 0
    Com_show_create_table 0
    Com_show_databases 0
    Com_show_errors 0
    Com_show_fields 0
    Com_show_grants 0
    Com_show_innodb_status 0
    Com_show_keys 0
    Com_show_logs 0
    Com_show_master_status 0
    Com_show_ndb_status 0
    Com_show_new_master 0
    Com_show_open_tables 0
    Com_show_privileges 0
    Com_show_processlist 0
    Com_show_slave_hosts 0
    Com_show_slave_status 0
    Com_show_status 1
    Com_show_storage_engines 0
    Com_show_tables 0
    Com_show_triggers 0
    Com_show_variables 0
    Com_show_warnings 0
    Com_slave_start 0
    Com_slave_stop 0
    Com_stmt_close 0
    Com_stmt_execute 0
    Com_stmt_fetch 0
    Com_stmt_prepare 0
    Com_stmt_reset 0
    Com_stmt_send_long_data 0
    Com_truncate 0
    Com_unlock_tables 0
    Com_update 0
    Com_update_multi 0
    Com_xa_commit 0
    Com_xa_end 0
    Com_xa_prepare 0
    Com_xa_recover 0
    Com_xa_rollback 0
    Com_xa_start 0
    Compression OFF
    Connections 176996
    Created_tmp_disk_tables 0
    Created_tmp_files 642
    Created_tmp_tables 1
    Delayed_errors 0
    Delayed_insert_threads 0
    Delayed_writes 0
    Flush_commands 1
    Handler_commit 0
    Handler_delete 0
    Handler_discover 0
    Handler_prepare 0
    Handler_read_first 0
    Handler_read_key 0
    Handler_read_next 0
    Handler_read_prev 0
    Handler_read_rnd 0
    Handler_read_rnd_next 0
    Handler_rollback 0
    Handler_savepoint 0
    Handler_savepoint_rollback 0
    Handler_update 0
    Handler_write 132
    Innodb_buffer_pool_pages_data 0
    Innodb_buffer_pool_pages_dirty 0
    Innodb_buffer_pool_pages_flushed 0
    Innodb_buffer_pool_pages_free 0
    Innodb_buffer_pool_pages_latched 0
    Innodb_buffer_pool_pages_misc 0
    Innodb_buffer_pool_pages_total 0
    Innodb_buffer_pool_read_ahead_rnd 0
    Innodb_buffer_pool_read_ahead_seq 0
    Innodb_buffer_pool_read_requests 0
    Innodb_buffer_pool_reads 0
    Innodb_buffer_pool_wait_free 0
    Innodb_buffer_pool_write_requests 0
    Innodb_data_fsyncs 0
    Innodb_data_pending_fsyncs 0
    Innodb_data_pending_reads 0
    Innodb_data_pending_writes 0
    Innodb_data_read 0
    Innodb_data_reads 0
    Innodb_data_writes 0
    Innodb_data_written 0
    Innodb_dblwr_pages_written 0
    Innodb_dblwr_writes 0
    Innodb_log_waits 0
    Innodb_log_write_requests 0
    Innodb_log_writes 0
    Innodb_os_log_fsyncs 0
    Innodb_os_log_pending_fsyncs 0
    Innodb_os_log_pending_writes 0
    Innodb_os_log_written 0
    Innodb_page_size 0
    Innodb_pages_created 0
    Innodb_pages_read 0
    Innodb_pages_written 0
    Innodb_row_lock_current_waits 0
    Innodb_row_lock_time 0
    Innodb_row_lock_time_avg 0
    Innodb_row_lock_time_max 0
    Innodb_row_lock_waits 0
    Innodb_rows_deleted 0
    Innodb_rows_inserted 0
    Innodb_rows_read 0
    Innodb_rows_updated 0
    Key_blocks_not_flushed 13323
    Key_blocks_unused 6757270
    Key_blocks_used 101674
    Key_read_requests 17876581
    Key_reads 101674
    Key_write_requests 191424
    Key_writes 16
    Last_query_cost 0.000000
    Max_used_connections 86
    Ndb_cluster_node_id 0
    Ndb_config_from_host
    Ndb_config_from_port 0
    Ndb_number_of_data_nodes 0
    Not_flushed_delayed_rows 0
    Open_files 172
    Open_streams 0
    Open_tables 138
    Opened_tables 0
    Prepared_stmt_count 0
    Qcache_free_blocks 1623
    Qcache_free_memory 122014088
    Qcache_hits 1860414
    Qcache_inserts 37883
    Qcache_lowmem_prunes 0
    Qcache_not_cached 144497
    Qcache_queries_in_cache 6682
    Qcache_total_blocks 15058
    Questions 2794970
    Rpl_status NULL
    Select_full_join 0
    Select_full_range_join 0
    Select_range 0
    Select_range_check 0
    Select_scan 1
    Slave_open_temp_tables 0
    Slave_retried_transactions 0
    Slave_running OFF
    Slow_launch_threads 0
    Slow_queries 0
    Sort_merge_passes 0
    Sort_range 0
    Sort_rows 0
    Sort_scan 0
    Ssl_accept_renegotiates 0
    Ssl_accepts 0
    Ssl_callback_cache_hits 0
    Ssl_cipher
    Ssl_cipher_list
    Ssl_client_connects 0
    Ssl_connect_renegotiates 0
    Ssl_ctx_verify_depth 0
    Ssl_ctx_verify_mode 0
    Ssl_default_timeout 0
    Ssl_finished_accepts 0
    Ssl_finished_connects 0
    Ssl_session_cache_hits 0
    Ssl_session_cache_misses 0
    Ssl_session_cache_mode NONE
    Ssl_session_cache_overflows 0
    Ssl_session_cache_size 0
    Ssl_session_cache_timeouts 0
    Ssl_sessions_reused 0
    Ssl_used_session_cache_entries 0
    Ssl_verify_depth 0
    Ssl_verify_mode 0
    Ssl_version
    Table_locks_immediate 108533
    Table_locks_waited 10713
    Tc_log_max_pages_used 0
    Tc_log_page_size 0
    Tc_log_page_waits 0
    Threads_cached 28
    Threads_connected 22
    Threads_created 601
    Threads_running 2
    Uptime 5115
    Uptime_since_flush_status 5115


    I also dont know which is causing my connection to grow because I got few different application using it. Please give me more question to answer you. Thank for the help.

  7. #32
    SitePoint Zealot
    Join Date
    Apr 2005
    Location
    London
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    the 'show status' has your max_used_connections at 86 only, so maybe this isn't the problem? keep checking, especially during peak times.

    your previous logs show 'abort connection <number>'. afaik the number increases sequentially, so looking at the timestamps and the number I came up with a 10000 per minute figure. You can also look at the 'Connections' in the status and see how fast that is moving.

    unauthenticated users are connections that haven't yet logged in.

    I'm not sure about the IP.. I think it is the app which decides which address to bind to.

    another way you can tell how many connections have been made is to run 'netstat -nt' and see where the tcp connections are coming from.

    how exactly did you determine that "The problem is too many connection coming at random"?

    can you also show us the output of the "show variables" command.

  8. #33
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Jurn,
    Where did you see the 'abort connection <number>'? I would like to learn that too? I dont know how to this "You can also look at the 'Connections' in the status and see how fast that is moving." Are you asking me to see the connection via the show status and if that is what you said yes the connection grow tremendously and what is this connections give you indication? I have tried to run 'netstat -nt' it show too lines I cant see in full? Can I run a command to show how many of it connected? I did not determinely exactly due to many connection but that is my guess looking roughly at how the system function. It could be other matters which I dont know need your guidance.
    Below is the show variables.

    Variable_name Value
    auto_increment_increment 1
    auto_increment_offset 1
    automatic_sp_privileges ON
    back_log 50
    basedir /usr/
    bdb_cache_size 8384512
    bdb_home
    bdb_log_buffer_size 262144
    bdb_logdir
    bdb_max_lock 10000
    bdb_shared_data OFF
    bdb_tmpdir
    binlog_cache_size 32768
    bulk_insert_buffer_size 8388608
    character_set_client latin1
    character_set_connection latin1
    character_set_database latin1
    character_set_filesystem binary
    character_set_results latin1
    character_set_server latin1
    character_set_system utf8
    character_sets_dir /usr/share/mysql/charsets/
    collation_connection latin1_swedish_ci
    collation_database latin1_swedish_ci
    collation_server latin1_swedish_ci
    completion_type 0
    concurrent_insert 1
    connect_timeout 10
    datadir /var/lib/mysql/
    date_format %Y-%m-%d
    datetime_format %Y-%m-%d %H:%i:%s
    default_week_format 0
    delay_key_write ON
    delayed_insert_limit 100
    delayed_insert_timeout 300
    delayed_queue_size 1000
    div_precision_increment 4
    keep_files_on_create OFF
    engine_condition_pushdown OFF
    expire_logs_days 0
    flush OFF
    flush_time 0
    ft_boolean_syntax + -><()~*:""&|
    ft_max_word_len 84
    ft_min_word_len 4
    ft_query_expansion_limit 20
    ft_stopword_file (built-in)
    group_concat_max_len 1024
    have_archive NO
    have_bdb DISABLED
    have_blackhole_engine NO
    have_compress YES
    have_crypt YES
    have_csv NO
    have_dynamic_loading YES
    have_example_engine NO
    have_federated_engine NO
    have_geometry YES
    have_innodb DISABLED
    have_isam NO
    have_merge_engine YES
    have_ndbcluster DISABLED
    have_openssl DISABLED
    have_ssl DISABLED
    have_query_cache YES
    have_raid NO
    have_rtree_keys YES
    have_symlink YES
    hostname localhost.localdomain
    init_connect
    init_file
    init_slave
    innodb_additional_mem_pool_size 1048576
    innodb_autoextend_increment 8
    innodb_buffer_pool_awe_mem_mb 0
    innodb_buffer_pool_size 8388608
    innodb_checksums ON
    innodb_commit_concurrency 0
    innodb_concurrency_tickets 500
    innodb_data_file_path
    innodb_data_home_dir
    innodb_adaptive_hash_index ON
    innodb_doublewrite ON
    innodb_fast_shutdown 1
    innodb_file_io_threads 4
    innodb_file_per_table OFF
    innodb_flush_log_at_trx_commit 1
    innodb_flush_method
    innodb_force_recovery 0
    innodb_lock_wait_timeout 50
    innodb_locks_unsafe_for_binlog OFF
    innodb_log_arch_dir
    innodb_log_archive OFF
    innodb_log_buffer_size 1048576
    innodb_log_file_size 5242880
    innodb_log_files_in_group 2
    innodb_log_group_home_dir
    innodb_max_dirty_pages_pct 90
    innodb_max_purge_lag 0
    innodb_mirrored_log_groups 1
    innodb_open_files 300
    innodb_rollback_on_timeout OFF
    innodb_support_xa ON
    innodb_sync_spin_loops 20
    innodb_table_locks ON
    innodb_thread_concurrency 8
    innodb_thread_sleep_delay 10000
    interactive_timeout 28800
    join_buffer_size 33554432
    key_buffer_size 8589934592
    key_cache_age_threshold 300
    key_cache_block_size 1024
    key_cache_division_limit 100
    language /usr/share/mysql/english/
    large_files_support ON
    large_page_size 0
    large_pages OFF
    lc_time_names en_US
    license GPL
    local_infile ON
    locked_in_memory OFF
    log OFF
    log_bin ON
    log_bin_trust_function_creators OFF
    log_error ./mysql-bin.err
    log_queries_not_using_indexes ON
    log_slave_updates OFF
    log_slow_queries ON
    log_warnings 2
    long_query_time 10
    low_priority_updates OFF
    lower_case_file_system OFF
    lower_case_table_names 0
    max_allowed_packet 16777216
    max_binlog_cache_size 18446744073709547520
    max_binlog_size 1073741824
    max_connect_errors 10
    max_connections 1250
    max_delayed_threads 20
    max_error_count 64
    max_heap_table_size 16777216
    max_insert_delayed_threads 20
    max_join_size 18446744073709551615
    max_length_for_sort_data 1024
    max_prepared_stmt_count 16382
    max_relay_log_size 0
    max_seeks_for_key 18446744073709551615
    max_sort_length 1024
    max_sp_recursion_depth 0
    max_tmp_tables 32
    max_user_connections 0
    max_write_lock_count 18446744073709551615
    multi_range_count 256
    myisam_data_pointer_size 6
    myisam_max_sort_file_size 9223372036853727232
    myisam_recover_options OFF
    myisam_repair_threads 1
    myisam_sort_buffer_size 67108864
    myisam_stats_method nulls_unequal
    ndb_autoincrement_prefetch_sz 1
    ndb_force_send ON
    ndb_use_exact_count ON
    ndb_use_transactions ON
    ndb_cache_check_time 0
    ndb_connectstring
    net_buffer_length 16384
    net_read_timeout 30
    net_retry_count 10
    net_write_timeout 60
    new OFF
    old_passwords OFF
    open_files_limit 6250
    optimizer_prune_level 1
    optimizer_search_depth 62
    pid_file /var/run/mysqld/mysqld.pid
    plugin_dir
    port 3306
    preload_buffer_size 32768
    profiling OFF
    profiling_history_size 15
    protocol_version 10
    query_alloc_block_size 8192
    query_cache_limit 524288
    query_cache_min_res_unit 4096
    query_cache_size 134217728
    query_cache_type ON
    query_cache_wlock_invalidate OFF
    query_prealloc_size 8192
    range_alloc_block_size 4096
    read_buffer_size 2097152
    read_only OFF
    read_rnd_buffer_size 262144
    relay_log
    relay_log_index
    relay_log_info_file relay-log.info
    relay_log_purge ON
    relay_log_space_limit 0
    rpl_recovery_rank 0
    secure_auth OFF
    secure_file_priv
    server_id 1283835628
    skip_external_locking ON
    skip_networking OFF
    skip_show_database OFF
    slave_compressed_protocol OFF
    slave_load_tmpdir /tmp/
    slave_net_timeout 3600
    slave_skip_errors OFF
    slave_transaction_retries 10
    slow_launch_time 2
    socket /var/lib/mysql/mysql.sock
    sort_buffer_size 4194304
    sql_big_selects ON
    sql_mode
    sql_notes ON
    sql_warnings OFF
    ssl_ca
    ssl_capath
    ssl_cert
    ssl_cipher
    ssl_key
    storage_engine MyISAM
    sync_binlog 0
    sync_frm ON
    system_time_zone MYT
    table_cache 2048
    table_lock_wait_timeout 50
    table_type MyISAM
    thread_cache_size 32
    thread_stack 262144
    time_format %H:%i:%s
    time_zone SYSTEM
    timed_mutexes OFF
    tmp_table_size 33554432
    tmpdir /tmp/
    transaction_alloc_block_size 8192
    transaction_prealloc_size 4096
    tx_isolation REPEATABLE-READ
    updatable_views_with_limit YES
    version 5.0.67-log
    version_bdb Sleepycat Software: Berkeley DB 4.1.24: (August 4, 2008)
    version_comment Source distribution
    version_compile_machine x86_64
    version_compile_os redhat-linux-gnu
    wait_timeout 200

  9. #34
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Jurn
    Below is my latest error log files. What is the Forcing close of thread 2416430 user: ''? Thank you.

    110221 9:25:37 [Warning] Aborted connection 2410635 to db: 'fms' user: 'fms' host: '116.0.102.197' (Got timeout reading communication packets)
    110221 9:25:37 [Warning] Aborted connection 2412310 to db: 'fms' user: 'fms' host: '116.0.102.197' (Got timeout reading communication packets)
    110221 9:25:37 [Warning] Aborted connection 2414071 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got timeout reading communication packets)
    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416451 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416450 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416449 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416448 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416447 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416446 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416445 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416444 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416443 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416442 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416441 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416440 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416439 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416438 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416437 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416436 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416435 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416434 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416433 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416432 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416431 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416430 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416429 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416428 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416427 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416426 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416425 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416424 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416423 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416422 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416421 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416420 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416419 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416418 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416417 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416416 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416415 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416414 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416413 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416412 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416411 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416410 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416409 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416408 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416407 user: ''

    110221 9:25:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 2416406 user: ''

    110221 9:26:01 [Note] /usr/libexec/mysqld: Shutdown complete

    110221 9:26:11 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
    110221 9:29:15 [Warning] Aborted connection 6988 to db: 'fms' user: 'fms' host: '192.168.1.2' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6957 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6962 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6912 to db: 'fms' user: 'fms' host: '192.168.1.2' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6995 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6911 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6915 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6959 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 7018 to db: 'fms' user: 'fms' host: '192.168.1.2' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6975 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6914 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6989 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6986 to db: 'fms' user: 'fms' host: '192.168.1.2' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6918 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 7004 to db: 'fms' user: 'fms' host: '192.168.1.2' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 7011 to db: 'fms' user: 'fms' host: '192.168.1.2' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6981 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6919 to db: 'fms' user: 'fms' host: '192.168.1.2' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6926 to db: 'fms' user: 'fms' host: '192.168.1.2' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6766 to db: 'fms' user: 'fms' host: '192.168.1.2' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 6949 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:29:15 [Warning] Aborted connection 7008 to db: 'fms' user: 'fms' host: '116.0.102.219' (Got an error reading communication packets)
    110221 9:30:15 [Note] /usr/libexec/mysqld: Normal shutdown

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9553 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9552 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9551 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9550 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9549 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9548 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9547 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9546 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9545 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9544 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9543 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9542 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9541 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9540 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9539 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9538 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9537 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9536 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9535 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9534 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9533 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9532 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9531 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9530 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9529 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9528 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9527 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9526 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9525 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9524 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9523 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9522 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9521 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9520 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9519 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9518 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9517 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9516 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9515 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9514 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9513 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9512 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9511 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9510 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9509 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9508 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9507 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9506 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9505 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9504 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9503 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9502 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9501 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9500 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9499 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9498 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9497 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9496 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9495 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9494 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9493 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9492 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9490 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9491 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9489 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9488 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9487 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9486 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9485 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9484 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9483 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9482 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9481 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9480 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9479 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9478 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9477 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9476 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9475 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9474 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9473 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9472 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9471 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9470 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9469 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9468 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9467 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9466 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9465 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9464 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9463 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9462 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9461 user: ''

    110221 9:30:17 [Warning] /usr/libexec/mysqld: Forcing close of thread 9459 user: ''

    110221 9:30:23 [Note] /usr/libexec/mysqld: Shutdown complete

    110221 9:30:24 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
    110221 9:33:02 [Note] /usr/libexec/mysqld: Normal shutdown

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4286 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4285 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4284 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4283 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4282 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4281 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4280 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4279 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4278 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4277 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4276 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4275 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4274 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4273 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4272 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4271 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4270 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4269 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4268 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4267 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4266 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4265 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4264 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4263 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4262 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4261 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4260 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4259 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4258 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4257 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4256 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4255 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4254 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4253 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4252 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4251 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4250 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4249 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4248 user: ''

    110221 9:33:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4247 user: ''

    110221 9:33:13 [Note] /usr/libexec/mysqld: Shutdown complete

    110221 9:35:33 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
    110221 9:41:11 [Warning] Aborted connection 35848 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 9:47:12 [Warning] Aborted connection 121340 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 9:53:10 [Warning] Aborted connection 208529 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 9:54:04 [Warning] Aborted connection 67726 to db: 'fms' user: 'fms' host: '192.168.1.20' (Got an error reading communication packets)
    110221 9:59:11 [Warning] Aborted connection 292238 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 10:05:11 [Warning] Aborted connection 375465 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 10:11:11 [Warning] Aborted connection 454827 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 10:17:11 [Warning] Aborted connection 541049 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 10:23:11 [Warning] Aborted connection 624349 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 10:24:04 [Warning] Aborted connection 486790 to db: 'fms' user: 'fms' host: '192.168.1.20' (Got an error reading communication packets)
    110221 10:29:11 [Warning] Aborted connection 710302 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 10:35:11 [Warning] Aborted connection 793063 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 10:48:00 [Warning] Aborted connection 955962 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 10:53:11 [Warning] Aborted connection 1036018 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 10:59:13 [Warning] Aborted connection 1116385 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 11:05:11 [Warning] Aborted connection 1200507 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 11:11:13 [Warning] Aborted connection 1279670 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 11:17:11 [Warning] Aborted connection 1360983 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 11:23:11 [Warning] Aborted connection 1442867 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 11:29:10 [Warning] Aborted connection 1528092 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 11:35:11 [Warning] Aborted connection 1612899 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 11:41:12 [Warning] Aborted connection 1694674 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 11:47:12 [Warning] Aborted connection 1778689 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110221 11:54:35 [Warning] Aborted connection 1832018 to db: 'sms' user: 'fms' host: '192.168.1.2' (Got timeout reading communication packets)
    110221 11:55:57 [Note] /usr/libexec/mysqld: Normal shutdown

  10. #35
    SitePoint Zealot
    Join Date
    Apr 2005
    Location
    London
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hello,

    Sorry I had a typo. you showed logs such as
    Aborted connection 459089
    which implies you had at least 459089 previous connections.

    The command
    show status like 'Connections'
    will show you how many connections you'd had since mysql was started.
    How fast is this value increasing?
    Even if you do reach max connections I don't understand how MySQL would restart by itself.

    I'm guessing the "Forcing close of thread" is mysql shutting down and kicking off users.

    I'm running out of ideas. when you have some downtime, could you also run 'check table' on your data and look for any data corruption?

  11. #36
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    4,904
    Mentioned
    93 Post(s)
    Tagged
    0 Thread(s)
    What storage engine is being used for the tables concerned? Perhaps there is an issue with table locking
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  12. #37
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Jurn,
    I tested the show status like 'Connections' and it show me within a minute there is 3000 connections being made. What do you mean by "Forcing close of thread"? Is not my connection values are high on a normal basis? Where do you want me to run check table for particular table or all tables? Just run it as check table is it?

  13. #38
    SitePoint Zealot
    Join Date
    Apr 2005
    Location
    London
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    "Forcing close of thread" is mysqld dropping a client's connection. A client's connection is a "thread".
    personally I think it is very high and you should be using connection pools or php's 'persistent' connections.

    i'd run it on all tables. see http://dev.mysql.com/doc/refman/5.0/en/check-table.html for the syntax

  14. #39
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Space,
    I am using myisam. Can that be a problem?

  15. #40
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Jurn,
    But at present the system is quite big and a lot of pages to be updated. So what will be short term solution. So mysql is dropping the connection due to network problem or why? I have noted things like this in my error log. It say cant create thread to kill.

    110221 23:59:12 [Warning] Aborted connection 127309 to db: 'fms' user: 'fms' host: '192.168.1.27' (Got timeout reading communication packets)
    110222 0:24:43 [Note] /usr/libexec/mysqld: Normal shutdown

    110222 0:24:45 [Note] /usr/libexec/mysqld: Shutdown complete

    110222 0:24:47 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
    110222 0:39:05 [Warning] Aborted connection 49 to db: 'fms' user: 'fms' host: '192.168.1.20' (Got an error reading communication packets)


    110222 14:39:05 [Warning] Aborted connection 5207394 to db: 'fms' user: 'fms' host: '192.168.1.20' (Got an error reading communication packets)
    110222 21:42:19 [ERROR] Can't create thread to kill server
    110222 21:42:44 [Warning] Aborted connection 9179283 to db: 'fms' user: 'fms' host: '192.168.1.20' (Got an error reading communication packets)
    110222 21:47:50 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
    110223 0:54:04 [Warning] Aborted connection 484856 to db: 'fms' user: 'fms' host: '192.168.1.20' (Got an error reading communication packets)

  16. #41
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    4,904
    Mentioned
    93 Post(s)
    Tagged
    0 Thread(s)
    MyISAM uses table-level locking so possibly either the php side or the java side or both sides are having trouble perhaps with one using (and locking) a table so the other can't access it.

    Try commenting out in PHP the mysql_close() line the the equivilant line in the Java
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  17. #42
    SitePoint Zealot
    Join Date
    Apr 2005
    Location
    London
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm not sure.
    Do you have any monitoring for your network? especially between the db server and the IPs that are reporting problems?
    Is the client program crashing or not exiting cleanly?

    110222 21:42:19 [ERROR] Can't create thread to kill server
    is a worry though. It sounds like your server was so busy it couldn't even shutdown cleanly.
    http://dev.mysql.com/doc/refman/5.0/...-shutdown.html
    do you have any logs of 'show full processlist' or 'show status' around the time the server was shutdown? this should tell us what was running.

  18. #43
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Space,
    I have too many php file which will need to comment out mysql_close so I dont think so I can do that either because once I close then I got to reopen which is going to be hell too.

  19. #44
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    4,904
    Mentioned
    93 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by newtomysql View Post
    Dear Space,
    I have too many php file which will need to comment out mysql_close so I dont think so I can do that either because once I close then I got to reopen which is going to be hell too.
    You should be able to do a bulk "find and replace" across files, the editor I use can do a "find and replace" across all files it has open.
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  20. #45
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Space,
    What editor are you using? Can you recommend it to me? Then maybe I can try over here. What is the reason to comment it actually?

  21. #46
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    4,904
    Mentioned
    93 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by newtomysql View Post
    Dear Space,
    What editor are you using? Can you recommend it to me? Then maybe I can try over here. What is the reason to comment it actually?
    I'm using Emerald Editor (it took over from Crimson Editor).

    The reason for commenting out the occurances of mysql_close() is because PHP normally closes open connections to MySQL when a script is finished, it may be the overhead of opening and closing connections.

    Try disabling php for a while, does MySQL still keep restarting with php disabled?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  22. #47
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Space,
    Now with the increase in number of connection the number of restart have gone less only unfortunately today the main table which record all the gps data crash and I manage to recover it. So when you say disable the php means disable the apache server itself is it. I dont think cause this system is being use. Another question in your experience how do you copy large data in million from one table to another table?

  23. #48
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Jurn,
    I dont have have any monitoring for my network. I am not too sure is the client crashing or not exiting cleanly I just saw this in the log file I am not too sure either. The problem why I can not give you 'show full processlist' or 'show status' because I do not know when it will restart too.


    Quote Originally Posted by jurn View Post
    I'm not sure.
    Do you have any monitoring for your network? especially between the db server and the IPs that are reporting problems?
    Is the client program crashing or not exiting cleanly?

    110222 21:42:19 [ERROR] Can't create thread to kill server
    is a worry though. It sounds like your server was so busy it couldn't even shutdown cleanly.
    http://dev.mysql.com/doc/refman/5.0/...-shutdown.html
    do you have any logs of 'show full processlist' or 'show status' around the time the server was shutdown? this should tell us what was running.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •