The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
121 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
25 views

How to to use a cgi file without an extension as index in Apache

I'm using WebMin to administer an Apache server and am having trouble getting Apache to use a python CGI file without an extension (named "home") as my index. The file is executable and works OK if I ...
0
votes
1answer
520 views

Nginx URL virtual host rewrite issues with Magento e-commerce. Help please

I've been running into some serious problems with my URL rewrites and I can't seem to fix it on my own strength and knowledge and troubleshooting on the web! Basically what happens is that when I ...
0
votes
1answer
78 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
146 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 ...
0
votes
1answer
43 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
0answers
31 views

iis7 restrict permissions for 1 file in wwwroot

How can I restrict permissions to only one file index.html placed in inetpub\wwwroot? I mean NT security. So everything else within wwwroot will be allowed for anyone, but index file - only one AD ...
0
votes
1answer
45 views

indexing logs for fast repeated grep/search

I have sets of verbose logfiles that in the course of solving a problem, I will repeatedly regrep. I usually have about 1-10GB sets of 50-150 files, that I'll spend a few hours with and then never ...
1
vote
3answers
130 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
2answers
361 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. ...
-2
votes
1answer
67 views

Fastest mail server for full body searching [closed]

I'm looking for the fastest mail server software currently available. I'm looking to store around 900GB of mail. I need to be able to perform full body searches across all messages via IMAP and get a ...
0
votes
1answer
285 views

Nginx proxy pass php index problems

I am having slight issues making my indexes work with nginx serving static content and passing php to apache on a different server. Basically if I need it to try index.php on the backend apache ...
0
votes
1answer
176 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
1answer
154 views

Why is index.cgi displayed as content instead of being executed?

I am trying to make a site with index.cgi, if available, served up as the content. In /etc/apache2/sites-enabled/000-default, I have: DirectoryIndex index.cgi index.html DocumentRoot ...
0
votes
1answer
27 views

What do I need to change in /etc/apache2/sites-avaible/default?

As in when I check my website at domain.com to show the configuration of wordpress if it's unzipped cause right now when I check it it shows Index of / and my site is in /wordpress. Thanks for any ...
0
votes
1answer
69 views

Unrecognized characters in a genereted index of a directory

I have some files on a server with non-ASCII names and when I'm browswing the apache-generated index of a directory, the non-ASCII characters are not recognized (shown as ?). I've added instructions ...
0
votes
1answer
103 views

How can I prevent browser access to the js and css directories?

What Apache directive would be appropriate to prevent browsers and spiders from exploring css, image and js directories on an Apache web server? I found this in the http.con file, but it is not ...
1
vote
1answer
28 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 ...
0
votes
2answers
62 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 ...
1
vote
0answers
52 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 ...
0
votes
0answers
215 views

Unique index failed?

Recently, we've been having some kind of memory leak in SQL Server. We do have a .NET assembly running to audit our tables, but this has ran for a few years without problems, so I doubt it's the ...
0
votes
1answer
120 views

Nginx index not at project root

I have an index.html page that's stored alongside with the rest of my client-side resources (/opt/django/media/index.html). I can get nginx to serve the page as the index for requests to just the ...
0
votes
1answer
212 views

In MySQL 5.1 InnoDB, does the maximum length of a VARCHAR affect secondary index size? [closed]

Assuming the data is the same either way, does the maximum length of the VARCHAR affect the space usage of a secondary index? Does InnoDB use fixed length records for indexes? Assume that we're ...
2
votes
1answer
196 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
2answers
832 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 ...
1
vote
1answer
384 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
707 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
0answers
57 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
335 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 ...
0
votes
1answer
79 views

Non Clustered Covering Index Column Selection Rules

I have a table with around 19 columns which contains reasonable large amount of data and is primarily being queried to retrieve data using select statements based on different where clause. Since this ...
1
vote
3answers
423 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 ...
0
votes
1answer
423 views

UBUNTU - Broken DPKG and Index

Was doing a package update and it ended a process and hung so I rebooted the server and now it will not allow me to perform any more updates. I tried the following to no avail: sudo apt-get clean ...
4
votes
2answers
2k 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 ...
2
votes
2answers
757 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.
0
votes
1answer
254 views

Mysql : Cannot create Index:

Hi all we are having trouble to create/drop index(s) on a table I keep getting the following error: ERROR 1280 (42000): Incorrect index name '<>' Now the table has the following: 1. PRIMARY ...
0
votes
2answers
731 views

Nginx requesting index through reverse-proxy

I'm working on a test setup for nginx+apache. I have nginx listening on port 80, apache on port 8080. Nginx is set up to deal out the static content, apache is there to deal out the dynamic content ...
0
votes
1answer
453 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 ...
2
votes
1answer
302 views

Index reorganizing slow after index rebuild

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
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; ...
0
votes
2answers
205 views

Sphinx indexer slows down the database: How to give it low priority?

All my tables use InnoDB, and I have set sphinx sql_range_step to the minimum, which is 128. This improved the performance a lot, but it is still very slow if you make a request right after a new step ...
0
votes
2answers
716 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 ...
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 ...
1
vote
1answer
285 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
124 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 = ...
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?
7
votes
8answers
715 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.) ...
0
votes
2answers
3k views

Changing default Apache page for a virtual host to a mod_autoindex generated listing

I have the following virtual host in my Apache configuration: <VirtualHost *:80> ServerName foobarspaz DocumentRoot "/path/to/document/root" </VirtualHost> There is no ...
1
vote
2answers
634 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 ...
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 ...
0
votes
2answers
1k views

Indexing Exchange Mailboxes with SharePoint

What options are recommended for indexing Exchange mailboxes with SharePoint? So far I have found the following: I found one article, which mentions that you can add http://<fqdn>/exchange ...