Hi
Can you through us more lights on error ? where does this occur ?
-bash-2.05b$ perror 10 30
OS error code 10: No child processes
OS error code 30: Read-only file system
-bash-2.05b$
-Praj
On Wed, 5 Apr 2006 08:48:08 +0700
"Truong Tan Son" <sontt@stripped> wrote:
> [S] Dhandapani wrote:
>
>
> > mysql> show global variables like '%innodb%';
> > +---------------------------------+------------------------+
> > | Variable_name | Value |
> > +---------------------------------+------------------------+
> > | have_innodb | YES
>
>
> OK, all thing is let default setting.
>
>
> > mysql> *|SET AUTOCOMMIT=0;|*
> > Query OK, 0 rows affected (0.00 sec)
> >
> > mysql> *|INSERT INTO CUSTOMER VALUES (15, 'John');|*
> > Query OK, 1 row affected (0.00 sec)
>
>
> ERROR 1030 (HY000): Got error -1 from storage engine
>
>
> What is error ?
>
> I follow Document:
> http://dev.mysql.com/doc/refman/5.0/en/innodb-transactions-with-different-apis.html
>
> The error is same.
>
>
> Please teach me.
>
>
> Best regards,
>
> --
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> > mysql> *|ROLLBACK;|*
> > Query OK, 0 rows affected (0.00 sec)
> >
> > mysql> *|SELECT * FROM CUSTOMER;|*
> >
> > +------+--------+
> >
> > | A | B |
> > +------+--------+
> > | | |
> > +------+--------+
> >
> > the inset stattement has been rollbacked.
> >
> > Reference
> >
> http://dev.mysql.com/doc/refman/5.0/en/innodb-transactions-with-different-apis.html
> >
> > Regards,
> > Dhandapani
> > Dba Sify Limited.
> >
> >
> > Truong Tan Son wrote:
> >
> >> Dear Sir,
> >>
> >> I install MySQL 5.0.18 on RH EL4, but do not know how to use InnoDB
> >> for "ROLLBACK".
> >>
> >> ./configure --prefix=/usr/local/mysql \
> >> --exec-prefix=/usr/local/mysql \
> >> --with-innodb
> >> make && make install
> >>
> >> **/etc/my.cnf:
> >> # Uncomment the following if you are using InnoDB tables
> >> innodb_data_home_dir = /usr/local/mysql/var/
> >> innodb_data_file_path = ibdata1:10M:autoextend
> >> innodb_log_group_home_dir = /usr/local/mysql/var/
> >> innodb_log_arch_dir = /usr/local/mysql/var/
> >> # You can set .._buffer_pool_size up to 50 - 80 %
> >> # of RAM but beware of setting memory usage too high
> >> innodb_buffer_pool_size = 16M
> >> innodb_additional_mem_pool_size = 2M
> >> # Set .._log_file_size to 25 % of buffer pool size
> >> innodb_log_file_size = 5M
> >> innodb_log_buffer_size = 8M
> >> innodb_flush_log_at_trx_commit = 1
> >> innodb_lock_wait_timeout = 50
> >>
> >> with setting above, I could not use InnoDB.
> >>
> >>
> >> How to know InnoDB is installed, and start it ?
> >>
> >>
> >> Thanks you and best regards,
> >> --
> >>
> >
> > ********** DISCLAIMER **********
> > Information contained and transmitted by this E-MAIL is proprietary to
> > Sify Limited and is intended for use only by the individual or entity to
> > which it is addressed, and may contain information that is privileged,
> > confidential or exempt from disclosure under applicable law. If this is a
> > forwarded message, the content of this E-MAIL may not have been sent with
> > the authority of the Company. If you are not the intended recipient, an
> > agent of the intended recipient or a person responsible for delivering the
> > information to the named recipient, you are notified that any use,
> > distribution, transmission, printing, copying or dissemination of this
> > information in any way or in any manner is strictly prohibited. If you have
> > received this communication in error, please delete this mail & notify us
> > immediately at admin@stripped
> >
> > www.sify.com - your homepage on the internet for news, sports, finance,
> > astrology, movies, entertainment, food, languages etc
> >
>
