Questions tagged [indexing]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
14 views

Changing database Elastic Pool disturb the indexes of the database

I have more the 5000 database and 15 Elastic Pools in Microsoft Azure and when I feel the database performance issue we change the Elastic Pool of that database. But today I note that our database ...
user avatar
0 votes
0 answers
16 views

In Windows cmd, does `dir /s` bypass the index?

I believe the answer to this question is Yes it does, but I can't find any source to confirm. The question is, if I'm in a cmd box at the root of a drive and I do dir /s <filename spec> does ...
user avatar
  • 101
0 votes
0 answers
18 views

Why windows search index differently on each Windows server?

I need to check the patching status on 20 Windows Server 2016 with similar configuration. So I remote control (mstsc) into each server, click the Window icon at left bottom, type in "installed&...
user avatar
  • 217
0 votes
1 answer
267 views

Workaround for Windows Search/Indexing on a deduplicated volume

According to Microsoft, Microsoft Windows Server 2019 still does not support Windows Search on Data Deduplication enabled volumes (source): Windows Search doesn't support Data Deduplication. Data ...
user avatar
0 votes
0 answers
541 views

indexing options hangs on waiting to receive indexing status

I’m using WS 2019 as a cloud server (AWS Lightsail). I have Office 2016 installed with about 15 RDS users. Already tried DISM .../restorehealth and sfc /scannow. Problem occurs with 2 of the 15 users,...
user avatar
  • 1
1 vote
1 answer
412 views

count.index for dictionary in Ansible

Is it possible to auto generate the vm10,vm11,vm12 in the below script (as count.index used in terraform) ? I would like to pass/define name "vm" and should be able to deploy 3 vm's with the ...
user avatar
  • 21
3 votes
1 answer
564 views

Create Postgres index on RDS is far slower than a weaker linux host

Background: Postgres 10.9 DB runs as a docker container on the dev hosts. (t3.large, gp2 500GB storage) DB runs in RDS for staging and production. (m5.2xlarge, gp2 1TB storage) Everything works ...
user avatar
  • 302
1 vote
2 answers
1k views

How to block crawlers like google from indexing gitlab?

How can I block any crawlers to access anything on gitlab? there should be a robots.txt or something similar to tell not to crawl. That would be good as a first step. But the more important thing, ...
user avatar
  • 277
2 votes
2 answers
162 views

Suggested indexes

I am new to indexing in general and have just started learning about query plans etc. I am working on this one specific query that keeps advising me to create the following index: CREATE NONCLUSTERED ...
user avatar
0 votes
0 answers
261 views

Apache autoindex showing empty file list

I'm trying to enable directory listing for a folder outside the web root that uses Basic Authentication, but I'm getting an empty list and no logged errors. What's strange is that if I put in the ...
user avatar
0 votes
2 answers
403 views

Windows search cannot find files in current directory

We have a windows server 2012 r2 that has the file server role and windows search installed. The drives with the shared folders are indexed and the shares folders are mapped on all clients. I can ...
user avatar
2 votes
1 answer
2k views

Windows index search on Server 2012 R2 fails randomly [closed]

To put it short, the file server's index would fail randomly. The file server has Windows Search service enabled and indexed. There are many clients connected to this server, possibly up to 100. The ...
user avatar
  • 33
0 votes
0 answers
101 views

How to search for all files owned by a particular user in SAN

