I have just recently upgraded my boards from UBB 5.46 to vBulletin 2.2.1. A number of users have noted that they are periodically receiving the following error :
Warning: Lost connection to MySQL server during query in /home/chris/sites/eclipseforums/htdocs/admin/db_mysql.php on line 40
Warning: MySQL Connection Failed: Lost connection to MySQL server during query in /home/chris/sites/eclipseforums/htdocs/admin/db_mysql.php on line 40
I also receive this same error when attempting to rebuild the search index.
I am on a dedicated tbird 1.2ghz box with 1Gig of RAM, running openBSD 2.9, apache 1.3.22, mySQL 3.23.41, and php 4.0.6.
the url to my forums is http://www.eclipseforums.org
we generally have between 80 - 130 users online during normal times.
my my.cnf file is as follows:
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = max_connections=400
set-variable = key_buffer=32M
set-variable = join_buffer=4M
set-variable = record_buffer=4M
set-variable = sort_buffer=8M
set-variable = thread_cache_size=128
set-variable = max_allowed_packet=4M
set-variable = table_cache=1024
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=64M
log-bin
server-id = 1
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
and the extended status output -
tech1# ./mysqladmin extended-status
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 0 |
| Aborted_connects | 3 |
| Bytes_received | 103182638 |
| Bytes_sent | 1257018188 |
| Connections | 26305 |
| Created_tmp_disk_tables | 13 |
| Created_tmp_tables | 22734 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 2284 |
| Handler_read_first | 15803 |
| Handler_read_key | 4742455 |
| Handler_read_next | 10005450 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 4131468 |
| Handler_read_rnd_next | 32942751 |
| Handler_update | 58705 |
| Handler_write | 1199529 |
| Key_blocks_used | 12198 |
| Key_read_requests | 21021592 |
| Key_reads | 4321 |
| Key_write_requests | 677753 |
| Key_writes | 606072 |
| Max_used_connections | 16 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 88 |
| Open_files | 115 |
| Open_streams | 0 |
| Opened_tables | 101 |
| Questions | 586697 |
| Select_full_join | 13 |
| Select_full_range_join | 0 |
| Select_range | 112696 |
| Select_range_check | 0 |
| Select_scan | 68513 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 3 |
| Sort_merge_passes | 0 |
| Sort_range | 95874 |
| Sort_rows | 4304724 |
| Sort_scan | 42359 |
| Table_locks_immediate | 629613 |
| Table_locks_waited | 560 |
| Threads_cached | 16 |
| Threads_created | 17 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 13001 |
+--------------------------+------------+
Please help if possible, thanks
Reply With Quote
Bookmarks