Server Fault Stack Exchange
Server Fault Stack Exchange

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…
dirtside
  • 1,551
  • 5
  • 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 -->…
Gribish Zurah
  • 11
  • 2
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…
Christian
  • 789
  • 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…
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?
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…
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…
BradC
  • 2,220
  • 4
  • 27
  • 36
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?
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?
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…
Ryan Griggs
  • 963
  • 2
  • 14
  • 29
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…
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…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
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…
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…
Emerald
  • 101
  • 1
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…
PaulDecember
  • 5
  • 1
  • 1
  • 4
1
2
3