منتدى استراحات زايد

WE have a large board
Threads: 148,467
Posts: 2,025,007
Members: 412,451

i am trying to prune users and am getting a 500 error everytime i try... no matter what the settings

does anyone know of a direct mysql query i can run to prune users that have not logged in within the past year ?

i should have mentioned some info about my setup

VB Version 3.8.2
MySQL Version 14.12 Distrib 5.0.27, for redhat-linux-gnu (i686) using readline 5.0
my.cnf
Code:
# The following options will be passed to all MySQL clients
[client]
socket=/tmp/mysql.sock

# The MySQL server
[mysqld]
tmpdir=/tmp
socket=/tmp/mysql.sock
skip-locking
# skip-networking
skip-name-resolve
server-id=1
max_connections=500
key_buffer_size=512M
max_allowed_packet=16M
table_cache=256
sort_buffer_size=16M
read_buffer_size=16M
join_buffer_size=5M
# if you are performing GROUP BY or ORDER BY queries on tables that
# are much larger than your available memory, you should increase
# the value of read_rnd_buffer_size to speed up the reading of rows
# following sorting operations.
# but: change the session variable only from within those clients
# that need to run large queries
read_rnd_buffer_size=4M
max_heap_table_size=256M
tmp_table_size=256M
myisam_sort_buffer_size=64M
# increase until threads_created doesnt grow anymore
thread_cache=256
query_cache_type=1
query_cache_limit=1M
query_cache_size=32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4

[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=128M
sort_buffer_size=128M
read_buffer=2M
write_buffer=2M
[myisamchk]
key_buffer=128M
sort_buffer_size=128M
read_buffer=2M
write_buffer=2M
[mysqlhotcopy]
interactive-timeout
8x
Apache 2
PHP 5.2.5
its the only site on a 3terra Grid aplication w/ load balancers
http://www.superimagehost.com/is.php...9&img=tgn1.JPG
and the interior of the web load balancer looking like
http://www.superimagehost.com/is.php...0&img=tgn2.JPG