At 05:00 PM 8/7/2006, you wrote:
Mike, if this data is at all important to you, I'd highly recommend
doing your testing on copies of your data files, rather than your
originals.
If it's not important, then I'd go ahead and try it. The MyISAM
storage engine is pretty mature and stable. For safety's sake once
you get it back to 4.1 I'd suggest running CHECK TABLE tablename
EXTENDED on each to ensure integrity.
I've always had success going forward with releases, but haven't ever
tried going back that I recall.
Dan
That's what I ended up doing, at least for one table. All of the data for
the other tables can be regenerated so if I do lose it, it's not the end of
the world.
Have you noticed any speed improvements in MySQL 5.0? The only reason I'd
want to upgrade is to improve the join or sort speeds, or rebuilding the
index speeds. I'm trying MySQL 5.0 out on a Win2003 server box with 4gb of
RAM. I'm still tweaking the mysql settings and I haven't noticed a
difference yet.
Mike
On 8/7/06, mos <[EMAIL PROTECTED]> wrote:
I'm planning on installing MySQL 5.0 today and will try rebuilding some of
the indexes for one of my tables to conduct some benchmarks. I will
probably reboot back to MySQL 4.10 and continue using the database. Have
the table formats changed from 4.10 to 5.0? Or can I create/modify tables
in 5.0 and then use the same tables in 4.0?
Are there any speed improvements in 5.0 compared to 4.1?
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
