>Description:
When I tried to start MySQL server with
shell>/usr/bin/safe_mysqld &
it gave me the error:
-----------------------------------------------------------------
Starting mysqld daemon with databases from /var/lib/mysql
030128 08:56:42 mysqld ended
---------------------------------------------------------
The log file "/var/lib/mysql/stvme2.log" has only following:
------------------------------------------------------------
/usr/libexec/mysqld, Version: 3.23.52-log, started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
------------------------------------------------------------
The log file "/var/log/mysqld.log" has the followings:
------------------------------------------------------
030128 08:56:42 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
030128 8:56:42 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errn
o: 13)
030128 08:56:42 mysqld ended
------------------------------------------------------------------------------
I did put the line
innodb_data_file_path = ibdata1:10M:autoextend
on the mentioned place now it gaves the same error with log:
--------------------------------------------------------------
030128 09:56:44 mysqld started
030128 9:56:44 InnoDB: Out of memory in additional memory pool.
InnoDB: InnoDB will start allocating memory from the OS.
InnoDB: You may get better performance if you configure a bigger
InnoDB: value in the MySQL my.cnf file for
InnoDB: innodb_additional_mem_pool_size.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
030128 9:56:44 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
030128 9:56:45 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
030128 9:56:45 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
030128 9:56:46 InnoDB: Started
030128 9:56:46 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
030128 09:56:46 mysqld ended
--------------------------------------------------------------------------------
It would be great if one could help me on this. Thanks in advance,
Ozlem
>How-To-Repeat:
>Fix:
<how to correct or work around the problem, if known (multiple lines)>
>Submitter-Id: Ozlem Celik
>Originator: development
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release: mysql-3.23.52 (Source distribution)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux stvme2.astro.ucla.edu 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002
i686 i686 i386 GNU/Linux
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-sh\
ared --enable-threads=posix --disable-checking --host=i386-redhat-linux
--with-system-zlib --enable-__cxa\
_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE
-D_FILE_OFFSET_BITS=64 -D_LA\
RGEFILE_SOURCE' CXX='g++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE
-D_FILE_OFFSET_BITS=64 -D_
\LIBC:
lrwxrwxrwx 1 root root 14 Jan 10 07:06 /lib/libc.so.6 ->
libc-2.2.93.so
-rwxr-xr-x 2 root root 1235468 Sep 5 16:12 /lib/libc-2.2.93.so
-rw-r--r-- 1 root root 2233342 Sep 5 15:59 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 5 15:50 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr
--bindir=/usr/bin --datadir=/usr/share --\
libdir=/usr/lib --mandir=/usr/share/man --infodir=/usr/share/info
--without-readline --without-debug --en\
able-shared --with-extra-charsets=complex --with-bench
--localstatedir=/var/lib/mysql --with-unix-socket-\
path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql
--with-extra-charsets=all --with-innodb --enable-\
local-infile --enable-large-files=yes --enable-largefile=yes --with-berkeley-db
--with-thread-safe-client\
'CFLAGS=-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64
-D_LARGEFILE_SOURCE' 'CXXFLAGS=-\
O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64
-D_LARGEFILE_SOURCE -fno-rtti -fno-excepti\
ons'
---------------------------------------------------------------------
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
