Slow type delete


(WhatElse) #1

Hi,

I have setted my index and add a mapping to one of his type and when i'm
trying to delete it, it's very very slow, like ten seconds to do that.

The curl request is very simple : curl -XDELETE
http://localhost:9200/french/user/

What's wrong ?

Thank you in advance ! (and sorry for my english :frowning: )


(David Pilato) #2

How many docs for this type in your index ?

BTW, dropping an index is really fast as it only deletes a dir.

David :wink:
Twitter : @dadoonet / @elasticsearchfr

Le 18 juin 2012 à 05:57, WhatElse kevin.perard@gmail.com a écrit :

Hi,

I have setted my index and add a mapping to one of his type and when i'm trying to delete it, it's very very slow, like ten seconds to do that.

The curl request is very simple : curl -XDELETE http://localhost:9200/french/user/

What's wrong ?

Thank you in advance ! (and sorry for my english :frowning: )


(WhatElse) #3

I have no docs, I just put setting and mapping of my index/type and I
wanted to delete this but that took so long time. If I delete on index or
node, it's instant... I will try to make a git to reproduce this...

Le lundi 18 juin 2012 01:02:54 UTC-4, David Pilato a écrit :

How many docs for this type in your index ?

BTW, dropping an index is really fast as it only deletes a dir.

David :wink:
Twitter : @dadoonet / @elasticsearchfr

Le 18 juin 2012 à 05:57, WhatElse kevin.perard@gmail.com a écrit :

Hi,

I have setted my index and add a mapping to one of his type and when i'm
trying to delete it, it's very very slow, like ten seconds to do that.

The curl request is very simple : curl -XDELETE
http://localhost:9200/french/user/

What's wrong ?

Thank you in advance ! (and sorry for my english :frowning: )


(WhatElse) #4

I have made a git repository where i put the settings and mappings file
with the script. The delete request is very long, please can you check it
and give me your feedback about this. Thank you.

This is the github link :
https://github.com/Nelrohd/WhatElse/tree/master/index

On Monday, June 18, 2012 2:25:24 PM UTC-4, WhatElse wrote:

I have no docs, I just put setting and mapping of my index/type and I
wanted to delete this but that took so long time. If I delete on index or
node, it's instant... I will try to make a git to reproduce this...

Le lundi 18 juin 2012 01:02:54 UTC-4, David Pilato a écrit :

How many docs for this type in your index ?

BTW, dropping an index is really fast as it only deletes a dir.

David :wink:
Twitter : @dadoonet / @elasticsearchfr

Le 18 juin 2012 à 05:57, WhatElse kevin.perard@gmail.com a écrit :

Hi,

I have setted my index and add a mapping to one of his type and when
i'm trying to delete it, it's very very slow, like ten seconds to do that.

The curl request is very simple : curl -XDELETE
http://localhost:9200/french/user/

What's wrong ?

Thank you in advance ! (and sorry for my english :frowning: )


(WhatElse) #5

Even the index is slow... what is wrong in this mapping ?

$mappings = array(
"user" => array(
"_all" => array("analyzer" => "french"),
"properties" => array(
"email" => array(
"type" => "multi_field",
"fields" => array(
"email" => array("type" => "string", "index" => "analyzed", "analyzer" =>
"email"),
"untouched" => array("type" => "string", "index" => "not_analyzed")
)
),
"password" => array(
"type" => "string",
"index" => "not_analyzed"
),
"last_name" => array(
"type" => "multi_field",
"fields" => array(
"last_name" => array("type" => "string", "index" => "analyzed", "analyzer"
=> "french"),
"untouched" => array("type" => "string", "index" => "not_analyzed")
)
),
"first_name" => array(
"type" => "multi_field",
"fields" => array(
"first_name" => array("type" => "string", "index" => "analyzed", "analyzer"
=> "french"),
"untouched" => array("type" => "string", "index" => "not_analyzed")
)
),
"birthday" => array(
"type" => "date",
"format" => "date"
),
"date_creation" => array(
"type" => "date",
"format" => "yyyy-MM-dd HH:mm:ss"
),
"date_activation" => array(
"type" => "date",
"format" => "yyyy-MM-dd HH:mm:ss",
"default_value" => "0000-00-00 00:00:00"
),
"key_activation" => array(
"type" => "string",
"index" => "not_analyzed",
"default_value" => ""
),
"key_password" => array(
"type" => "string",
"index" => "not_analyzed",
"default_value" => ""
),
"activate" => array(
"type" => "boolean",
"null_value" => 1
),
"type_permission" => array(
"type" => "multi_field",
"fields" => array(
"type_permission" => array("type" => "string", "index" => "analyzed",
"analyzer" => "french"),
"untouched" => array("type" => "string", "index" => "not_analyzed")
)
),
"permissions" => array(
"type" => "string",
"index" => "not_analyzed",
"null_value" => "user"
),
)
)
);

