George Mihalcea writes:
> 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.
Hi!
Seems like the error log file was stripped out, so we did not see it.
Did you have 1700 databases or 1700 tables. If that number is number
of databases , how many tables do you have ??
Can you repeat it all, with one variable values changed. Notably the
following one:
innodb_data_file_path =
ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
