Re: C API problems with InnoDB

. regards, Heri Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query

Re: InnoDB: a detailed bug report

Willie, what MySQL version you are running? On what OS? What does SHOW CREATE TABLE tabdocumentoconsultado; print? Have you used an InnoDB version = 3.23.43 and stored characters with code 127 in the table? E.g., accent characters? The ordering of such characters in the latin1 charset

Re: Bug Report: Replication in 4.0.5beta

would always repeat the replication failure? What is the CREATE TABLE statement of your table? What is your my.cnf like? Regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 28, 2002 1:27 PM

Re: Bug Report: Replication in 4.0.5beta

at log 'binlog. 026' position 27 I am forwarding these to the replication developer of MySQL AB. I hope he can fix these to 4.0.6. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from

Re: InnoDB shared lock with JOINs

it with 2 connections. -- Have a nice day. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query

Re: Record Lock?

MySQL ends a connection, it rolls back the current transaction. Thus, locks are never kept after the connection ended. ... HTH, Benjamin. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual

Re: Innodb row locking question

statement you can also use the LIMIT clause. 3. In an UPDATE or DELETE, InnoDB automatically sets exclusive locks on the index records it encounters in the search for the rows to be updated or deleted. Mike... Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support

Re: Question about SLAVE STOP

forwarding this to the replication developer of MySQL AB. He has to check the mechanisms. Bye, Benjamin. -- [EMAIL PROTECTED] Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http

Re: Question about SLAVE STOP

be used at all when you have transactions bigger than a single SQL statement running. I am forwarding this to the replication developer of MySQL AB. He must fix SLAVE STOP. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http

Re: Reading logs

you have added the line log-bin to the [mysqld] section of your my.cnf or my.ini, so that mysqld knows to produce these binlog files. The files you listed above are InnoDB files, not binlog files. Thanks. Amittai Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level

Re: May someone try this script under Mandrake 9 and Mysql 4.0.5

gives an error 150 from it. Thanks in advance, Adolfo Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query

Re: Record Lock?

Benjamin, - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 09, 2002 9:58 AM Subject: Re: Record Lock? Hi. On Sun 2002-12-08 at 14:50:35 +0200, [EMAIL PROTECTED] wrote: [...] SELECT

Re: InnoDB crash?

, and the data pages were not in reality flushed to disk. Do you use RAID, NFS, or anything exotic? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query - Original

Re: Question about SLAVE STOP

