Hello!
I compiled mysql 3.23.38 with support for innodb tables.
The server is a dual PIII 850, with 1 GB RAM, 1 SCSI disk.
OS is Slackware current . Kernel version is 2.4.4 , no patches.
I created 4 tablespaces of 1000M each.
I took a dump from another mysql server (with myisam tables), I changed type
to innodb in dump files and I tried to create the databases and tables in this
new server.
The dump has 2GB.
First, I tried with the big dump file, then with one file for each database
(about 2000 databases with the same structure).
When I tried with the big file, the mysql database crashed after about half of
the file, he tryed to restart, crashed again, he tried to restart an so on...
I had to delete all directories and files and restart with the default mysql
and test databases.
The seconf time, every database had its own dump. Mysql crashed after 1700
databases.
If I try to continue with the other databases remaining, it crashes again.
I attached the log mysql error log file and my.cnf config file.
What should I do? Is any of the parameters in my.cnf wrong ?
Should I stay to MyISAM tables ?
Thanks,
George Mihalcea.
log.err.gz
# Example mysql config file for large systems.
#
# This is for large system with memory = 512M 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=256M
set-variable = max_allowed_packet=1M
set-variable = table_cache=1
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=4
set-variable = max_connections=400
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=4
log-bin
server-id = 1
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=64M
#set-variable = bdb_max_lock=100000
# Uncomment the following if you are using Innobase tables
innodb_data_home_dir = /var/lib/mysql/
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:1000M;ibdata2:1000M;ibdata3:1000M;ibdata4:1000M
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=50M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=1
set-variable = innodb_buffer_pool_size=400M
set-variable = innodb_additional_mem_pool_size=50M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
# Point the following paths to different dedicated disks
tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
---------------------------------------------------------------------
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
