Hello, Silvio.
I guess you are using MySQL as shipped in Fedora distibution. See: http://dev.mysql.com/doc/mysql/en/Linux.html You may find that sometimes with non-official binaries happens little problems. So my advice for you in this situtation - upgrade to the latest release and use official binaries from MySQL. Silvio Porcellana <[EMAIL PROTECTED]> wrote: > Hi all > we are having a strange problem at the web site I work for (it's an Italian > registar). > > "Sometimes" (that means: every 15/20 days) our db (MySQL) just hangs with a > "Too many > connections" error. The strange thing is that the DB server is stuck untill > we restart it > (actually, we always had to restart the whole server as root didn't have > SUPER privileges, > so nobody could connect to the db...) > Since I'm pretty sure that we don't have such a traffic that justifies this > error (it > happened once at 2 a.m), I would *really* like to know what the heck is going > on. > > Odd things are that: > - we already raised the number of connections, and that didn't help > - we lowered the wait_timeout var, setting it to 3000, but this didn't help > neither (we > did this because, with a 'show processlist;' we noticed sometimes some > hanging queries and > we thought: "Well if me make the die quicker maybe they won't pile up and > won't block our > server anymore". Wrong.) > > Last time this thing happened the 'top' command showed about 380 'httpd' > processes > sleeping (and the system was very very slow, 'top' again showed a load > average above 100, > while it usually is at around 0.5). > > Now what I'm asking is: > - has anybody else ever experienced this problem? > - in any case, what do you think we should monitor? Top? MySQL logs (We once > turned on the > General Query Log, but nothing happened and the file became huge in very > little time...)? > Apache logs? > - could it be just a "client" issue (that is, PHP or Apache don't close the > connection - > although in PHP we only use mysql_connect, and never do a _pconnect)? How > could we monitor > this? > > Our system runs with: > - Linux 2.4.22-1.2188.nptl (Fedora 1) > - MySQL 4.0.13 > - PHP 4.3.4 > - Apache 2.0.48 > > Thank's everybody for any help! > Silvio > > > P.S: This is the output of 'show variables\G': > *************************** 1. row *************************** > Variable_name: back_log > Value: 50 > *************************** 2. row *************************** > Variable_name: basedir > Value: / > *************************** 3. row *************************** > Variable_name: binlog_cache_size > Value: 32768 > *************************** 4. row *************************** > Variable_name: bulk_insert_buffer_size > Value: 8388608 > *************************** 5. row *************************** > Variable_name: character_set > Value: latin1 > *************************** 6. row *************************** > Variable_name: character_sets > Value: latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis > dec8 dos > german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia > hungarian > koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 > *************************** 7. row *************************** > Variable_name: concurrent_insert > Value: ON > *************************** 8. row *************************** > Variable_name: connect_timeout > Value: 5 > *************************** 9. row *************************** > Variable_name: convert_character_set > Value: > *************************** 10. row *************************** > Variable_name: datadir > Value: /var/lib/mysql/ > *************************** 11. row *************************** > Variable_name: delay_key_write > Value: ON > *************************** 12. row *************************** > Variable_name: delayed_insert_limit > Value: 100 > *************************** 13. row *************************** > Variable_name: delayed_insert_timeout > Value: 300 > *************************** 14. row *************************** > Variable_name: delayed_queue_size > Value: 1000 > *************************** 15. row *************************** > Variable_name: flush > Value: OFF > *************************** 16. row *************************** > Variable_name: flush_time > Value: 0 > *************************** 17. row *************************** > Variable_name: ft_boolean_syntax > Value: + -><()~*:""&| > *************************** 18. row *************************** > Variable_name: ft_min_word_len > Value: 4 > *************************** 19. row *************************** > Variable_name: ft_max_word_len > Value: 254 > *************************** 20. row *************************** > Variable_name: ft_max_word_len_for_sort > Value: 20 > *************************** 21. row *************************** > Variable_name: ft_stopword_file > Value: (built-in) > *************************** 22. row *************************** > Variable_name: have_bdb > Value: NO > *************************** 23. row *************************** > Variable_name: have_crypt > Value: YES > *************************** 24. row *************************** > Variable_name: have_innodb > Value: YES > *************************** 25. row *************************** > Variable_name: have_isam > Value: YES > *************************** 26. row *************************** > Variable_name: have_raid > Value: NO > *************************** 27. row *************************** > Variable_name: have_symlink > Value: YES > *************************** 28. row *************************** > Variable_name: have_openssl > Value: NO > *************************** 29. row *************************** > Variable_name: have_query_cache > Value: YES > *************************** 30. row *************************** > Variable_name: init_file > Value: > *************************** 31. row *************************** > Variable_name: innodb_additional_mem_pool_size > Value: 1048576 > *************************** 32. row *************************** > Variable_name: innodb_buffer_pool_size > Value: 8388608 > *************************** 33. row *************************** > Variable_name: innodb_data_file_path > Value: ibdata1:10M:autoextend > *************************** 34. row *************************** > Variable_name: innodb_data_home_dir > Value: > *************************** 35. row *************************** > Variable_name: innodb_file_io_threads > Value: 4 > *************************** 36. row *************************** > Variable_name: innodb_force_recovery > Value: 0 > *************************** 37. row *************************** > Variable_name: innodb_thread_concurrency > Value: 8 > *************************** 38. row *************************** > Variable_name: innodb_flush_log_at_trx_commit > Value: 1 > *************************** 39. row *************************** > Variable_name: innodb_fast_shutdown > Value: ON > *************************** 40. row *************************** > Variable_name: innodb_flush_method > Value: > *************************** 41. row *************************** > Variable_name: innodb_lock_wait_timeout > Value: 50 > *************************** 42. row *************************** > Variable_name: innodb_log_arch_dir > Value: ./ > *************************** 43. row *************************** > Variable_name: innodb_log_archive > Value: OFF > *************************** 44. row *************************** > Variable_name: innodb_log_buffer_size > Value: 1048576 > *************************** 45. row *************************** > Variable_name: innodb_log_file_size > Value: 5242880 > *************************** 46. row *************************** > Variable_name: innodb_log_files_in_group > Value: 2 > *************************** 47. row *************************** > Variable_name: innodb_log_group_home_dir > Value: ./ > *************************** 48. row *************************** > Variable_name: innodb_mirrored_log_groups > Value: 1 > *************************** 49. row *************************** > Variable_name: innodb_max_dirty_pages_pct > Value: 90 > *************************** 50. row *************************** > Variable_name: interactive_timeout > Value: 3000 > *************************** 51. row *************************** > Variable_name: join_buffer_size > Value: 131072 > *************************** 52. row *************************** > Variable_name: key_buffer_size > Value: 8388600 > *************************** 53. row *************************** > Variable_name: language > Value: /usr/share/mysql/english/ > *************************** 54. row *************************** > Variable_name: large_files_support > Value: ON > *************************** 55. row *************************** > Variable_name: local_infile > Value: ON > *************************** 56. row *************************** > Variable_name: locked_in_memory > Value: OFF > *************************** 57. row *************************** > Variable_name: log > Value: OFF > *************************** 58. row *************************** > Variable_name: log_update > Value: OFF > *************************** 59. row *************************** > Variable_name: log_bin > Value: OFF > *************************** 60. row *************************** > Variable_name: log_slave_updates > Value: OFF > *************************** 61. row *************************** > Variable_name: log_slow_queries > Value: OFF > *************************** 62. row *************************** > Variable_name: log_warnings > Value: OFF > *************************** 63. row *************************** > Variable_name: long_query_time > Value: 10 > *************************** 64. row *************************** > Variable_name: low_priority_updates > Value: OFF > *************************** 65. row *************************** > Variable_name: lower_case_table_names > Value: OFF > *************************** 66. row *************************** > Variable_name: max_allowed_packet > Value: 1048576 > *************************** 67. row *************************** > Variable_name: max_binlog_cache_size > Value: 4294967295 > *************************** 68. row *************************** > Variable_name: max_binlog_size > Value: 1073741824 > *************************** 69. row *************************** > Variable_name: max_connections > Value: 100 > *************************** 70. row *************************** > Variable_name: max_connect_errors > Value: 10 > *************************** 71. row *************************** > Variable_name: max_delayed_threads > Value: 20 > *************************** 72. row *************************** > Variable_name: max_heap_table_size > Value: 16777216 > *************************** 73. row *************************** > Variable_name: max_join_size > Value: 4294967295 > *************************** 74. row *************************** > Variable_name: max_sort_length > Value: 1024 > *************************** 75. row *************************** > Variable_name: max_user_connections > Value: 0 > *************************** 76. row *************************** > Variable_name: max_tmp_tables > Value: 32 > *************************** 77. row *************************** > Variable_name: max_write_lock_count > Value: 4294967295 > *************************** 78. row *************************** > Variable_name: myisam_max_extra_sort_file_size > Value: 268435456 > *************************** 79. row *************************** > Variable_name: myisam_max_sort_file_size > Value: 2147483647 > *************************** 80. row *************************** > Variable_name: myisam_repair_threads > Value: 1 > *************************** 81. row *************************** > Variable_name: myisam_recover_options > Value: OFF > *************************** 82. row *************************** > Variable_name: myisam_sort_buffer_size > Value: 8388608 > *************************** 83. row *************************** > Variable_name: net_buffer_length > Value: 16384 > *************************** 84. row *************************** > Variable_name: net_read_timeout > Value: 30 > *************************** 85. row *************************** > Variable_name: net_retry_count > Value: 10 > *************************** 86. row *************************** > Variable_name: net_write_timeout > Value: 60 > *************************** 87. row *************************** > Variable_name: new > Value: OFF > *************************** 88. row *************************** > Variable_name: open_files_limit > Value: 0 > *************************** 89. row *************************** > Variable_name: pid_file > Value: /var/lib/mysql/dns.nomitaly.it.pid > *************************** 90. row *************************** > Variable_name: log_error > Value: > *************************** 91. row *************************** > Variable_name: port > Value: 3306 > *************************** 92. row *************************** > Variable_name: protocol_version > Value: 10 > *************************** 93. row *************************** > Variable_name: read_buffer_size > Value: 131072 > *************************** 94. row *************************** > Variable_name: read_rnd_buffer_size > Value: 262144 > *************************** 95. row *************************** > Variable_name: rpl_recovery_rank > Value: 0 > *************************** 96. row *************************** > Variable_name: query_cache_limit > Value: 1048576 > *************************** 97. row *************************** > Variable_name: query_cache_size > Value: 0 > *************************** 98. row *************************** > Variable_name: query_cache_type > Value: ON > *************************** 99. row *************************** > Variable_name: server_id > Value: 0 > *************************** 100. row *************************** > Variable_name: slave_net_timeout > Value: 3600 > *************************** 101. row *************************** > Variable_name: skip_external_locking > Value: ON > *************************** 102. row *************************** > Variable_name: skip_networking > Value: OFF > *************************** 103. row *************************** > Variable_name: skip_show_database > Value: OFF > *************************** 104. row *************************** > Variable_name: slow_launch_time > Value: 2 > *************************** 105. row *************************** > Variable_name: socket > Value: /var/lib/mysql/mysql.sock > *************************** 106. row *************************** > Variable_name: sort_buffer_size > Value: 2097144 > *************************** 107. row *************************** > Variable_name: sql_mode > Value: 0 > *************************** 108. row *************************** > Variable_name: table_cache > Value: 64 > *************************** 109. row *************************** > Variable_name: table_type > Value: MYISAM > *************************** 110. row *************************** > Variable_name: thread_cache_size > Value: 0 > *************************** 111. row *************************** > Variable_name: thread_stack > Value: 126976 > *************************** 112. row *************************** > Variable_name: tx_isolation > Value: REPEATABLE-READ > *************************** 113. row *************************** > Variable_name: timezone > Value: CET > *************************** 114. row *************************** > Variable_name: tmp_table_size > Value: 33554432 > *************************** 115. row *************************** > Variable_name: tmpdir > Value: /tmp/ > *************************** 116. row *************************** > Variable_name: version > Value: 4.0.13 > *************************** 117. row *************************** > Variable_name: wait_timeout > Value: 3000 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]