| View previous topic :: View next topic |
| Author |
Message |
BZB
Expert
Joined: 26 Apr 2005
Posts: 1390
|
|
| Back to top |
|
 |
administrator
Developer
Joined: 24 Jul 2004
Posts: 4752
Location: King William, VA
|
 Posted: Thu Dec 16, 2010 12:44 am Post subject: |
 |
|
No idea if NMP works with it or not, but I don't see anything in the changelog that would obviously break it. However, the upgrade process looks like there are some required steps that you'll need to do that I can't remember having to do in past upgrades. It might be simpler to do a dump, reinstall, then reload.
I also don't see any specific improvements that would impact MyISAM, so if that's what you're using, I don't see any need to upgrade. I think the last MySQL version I actually tested was 5.1.37. I'm running that on one computer and 5.0.45 on another.
Regards |
|
| Back to top |
|
|
John Elliott
Experienced
Joined: 10 May 2005
Posts: 121
|
| Posted: Thu Dec 16, 2010 11:36 am Post subject: |
|
|
Which do you think is the fastest of those 2 older versions you're using?
The parallelism stressed in the new version 5.5 interested me, since I have a 4 core machine. It did seem to say that the biggest impact was for InnoDB rather than MyISAM though.
On an earlier beta version you said that InnoDB was being supported experimentally. Is it supported now?
The new 5.5 version said that where InnoDB didn't do what MyISAM did, that MyISAM tables would be used instead. Think this hybridization would be a problem?
You mentioned that PowerPurge didn't work with InnoDB. How would table size be kept under control?
Part of the new documentation praising InnoDB's strengths stated that it could truncate tables. There were a lot of references to the newer version requiring less maintenance, and being more robust, as well as faster if InnoDB was used.
It said the My.ini file commands change somewhat. Does InnoDB use change your command syntax in any way? |
|
| Back to top |
|
|
administrator
Developer
Joined: 24 Jul 2004
Posts: 4752
Location: King William, VA
|
| Posted: Thu Dec 16, 2010 1:02 pm Post subject: |
|
|
| John Elliott wrote: | | Which do you think is the fastest of those 2 older versions you're using? |
I don't see much, if any, difference between them with MyISAM. I don't use InnoDB, so I can't tell you that.
| John Elliott wrote: | | On an earlier beta version you said that InnoDB was being supported experimentally. Is it supported now? |
It's still at the same stage. I had one request for InnoDB support so I added code to allow NMP to work with InnoDB, but I never got any further feedback. I've back-burnered that project. InnoDB is a lot more like SQL Server then MyISAM.
| John Elliott wrote: | | The new 5.5 version said that where InnoDB didn't do what MyISAM did, that MyISAM tables would be used instead. Think this hybridization would be a problem? |
No idea.
| John Elliott wrote: | | You mentioned that PowerPurge didn't work with InnoDB. How would table size be kept under control? |
For now, you would have to do a background purge, then maintain the database using MySQL Administrator. This could be changed to allow the Powerpurge delete routines to function like they do for SQL Server, but maintenance would likely move outside of NMP.
| John Elliott wrote: | | Part of the new documentation praising InnoDB's strengths stated that it could truncate tables. There were a lot of references to the newer version requiring less maintenance, and being more robust, as well as faster if InnoDB was used. |
I think that's a tacit admission of just how slow InnoDB has been. For business use, InnoDB makes sense. For a newsreader where data is regularly added and dumped, I'm not so sure that it does.
| John Elliott wrote: | | It said the My.ini file commands change somewhat. Does InnoDB use change your command syntax in any way? |
NMP Still checks for certain MyISAM settings even if you try to use InnoDB. There are a lot of changes that would have to be made to NMP to fully support InnoDB and I'm not certain that it will happen.
Regards |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
