Hi! I just installed mysql 3.23.38b max to my Suse Linux 6.2. Everything worked fine until I wanted row locking. I created innodb table and tried the instructions from manual and curiosly, those did not work - transactions committed automatically regardless what I did. Then I looked the manual up for more and found out it said - set the innodb options. I did. I set these on the root directory of mysql (/usr/local/mysql) .my.cnf. # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:25M;ibdata2:25M;ibdata3:25M;ibdata4:25M innodb_data_home_dir = /usr/local/mysql/var/ innodb_log_group_home_dir = /usr/local/mysql/var/ innodb_log_arch_dir = /usr/local/mysql/var/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 ... After this the system segmentation faults: > mysql@bonn:~ > ./support-files/mysql.server ./support-files/mysql.server: @HOSTNAME@: command not found usage: ./support-files/mysql.server start|stop mysql@bonn:~ > ./support-files/mysql.server start ./support-files/mysql.server: @HOSTNAME@: command not found mysql@bonn:~ > Starting mysqld daemon with databases from /usr/local/mysql/data ./bin/safe_mysqld: line 274: 15129 Segmentation fault $NOHUP_NICENESS $ledi r/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTIO N --pid-file=$pid_file --skip-locking >>$err_log 2>&1 010605 11:24:54 mysqld ended > And even if I recomment the innodb's it still crashes : mysql@bonn:~ > ./support-files/mysql.server start ./support-files/mysql.server: @HOSTNAME@: command not found mysql@bonn:~ > Starting mysqld daemon with databases from /usr/local/mysql/data ./bin/safe_mysqld: line 274: 15163 Segmentation fault $NOHUP_NICENESS $ledi r/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTIO N --pid-file=$pid_file --skip-locking >>$err_log 2>&1 010605 11:26:11 mysqld ended > Any clue, anyone ? ___________________________________________________________________ To get your own FREE ZDNet Onebox - FREE voicemail, email, and fax, all in one place - sign up today at http://www.zdnetonebox.com --------------------------------------------------------------------- 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
