vb.org Archive - SQL Problems when approving users...

I've been having this problem when Moderating Users... I'll have a list of 100-200 users pending moderation, and when I go to approve them, only ~5-10 get approved before I get a "File download" window for user.php about 15-20 seconds later. The "File download" window also pops up for ipinfo.php when I try to lookup a user's IP info for a post.

I'm not sure if this is SQL related, apache related, or even client related. At first I thought it was client related, but (I'm using Firefox) using IE, I get the "Cannot Load Page" error instead of a file download error.

My boards have from ~400-800 concurrent users, and this happens when both the server loads are high and low (low being under 1); although I think more users get approved when the server loads are low.

Here is the MySQL Variables:

Code:

auto_increment_increment 1 

auto_increment_offset 1 

automatic_sp_privileges ON 

back_log 50 

basedir / 

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 

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 3 

ft_query_expansion_limit 20 

ft_stopword_file (built-in) 

group_concat_max_len 1024 

have_archive YES 

have_bdb NO 

have_blackhole_engine NO 

have_compress YES 

have_crypt YES 

have_csv NO 

have_example_engine NO 

have_federated_engine NO 

have_geometry YES 

have_innodb DISABLED 

have_isam NO 

have_ndbcluster NO 

have_openssl DISABLED 

have_query_cache YES 

have_raid NO 

have_rtree_keys YES 

have_symlink YES 

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_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_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 1044480 

key_buffer_size 268435456 

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 

license GPL 

local_infile ON 

locked_in_memory OFF 

log OFF 

log_bin OFF 

log_bin_trust_function_creators OFF 

log_error   

log_slave_updates OFF 

log_slow_queries OFF 

log_warnings 1 

long_query_time 10 

low_priority_updates OFF 

lower_case_file_system OFF 

lower_case_table_names 0 

max_allowed_packet 67107840 

max_binlog_cache_size 4294967295 

max_binlog_size 1073741824 

max_connect_errors 10 

max_connections 500 

max_delayed_threads 20 

max_error_count 64 

max_heap_table_size 268434432 

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 4294967295 

max_sort_length 1024 

max_sp_recursion_depth 0 

max_tmp_tables 32 

max_user_connections 0 

max_write_lock_count 4294967295 

multi_range_count 256 

myisam_data_pointer_size 6 

myisam_max_sort_file_size 2147483647 

myisam_recover_options OFF 

myisam_repair_threads 1 

myisam_sort_buffer_size 67108864 

myisam_stats_method nulls_unequal 

net_buffer_length 16384 

net_read_timeout 30 

net_retry_count 10 

net_write_timeout 60 

new OFF 

old_passwords ON 

open_files_limit 4110 

optimizer_prune_level 1 

optimizer_search_depth 62 

pid_file /var/lib/mysql/ded-lax-016.blitzen.net.pid 

prepared_stmt_count 0 

port 0 

preload_buffer_size 32768 

protocol_version 10 

query_alloc_block_size 32768 

query_cache_limit 8388608 

query_cache_min_res_unit 4096 

query_cache_size 134217728 

query_cache_type ON 

query_cache_wlock_invalidate OFF 

query_prealloc_size 65536 

range_alloc_block_size 2048 

read_buffer_size 1044480 

read_only OFF 

read_rnd_buffer_size 520192 

relay_log_purge ON 

relay_log_space_limit 0 

rpl_recovery_rank 0 

secure_auth OFF 

server_id 0 

skip_external_locking ON 

skip_networking ON 

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 2097144 

sql_mode   

sql_notes ON 

sql_warnings ON 

storage_engine MyISAM 

sync_binlog 0 

sync_frm ON 

system_time_zone PDT 

table_cache 1800 

table_lock_wait_timeout 50 

table_type MyISAM 

thread_cache_size 384 

thread_stack 196608 

time_format %H:%i:%s 

time_zone SYSTEM 

timed_mutexes OFF 

tmp_table_size 268435456 

tmpdir   

transaction_alloc_block_size 8192 

transaction_prealloc_size 4096 

tx_isolation REPEATABLE-READ 

updatable_views_with_limit YES 

version 5.0.21-standard 

version_comment MySQL Community Edition - Standard (GPL) 

version_compile_machine i686 

version_compile_os pc-linux-gnu 

wait_timeout 90

If anyone has ideas, please let me know, thanks :)

Looking at the apache conf, Timeout is set at 15 -- but it shouldn't take 15 seconds to approve 100-200 users....

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00963 seconds Memory Usage 1,736KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: