<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 12pt; color: #000000'>Hello,<br><br>I have a (happily) running RT 3.6.5 with approx 300,000 tickets in it and a database of size of around 9 Gig (lots of attachments sadly). I have the application upgraded, but when I try and run the schema upgrade in my test environment it is taking forever (for values of forever which equate to around 6 days anyway):<br><br># perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 root "password > ~/sql.queries<br># time `mysql -p rt3 < ~/sql.queries`<br>Enter password: <br><br>real 8727m23.622s<br>user 0m0.012s<br>sys 0m0.004s<br><br>Does anyone have any suggestions as to how I can make this faster? I have tried to optimise MySQL as much as possible, but I am not a db expert and obviously there is something wrong. Nb. The test environment is actually more powerful than the production one after having shutdown evey VM on the machine and ensured I was only running this for the time it took.<br>-- <br>Cheers,<br>David <br><br></div></body></html>