Carl, - Original Message - From: Carl McNamee [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, December 10, 2002 6:36 AM Subject: RE: Question about SLAVE STOP I know that the slave will honor transactions but how does that effect the STOP SLAVE command? Based on

Re: InnoDB crash?

Ervin, - Original Message - From: Ervin Gerke [EMAIL PROTECTED] To: 'Heikki Tuuri' [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 8:53 PM Subject: RE: InnoDB crash? Heikki, That's all mysqld reported in err log. In fact I wasn't able to do a check table since mysqld died

Re: safe_mysqld will not start correctly

] section of your my.cnf and start mysqld. Then dump your tables, recreate the whole InnoDB tablespace, and import the tables again. Please upgrade to MySQL-Max-3.23.53a because it is the stablest version so far. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https

MySQL/InnoDB-3.23.54 is released

. * An outstanding bug: in replication issuing SLAVE STOP in the middle of a multi-statement transaction can cause that SLAVE START will only perform part of the transaction. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com - Before

Re: Group by problem

, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query - Before posting, please check: http

Re: [MySQL] InnoDB Lock status

to determine if a row is locked or not. Thanks in advance, Patricio. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query

Re: MySQL crashes with foreign key restraints

Stefan, please upgrade to 4.0.5 and test again. 4.0.1 is a very old alpha release, and lots of bugs have been fixed since. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news

Re: The InnoDB on raw devices...

Dyego, from the documentation of CreateFile in old Visual C++ docs I found the following description how to specify in Windows the name of a disk drive or a partition on a disk drive. The name you used below looks more a Linux way to specify a disk partition. Best regards, Heikki Tuuri Innobase

Re: VERY URGENT, possible bug. More on: What does this error message mean: InnoDB: Warning: difficult to find free blocks from the buffer pool..

in 3.23.45. ... I have also a faint recollection that I then also fixed some additional error in the buffer pool flush algorithm which could cause the error messages to be printed in normal operation, not just recovery. Regards, Heikki Tuuri Innobase Oy - Original Message - From: JW

InnoDB-3.23.50 source prerelease downloadable from www.innodb.com

in this prerelease because that requires a small change also in the MySQL part of code. Best regards, Heikki Tuuri Innobase Oy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: InnoDB

the 'Table is full' errors. But when you give it more disk space, auto-extension continues. I have not tested what happens on those file systems where max file size is 2 GB. If you run on such a file system, best to specify ibdata1:10M:autoextend:max:2000M Best regards, Heikki Tuuri Innobase Oy

Re: mySQL and innoDB

, but then let a user to slip it through using a NULL value. But, since we may declare a column as NOT NULL, we can still force full referential integrity in 3.23.50. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http

Re: InnoDB

in innodb_data_file_path. After that you can add another data file: innodb_data_file_path = /ibdata/ibdata1:988M;/disk2/ibdata2:50M:autoextend Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual

Re: InnoDB

Rodrigo, - Original Message - From: Rodrigo Gonzalez [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: MySQL List [EMAIL PROTECTED] Sent: Friday, April 12, 2002 10:27 PM Subject: Re: InnoDB You are right, I didnot see this section so well BTW: I am really interested

Re: How does DISTINCT really work ?

in the MySQL support ftp server. I do not remember the directory exactly, but you have reported so many bugs in MySQL that maybe you remember :). Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual

Re: How does DISTINCT really work ?

Hi! - Original Message - From: SDiZ (UHome) [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 15, 2002 7:51 AM Subject: Re: How does DISTINCT really work ? I think every thing are documented. http://www.mysql.com/doc/B/u/Bugs.html

Re: How does DISTINCT really work ?

Hi! Ok, Monty said that this DISTINCT ... ORDER BY bug has already been fixed in 4.0. Regards, Heikki Innobase Oy - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: SDiZ (UHome) [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED

Re: MySQL and stored procedures - v4.1 :(

Hi! I can disclose that there is actually some progress being made in stored procedures + triggers. Regards, Heikki Innobase Oy - Original Message - From: Jon Frisby [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, April 16, 2002 2:12 AM Subject: RE: MySQL and

Re: can't init my database for innoDB in mysql

Hi! Autoextend is only supported by versions = 3.23.50. I heard a rumor that a binary of .50 could be out in 2 days. At http://www.innodb.com you can download a source prelease of .50. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com

Re: transaction with MySQL

Andrew, MySQL-Max-3.23 also supports transactions, and that is a stable release. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original

Re: foreign key on update cascade in mysql doesn't work

key is updated. Thus I chose to write ON DELETE CASCADE first. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: bin cai

Re: Foreign keys

Hi! use mysqlSHOW TABLE STATUS FROM yourdatabasename LIKE 'yourtablename'; Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message

Re: can't init my database for innoDB in mysql

;ibdata 7:2000M;ibdata8:2000M;/usr/ibdata/ibdata9:2000M;/usr/ibd ata/ibdata10:2000M You should set in my.cnf innodb_data_home_dir= and then specify the absolute file paths to each of your data files. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https

Re: InnoDB Error 150, MySQL 4.0.1 alpha 3.23.49

) Exception in thread main Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Before posting

Re: InnoDB transactions with Connection Pooling

snapshot of the database in each consistent read. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: Mark Hazen [EMAIL

Re: InnoDB transactions with Connection Pooling

Jeremy, - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:37 AM Subject: Re: InnoDB transactions with Connection Pooling On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri wrote

Re: InnoDB, BDB

manual section is a guide to creating an InnoDB database. If you have already installed mysqld... as a service, stop the service from the Control Panel of Windows. Start mysqld-max.exe from an MS-DOS prompt as instructed below. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL

Re: InnoDB data files created but not used...how to fix ?

parameter, section 2 of http://www.innodb.com/ibman.html is your best help. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message - From: [EMAIL

Prerelease of MySQL/InnoDB-3.23.50

'foreign' followed by a non-space character confused the FOREIGN KEY parser and caused table creation to fail with errno 150. Best regards, Heikki Tuuri Innobase Oy [EMAIL PROTECTED] http://www.innodb.com - Before posting

Re: Prerelease of MySQL/InnoDB-3.23.50

Andrew, unfortunately it usually takes 7 days for the Windows binary to appear. Regards, Heikki - Original Message - From: Andrew Chan [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 8:43 PM Subject: Re: Prerelease of MySQL/InnoDB

Re: Circular replication

, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Before posting, please check: http

Re: InnoDB's inner workings + checkpoints

about year 1992, is the best reference. Much of InnoDB has been written according to the instructions in that book. Can you please correct the above if it is wrong. Thanks in advance, Balteo. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key

Re: Innodb's inner workings and checkpoints

. Thanks in advance, Balteo. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Before posting

Re: Innodb's inner workings and checkpoints

Hi! - Original Message - From: Balteo [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Sent: Wednesday, May 01, 2002 8:02 AM Subject: Re: Innodb's inner workings and checkpoints Heikki, Thanks for your prompt reply. If I understand: 1. In order for data to make

Re: memcpy segfaults from store_record_in_cache under load on p4, 3.23.41 and .49

Jay, please send me the error log, the queries, and the table definitions. What is your my.cnf like? Are your sure memory consumption does not approach 2 GB? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com

Re: 3.23.50???

see http://www.innodb.com/ibman.html#InnoDB_history. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: [EMAIL PROTECTED

Re: innodb tables problem

innodb_flush_log_at_trx_commit=0 when you tried to use the script to pipe inserts to MySQL? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message

Re: innodb tables problem

as recommended in section 2 of http://www.innodb.com/ibman.html. Regards, Heikki - Original Message - From: Oren Zeev-Ben-Mordehai [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 5:26 PM Subject: RE: innodb tables problem my.cnf -- [mysqld

Re: InnoDB Foreign Key Constraints

| +---+--- + 1 row in set (0.00 sec) mysql Thanks, DAN Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL

Re: [bug] Multiple daily crashes of mysql/innodb

. Then send the error log 'hostname'.err for me to examine. The Linux binary of 3.23.51 was built today. You may also want to wait for that to be released. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com

Re: foreign key constraint to itself

, then you will get an assertion failure in row0ins.c line 511. Fixed in 3.23.51. Thanks, Lisa Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

Re: Is InnoDB 64bit clean?

, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: Ralph Mengen [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, May 14, 2002

Re: Assertion failure with mysql-3.23.49a/InnoDB

Michael, the assertion below looks like table corruption. Please check with CHECK TABLE your tables. If some is corrupt, dump, drop, and reimport it. The symbols file was forgotten from .49a and we cannot resolve the stack trace. You might want to try .50 in which the symbols file exists. I

Re: Max vs. InnoDB?

Vaclav, MySQL-Max and MySQL/InnoDB as referred to at www.innodb.com are the same product. Innobase Oy does not distribute or sell directly MySQL-Max. All distribution and sales are done through MySQL AB. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking

Re: MySQL/InnoDB questions from a MyISAM background

, stored in a fireproof safe. My thanks in advance. -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] Best regards, Heikki Tuuri

Re: MyISAM - Innodb

, because InnoDB does not store the row count internally. - Mark Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB

Re: 4.0.1 Bugs

a rather old release and several bugs have been fixed since then. Unfortunately, 3.23 does not support unions. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB

Re: 4.0.1 Bugs

later. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message - From: Richard Clarke [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Sent

Re: 4.0.1 Bugs

later. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message - From: Richard Clarke [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Sent

Re: 4.0.1 Bugs

database load. Lenz of MySQL AB is working hard to get good Linux builds of 3.23.51 and 4.0.2 done. Let us hope we finally get the new releases soon. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online

Re: InnoDB, possible bug?

Andrei, how many rows in ne satisfy (1) ne.playerid=28575, (2) ne.type=2? What version you are using? .48 was tuned to favor index searches over table scans. What does EXPLAIN SELECT say if you force the index usage with USE INDEX and STRAIGHT JOIN clauses? Best regards, Heikki Tuuri

Re: InnoDB, possible bug?

, the fact that MySQL refuses to use the index specified in the USE INDEX clause may be a bug. I have forwarded this email to MySQL developers. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual

Re: MySQL InnoDB startup problem

is now corrupt. Please use the instructions of section 6.1 in http://www.innodb.com/ibman.html to force recovery. Then dump + drop + reimport. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual

Re: MySQL InnoDB startup problem

David, if the corruption happens again, please run CHECK TABLE and report what you get to 'hostname'.err. 3.23.52 will also contain diagnostic code which will help to track the problem. Best regards, Heikki - Original Message - From: David Piasecki [EMAIL PROTECTED] To: 'Heikki Tuuri

Re: case-sensitivity broken in FK clause for MySQL+InnoDB

Hi! The fact that foreign key definitions do not honor lower_case_table_names=1 is mentioned in the manual. I have added the fix to this on the TODO list for July 2002. You have found the right place, this mailing list is the right place to report bugs in InnoDB. Best regards, Heikki Tuuri

Re: 4.0.1 Bugs

, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message - From: Richard Clarke [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Sent: Sunday, May 19

Re: Ibdata1 file thats just too big...

are contained in the ibdata files. You should first convert your InnoDB tables to MyISAM with ALTER TABLE tablename TYPE=MyISAM Then you can delete and resize the ibdata files. Then convert back. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support

Re: InnoDB crash on 3.23.49a...

means the magic number of a trx struct was wrong. A resolved stack trace might help a lot if this is not random memory corruption. Regards, Heikki - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Heikki Tuuri [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 9

Re: InnoDB crash on 3.23.49a...

Jeremy, I do not know. I am not an expert on the hostname_r memory overrun bug :). Also, I guess the crash you get does not come from it. Regards, Heikki - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday

Re: MySQL-Max and Innodb

Hi! Please go through the checklist in section 3.1 in http://www.innodb.com/ibman.html. I have a faint recollection that Linux in some of these cases gives a very obscure error number 22 which in Linux means 'Invalid argument'. It might really be out of disk space/quota. Best regards, Heikki

Re: InnoDB crash repeated under 3.23.51...

-transaction.all.innobase_tid = NULL; } return(0); } - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 10:13 AM Subject: InnoDB crash repeated under 3.23.51... Heikki

Fw: InnoDB crash repeated under 3.23.51...

functions GET_LOCK() and RELEASE_LOCK(). I believe the patch below to ha_innobase.cc fixes the problem. Regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 1:16 PM Subject: Re: InnoDB crash

Re: Log Files in InnoDB (MySQL)

- Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: ritu singla [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 2:31 PM Subject: Re: Log Files in InnoDB (MySQL) Ritu, the ib log files contain records of every change to database pages in the ibdata files

Re: innodb rollbacks

, if there are lots of updates, and the user has a dangling uncommitted consistent read to the database for a long time, then the size of the undo logs may become significant also in InnoDB. I have to consider adding the size info to the InnoDB Monitor. Best regards, Heikki Tuuri Innobase Oy --- Order

Re: about crash

diagnostic code to fsp0fsp.c which may help to track the problem if it reappears. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From

Re: Dumping in the right order (Innodb)

Soren, the SQL command SET FOREIGN_KEY_CHECKS=0 is in the TODO list of May 2002. It will probably be in 3.23.52. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http

Re: innodb rollbacks

Jeremy, - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 8:43 PM Subject: Re: innodb rollbacks On Thu, May 30, 2002 at 12:16:28PM +0300, Heikki Tuuri wrote: However, if there are lots

Re: Constraints - Error or Bug????

Frank, please check with SHOW TABLE STATUS that the tables really are InnoDB type. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message

Re: InnoDB Delete On Cascade

(0.00 sec) mysql insert into child values(0,5); Query OK, 1 row affected (0.00 sec) mysql mysql delete from parent where id=5; Query OK, 1 row affected (0.01 sec) mysql mysql mysql select * from parent; Empty set (0.00 sec) mysql select * from child; Empty set (0.01 sec) Best regards, Heikki

Re: Will we ever get 3.23.50 for Linux????

not been declared stable on Linux. On other platforms the release 3.23.50 is a regular stable release. Thanks Mark Regards, Heikki Tuuri Innobase Oy - Before posting, please check: http://www.mysql.com/manual.php

MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html

-built glibc library. But as far as I know the bug has not caused much problems to Linux users either. Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

Re: MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html

systems) Download MySQL-Max 3.23.50 Linux (Alpha) Download MySQL-Max 3.23.50 Linux (IA64) Download MySQL-Max 3.23.50 Linux (Sparc) Download Regards, Heikki - Original Message - From: Arul [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 2:00

Re: PLEASE SEE THE MYSQL.ERR FILE ATTACHED

it print to the the error log mysql.err? You can repair these tables by dump + drop + reimport, but I would like to see first what CHECK TABLE prints. Regards, Heikki Tuuri Innobase Oy - Original Message - From: Cesar Andrade [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday

Re: Attn: MySQL AB: we need 3.23.5x NOW !

Mark, 3.23.51 is built and works on most major platforms, including Linux, Solaris, Windows, and FreeBSD. But the mysqld.sym file was forgotten from the Linux distribution. The build master is working on that right now. I think the release will be handed over to the web team after that, and

Re: Release Schedule

master gets .51 out he immediately has to start building .52. Let us see how these predictions fare :). Regards, Heikki Innobase Oy - Original Message - From: Frederick L. Steinkopf [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 07, 2002 2:31 PM

Re: MySQL AB: Need documentation clarification

. Thanks. --Erv Young Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Before posting

Re: MySQL AB: Need documentation clarification

For the mail filter: SQL database - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 11, 2002 2:47 PM Subject: Re: MySQL AB: Need documentation clarification Erv, - Original Message - From: Erv Young [EMAIL PROTECTED

Re: MySQL/InnoDB Hot Backups - What's a binlog segment?

Steve, the binlog is the MySQL logical log which it writes if you specify [mysqld] log-bin in my.cnf. They are the files called 'hostname'-bin.00x in the datadir of MySQL. They contain all INSERT, UPDATE, etc. SQL statements in an almost human-readable form. The binlog is used to recover from

Re: MySQL/InnoDB Hot Backups - What's a binlog segment?

Steve, - Original Message - From: Orr, Steve [EMAIL PROTECTED] To: 'Heikki Tuuri' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 3:27 AM Subject: RE: MySQL/InnoDB Hot Backups - What's a binlog segment? Thanks Heikki, I knew about the binlogs but that segment word

Re: innodb keeps crashing due to out-of-memory errors.

Per, - Original Message - From: Per Andreas Buer [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, June 15, 2002 11:40 PM Subject: Re: innodb keeps crashing due to out-of-memory errors. Hi Heikki, thanks for replying so swiftly. Heikki Tuuri [EMAIL PROTECTED

Re: innodb keeps crashing due to out-of-memory errors.

Per, - Original Message - From: Per Andreas Buer [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, June 16, 2002 2:10 PM Subject: Re: innodb keeps crashing due to out-of-memory errors. Oh, by the way. The error does not occur if I use less memory. please show us your

Re: innodb keeps crashing due to out-of-memory errors.

Per, set-variable= key_buffer=16M set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= max_allowed_packet=16M set-variable= thread_stack=256K set-variable = innodb_log_file_size=32M set-variable = innodb_log_buffer_size=8M set-variable =

Re: Backing up InnoDb

INDEX, DROP INDEX, CREATE TABLE, and DROP TABLE are the SQL commands, I think. Regards, -H Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

Re: Alter table problem

Ferdek, what character set you have specified in my.cnf? I tested your script with latin1 (the default) and 3.23.52, and it seemed to work without errors. For example, for the table reklamacja you see below it created the 3 foreign key constraints. Can you provide a simple repeatable test case

Re: Alter table problem

style: usually it is logical that the column in the referenced table should have the exact same data type as the column in the referencing table. Thank you for discovering this bug! Heikki Innobase Oy - Original Message - From: Ferdek [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED

Re: locking on row level ...

of the user who does the SELECT). Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Before

Re: locking on row level ...

Michael, - Original Message - From: Michael Bacarella [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] SELECT * FROM mytable WHERE mycol = xxx LOCK IN SHARE MODE; or SELECT * FROM mytable WHERE mycol = xxx FOR UPDATE; The upper query sets

<    1   2   3   4   5   6   7   8   9   10   >