Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

mod perl problem?

Aug 26, 2002, 10:30 AM
xpert
User (277 posts)
Aug 26, 2002, 10:30 AM
Post #1 of 6
Views: 2003
Shortcut
Quote Reply
mod perl problem?
I'm using dynamic and modperl, for some reason; there's frequent mysql errors like can't connect to database because of too many connections. what might have cause that?
Aug 26, 2002, 5:24 PM
xpert
User (277 posts)
Aug 26, 2002, 5:24 PM
Post #2 of 6
Views: 1914
Shortcut
Quote Reply
Re: [xpert] mod perl problem? In reply to
The error msg is 200 OK, maybe somebody know what's going on, since everything seems so unstable now with frequent errors!
Aug 26, 2002, 5:44 PM
xpert
User (277 posts)
Aug 26, 2002, 5:44 PM
Post #3 of 6
Views: 1913
Shortcut
Quote Reply
Re: [xpert] mod perl problem? In reply to
Right now, every request results in the too many mysql connections error!! SOme stats given below shows that there's Connections 20782

Rather rare, this is my db used onyl for linkssql, seems like a certain script is opening up mysql and not closing the connection!! Some help? Database mysql SQL-query
SQL-query : [Edit]
SHOW STATUS




Variable_name Value Aborted_clients 19 Aborted_connects 2170 Bytes_received 60862517 Bytes_sent 790888215 Connections 20782 Created_tmp_disk_tables 6650 Created_tmp_tables 11291 Created_tmp_files 0 Delayed_insert_threads 0 Delayed_writes 0 Delayed_errors 0 Flush_commands 1 Handler_delete 1216 Handler_read_first 71123 Handler_read_key 1632284 Handler_read_next 1149720 Handler_read_prev 0 Handler_read_rnd 1680549 Handler_read_rnd_next 5122259 Handler_update 50040 Handler_write 178329 Key_blocks_used 3472 Key_read_requests 7352532 Key_reads 2670 Key_write_requests 34551 Key_writes 20585 Max_used_connections 100 Not_flushed_key_blocks 0 Not_flushed_delayed_rows 0 Open_tables 64 Open_files 117 Open_streams 0 Opened_tables 720 Questions 441200 Select_full_join 6669 Select_full_range_join 0 Select_range 33712 Select_range_check 0 Select_scan 67427 Slave_running OFF Slave_open_temp_tables 0 Slow_launch_threads 0 Slow_queries 0 Sort_merge_passes 0 Sort_range 30083 Sort_rows 1691659 Sort_scan 48757 Table_locks_immediate 469870 Table_locks_waited 69 Threads_cached 0 Threads_created 20781 Threads_connected 97 Threads_running 1 Uptime 34528
Aug 26, 2002, 8:29 PM
xpert
User (277 posts)
Aug 26, 2002, 8:29 PM
Post #4 of 6
Views: 1903
Shortcut
Quote Reply
Re: [xpert] mod perl problem? In reply to
My process list is showing too many process from the database thta lsql resides on, and all those processes r on sleep. How come those connections don't close? Can a GT address please address to this issue?

Last edited by:

xpert: Aug 26, 2002, 9:28 PM
Aug 27, 2002, 12:31 AM
Aki
Staff (429 posts)
Aug 27, 2002, 12:31 AM
Post #5 of 6
Views: 1892
Shortcut
Quote Reply
Re: [xpert] mod perl problem? In reply to
Could you do the command "mysqladmin process" for me? Also, when you paste up the results, can you also use the "code" markup to format the output so it's easier to read?
Aug 27, 2002, 5:56 AM
xpert
User (277 posts)
Aug 27, 2002, 5:56 AM
Post #6 of 6
Views: 1896
Shortcut
Quote Reply
Re: [Aki] mod perl problem? In reply to
Here's the process list!
Code:
Database mysql
SQL-query

