Re: Indexes in MySQL
Hi.. Ive added a simplified schema here:
http://www.fredstie.com/mystudies/getProjectFiles.php?id=2
Run first the table_schema, then the insert_schema and the update_blob_schema.
As you might see the xray blob contains just random data (300KB) and will update each of the
10000 rows (so the size of the table should be 3GB ++). Then insert the xray index and check out if the disk size is reduced by another 3GB.
Cheers,
Oyvind
Subject
Views
Written By
Posted
2319
September 05, 2005 01:19AM
1492
September 05, 2005 01:12PM
1326
September 05, 2005 10:34PM
1467
September 05, 2005 10:38PM
1302
September 05, 2005 11:40PM
Re: Indexes in MySQL
1438
September 07, 2005 06:18AM
1574
September 07, 2005 08:10AM
1306
September 07, 2005 08:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.