Questions tagged [indexing]

94 questions
12
votes
2 answers

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 the script? or do they last until you explicitly…
10
votes
7 answers

Mysql: create index on 1.4 billion records

I have a table with 1.4 billion records. The table structure is as follows: CREATE TABLE text_page ( text VARCHAR(255), page_id INT UNSIGNED ) ENGINE=MYISAM DEFAULT CHARSET=ascii The requirement is to create an index over the column text.…
SiLent SoNG
  • 257
  • 1
  • 2
  • 5
8
votes
2 answers

Correct value for fill factor for clustered indexes with surrogate identity keys

I have a large table which has a clustered index with an identity primary key. I'm deciding on the correct value for the fill factor for this table to minimise page splits. We maintain indexes using a script run daily which measures fragmentation…
SuperCoolMoss
  • 1,252
  • 11
  • 20
7
votes
1 answer

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 still lists it as a max of 84 (I need 128+). When I…
LoveAndCoding
  • 231
  • 1
  • 5
6
votes
4 answers

How long does reindexing take on SQL Server?

I've inherited a very large and very messy database recently and need to clean it up. To give some idea of size, the primary database currently contains 3 big tables each with around 300 million rows and takes up about 225GB storage space. Over 5…
Whiteknight
  • 183
  • 1
  • 1
  • 5
6
votes
2 answers

How do you force Outlook 2007 to re-index it's seach on Windows XP SP 3?

So I have a Windows XP SP 3 machine which is running Outlook 2007. When I search in Outlook for an email that exists using a basic keyword, like say "MySQL", I get no results. However, Outlook gives me the following message: Search results may be…
Aaron K
  • 1,505
  • 5
  • 18
  • 16
5
votes
7 answers

Best way to index this very large table

I have the following table CREATE TABLE DiaryEntries ( [userId] [uniqueidentifier] NOT NULL, [setOn] [datetime] NOT NULL, -- always set to GETDATE(). [entry] [nvarchar](255) NULL ) Each user will insert around 3 entries per day. There will be…
niaher
  • 135
  • 1
  • 1
  • 9
5
votes
2 answers

Vista / Win7 indexing on TrueCrypt drives

Vista and Windows 7 save bits of information to a central location in the background. Instances I know of are desktop search indexes, recent documents and thumbnails (saved to \Users\[User Account Name]\AppData\Local\Microsoft\Windows\Explorer). How…
dbkk
  • 263
  • 5
  • 8
5
votes
2 answers

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 right-click properties in Explorer set some folders…
Cylindric
  • 1,107
  • 5
  • 24
  • 44
5
votes
3 answers

Indexing PDF files on Ubuntu

I'm looking for a solution in Ubuntu that indexes PDF (and ps?) files for searching later. The criteria would be: Compatibility: Often extracting text varies, depending on what software was used to create the PDF. Some PDFs can also be "locked",…
pufferfish
  • 2,660
  • 9
  • 37
  • 40
5
votes
6 answers

What happens if a website does not have a robots.txt file?

If the robots.txt file is missing in the root directory of a website, how are things treated as: the site is not indexed at all the site is indexed without any restrictions It should logically be the second one according to me. I ask in reference…
Lazer
  • 415
  • 3
  • 7
  • 9
4
votes
3 answers

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 workstation has its own email software. Aside from looking…
bistromath
  • 89
  • 1
  • 7
4
votes
3 answers

Search Engine for Network Shares

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 FAST Search for indexing these network shares. But…
oruchreis
  • 179
  • 3
  • 12
4
votes
5 answers

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 am not sure if by RAM they mean only memcached,…
Lance
  • 233
  • 2
  • 8
4
votes
2 answers

how to disable indexing service (permanently!), on Windows 2003 R2

We have a Windows 2003 R2 server, and its c: drive keeps filling up. When I look for what's taking the space, I see an almost-2GB EDB file: C:\Documents and Settings\All Users\Application…
LarsH
  • 380
  • 3
  • 7
  • 19
1
2 3 4 5 6 7