The indexes tag has no wiki summary.
2
votes
2answers
77 views
Find MySQL indexes without cardinality
I've recently found a few queries in my slow query log that should have been using indexes. When investigating the indexes in phpmyadmin it shows a null or empty cardinality. I'm unsure what causes ...
-2
votes
1answer
22 views
suppress viewing indexes - apache [closed]
Does this syntax prevent indexes to be visable in var/www?
<Directory "/var/www">
Options FollowSymLinks
AllowOverride All
Order allow,deny
Allow from all
</Directory>
or ...
1
vote
1answer
96 views
Why is “Options Includes Indexes” Enabled by Default in Apache?
I was curious as to why Options Includes Indexes is generally enabled by default in Apache configurations.
Anyone know why this is, as it's generally frowned upon for security reasons?
0
votes
1answer
4k 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 ...
0
votes
2answers
307 views
Apache Options -Indexes give me 404 instead of 403, why?
I have an Apache/2.2.21 (Debian) webserver, which I disabled directory listing with Options -Indexes but now I got 404 error for a directory, but I think I should get a 403.
I have no idea why I get ...
0
votes
1answer
1k views
Rails program is not being run on apache + passenger - only directory listing
I have successfully installed Phusion passenger + Apache 2 + Rails 3.1 program + git on a linux Debian 6. I ran passenger-install-apache2-module and followed the configuration instructions. I followed ...
0
votes
1answer
191 views
Apache (with Nginx) redirects on directory listing
I have setup Nginx as a reverse proxy in front of Apache. Everything seems to be working fine, although:
When i try to access an index-file (say index.php) but without specifying the file itself, and ...
1
vote
2answers
109 views
sys.dm_db_missing_index_stats reports existing index
I'm confused by the results that I'm getting from sys.dm_db_missing_index_stats ...
The following query returns missing indexes that are actually created on the tables.
select * from ...
1
vote
2answers
170 views
Should I implement all “missing index” suggestions?
Running the SQL Server Performance Dashboard Reports (nice name) gives lots of suggestions for missing indexes in my DB. Should I implement all of these uncritically? Or should I "sort" them somehow ...
0
votes
1answer
42 views
Why did my newly added index show up as a 'statistic'?
We are attempting to tune our SQL Server 2005 database as we frankly have no indexing on our tables and our CPU usage is starting to max out at 100%.
We have ran SQL Server profiler for a 3 hour ...
0
votes
1answer
198 views
Creating indexes on tables filled from transactional replication - SQL 2005
I've got two SQL 2005 servers, one OLTP [let's call it SQLA] and one used for reporting [SQLB] to reduce load on SQLA when people run crazy queries. Our main database is replicated from SQLA to SQLB ...
1
vote
3answers
300 views
Duplicate primary keys in MySQL table due to DoS attack
We have a MySQL database with duplicate primary key index entries as a result of a DoS attack. The duplicates cannot be found by selects on the ID (it will only show one row, not two), but if you ...
0
votes
2answers
417 views
How to list all indexes/constraints/FKs in a MySQL Database from commandline
Is it possible, from the MySQL command line, to list in a single query all the indexes/constraints/FKs etc that are in the database in question?
Thanks in advance
Rich
1
vote
2answers
255 views
Will deleting old MySQL data improve performance?
Would deleting old data from my tables improve MySQL query performance?
When my queries use indexes?
When my queries don't use indexes?
When I use InnoDB?
When I use MyISAM?
1
vote
1answer
690 views
Listing MySQL JOINS with no index
Is there a way to generate a list of JOINS being performed without indexes in MySQL?
1
vote
2answers
44 views
Remove server and system name from apache auto indexes
I've configured apache2 to display folder content with option Indexes in one of my locations, but I really dislike how apache brags about its version and system's version.
How do I remove this ...
1
vote
3answers
893 views
Apache directory listing only for specific IPs?
How can I enable Indexes only for specific IP addresses?
Generally, I want directory listing to be disabled but only be enabled for a specific IP
4
votes
4answers
353 views
If I drop my clustered PK and add a new one, what order will my rows be in?
In SQL Server, I'm looking at TableA, which currently has a uniqueidentifier clustered primary key. The GUID has no meaning in any context.
(I'll give you a second to clean up your keyboard and ...
0
votes
2answers
465 views
Table has no clustered index so what happens if i rebuild indexes?
We have a vendor app that has a SQL Server 2005 database. During data entry, app writes data to a table that has no clustered indexes on it. It has a number of indexes on the table, though.
I used ...
0
votes
2answers
991 views
SQL Server: Index utilization statistics?
Is there a way in SQL Server to get a report of index usage?
i know starting with SQL Server 2005, you can get reports of top resource-using queries, based on what's in the Plan Cache:
i'm curious ...
2
votes
2answers
3k views
Why is Apache ignoring the “Options Indexes” directive?
I have the following block in my .conf file but when I load the appropriate URL (which points to a directory with just a dummy .txt file in it) I get the Apache 2 Test Page instead of a directory ...
1
vote
1answer
193 views
Modify Apache directory listings?
When I use
Options +indexes
...in an .htaccess file, Apache (1.3) displays a formatted list of files in that directory. Yay! However, the actual layout of that formatting kind of sucks; the ...
5
votes
2answers
5k views
Clustered indexes versus non-clustered indexes?
I am in charge of a smaller DB 300+ hundred megs 100'ish tables about 45 users hit it throughout the work day. Mostly reads, but a fair number of updates and inserts. I have been slowing learning the ...
8
votes
2answers
1k 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 ...
3
votes
6answers
1k views
Method for finding unnecessary indexes of an operational SQL Server database?
Besides wasting space on the database, unnecessary indexes on SQL Server can slow down insert and update operations. Developers who lack experience in database principles sometimes tend to create ...
1
vote
3answers
3k views
Update Statistics actually decreases performance?
I have a nightly sp_updatestats on a production database, which seems to work fine, except for one particular stored proc that experience performance issues after the update.
The dev team is ...
14
votes
3answers
2k views
How to exclude indexes from backups in SQL Server 2008
Our nightly full (and periodic differential) backups are becoming quite large, due mostly to the amount of indexes on our tables; roughly half the backup size is comprised of indexes.
We're using the ...
