Re: [General] Indexing Failed with large database

2014-07-02 Thread Alexander Barkov 

Hi,


On 06/26/2014 06:49 PM, d...@hodei.net 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 :

  namelinessize
--
 bdict 864  575 1,1 Go
 bdicti utilisé
 bdict_tmp2,0 Ko
 categories1,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 889156,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
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

[General] Indexing Failed with large database

2014-06-26 Thread d...@hodei.net 

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 :

 namelinessize
--
bdict 864  575 1,1 Go
bdicti utilisé
bdict_tmp2,0 Ko
categories1,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 889156,7 Ko
srvinfo  1,0 Ko
url utilisé
urlinfo 11  009  854   27,4 Go


Have you an idea ?

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
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general