Questions tagged [indexes]
The indexes tag has no usage guidance.
38
questions
0
votes
1
answer
578
views
Why is htdocs not displaying directories when a virtual host has an error?
I just set up Apache v2.4, PHP and MySQL on new windows machine. I've made only a few changes to httpd.conf. I'm including httpd-vhosts.conf, which has 2 custom sites defined (I removed the default ...
- 11
2
votes
1
answer
2k
views
When to use a new index in Graylog (Elasticsearch)?
I have been searching for days now to find a good explanation on how indices are used by Graylog/Elasticsearch and when to create a new one. There is a lot of info about sharding indices but not much ...
- 133
0
votes
1
answer
1k
views
MySQL (MariaDB) is running at 100% CPU utilization after adding an index
I attempted to add an index to a date field in a table (MyISAM) having about 4,000 rows, using PHPMyAdmin.
PHPMyadmin froze, finally timed out. Now, even after rebooting the server, the MySQL (...
- 963
2
votes
2
answers
174
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 ...
- 83
1
vote
1
answer
125
views
Different cardinality after each ALTER TABLE;
There is no new entries in this table. Same error on 10.3.8-MariaDB and 10.2.6
What could cause that?
Also this is strange too.
- 68
-5
votes
2
answers
300
views
How do I create a static website on aws s3 specifying an index document with spaces in the name
for example suppose I have a file "test index.html" and I want to set this as the index document for static website hosting, how do I do this? I've tried test index.html, "test index.html", test+index....
- 91
0
votes
1
answer
151
views
Move SQL Indexes in bulk
Let me start off by saying I am not a SQL guru, I know just enough to get into trouble with it :) We just migrated a client over from SQL 2008 R2 to SQL 2016 on new hardware and we want to move the ...
- 605
0
votes
2
answers
1k
views
Web page showing index list
I am using Apache 2.2.22 for web hosting and I had created a directory tree like C:/server/www/apacheserver.dev/public_html and put everything (my web page file) inside the public_html, but inside the ...
- 101
1
vote
1
answer
1k
views
Apache server running Passenger can't display Rails app
I have a project that was pulled from github into my /home partition, and made symbolic links to the /var partition as per convention.
How it looks :
/home/vagrant/github/whois-dreyfus --> repo of ...
1
vote
1
answer
301
views
Re-ocurring issue with keys on temp tables
We run a large forum with lots of reads and writes, particularly to the posts and topics tables which are both innodb.
Last week I started doing 12 hourly backups with innobackupex because mysqldump ...
- 789
1
vote
1
answer
891
views
Slow MSSQL on DB (~2TB) - Index / fragmentation?
I have a fairly large MS SQL database (~2TB). Most of the data is in one table (~6 billion rows).
Two weeks ago I dropped two non-clustered indexes on the large table and migrated the data onto a ...
- 19
4
votes
2
answers
2k
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 ...
- 1,386
-2
votes
1
answer
37
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 ...
3
votes
1
answer
3k
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?
- 1,389
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 ...
0
votes
2
answers
2k
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 ...
- 269
2
votes
1
answer
4k
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 ...
user909943
0
votes
1
answer
636
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 ...
- 249
2
votes
2
answers
359
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 sys....
- 65
1
vote
2
answers
406
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
1
answer
52
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 ...
- 262
0
votes
1
answer
1k
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 ...
- 408
1
vote
3
answers
524
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 ...
- 131
0
votes
2
answers
3k
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,343
1
vote
2
answers
662
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?
- 111
4
votes
1
answer
6k
views
Listing MySQL JOINS with no index
Is there a way to generate a list of JOINS being performed without indexes in MySQL?
- 261
1
vote
2
answers
82
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 ...
- 284
3
votes
3
answers
5k
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
- 1,516
4
votes
4
answers
534
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 ...
- 143
0
votes
2
answers
627
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 ...
- 173
0
votes
2
answers
1k
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 ...
- 5,293
4
votes
3
answers
12k
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 ...
- 510
1
vote
1
answer
293
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 ...
- 1,561
5
votes
2
answers
6k
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 ...
- 1,207
8
votes
2
answers
4k
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 ...
- 1,262
5
votes
6
answers
3k
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 ...
- 28.5k
1
vote
3
answers
5k
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 ...
- 2,220
20
votes
4
answers
7k
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 ...
- 685