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] - OpenPGP: 0xED325C64 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[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 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tuning problem or bug?
Hi all, I have a question about a mysql server under Debian GNU/Linux. debian version: woody mysql version: 3.23.49-8.2 libc6 version: 2.2.5-11.2 kernel: 2.4.20 CPU: bi-P3-1266 (Compaq Server proliant) Memory: 2 Go I have often the error message Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug. Then I recompiled the libc6 package with these changes (debian use softs with shared libraries): in linuxthreads/internals.h: #define STACK_SIZE (2 * 128 * 1024) in linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h: #define PTHREAD_THREADS_MAX 4096 in /etc/sysctl.conf: fs/file-max=65536 in /etc/mysql/my.cnf: [safe_mysqld] err-log = /var/log/mysql/mysql.err open-files-limit = 8192 [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 basedir = /usr datadir = /var/mysql/data tmpdir = /tmp language= /usr/share/mysql/english skip-locking set-variable= key_buffer=128M set-variable= max_allowed_packet=4M set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= thread_stack=128K set-variable= max_connections=500 set-variable= max_connect_errors=100 set-variable= wait_timeout=1 # Try number of CPU's*2 for thread_concurrency set-variable= 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: 0xED325C64 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql limitations
Martin Hudec wrote: Hello, I would like to know what are limitations for mysql in number of records, size of records, size of tables etc. Can anyone help me please? You could see information about it on: http://www.mysql.com/doc/en/Features.html http://www.mysql.com/doc/en/Table_size.html -- 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/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php