Announcement

Collapse
No announcement yet.

Search rebuild stuck

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Search rebuild stuck

    Hello,

    My search index rebuild is stuck at 74463. What can I do now? If I re-start, it'll re-start from the beginning.

    Thanks.

  • #2
    which version of vB, mysql and PHP ? does it restart from beginning if you set Post ID to start at at 74460 ?

    how many posts to process at a time you setting it at ?

    server specs and forum size ?
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

    Comment


    • #3
      Hello,

      vBulletin 3.5.2.
      php 4.3.11
      mySQL 3.23.58

      It is now having problems loading at a reasonable speed. It didn't serve pages for a minute or two, then now it is serving but with some icons and photos missing. It indicates that the server loads are below 1.0 when I issued it a top command after logging in using Putty. I was using the default settings, which was 250 post each time.

      MySQL Status as indicated in the Admin CP says:
      Aborted_clients 158
      Aborted_connects 4182
      These are values since the board started, right?

      I have it rebuild at 74460. Does it matter if this rebuild is being performed a few hours after the first one has stopped and members have posted new posts? This time I have selected to build with 200 each time.

      Server is as copied from ISP site:
      AMD Sempron 2800+ 64-bit
      512MB RAM
      40GB ultra fast hard drive

      This is for 2000 members.

      Thanks.

      Comment


      • #4
        Does it matter if this rebuild is being performed a few hours after the first one has stopped and members have posted new posts? This time I have selected to build with 200 each time.
        no probs doing that at all

        seems part of problem could be mysql config and version related as mysql 3.23.58 is very out dated

        can you provide info asked at http://www.vbulletin.com/forum/showthread.php?t=70117

        i would upgrade to MySQL 4.1.16 at least taking special note of info /tips outlined and linked to at

        http://dev.mysql.com/doc/refman/4.1/...from-3-23.html

        and

        http://www.vbulletin.com/forum/showthread.php?t=167924
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment


        • #5
          1) Dedicated
          2) AMD Sempron 2800+ 64-bit
          512MB RAM
          40GB ultra fast hard drive
          Apache 1.3.27
          php 4.3.11
          mySQL 3.23.58

          4) Came with server
          5) Which part of the top stats do you need
          Not sure why 6) & 7) turns out to be the way they are. When I pasted the copied output from the AdminCP into the message editor, the table was pasted in as an image. But it doesn't retain this image after Submitting.
          6)
          back_log50basedir/usr/bdb_cache_size8388600bdb_log_buffer_size32768bdb_home/var/lib/mysql/bdb_max_lock10000bdb_logdir bdb_shared_dataOFFbdb_tmpdir/tmp/bdb_versionSleepycat Software: Berkeley DB 3.2.9a: (September 11, 2003)binlog_cache_size32768character_setlatin1character_setslatin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7 win1250 win1251 win1251ukr ujis sjis tis620concurrent_insertONconnect_timeout5datadir/var/lib/mysql/delay_key_writeONdelayed_insert_limit100delayed_insert_timeout300delayed_queue_size1000flu shOFFflush_time0have_bdbYEShave_geminiNOhave_innodbYEShave_isamYEShave_raidNOhave_opensslN Oinit_file innodb_additional_mem_pool_size1048576innodb_buffer_pool_size8388608innodb_data_file_pathi bdata1:10M:autoextendinnodb_data_home_dir innodb_file_io_threads4innodb_force_recovery0innodb_thread_concurrency8innodb_flush_log_at _trx_commit1innodb_fast_shutdownONinnodb_flush_method innodb_lock_wait_timeout50innodb_log_arch_dir innodb_log_archiveOFFinnodb_log_buffer_size1048576innodb_log_file_size5242880innodb_log_fi les_in_group2innodb_log_group_home_dir./innodb_mirrored_log_groups1interactive_timeout28800join_buffer_size131072key_buffer_size83 88600language/usr/share/mysql/english/large_files_supportONlocked_in_memoryOFFlogOFFlog_updateOFFlog_binOFFlog_slave_updatesOFFl og_long_queriesOFFlong_query_time10low_priority_updatesOFFlower_case_table_names0max_allow ed_packet1048576max_binlog_cache_size4294967295max_binlog_size1073741824max_connections100 max_connect_errors10max_delayed_threads20max_heap_table_size16777216max_join_size429496729 5max_sort_length1024max_user_connections0max_tmp_tables32max_write_lock_count4294967295myi sam_max_extra_sort_file_size256myisam_max_sort_file_size2047myisam_recover_options0myisam_ sort_buffer_size8388608net_buffer_length16384net_read_timeout30net_retry_count10net_write_ timeout60open_files_limit0pid_file/var/run/mysqld/mysqld.pidport3306protocol_version10record_buffer131072record_rnd_buffer131072query_buffer _size0safe_show_databaseOFFserver_id0slave_net_timeout3600skip_lockingONskip_networkingOFF skip_show_databaseOFFslow_launch_time2socket/var/lib/mysql/mysql.socksort_buffer2097144sql_mode0table_cache64table_typeMYISAMthread_cache_size0thread _stack65536transaction_isolationREAD-COMMITTEDtimezonePDTtmp_table_size33554432tmpdir/tmp/version3.23.58wait_timeout28800
          7) Aborted_clients164Aborted_connects4182Bytes_received2419206427Bytes_sent1439170826Com_admi n_commands115Com_alter_table281Com_analyze0Com_backup_table0Com_begin189599Com_change_db14 707259Com_change_master0Com_check0Com_commit189599Com_create_db3Com_create_function0Com_cr eate_index0Com_create_table2820Com_delete1096554Com_drop_db1Com_drop_function0Com_drop_ind ex0Com_drop_table2485Com_flush10Com_grant0Com_insert11772241Com_insert_select108140Com_kil l0Com_load0Com_load_master_table0Com_lock_tables1Com_optimize329Com_purge0Com_rename_table 0Com_repair0Com_replace504118Com_replace_select234Com_reset0Com_restore_table0Com_revoke0C om_rollback0Com_select67295865Com_set_option32172Com_show_binlogs0Com_show_create32424Com_ show_databases358Com_show_fields34577Com_show_grants31Com_show_keys92Com_show_logs0Com_sho w_master_status0Com_show_open_tables0Com_show_processlist8Com_show_slave_status0Com_show_s tatus7Com_show_innodb_status0Com_show_tables3852Com_show_variables432Com_slave_start0Com_s lave_stop0Com_truncate1Com_unlock_tables0Com_update10195294Connections14895784Created_tmp_ disk_tables2846801Created_tmp_tables7004989Created_tmp_files0Delayed_insert_threads0Delaye d_writes0Delayed_errors0Flush_commands1Handler_delete1328624Handler_read_first36631067Hand ler_read_key2842149442Handler_read_next1256225158Handler_read_prev80346Handler_read_rnd665 788236Handler_read_rnd_next1765198818Handler_update2184784394Handler_write3139805461Key_bl ocks_used7793Key_read_requests1185453300Key_reads18971952Key_write_requests48168183Key_wri tes34376050Max_used_connections100Not_flushed_key_blocks0Not_flushed_delayed_rows0Open_tab les64Open_files124Open_streams0Opened_tables190490Questions121068742Select_full_join194710 Select_full_range_join5404Select_range1847614Select_range_check0Select_scan23474111Slave_r unningOFFSlave_open_temp_tables0Slow_launch_threads6Slow_queries72Sort_merge_passes0Sort_r ange4259272Sort_rows2358376698Sort_scan12576473Table_locks_immediate122149445Table_locks_w aited30437Threads_cached0Threads_created14895783Threads_connected1Threads_running1Uptime20 080420
          8) PhotoPost, phpBB2 (closed but still exist), vBulletin, and vbPortal.
          9) Max concurrent is about 50. Average around 25. Timeout should be default.
          10) www.canreef.com/check.php
          11) Not sure how to get info
          12) vBulletin 3.5.2
          13) Don't think there are because "find / -size +2000000k" didn't return anything. Although I'm not sure why this is the case because I have a few backups over this size.

          Thanks.
          Last edited by parafieldtower; Mon 19th Dec '05, 5:39am.

          Comment


          • #6
            well need top stats upto the last memory stats display no need for the individual processes under it

            BUT, your biggest improvement would be by backing up databases using mysqldump, then upgrading from MySQL 3.23.58 to 4.1.16 and reimporting the database sql dumps into newly MySQL 4.1.16 created empty databases

            then come back with to this thread for a new my.cnf for MySQL 4.1.16
            :: Always Back Up Forum Database + Attachments BEFORE upgrading !
            :: Nginx SPDY SSL - World Flags Demo [video results]
            :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

            Comment


            • #7
              Hello,

              Okay. I'll ask the hosting company to do the mySQL update for me. What is this my.cnf file and should I get this before the update so there won't be any downtime?

              Code:
                3:45pm  up 238 days, 20:27,  1 user,  load average: 0.00, 0.02, 0.00
              87 processes: 85 sleeping, 1 running, 1 zombie, 0 stopped
              CPU states:  0.0% user,  0.1% system,  0.1% nice,  0.0% idle
              Mem:   497968K av,  483124K used,   14844K free,       0K shrd,   73912K buff
              Swap: 2096472K av,  108012K used, 1988460K free                  253348K cached

              Comment


              • #8
                my.cnf is mysql settings file which is to be placed at /etc/my.cnf you may have one there already if not create a my.cnf at /etc/my.cnf

                settings to use in my.cnf you can do this after the mysql upgrade... remember back up forum using mysqldump FIRST before the upgrade

                http://www.vbulletin.com/docs/html/m...atabase_backup

                http://www.sitepoint.com/article/678

                as AFTER mysql upgrade you need to reimport the mysqldump created sql back up file into a newly created mysql database to ensure 100% compatibility with new mysql version
                :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                :: Nginx SPDY SSL - World Flags Demo [video results]
                :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                Comment

                Loading...
                Working...
                X