SQL-query : [Edit]
SHOW PROCESSLIST
Id User Host db Command Time State Info
Kill 8331 admin9 localhost admin9_com Sleep 155
Kill 8332 admin9 localhost admin9_com Sleep 392
Kill 8333 admin9 localhost admin9_com Sleep 477
Kill 8334 admin9 localhost admin9_com Sleep 101
Kill 8335 admin9 localhost admin9_com Sleep 77
Kill 8336 admin9 localhost admin9_com Sleep 669
Kill 8382 admin9 localhost admin9_com Sleep 326
Kill 8383 admin9 localhost admin9_com Sleep 326
Kill 8385 admin9 localhost admin9_com Sleep 259
Kill 8391 admin9 localhost admin9_com Sleep 26
Kill 8392 admin9 localhost admin9_com Sleep 26
Kill 8393 admin9 localhost admin9_com Sleep 503
Kill 8395 admin9 localhost admin9_com Sleep 142
Kill 8396 admin9 localhost admin9_com Sleep 142
Kill 8397 admin9 localhost admin9_com Sleep 358
Kill 8398 admin9 localhost admin9_com Sleep 1215
Kill 8403 admin9 localhost admin9_com Sleep 849
Kill 8409 admin9 localhost admin9_com Sleep 307
Kill 8411 admin9 localhost admin9_com Sleep 199
Kill 8431 admin9 localhost admin9_com Sleep 213
Kill 8432 admin9 localhost admin9_com Sleep 200
Kill 8434 admin9 localhost admin9_com Sleep 315
Kill 8435 admin9 localhost admin9_com Sleep 955
Kill 8446 admin9 localhost admin9_com Sleep 283
Kill 8458 admin9 localhost admin9_com Sleep 225
Kill 8460 admin9 localhost admin9_com Sleep 20
Kill 8466 admin9 localhost admin9_com Sleep 307
Kill 8501 admin9 localhost admin9_com Sleep 283
Kill 8559 admin9 localhost admin9_com Sleep 200
Kill 8571 admin9 localhost admin9_com Sleep 477
Kill 8709 admin9 localhost admin9_com Sleep 160
Kill 8710 admin9 localhost admin9_com Sleep 225
Kill 8726 admin9 localhost admin9_com Sleep 506
Kill 9697 admin9 localhost admin9_com Sleep 281
Kill 9712 admin9 localhost admin9_com Sleep 350
Kill 9738 admin9 localhost admin9_com Sleep 350
Kill 9783 admin9 localhost admin9_com Sleep 338
Kill 9787 admin9 localhost admin9_com Sleep 66
Kill 9818 admin9 localhost admin9_com Sleep 64
Kill 9819 admin9 localhost admin9_com Sleep 124
Kill 9847 admin9 localhost admin9_com Sleep 66
Kill 9858 admin9 localhost admin9_com Sleep 124
Kill 10001 admin9 localhost admin9_com Sleep 144
Kill 10002 admin9 localhost admin9_com Sleep 860
Kill 10062 admin9 localhost admin9_com Sleep 382
Kill 10070 admin9 localhost admin9_com Sleep 52
Kill 10077 admin9 localhost admin9_com Sleep 55
Kill 10091 admin9 localhost admin9_com Sleep 51
Kill 10162 admin9 localhost admin9_com Sleep 55
Kill 10163 admin9 localhost admin9_com Sleep 370
Kill 10164 admin9 localhost admin9_com Sleep 370
Kill 10220 admin9 localhost admin9_com Sleep 88
Kill 10221 admin9 localhost admin9_com Sleep 17
Kill 10222 admin9 localhost admin9_com Sleep 106
Kill 10223 admin9 localhost admin9_com Sleep 8
Kill 10224 admin9 localhost admin9_com Sleep 91
Kill 10225 admin9 localhost admin9_com Sleep 89
Kill 10247 admin9 localhost admin9_com Sleep 54
Kill 10248 admin9 localhost admin9_com Sleep 54
Kill 10251 admin9 localhost admin9_com Sleep 51
Kill 10275 admin9 localhost admin9_com Sleep 18
Kill 10276 admin9 localhost admin9_com Sleep 20
Kill 10277 admin9 localhost admin9_com Sleep 20
Kill 10278 admin9 localhost admin9_com Sleep 18
Kill 10287 wpphpadmin localhost Sleep 0
Kill 10288 root localhost mysql Query 0 SHOW PROCESSLIST