The tag has no wiki summary.

learn more… | top users | synonyms

8
votes
2answers
2k views

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 ...
7
votes
8answers
764 views

How do you verify a restore?

What tool(s) would you use to verify that a restored file structure is whole and complete? My environment is a Windows Server 2008 file server. (We use tape for backup, but that is inconsequential.) ...
4
votes
4answers
6k views

Locate, Find, Which - How do I launch an index/scan command for these utilities?

How do I re-scan my drive so my 'search utilities' are able to find a new file on my system? I'm having a tough time googling HOW TOs for launching an index/scan command to any of this applications. ...
4
votes
2answers
3k views

Why is dropping an index on MyISAM table so slow?

Why is dropping an index on MyISAM table so slow? I can't imagine I'd have social network with 700m records & dropping index. There are only one-column indexes, all of them are fulltext (I need ...
3
votes
1answer
899 views

Why won't SQL Server use an index seek when running a parameterized query?

When I execute the following query in SQL Server 2005 it uses an index seek, as verified by viewing the execution plan. SELECT * FROM Account WHERE Number = '123456789' But when I run the same ...
3
votes
3answers
2k views

Apache will not display index in web root, subfolders are fine

I have an Apache 2.2.3 server running on CentOS 5.5. In the root of my web directory, there is an index.html file. Going to something like, say, www.exampledomain.egg/index.html works, but going to ...
3
votes
1answer
1k views

Mysql auto_increment reset WITHOUT rebuilding index?

There just HAS to be a way to reset the auto_increment value on a table without rebuilding the entire index. I have a table with over 2 billion rows in it that accidentally got an ID inserted into it ...
2
votes
4answers
3k views

How to reduce mysql disk io?

mysql> explain SELECT * -> FROM (`items`) -> WHERE `states` = 'A' -> ORDER BY `updated_date` desc -> LIMIT 20520, 40; ...
2
votes
3answers
2k views

How remove/de-index a page from Google? [closed]

On the results page when I Google "e-luminate", the 3rd and 4th link seems to point to specific directory deep within the folders which stores the images. How can I get rid of these 2 results from ...
2
votes
1answer
841 views

MySQL query is taking long time after index is rebuilt, but then works fast… why?

I have a simple table with 3M records and a simple unique index on an integer field. When selecing SELECT * FROM ThisTable ORDER BY ThatField LIMIT 10 It works very fast, as expected. When I insert ...
2
votes
1answer
262 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 ...
2
votes
3answers
1k views

EXPLAIN with index suggestions

Is there any (preferably open source) software than can analyze a PostgreSQL EXPLAIN, and recommend the necessary indices that would speed up the query?
2
votes
2answers
976 views

MySql crash: Incorrect key file for table

We have a MySql 5.5 database running InnoDB on Linux. One table (named table_search) is running MyISAM to be able to perform full text searches. The table has 823 368 rows. Yesterday we had a server ...
2
votes
1answer
333 views

Index reorganizing slow after index rebuild with MS SQL

Why does index reorganizing take 3 times longer after I make an index rebuild? I wasn't sure if this happens every time, so I made a test for the last month. I configured SSMS to execute Index ...
2
votes
2answers
1k views

Custom autoindex pages with nginx

Is there a way to define your own autoindex pages in nginx? I want to add my own HTML and CSS to the generated autoindex pages.
1
vote
2answers
111 views

Bots see something different?

I've submitted my web site to different apps like YahooWebmasters and similar places. They see my web site's main page's title as Index of/ . However I see it normally, as My Title. Server: it says ...
1
vote
1answer
514 views

Rebuilt nonclustered indexes quickly get fragmented again

I've got a couple of nonclustered indexes on tables that have rows inserted quite often. These indexes are currently around 90% fragmented, according to SQL Server. If I rebuild them, they go down to ...
1
vote
1answer
2k views

How to Check Oracle Extent Free Space Available?

I need to add some indexes to a moderately large table and I'd like to know in advance if the tablespace has room to hold the index. (The extents are suppose to automatically increas in size, but the ...
1
vote
2answers
34 views

Any solution for MySQL Servers to avoid rendering them unresponsive when running big queries?

I do run several mysql servers for several clients, there is a common problem I used to see. When I run some big query against big databases, for example: I have a MyISAM table with several fulltext ...
1
vote
3answers
175 views

MySQL high cpu load slow quries being logged need help to understand

I'm trying to troubleshoot a high load problem on a server, Today for some reason MySQL is taking up excessive CPU time. I have enabled slow-queries and found this query and others similar. The ...
1
vote
1answer
873 views

PostgreSQL: performance descrease due to index bloatper

I'm running a PgSQL 8.1 on a CentOS 4.4 system (not upgradable unfortunately). There's a Java app running on top of the PgSQL daemon and we got to reindex the database every 2 months or so. Also ...
1
vote
3answers
500 views

Rebuilding the Management Studio Index in SQL Server 2005

Does anyone know if using the SQL Server Management Studio Index Rebuild, rebuilds the index online or offline? Reading the help documentation doesn't say anything on this (so I would assume it is ...
1
vote
2answers
703 views

Error on creating index on table in sql server, how to fix it?

On creating clustered index on table in SQL SERVER 2008 (LIVE DB) got above error. Total records in table is 1046789. I have created same index on test db with same number of records and it ...
1
vote
2answers
87 views

Search Files (Preferably with index) on Windows 2000 Server

I have many files on a windows server 2000 machine that is setup to act as a networked disk drive, is there anyway I can index the files and make that index available as a search to more people than ...
1
vote
2answers
3k views

Multiple columns in a single index versus multiple indexes

The short version of my question is what's the difference between three indexes each indexing a single column and one index indexing three columns. Background follows. I'm primarily a programmer but ...
1
vote
1answer
1k views

How to create a table in MySQL with automatic numeration of rows?

I just want to have a table in which a first column is a monotonically increasing unique integer number. For example, if I have a table with 5 rows the indexes of the rows should be 1,2,3,4,5. And if ...
1
vote
1answer
841 views

Thinking Sphinx index rebuild error on windows xp: searchd is already running

I have Sphinx installed on windows xp system. A I use Thinking Sphinx plug-in within my rails application. I can't rebuild index with Thinking Sphinx rake task after application server starting up ...
1
vote
1answer
21 views

Size of MYI index smaller on slave server

I've recently altered a huge MyISAM table (80 million entries) by adding a new value in an enum field. After I did this I've checked the health of the table on 2 slave servers which are used to ...
1
vote
1answer
319 views

Index fragmentation and reorganizing database pages

Say you have a database with heavy index fragmentation. Say this database also has a lot of free space due to frequent deletes in its data file. This free space is not contiguous. If I rebuild all ...
1
vote
2answers
130 views

MSSQL 2008R2: Phantom Index Updates

I was trying to run the following query: Update A SET A.Col1 = B.Col1, ... A.ColN = B.ColN FROM A INNER JOIN B ON (A.Col1 = B.Col1) WHERE B.Col2 = ...
1
vote
1answer
1k views

Can't rebuild master DB on MS SQL Server 2005 Express after power failure

There has been a power loss on our server and I cannot start the SQL service because the master DB is corrupted (as the log states). I found many articles recommending running the setup.exe with ...
1
vote
2answers
128 views

When I add an index, do I need to do anything else to get it to build?

When I add an index in Sybase, is it built automatically or do I need to do something extra? Is there a way to tell?
1
vote
1answer
288 views

nginx try_files index conflict

I'm trying to achieve a setup with nginx to: use index.html for '/' clean up .html urls default to 404 if no corresponding file is found My server block looks like this: server { listen ...
1
vote
2answers
798 views

403 error; won't proxy: NginX and Node.js

I currently have a setup where all static files are served by NginX, and if no static file is found it is moved onto a node.js server. Unfortunately I am getting a 403 error for the root request. ...
1
vote
1answer
32 views

Understanding mongod log entries

Can anyone explain the numbers in the % column, in this mongod log snippet ? It is building a new index but I'm not sure I understand why the numbers look like that Tue Nov 20 11:38:08 ...
1
vote
0answers
59 views

Passenger_wsgi.py given precedence over DirectoryIndex?

I was having an issue with my site today, where apache wasn't serving index.php by default. I had moved passenger_wsgi.py to the directory above document root so that I could serve python files ...
1
vote
0answers
60 views

Update Statistics Strategy after Index Maintenance Activity

Since Index Rebuilds will update statistics data for the concerned indexes with full scan, so it is not advisable to update statistics on those indexes using the Update Statistics with default sample ...
1
vote
1answer
427 views

FTS - Index rebuild causing CPU issues (SQL Server 2008 R2)

I am encountering some critical issues on SQL Server 2008 in a production environment; We have a database that contains a FTS index; we also have a maintenance job that rebuilds the FTS index and ...
1
vote
3answers
147 views

MySQL FullText Weird Characters

It appears MySQL FullText index does not index the word 'C#'. Probably because the character '#' is removed and you are left with C, which is too short to index. My question is, how would I go about ...
1
vote
2answers
1k views

How to fix a table with a single bad record (or a corrupt index)?

I have a single row in a table that seems to be corrupt. It has an identity field called ID, and I can select where ID < 337 or ID > 337, but not ID = 337. I ran DBCC CHECKTABLE and DBCC CHECKDB ...
1
vote
3answers
100 views

How to set a page as default for apache, that doesn't live in the directory and only applies if there isn't an index

I know. This sounds complicated =D I made a PHP file browser, as an alternative to the apache one. I needed it for logic purposes, it does extra things for me, &etc. So instead of dropping this ...
0
votes
2answers
63 views

Added an index to my MySQL database, now queries get locked

I just added another index to a table in my database but now the site is crashing, queries get locked and not unlocked and queries are not executed (I can see them in the process list and they usually ...
0
votes
1answer
149 views

How do you set a directory's default file?

Can I configure one specific directory on my webserver to use an atypical default file such as "default.php" instead of "index.php"? Do I have to create a ".htaccess" file in that dir?
0
votes
1answer
644 views

SQL Server - Alter Index reorg or rebuild to change fill factor

If I change the fill factor of an index, to make the change effective do I have to rebuild the index using "alter index rebuild" or can I also use "alter index reorganise"?
0
votes
2answers
282 views

Dovecot disable zlib compression and decompress existing messages

After upgrading dovecot to 2.1.7 (wheezy) the mailbox index files seems to be broken. Normaly dovecot should repairs them automatically but due to zlib compression it is not able to determine the ...
0
votes
1answer
240 views

How do I change the format of Apache HTTP Indices?

For instance, this index: http://howto.unixdev.net/ Differs from this index: http://gcc.petsads.us/ How do I change the format of the indices for my web server?
0
votes
2answers
890 views

Can I backup a mysql index? On an innodb table?

I have several tables that are 10's of millions of rows, and have multiple indexes. When dumping and reloading the data it takes quite a while to reinsert because of the indexes, or to insert without ...
0
votes
1answer
378 views

How to make Nginx include index.php in file paths for sub-directories as well (Magento Multistore)

Running multistore setup with Magento on an Nginx server. I'm watching the access logs and can plainly see what is happening. Like many PHP web apps, it uses index.php in its URLs and I have it set to ...
0
votes
1answer
45 views

Apache directory listing

Hi i previously had setup a web server using apache 2.0.65, but i decided to update to 2.2. After updating i noticed that the look of the directory listing changed. It previously looked like this, but ...
0
votes
1answer
502 views

index.php not displaying when navigating to directory with iis6

Found that IIS was looking for iistart.htm before looking for index.php! I am building an application on a iis 6 server and I am running into a problem. When I type in http://server/index.php, I ...