4.0 vs 4.1

2004-12-07 Thread Ronan Lucio
Hi, Has anyone any benchmark between 4.0 and 4.1? MySQL website says that version 4.0 has some performance improvements but I´ve heard that MySQL-4.0 is 20% faster than MySQL-4.1. Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: 4.0 vs 4.1

2004-12-07 Thread Jeff Smelser
On Tuesday 07 December 2004 06:41 am, Ronan Lucio wrote: Hi, Has anyone any benchmark between 4.0 and 4.1? MySQL website says that version 4.0 has some performance improvements but I´ve heard that MySQL-4.0 is 20% faster than MySQL-4.1. As far as what? Thats a very general statement. How

Re: 4.0 vs 4.1

2004-12-07 Thread Ronan Lucio
Jeff, Has anyone any benchmark between 4.0 and 4.1? MySQL website says that version 4.0 has some performance improvements but I´ve heard that MySQL-4.0 is 20% faster than MySQL-4.1. As far as what? Thats a very general statement. How do you even know that affects you? The following

Re: 4.0 vs 4.1

2004-12-07 Thread Jeff Smelser
On Tuesday 07 December 2004 12:58 pm, Ronan Lucio wrote: The following thread appeared in the FreeBSD list: snip Once I plan to run FreeBSD-5.3 + MySQL-4.1.7 in my server, it can affect me. I may have missed it, but myisam, or innodb? Jeff pgpSqggIBC6My.pgp Description: PGP signature

Re: 4.0 vs 4.1

2004-12-07 Thread Ronan Lucio
Once I plan to run FreeBSD-5.3 + MySQL-4.1.7 in my server, it can affect me. I may have missed it, but myisam, or innodb? Both, because I have tables that have few inserts and too few updates/deletes, like states, cities and so on, but I plan transform every table in InnoDB to avoid

Re: 4.0 vs 4.1

2004-12-07 Thread Jeff Smelser
On Tuesday 07 December 2004 01:22 pm, Ronan Lucio wrote: Both, because I have tables that have few inserts and too few updates/deletes, like states, cities and so on, but I plan transform every table in InnoDB to avoid corruption issues. Nothing here has slowed down. A few innodb stuff I

Re: 4.0 vs 4.1

2004-12-07 Thread Ronan Lucio
Jeff, Both, because I have tables that have few inserts and too few updates/deletes, like states, cities and so on, but I plan transform every table in InnoDB to avoid corruption issues. Nothing here has slowed down. A few innodb stuff I use, has, but thats it.. I run linux on a x86.

Re: 4.0 vs 4.1

2004-12-07 Thread Greg Whalin
Ronan Lucio wrote: Jeff, Actually, Ive never had such problem. Im just afraid of it because Ive read some issues about corruption in MySQL tables and the own MySQL Manual says that exist a command just to repair MyISAM tables (myisamchk - http://dev.mysql.com/doc/mysql/en/Table_maintenance.html).

Re: 4.0 vs 4.1

2004-12-07 Thread Ronan Lucio
Greg, Never had table corruption, though I have had index corruption in myisam tables many times on sound hardware. Usually, this is due to an unclean shutdown, though I have seen it happen other times when the server is supposedly running with no problems. A repair table tablename always

Re: 4.0 vs 4.1

2004-12-07 Thread Jeff Smelser
On Tuesday 07 December 2004 01:56 pm, Ronan Lucio wrote: Actually, I´ve never had such problem. I´m just afraid of it because I´ve read some issues about corruption in MySQL tables and the own MySQL Manual says that exist a command just to repair MyISAM tables (myisamchk -