On Monday, June 18, 2012 9:25:58 PM UTC-4, WhatElse wrote:

I have made a git repository where i put the settings and mappings file
with the script. The delete request is very long, please can you check it
and give me your feedback about this. Thank you.

This is the github link :
https://github.com/Nelrohd/WhatElse/tree/master/index

On Monday, June 18, 2012 2:25:24 PM UTC-4, WhatElse wrote:

I have no docs, I just put setting and mapping of my index/type and I
wanted to delete this but that took so long time. If I delete on index or
node, it's instant... I will try to make a git to reproduce this...

Le lundi 18 juin 2012 01:02:54 UTC-4, David Pilato a écrit :

How many docs for this type in your index ?

BTW, dropping an index is really fast as it only deletes a dir.

David :wink:
Twitter : @dadoonet / @elasticsearchfr

Le 18 juin 2012 à 05:57, WhatElse kevin.perard@gmail.com a écrit :

Hi,

I have setted my index and add a mapping to one of his type and when
i'm trying to delete it, it's very very slow, like ten seconds to do that.

The curl request is very simple : curl -XDELETE
http://localhost:9200/french/user/

What's wrong ?

Thank you in advance ! (and sorry for my english :frowning: )


(David Pilato) #6

Do you see something in logs ? Look at the slowlog file.

Le 19 juin 2012 à 07:13, WhatElse kevin.perard@gmail.com a écrit :

Even the index is slow... what is wrong in this mapping ?

$mappings = array(
"user" => array(
"_all" => array("analyzer" => "french"),
"properties" => array(
"email" => array(
"type" => "multi_field",
"fields" => array(
"email" => array("type" => "string", "index" => "analyzed", "analyzer" => "email"),
"untouched" => array("type" => "string", "index" => "not_analyzed")
)
),
"password" => array(
"type" => "string",
"index" => "not_analyzed"
),
"last_name" => array(
"type" => "multi_field",
"fields" => array(
"last_name" => array("type" => "string", "index" => "analyzed", "analyzer" => "french"),
"untouched" => array("type" => "string", "index" => "not_analyzed")
)
),
"first_name" => array(
"type" => "multi_field",
"fields" => array(
"first_name" => array("type" => "string", "index" => "analyzed", "analyzer" => "french"),
"untouched" => array("type" => "string", "index" => "not_analyzed")
)
),
"birthday" => array(
"type" => "date",
"format" => "date"
),
"date_creation" => array(
"type" => "date",
"format" => "yyyy-MM-dd HH:mm:ss"
),
"date_activation" => array(
"type" => "date",
"format" => "yyyy-MM-dd HH:mm:ss",
"default_value" => "0000-00-00 00:00:00"
),
"key_activation" => array(
"type" => "string",
"index" => "not_analyzed",
"default_value" => ""
),
"key_password" => array(
"type" => "string",
"index" => "not_analyzed",
"default_value" => ""
),
"activate" => array(
"type" => "boolean",
"null_value" => 1
),
"type_permission" => array(
"type" => "multi_field",
"fields" => array(
"type_permission" => array("type" => "string", "index" => "analyzed", "analyzer" => "french"),
"untouched" => array("type" => "string", "index" => "not_analyzed")
)
),
"permissions" => array(
"type" => "string",
"index" => "not_analyzed",
"null_value" => "user"
),
)
)
);

On Monday, June 18, 2012 9:25:58 PM UTC-4, WhatElse wrote:
I have made a git repository where i put the settings and mappings file with the script. The delete request is very long, please can you check it and give me your feedback about this. Thank you.

This is the github link : https://github.com/Nelrohd/WhatElse/tree/master/index

On Monday, June 18, 2012 2:25:24 PM UTC-4, WhatElse wrote:
I have no docs, I just put setting and mapping of my index/type and I wanted to delete this but that took so long time. If I delete on index or node, it's instant... I will try to make a git to reproduce this...

Le lundi 18 juin 2012 01:02:54 UTC-4, David Pilato a écrit :
How many docs for this type in your index ?

BTW, dropping an index is really fast as it only deletes a dir.

David :wink:
Twitter : @dadoonet / @elasticsearchfr

Le 18 juin 2012 à 05:57, WhatElse kevin.perard@gmail.com a écrit :

Hi,

I have setted my index and add a mapping to one of his type and when i'm trying to delete it, it's very very slow, like ten seconds to do that.

The curl request is very simple : curl -XDELETE http://localhost:9200/french/user/

What's wrong ?

Thank you in advance ! (and sorry for my english :frowning: )


(system) #7