List:General Discussion« Previous MessageNext Message »
From:Prasanna Raj Date:April 5 2006 6:29am
Subject:Re: InnoDB how to.
View as plain text  
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
> >
> 
Thread
InnoDB how to.Truong Tan Son4 Apr
  • Re: InnoDB how to.sheeri kritzer4 Apr
  • Re: InnoDB how to.Truong Tan Son5 Apr
    • Re: InnoDB how to.Prasanna Raj5 Apr
  • Re: InnoDB how to.Truong Tan Son5 Apr
    • Re: InnoDB how to.Prasanna Raj5 Apr
  • (WORKED) Re: InnoDB how to.Truong Tan Son5 Apr