Dear Tim,
So my guess is that when it comes to RAID is normally more than one hardissk as one is the master and the rest are keeping the lastest copy of the db is it true? Ok when you say that once the query lock the table connection build up I dont quite get you here. I thought that once I make one connection and query the a particular table then how will the connection grow. I am kind of confuse here. Yes I agree I dont want to just reset as that is not the solution and struggling to find the solution. Thank you.
Try having the server-side language your using log to a file, whatever query is being sent to MySQL when MySQL isn’t responding.
How does the app your connect to MySQL, does it create many connections or share a single connection around? Does it create temporary or permanent connections to MySQL?
Dear Space,
I dont get you how to log only when the server is log responding? Any method for that specifically. One is the web application and here I have config file and keep the details here as below.
<?php
error_reporting(0);
define(‘DB_HOST’, );
define(‘DB_USER’, '');
define(‘DB_PASSWORD’, '*);
define(‘DB_DATABASE’, ‘*****’);
?>
Then in other files I called it like this $dbconn = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); and finall close it like this mysql_close(); . Then I have java listener which keep opening the db connection and close it later too. So I dont know how you consider this as single connection and permanent?
Hold on, where does the Java listener come into the PHP accessing the database?! Is it possible the Java listener isn’t closing connections so its eating all the spare ones after a period?
RAID is more than 1 drive, yes, it can be a ‘large’ disk that spans all drives, or a mirror (or a combination of both).
With regards to the query locking, if i run a complex query against a database, I can gain locks on that table - if another user wants to query the same table, it has to wait for me to free my locks, adding them to a queue to wait for a table - they’ll kjeep waiting until its free.
Dear Tim,
Ok let me clearly explain it. My application is a gps application where in the background around 3000 devices are inserting and updating data into my db.Java listener is working here to capture the data and store into the db. On the front end is the php based web application where the user are viewing the gps data and also generate various reports.
What do you mean by ‘large’ disk that spans all drives? Drive here mean single hard disk is it?
So when a user have locked a particular table the rest will be waiting in the queue will this lead to number of connection problems? Thank you.
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?
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.
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?
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)
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 
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.
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.
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
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
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?
What storage engine is being used for the tables concerned? Perhaps there is an issue with table locking
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?
“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
Dear Space,
I am using myisam. Can that be a problem?
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)