[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]
