| Author |
 Topic  |
|
|
pring
Starting Member
USA
9 Posts |
 Posted - 26 July 2009 : 07:53:55
|
I've been trying to migrate a very large Snitz forum (229MB) from Access to MySQL with little progress.
I have allowed access to the MS system tables of the Access database, and I migrated into MySQL 5.1.36. I then set the proper connect type and driver type in the config.asp. (I had to modify the MySQL driver name to say 5.1 instead of 3.5).
The forum comes up, and the topics and data show up, but the performance is extremely slow and the disk usage is pegged to the wall. Searches don't finish and if I click a username to pull up a profile, it just sits there hitting the hard disks. It seems that MySQL is choking.
When running on the Access database, the performance was much better and that was on a very old P3 server under Windows 2000 server.
The new server has a fresh load of Windows 2003 Web Edition. I do have MS SQL 2005 express installed (but disabled), but there was no migration path for that unless the full MS SQL is available (I have that on another box...but that's a different migration problem). The server is running in VMWare ESXi with the vast majority of resources assigned from dual 3GHz Xeons and 4GB RAM (the hard disks are on a U320 RAID controller).
Can anybody give me some pointers or know of a post (or website) that might have an answer? (especially since I keep getting timeout errors on the search of this forum)
Thanks in advance,
Patrick Ring |
Edited by - pring on 26 July 2009 07:54:22 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 26 July 2009 : 09:53:49
|
| it is actually pretty easy to migrate access to sql express, microsoft provide a free tool to do it. as for your mysql issue, it probably needs indexes creating at a guess |
 |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
pring
Starting Member
USA
9 Posts |
Posted - 29 July 2009 : 10:31:51
|
quote:
Originally posted by modifichicci
Yes the problems are indexes and default value in fields.
You need to let the forum to create tables in db, then import in it the values from access db.
You can give a look at the migration tutorial in my sig, just to have an idea.
I ended up having to adjust the create_mysqlforum.asp by removing the "default" from alot of the table creations. However, even after importing, the performance left alot to be desired. The disk usage was off the charts..almost like MySQL was just spinning out of control.
I did try setting up a dummy forum in MySQL, and that seemed to work fine (of course it was only a few categories and a couple of BS type posts). The problems I encountered were in the imported forum.
Anyway, I ended up finding a tools for both MySQL conversion and MS SQL 2005 Express conversion (by a company called BullZIP). The MySQL was still having the same problems, so I disabled the MySQL engine and re-enabled my MS SQL 2005 engine, and imported to there.
Performance there is incredibly fast, but I'm now having the same search timeout issue this forum (Snitz website) was having over the weekend. (seems fixed now) ...but that's a discussion for the MS SQL category.
I will definitely check out the tutorial in your sig.
Thanks,
-P. Ring |
|
|
|
oldtimer
Starting Member
USA
6 Posts |
Posted - 20 August 2009 : 10:43:22
|
| What kind of search timeout issue were you experiancing? I am thinking of starting a forum and I am trying to have a clue as to where I should be headed. The tool at Bullzip looks like a no-brainer. |
|
|
| |
Topic |
|
Topic Locked
