[mirrorbrain-commits] [opensuse-svn] r6323 - trunk/tools/download-redirector-v2/sql

Author: poeml
Date: 2009-02-02 15:38:28 -0700 (Mon, 02 Feb 2009)
New Revision: 6323

Modified:
   trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql
Log:
MirrorBrain database schema for MySQL: 

Drop an index on the file_server table, which existed twice, 
wasting 600 MB of space with the huge openSUSE database.

1950498816/1024/1024
1860.14
1333788672/1024/1024
1272.00



Modified: trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql
===================================================================
--- trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql	2009-02-02 22:21:02 UTC (rev 6322)
+++ trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql	2009-02-02 22:38:28 UTC (rev 6323)
_at_@ -20,8 +20,6 @@
 -- timestamp_file: the default and update trigger are not used
   `timestamp_file` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
   `timestamp_scanner` timestamp NOT NULL default '0000-00-00 00:00:00',
--- BUG: This index is a duplicate of file_server_fileid_serverid_idx
-  KEY `fileid` (`fileid`,`serverid`),
   KEY `file_server_fileid_idx` (`fileid`),
   KEY `file_server_serverid_idx` (`serverid`),
   KEY `file_server_fileid_serverid_idx` (`fileid`,`serverid`),

_______________________________________________
Opensuse-svn mailing list
Opensuse-svn_at_forge.novell.com
http://forge.novell.com/mailman/listinfo/opensuse-svn


_______________________________________________
mirrorbrain-commits mailing list

Note: To remove yourself from this list, send a mail with the content
 	unsubscribe
to the address mirrorbrain-commits-request_at_mirrorbrain.org