Re: Indexing Failed with large database

Alexander Barkov <[email protected]> Wed, 02 Jul 2014 11:02:45 +0400
Newsgroups gmane.comp.web.mnogosearch.general
Message-ID <[email protected]>
Hi,


On 06/26/2014 06:49 PM, [email protected] wrote:
> Hi
>
> I have a problem when i indexing my database :
> ___________________________________________________________________________________________
>
> root@botujo:/home/jean# /usr/local/mnogosearch/sbin/indexer -Eblob
> indexer[4787]: Indexing
> indexer[4787]: Loading URL list
> {sql.c:1513} Query: SELECT rec_id, site_id, pop_rank, last_mod_time FROM
> url
>
> indexer[4787]: MySQL driver: #144: Table './mnogosearch/url' is marked
> as crashed and last (automatic?) repair failed
>
>
> Here is my database information in phpmyadmin :
>
>       name            lines        size
> ------------------------------------------------------
>      bdict             864  575     1,1 Go
>      bdicti             utilisé
>      bdict_tmp                        2,0 Ko
>      categories                        1,0 Ko
>      crossdict                          1,0 Ko
>      dict                                   1,0 Ko
>      links                                  1,0 Ko
>      qcache                              1,0 Ko
>      qinfo                                 2,0 Ko
>      qtrack                               1,0 Ko
>      server         889                156,7 Ko
>      srvinfo                              1,0 Ko
>      url             utilisé
>      urlinfo     11  009  854   27,4 Go
>
>
> Have you an idea ?

Does manual "REPAIR TABLE url" help?


>
> Thanks
>
> __________________________________________________________________
> my config :
>
> * Debian 3.2.51-1 x86_64 GNU/Linux
> * mnogosearch 3.3.15
> * indexer.conf :
>         ......
>        DBAddr mysql://root:password@localhost/mnogosearch/?dbmode=blob
>
>
> ---
> Ce courrier électronique ne contient aucun virus ou logiciel malveillant
> parce que la protection avast! Antivirus est active.
> http://www.avast.com
>
> _______________________________________________
> General mailing list
> [email protected]
> http://lists.mnogosearch.org/listinfo/general
_______________________________________________
General mailing list
[email protected]
http://lists.mnogosearch.org/listinfo/general