Thread:Project:Support desk/Unusually Large database: 8GB/reply (7)

Another aspect might be: After running the script, did you OPTIMIZE the text table? The script basically will change close to every record in the table and make many records smaller. This will fragment the table without end and might also make it slower than necessary. Running an OPTIMIZE query should improve performance; if the table uses InnoDB, the query will recreate the table making the actual size difference visible. It will then free fragmented space within a table to the tablespace. Note that during the execution of the query, since a copy of the table is created, you will need up to 5 GB of additional space while the query is running.