Questions tagged [indexes]
38 questions
1
vote
1 answer
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 filenames are only about 20 characters wide, and get…
![](../../users/profiles/10376.webp)
dirtside
- 1,481
- 4
- 17
- 22
1
vote
1 answer
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 the actual project
/var/www/whois-dreyfus -->…
![](../../users/profiles/261734.webp)
Gribish Zurah
- 11
- 1
1
vote
1 answer
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 just takes forever (7+ million rows in posts…
![](../../users/profiles/7732.webp)
Christian
- 779
- 1
- 13
- 31
1
vote
1 answer
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 single 6TB RAID SSD array. I then recreated the two…
![](../../users/profiles/192467.webp)
A-Kay
- 19
- 1
1
vote
2 answers
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 and decide which ones I should implement?
![](../../users/profiles/39073.webp)
Christian Wattengård
- 145
- 7
1
vote
3 answers
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 select by a username or password, it will show the…
![](../../users/profiles/58695.webp)
taber
- 131
- 6
1
vote
3 answers
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 currently working on fixing the proc (some new indexes and…
![](../../users/profiles/530.webp)
BradC
- 2,200
- 4
- 25
- 35
1
vote
2 answers
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?
![](../../users/profiles/55992.webp)
swxxii
- 111
- 3
1
vote
2 answers
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 message?
![](../../users/profiles/43709.webp)
naugtur
- 284
- 3
- 11
0
votes
1 answer
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 (MariaDB) server is using 100% cpu, and is almost…
![](../../users/profiles/143364.webp)
Ryan Griggs
- 885
- 2
- 12
- 27
0
votes
2 answers
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 the Maintenance Plan wizard to rebuild the indexes…
![](../../users/profiles/9826.webp)
Ra Osolage
- 173
- 2
- 2
- 10
0
votes
2 answers
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 to know if there are any indexes that are no…
![](../../users/profiles/4822.webp)
Ian Boyd
- 5,131
- 14
- 57
- 79
0
votes
1 answer
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 indexes over to a different partition that is on…
![](../../users/profiles/82150.webp)
msindle
- 605
- 8
- 26
0
votes
2 answers
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 public_html I still have sub directory file and…
![](../../users/profiles/322378.webp)
Emerald
- 101
0
votes
1 answer
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 probably does not make sense, but my point being I don't…
![](../../users/profiles/101631.webp)
PaulDecember
- 5
- 1
- 1
- 4