Very slow in updating preparations (3.5.4)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • alshehi
    New Member
    • Aug 2003
    • 24
    • 4.0.0

    Very slow in updating preparations (3.5.4)

    I have a problem with the modernization Nafis Forum There are too slow

    Note that the issuance of version 3.5.4

    The most important options you have slow :
    1-Update User Titles and Ranks
    2-Rebuild Thread Information
    3-Rebuild Forum Information
    4-Update Post Counts
    5-Update User Names

    This is an example of image :





    Thank you , alshehi
    Alshohooh.ws
    sigpic
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Please see this thread for help with optimizing your server:



    Then post the requested info in a new thread in that forum.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • Zachery
      Former vBulletin Support
      • Jul 2002
      • 59097

      #3
      Most of these functions shouldn't have to be run on a daly basis. Maybe once a month at best.

      Comment

      • alshehi
        New Member
        • Aug 2003
        • 24
        • 4.0.0

        #4
        Welcome to technical support


        1- Signed jointly with several locations in Alserver, but unfortunately other sites operated fully 100%
        2-
        (General server information)
        Operating system : Linux
        Kernel version : 2.4.21-37.0.1.ELsmp
        Machine Type : i686
        Apache version : 1.3.36 (Unix)
        PERL version : 5.8.6
        PHP version : 4.4.2
        MySQL version : 4.0.27-standard-log
        cPanel Build : 10.8.1-RELEASE 113
        Theme cPanel X : v2.5.0


        3- No
        4- Yes
        5-N/A
        6-N/A
        7-N/A
        8- yes ,vb only
        9-4700 - 900 cookie

        10- Ok
        11-N/A
        12- 3.5.4
        13- nobady
        14-N/A


        I got this. I note that corresponds Alserver director. But I have not responded so far.

        Thank you , alshehi
        Alshohooh.ws
        Last edited by alshehi; Sat 1 Jul '06, 1:48pm.
        sigpic

        Comment

        • Zachery
          Former vBulletin Support
          • Jul 2002
          • 59097

          #5
          How often are you running these functions and why are you running them so often

          Comment

          • alshehi
            New Member
            • Aug 2003
            • 24
            • 4.0.0

            #6
            I am tasks after upgrade. Only
            sigpic

            Comment

            • Zachery
              Former vBulletin Support
              • Jul 2002
              • 59097

              #7
              Upgrade from what?

              Comment

              • alshehi
                New Member
                • Aug 2003
                • 24
                • 4.0.0

                #8
                Upgraded version, of course, ^_^



                alshehi
                sigpic

                Comment

                • alshehi
                  New Member
                  • Aug 2003
                  • 24
                  • 4.0.0

                  #9
                  MySQL Variables

                  back_log 50
                  basedir /
                  binlog_cache_size 32768
                  bulk_insert_buffer_size 8388608
                  character_set latin1
                  character_sets 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
                  concurrent_insert ON
                  connect_timeout 180
                  convert_character_set
                  datadir /var/lib/mysql/
                  default_week_format 0
                  delay_key_write ON
                  delayed_insert_limit 100
                  delayed_insert_timeout 300
                  delayed_queue_size 1000
                  flush OFF
                  flush_time 0
                  ft_boolean_syntax + -><()~*:""&|
                  ft_max_word_len 254
                  ft_max_word_len_for_sort 20
                  ft_min_word_len 4
                  ft_stopword_file (built-in)
                  have_bdb NO
                  have_crypt YES
                  have_innodb DISABLED
                  have_isam YES
                  have_openssl NO
                  have_query_cache YES
                  have_raid NO
                  have_symlink YES
                  init_file
                  innodb_additional_mem_pool_size 1048576
                  innodb_autoextend_increment 8
                  innodb_buffer_pool_size 8388608
                  innodb_data_file_path
                  innodb_data_home_dir
                  innodb_fast_shutdown ON
                  innodb_file_io_threads 4
                  innodb_flush_log_at_trx_commit 1
                  innodb_flush_method
                  innodb_force_recovery 0
                  innodb_lock_wait_timeout 50
                  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_table_locks ON
                  innodb_thread_concurrency 8
                  interactive_timeout 100
                  join_buffer_size 1044480
                  key_buffer_size 16777216
                  language /usr/share/mysql/english/
                  large_files_support ON
                  license GPL
                  local_infile ON
                  locked_in_memory OFF
                  log OFF
                  log_bin ON
                  log_error
                  log_slave_updates OFF
                  log_slow_queries OFF
                  log_update 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_heap_table_size 16777216
                  max_insert_delayed_threads 20
                  max_join_size 4294967295
                  max_relay_log_size 0
                  max_seeks_for_key 4294967295
                  max_sort_length 1024
                  max_tmp_tables 32
                  max_user_connections 0
                  max_write_lock_count 4294967295
                  myisam_max_extra_sort_file_size 268435456
                  myisam_max_sort_file_size 2147483647
                  myisam_recover_options OFF
                  myisam_repair_threads 1
                  myisam_sort_buffer_size 67108864
                  net_buffer_length 16384
                  net_read_timeout 30
                  net_retry_count 10
                  net_write_timeout 60
                  new OFF
                  open_files_limit 4110
                  pid_file /var/lib/mysql/server6.uae-dns.com.pid
                  port 3306
                  protocol_version 10
                  query_alloc_block_size 8192
                  query_cache_limit 1048576
                  query_cache_size 33554432
                  query_cache_type ON
                  query_cache_wlock_invalidate OFF
                  query_prealloc_size 8192
                  range_alloc_block_size 2048
                  read_buffer_size 2093056
                  read_only OFF
                  read_rnd_buffer_size 520192
                  rpl_recovery_rank 0
                  server_id 1
                  skip_external_locking ON
                  skip_networking OFF
                  skip_show_database OFF
                  slave_net_timeout 3600
                  slow_launch_time 2
                  socket /var/lib/mysql/mysql.sock
                  sort_buffer_size 2097144
                  sql_mode 0
                  table_cache 1800
                  table_type MYISAM
                  thread_cache_size 384
                  thread_stack 196608
                  timezone GST
                  tmp_table_size 33554432
                  tmpdir /tmp/
                  transaction_alloc_block_size 8192
                  transaction_prealloc_size 4096
                  tx_isolation REPEATABLE-READ
                  version 4.0.27-standard-log
                  version_comment Official MySQL RPM
                  version_compile_os pc-linux-gnu
                  wait_timeout 100
                  sigpic

                  Comment

                  • Zachery
                    Former vBulletin Support
                    • Jul 2002
                    • 59097

                    #10
                    Originally posted by alshehi
                    Upgraded version, of course, ^_^



                    alshehi
                    But you _rarely_ need to run these counters unless we tell you do, and even then we don't tell you to often.

                    If you upgraded from 2.x to 3.x you'd need to rebuild a few of those, but not all. Like I've said theres no real reason to run these counters unless the upgrade instructed you too.

                    Comment

                    • alshehi
                      New Member
                      • Aug 2003
                      • 24
                      • 4.0.0

                      #11
                      Welcome

                      Yes, Let me now want promotion to Release 3.6.0
                      Upon promotion must modernization.
                      What I do to solve the problem

                      alshehi
                      sigpic

                      Comment

                      • Floris
                        Senior Member
                        • Dec 2001
                        • 37767

                        #12
                        I am afraid you just have to let it run slow if it goes slow. Big forums have the downside of this. Not something vBulletin can fix. If we could make it faster it would have been coded that way.

                        Comment

                        • alshehi
                          New Member
                          • Aug 2003
                          • 24
                          • 4.0.0

                          #13
                          Originally posted by Floris
                          I am afraid you just have to let it run slow if it goes slow. Big forums have the downside of this. Not something vBulletin can fix. If we could make it faster it would have been coded that way.

                          Welcome
                          Conversely, there are other options To be updated quickly

                          Is there a flaw in the tables based?


                          Thank
                          alshehi
                          sigpic

                          Comment

                          • Zachery
                            Former vBulletin Support
                            • Jul 2002
                            • 59097

                            #14
                            Theres no flaw, these options are not ment to be run 99% of the time, they are only for rebuilding things when a vbulletin message tells you or we tell you to.

                            Comment

                            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                            Working...