|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
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 and the interior of the web load balancer looking like __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
prune is very slow! | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-22-2010 09:10 PM |
How do you prune pms? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-10-2010 08:10 AM |
Prune users by email adres/postcount query or prune them by ip addres | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 03-02-2010 04:30 AM |
Prune / Move Users Error! | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 10-10-2009 07:30 AM |
Who can prune mod log? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-12-2009 01:10 AM |