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" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] > > > > www.sify.com - your homepage on the internet for news, sports, finance, > > astrology, movies, entertainment, food, languages etc > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
