Re: 4.0 vs 4.1
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.mysql.com/doc/mysql/en/Table_maintenance.html). This happens when you illegally shutdown mysql and the like.. Even then, it doesn't always happen. Innodb can do the same thing.. I think it just does an auto check on start up for this, where myisam you do it yourself. > Once I dealing with hangs problems with MySQL + FreeBSD-4.x, I´m > afraid that the table could crashs when MySQL hangs... :-/ Sounds like a local issue, not mysql.. I would go after that over bandaging mysql. Jeff pgpRjYfpgJ4bj.pgp Description: PGP signature
Re: 4.0 vs 4.1
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 > fixes the problem. I agree with you, but my worry is in cases that IÂm not accessible. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.0 vs 4.1
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). Once I dealing with hangs problems with MySQL + FreeBSD-4.x, IÂm afraid that the table could crashs when MySQL hangs... :-/ Ronan 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 fixes the problem. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.0 vs 4.1
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. Nothing I probably couldnt iron with some variable > changes. You might want to look into that first. > > what kind of corruption issues have you had? All my syslog daemons log to > mysql, couple hundred inserts per min, and I never get these 'issues'. These > are all on myisam tables. 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). Once I dealing with hangs problems with MySQL + FreeBSD-4.x, I´m afraid that the table could crashs when MySQL hangs... :-/ Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.0 vs 4.1
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 use, has, but thats it.. I run linux on a x86. Nothing I probably couldnt iron with some variable changes. You might want to look into that first. what kind of corruption issues have you had? All my syslog daemons log to mysql, couple hundred inserts per min, and I never get these 'issues'. These are all on myisam tables. Jeff pgpruzBlF9R3z.pgp Description: PGP signature
Re: 4.0 vs 4.1
>> 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 corruption issues. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.0 vs 4.1
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
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 thread appeared in the FreeBSD list: --- > Here are the results of the brief benchmarks that I ran. I posted the > best and worse results out of running each test 5 times. > > - > System: > > Dual Opteron 244s > RAM 1GB > 3 x 36GB U320 SCSI RAID-5 on Adaptec 2120s > > - > OS: > > FreeBSD 5.3-RELEASE FreeBSD 5.3-RELEASE #2: Mon Nov 15 10:35:13 > PST 2004 i386 > > --- > MySQL 4.1.7 WITH_OPENSSL BUILD_OPTIMIZED > --- > master# super-smack update-select.smack 30 1 > Query Barrel Report for client smacker > connect: max=15ms min=4ms avg= 8ms from 30 clients > Query_type num_queries max_timemin_timeq_per_s > select_index30 3 0 4365.04 > update_index30 4 0 4365.04 > > master# super-smack update-select.smack 30 1 > Query Barrel Report for client smacker > connect: max=12ms min=0ms avg= 7ms from 30 clients > Query_type num_queries max_timemin_timeq_per_s > select_index30 3 0 4799.58 > update_index30 3 0 4799.58 > > master# super-smack select-key.smack 30 1 > Query Barrel Report for client smacker1 > connect: max=10ms min=7ms avg= 9ms from 30 clients > Query_type num_queries max_timemin_timeq_per_s > select_index60 3 0 10614.75 > > master# super-smack select-key.smack 30 1 > Query Barrel Report for client smacker1 > connect: max=10ms min=6ms avg= 7ms from 30 clients > Query_type num_queries max_timemin_timeq_per_s > select_index60 4 0 10666.14 > > --- > MySQL 4.0.22 WITH_OPENSSL BUILD_OPTIMIZED > --- > master# super-smack update-select.smack 30 1 > Query Barrel Report for client smacker > connect: max=13ms min=9ms avg= 11ms from 30 clients > Query_type num_queries max_timemin_timeq_per_s > select_index30 3 0 4839.98 > update_index30 3 0 4839.98 > > master# super-smack update-select.smack 30 1 > Query Barrel Report for client smacker > connect: max=22ms min=0ms avg= 17ms from 30 clients > Query_type num_queries max_timemin_timeq_per_s > select_index30 3 0 4963.34 > update_index30 2 0 4963.34 > > master# super-smack select-key.smack 30 1 > Query Barrel Report for client smacker1 > connect: max=19ms min=5ms avg= 9ms from 30 clients > Query_type num_queries max_timemin_timeq_per_s > select_index60 2 0 12387.57 > > master# super-smack select-key.smack 30 1 > Query Barrel Report for client smacker1 > connect: max=15ms min=0ms avg= 7ms from 30 clients > Query_type num_queries max_timemin_timeq_per_s > select_index60 2 0 13201.30 > > -- > > It seems 4.0.22 is faster in each benchmark. Around a 20% increase. I > wonder why this is? --- Once I plan to run FreeBSD-5.3 + MySQL-4.1.7 in my server, it can affect me. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.0 vs 4.1
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 do you even know that affects you? Jeff pgpeYgKL0ynpT.pgp Description: PGP signature
4.0 vs 4.1
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:http://lists.mysql.com/[EMAIL PROTECTED]