My question might be confused you but honestly that very straight forward. I have a SAN with many terabytes of data. All users have their own home directory or share directory on that (And most ...
user avatar
  • 51
1 vote
2 answers
695 views

Can I prevent Exchange from indexing during workhours?

We run 2 Exchange servers in a DAG environment. Both servers host 2 databases and have a passive copy of the opposite 2. One of our Exchange servers is indexing a passive copy of the largest database,...
user avatar
  • 111
0 votes
1 answer
6k views

Nginx + PHP index.php not found 404

I'm running debian 9 with nginx 12 and php7.1 I've set evrrything up. Nginx does not give me anything in error log, all the PHP scripts are working 100% fine. Nginx indexes index.html as index but ...
user avatar
4 votes
3 answers
1k views

How should I create a master index of all email correspondence in an office?

My employer requires all email correspondence in the organization to be indexed, for regulatory compliance reasons. Our mail server is not managed by us, and does not have this feature. Each ...
user avatar
0 votes
1 answer
134 views

Server 2012 indexing

we are encountering an issue where an Index file keeps growing indefinite until the special partition for it becomes full and causes it to be come corrupted, which the indexer then deletes and ...
user avatar
0 votes
1 answer
41 views

Windows Server 2008 Not finding recently added files

Recently I am having an issue at work where users cannot search for PDF's added from January of this year and on. I have all the folders indexed, I have tried installing the File Indexing and the ...
user avatar
  • 1
1 vote
0 answers
635 views

Adding new indexes and facet fields to KOHA

I use the following procedures from https://wiki.koha-community.org/wiki/How_to_add_new_zebra_index and https://wiki.koha-community.org/wiki/Understanding_Zebra_indexing, but get no facet shown: /etc/...
user avatar
  • 21
2 votes
0 answers
1k views

The wait operation timed out

I have encountered this problem when running a Data-fill routine for a Data-set Data-adapter in C# which uses a stored procedure written in SQL Server Azure. The SQL Server stored procedure executed ...
user avatar
1 vote
2 answers
769 views

Elasticsearch index much larger than the actual size of the logs it indexed?

I noticed that elasticsearch consumed over 30GB of disk space over night. By comparison the total size of all the logs I wanted to index is only 5 GB...Well, not even that really, probably more like 2....
user avatar
3 votes
1 answer
5k views

mongorestore with indexing in foreground

I need to restore huge dump taken with mongodump utility. As the collections are big and mongorestore rebuilds indexes in backround, index building takes very long to finish. What I want is to somehow ...
user avatar
  • 151
3 votes
0 answers
49 views

Windows Search service, mixed clients - what to choose?

I have been given the task to implement the traditional Windows 2008 R2 Search services on an existing Win2008 R2 file server. Sure, no problem I was thinking, just add the role service and then it ...
user avatar
  • 31
1 vote
2 answers
6k views

MSSQL-Server: rebuild vs reorganize Index and Update Statistics

We had a database which was very slow (MS SQL SERVER). Now we figured out, that the indexes were never rebuild oder reorganised. (At the moment it is not clear if this really was the problem but we ...
user avatar
  • 853
0 votes
0 answers
343 views

indexing a ~3gb database into elasticsearch: how?

I have a new database of 2 million records (around 3gb when dumped json) produced every several days. I want to quickly put it into ElasticSearch. That's what I do right now: Create a new index and ...
user avatar
  • 203
1 vote
1 answer
1k views

Get modified date from Windows indexing search

I'm wondering it it is possible to retrieve the file modified date from a windows indexing search. I'm getting the name of the file with: objRecordset.Fields.Item("System.ItemName") And I'm not ...
user avatar
  • 203
0 votes
0 answers
58 views

Exchange 2013 has stopped indexing mail on a specific date [duplicate]

A problem has recently occured where no ones mail is being indexed any more. Everyone can search their mail up until early December and then it just stopped. When you go to the Indexing options on ...
user avatar
1 vote
1 answer
2k views

Windows Search Service on File server

We currently have a Server 2008 R2 file server hosting DFS ABE Shares that are pushed out to our Citrix XenApp 6.5 (published desktop) users as mapped drives via GPO. Recently there have been a lot ...
user avatar
2 votes
0 answers
733 views

How to index document files in NAS storage?

I'm currently developing an application that have to index document files (.pdf and .doc) which are in NAS storage. After that I want to query them over the application. My customer does not want to ...
user avatar
  • 133
1 vote
1 answer
1k views

Hide every directory in a folder from index, but not their contents

On my server, I want to create a directory hidden from normal users, but that is accessible with a link without authentication. Currently I have set it up like this: In the virtual host ...
user avatar
0 votes
1 answer
3k views

What is the effect of disabling the index on a Exchange 2010 database on various clients?

My E2010 database is 435GB, and we are running out of disk space on the database LUN and I'm looking for ways to reclaim this space in an efficient manner. Right now I'm moving mailboxes, but I don't ...
user avatar
2 votes
1 answer
2k views

Sphinx searchd: failed to lock .spl file, no such file or directory

I use sphinx for indexing on my development environment, and it is working fine. But when i take it to the server. I can index and I have the indexes with search working on them, but everytime I run ...
user avatar
1 vote
1 answer
451 views

Is there any way to store the index of a network file system (SMB 2.0) on the server, so that my users don't have to manually set up the index?

I apologize if this is in the wrong place, but I believe it is sufficiently server related. Also, just as a disclaimer: I'm not the server guy! I'm just trying to find out information. I have several ...
user avatar
  • 159
1 vote
1 answer
2k views

Configure .htaccess to block bot indexing but allow browser directory listing/viewing

I know in order to show a directory listing of my files in a browser through .htaccess I can use Options +Indexes and to prevent Google and most bots from crawling my directory I can use Options -...
user avatar
  • 595
3 votes
1 answer
4k views

Windows 7 clients can't search indexed files on Server 2008 R2 file server

I've been having problems getting Windows Search Service on our file server to provide our Windows 7 clients with searching capability of the indexed files on the server. I've got the Windows Search ...
user avatar
  • 7,530
0 votes
1 answer
215 views

prevent search engines indexing depending on domain

We have a dedicated server with a hosting company with a couple of dozens of webs in it. It happens that the nameservers (EG: ns1.domain.com, ns2.domain.com) ip's are coincident with some client webs, ...
user avatar
-4 votes
1 answer
195 views

where should my index.html be? django [closed]

I have a friend working with me preparing some web services in a virtual server of mine, he is in a different time zone, and can't talk to him right now, i have access to the server, with ssh, sftp ...
user avatar
2 votes
1 answer
1k views

What exactly is "pinning" in relation to indexes? [closed]

When one talks about "pinning" in indexes, what exactly is this? Is there some other word/term I can search for, as google has not provided any solutions. It is part of a test question, where ...
user avatar
5 votes
2 answers
28k views

Windows Search not searching in files

I am trying to get Windows Search to work on my Windows Server 2008 SP2 fileserver, so I can search in files for content. I have added the Windows Search Service role to the server, and using the ...
user avatar
  • 1,097
4 votes
3 answers
4k views

Search Engine for Network Shares [closed]

We have a clustered storage server that contains many project files like Corel, Indesign, Edius, Adobe Premiere, etc.. Also it has lots of image, audio and video files. We are using sharepoint and ...
user avatar
  • 179
7 votes
1 answer
477 views

Mysql change ft_max_word_len bug

So, I have MySQL installed on my machine, and I need to change the ft_max_word_len, the maximum word length that MySQL will index. However, when I set it up via the tools provided, and query it, it ...
user avatar
-2 votes
1 answer
254 views

Google desktop on Server - indexing takes a long time

How is your experience of Google desktop on server? My server is relatively slow (quite slow actually). I have installed Google desktop to speed up the search process. It started indexing a week ago. ...
user avatar
0 votes
1 answer
13k views

How to create non-clustered indexes on a SQL Server 2008 database? Preferably without code?

I would appreciate help on how to create non-clustered indexes on a SQL Server 2008 database without using code--or rather, 'statically' once and for all prior to running any SQL queries (that ...
user avatar
0 votes
1 answer
199 views

Creating a HTML index of documents (PDF,PS) for a knowledge base

I've been looking for a command line / Linux-friendly "index" generator. I want to load PDF, PS, DOC and other documents and generate a static (X)HTML frame-based interface, as a knowledge base of ...
user avatar
  • 101
12 votes
2 answers
8k views

With MySQL, how long does an "ALTER TABLE ... DISABLE KEYS;" statement last?

If you disable the keys (suspending indexing) on a mysql INNODB table, how long does that setting last? For a query like: ALTER TABLE users DISABLE KEYS; Do the keys get re-enabled at the end of ...
user avatar
2 votes
2 answers
124 views

Indexing windows server for searching

Is there a way to index file shares on a windows file server so that they can be quickly searched by end users, that isn't part of sharepoint?
user avatar
  • 2,023
1 vote
2 answers
352 views

Linux search tool for a server [closed]

I would like to search my server (or even the entire local area network) for files with possibility of indexing (even the content of txt, pdf, ... files). I got suggested this link (https://...
user avatar
  • 141
0 votes
1 answer
164 views

Add index to very large SQL Server table

I've got a table with 9 million rows (just received it from our underwriting provider). 4 columns -- leadid (guid), RawLeadXML (nvarchar(max) that contain an xml doc in each row that is 2-3kb), ...
user avatar
4 votes
5 answers
2k views

What does it mean when Twitter says their entire database is in RAM?

I am wondering where to begin with database scaling/optimization strategies. After reading articles like highscalability.com's facebook architecture article, and this twitter architecture article, I ...
user avatar
  • 233
0 votes
3 answers
154 views

Explaining the MySQL Indexing

On my journey exploring MySQL and its advanced features, especially regarding the performance optimization I bumped in some extremely important feature for SQL performance improvement mos of us knows ...
user avatar
  • 268