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 - > http://dev.mys

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 alw

Re: 4.0 vs 4.1

2004-12-07 Thread Greg Whalin
Ronan Lucio wrote: Jeff, 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 - http://dev.mysql.com/doc/mysql/en/Table_maintenance.html)

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

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
>> 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 corr

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: > > 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
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 fol

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.

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:h