Upgrade from MySQL 3.23.x to MySQL 4.1.x [InnoDB question]

Hi all, A little question... Can I upgrade directly a server with MySQL 3.23.x version which has some MyISAM databases (no problem with it) and some InnoDB databases towards MySQL 4.1.x? Or have I to do a dump and restore instead of re-use databases? wdyt? -- Cedric Gavage - [EMAIL PROTECTED

MyISAM

Hi all, I have a question about MyISAM, during an UPDATE for a row, is it a row locking or a table locking? -- Cedric Gavage [EMAIL PROTECTED] http://unixtech.be - http://gavage.com - OpenPGP: 0xED325C64 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

tuning problem or bug?

= thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M I receive the error message when I have more than 255 threads at the same moment (mytop report). May be the kernel to tune? (ulimit ?) -- Cedric Gavage [EMAIL PROTECTED] - Niddle http://unixtech.be - http://gavage.com - OpenPGP

Re: mysql limitations

-- Cedric Gavage [EMAIL PROTECTED] - Niddle@IRC http://unixtech.be - http://gavage.com - OpenPGP: 0xED325C64 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

SMP on Sparc/Solaris7

Hi all, Is there someone which use mysql-3.22.* or mysql-3.23.* on a UltraSparc bi cpu with Solaris7? In my case, mysqld (with all its threads ;)) is always on one cpu... the second is never used... Thanks -- Cédric Gavage [EMAIL PROTECTED] [www] http://linuxbe.org - http://bsdbe.org