Well, it will NOT let me add more ibdata files: Any ideas?? Thanks, Spiros
Here is hostname.err (On a 2GB RAM, 2x1000 CPU, ) InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 3 751045500 020418 0:50:33 InnoDB: Started /usr/sbin/mysqld: ready for connections InnoDB: Assertion failure in thread 40971 in file trx0trx.c line 228 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402649088 record_buffer=2093056 sort_buffer=2097144 max_used_connections=1 max_connections=10 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer) *max_connections = 434131 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x807db7f 0x823d60a 0x8179eac 0x80d50b7 0x80cd82d 0x807798d 0x807d88a 0x8082515 0x824f1b8 0x823d383 0x823ab69 0x807d905 0x8084403 0x823baa7 0x826c1ca New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at (nil) is invalid pointer thd->thread_id=2916 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 2916 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 020418 14:01:56 mysqld restarted InnoDB: Warning: operating system error number 2 in a file operation. InnoDB: Cannot continue operation. # Example mysql config file for very large systems. # # This is for large system with memory of 1G-2G where the system runs mainly # MySQL. # # You can copy this file to # /etc/mf.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer=384M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = max_connections=10 set-variable = tmp_table_size=400M set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = thread_cache=8 set-variable = thread_concurrency=4 # Try number of CPU's*2 #set-variable = myisam_sort_buffer_size=64M set-variable = myisam_sort_buffer_size=4M innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdata 3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata 7:2000M;ibdata8:2000M;/usr/ibdata/ibdata9:2000M;/usr/ibd ata/ibdata10:2000M #Comment works ok with: #innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdat a3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdat a7:2000M;ibdata8:2000M # Also adding ibdata9:2000M to /var/lib/mysql does not work log-bin server-id = 1 #set-variable = open-files-limit=8192 #ulimit is 1024,hard 8192 set-variable = innodb_buffer_pool_size=750M set-variable = innodb_additional_mem_pool_size=400M # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=384M #set-variable = bdb_max_lock=100000 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname [mysqldump] quick set-variable = max_allowed_packet=256M [mysql] no-auto-rehash #safe-updates # Remove the comment character if you are not familiar with SQL [isamchk] set-variable = key_buffer=256M set-variable = sort_buffer=256M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] #set-variable = key_buffer=256M #set-variable = sort_buffer=256M #set-variable = read_buffer=2M #set-variable = write_buffer=2M set-variable = key_buffer=25M set-variable = sort_buffer=25M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout ------------------------df -h Filesystem Size Used Avail Use% Mounted on /dev/sda5 10G 758M 9.4G 8% / /dev/sda1 45M 3.8M 39M 9% /boot /dev/vg0home/vg0home 17G 16G 1.4G 92% /home /dev/sda6 12G 1.6G 10G 13% /usr /dev/sda7 6.9G 104M 6.7G 2% /var /dev/vg0mysql/vg0mysql 34G 19G 15G 54% /var/lib/mysql shmfs 1007M 0 1006M 0% /dev/shm Παράθεση Luciano Barcaro <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: > > >Thanks, > > > >still a few points: > >1) I have ibdata1-ibdata8, all at 2GB > >mysql will not let me add ibdata9, even though the > > partition still has space(/var/lib/mysql) and indeed > >is only half-full. Can I add these at some other > >directory? > > > > > First, did you read your hostname.err located at your DATADIR for the > cause of > the mysql not create your ibdata9 ? > > Second, yes. You can create your extend files at any place you want. For > example: > (in your my.cnf) > > innodb_data_home_dir=/ > innodb_data_file_path=mysqldata/ibdata001:150M;mydata/ib data002:100M > > it will create the files: > /mysqldata/ibdata001 and > /mydata/ibdata002 > > --------------------------------------------------------------------- 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
