Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>How to increase the maximum number of allowed open files depends slightly on your linux distribution. Here are some instructions for ubuntu and centos:</p> <p><a href="http://posidev.com/blog/2009/06/04/set-ulimit-parameters-on-ubuntu/">http://posidev.com/blog/2009/06/04/set-ulimit-parameters-on-ubuntu/</a> <a href="http://pro.benjaminste.in/post/318453669/increase-the-number-of-file-descriptors-on-centos-and">http://pro.benjaminste.in/post/318453669/increase-the-number-of-file-descriptors-on-centos-and</a></p> <p>The elasticsearch documentation recommends setting the maximum file limit to 32k or 64k. Since you are at 16k and are already hitting a limit, I'd probably set it higher; something like 128k. See: <a href="http://www.elasticsearch.org/guide/reference/setup/installation/">http://www.elasticsearch.org/guide/reference/setup/installation/</a></p> <p>After upping the number of open files and restarting elasticsearch you will want to verify that it worked by re-running the curl command you mentioned:</p> <pre><code>curl -XGET 'http://localhost:9200/_nodes?os=true&amp;process=true&amp;pretty=true' </code></pre> <p>As you add more indices (along with more documents), you will also see the number of files elasticsearch keeps track of increase. If you notice performance degradation with all of the indicies and documents, you can try adding a new node to your cluster: <a href="http://www.elasticsearch.org/guide/reference/setup/configuration/">http://www.elasticsearch.org/guide/reference/setup/configuration/</a> - since you already have a sharded, replicated configuration, this should be a relatively painless process.</p>
    singulars
    1. This table or related slice is empty.
    1. POToo many open files warning from elasticsearch
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USDan Noble
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POToo many open files warning from elasticsearch
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHi @Dan Noble thanks for the info. My ulimit is already set to 65535. How come elasticsearch is taking only 16384? Do I need to change in setting in the config file to get the ulimit set by OS...?
      singulars
      1. PO
      1. USVamsi Krishna
    2. COyes precisely. did you get it worked out?
      singulars
      1. PO
      1. USDan Noble
    3. COOops... sorry I have accepted the answer. But forgot to mention the same. Yes, I had to change the same at OS level to get the updated limit. Your comment helped a lot. Thanks @Dan
      singulars
      1. PO
      1. USVamsi Krishna
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload