Re: InnoDB Hot Backup + MySQL embedded?

Chris, - Original Message - From: "Chris Nolan" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 12, 2004 2:26 PM Subject: Re: InnoDB Hot Backup + MySQL embedded? > Dear Heikki, &g

MySQL/InnoDB-4.0.18 is released

UNIQUE secondary index, and NULL values in that unique index; with the IS NULL predicate, InnoDB returned only the first matching row, though there can be many. This bug was introduced in 4.0.16. (Bug #2483) Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com -- MySQL General Mai

Re: InnoDB Hot Backup + MySQL embedded?

the mysqld server at all. It just reads the InnoDB data and log files. On the other hand, the innobackup Perl script does start a mysql connection to the server. > Regards, > > Chris Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row

Re: Foreign Key Reference to a VARCHAR

languages on Earth. Thank you, Heikki - Alkuperäinen viesti - Lähettäjä: "Sven Woltmann" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Lähetetty: Tuesday, February 10, 2004 3:53 PM Aihe: RE: Foreign Key Reference

Re: Foreign Key Reference to a VARCHAR

Sven, are you using the UTF8 charset? Then a single character may use up to 3 bytes. Since MySQL cannot work with index columns longer than 255 bytes, for columns CHAR(86) or longer, MySQL must define a 'column prefix' index, if you define an index on the column. That is, MySQL internally creates

Re: Version 4.1.2. when?

ext problem (bug #2490). > > Thanks for info, > mirza 2 months ago I predicted 4.1.2-beta would be released Jan 25th, 2004. But now I would guess March 5, 2004. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB

Re: InnoDB Hot Backup & new tablespace format

ing all lsn's and trx id's in the .ibd file. > Thanks for any replies, > -- > Chris Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISA

Re: Memory Leak using InnoDB ?

Geoffrey, - Original Message - From: "Geoffrey" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, February 07, 2004 10:11 PM Subject: Re: Memory Leak using InnoDB ? > Dan, Heikki, > >

Re: INNODB - Reclaiming ibdata space and various ibdata questions

r that. > We have found that you can defrag a table: "From MySQL Manual: The way to do the defragmenting is to perform a 'null' alter table operation ALTER TABLE tablename TYPE=InnoDB." We would like to do this for the complete database. > > Thanks again for a

Re: Memory Leak using InnoDB ?

p' line for that process. By the way, monitoring if InnoDB has memory leaks is very easy. Just look with SHOW INNODB STATUS at the 'total allocated memory'. If that keeps climbing without bounds, that is an indication of a memory leak. > -- > Dan Nelson > [EMAIL PROTECTED]

Re: starting a crashed mysqld

. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From

Re: Why does MySQL generate internal foreign key id when constrain name

`databasename.tablename_fk_` Replication does not like globally generated id's like `0_1584`, because the id's will differ if the slave is not set up as an exact binary replica of the master. I hope these bug fixes make it to 4.0.18 and 4.1.2. > Thanks > > Phil Best r

Re: AUTO_INCREMENT in InnoDB

ome arbitrary number? My > table type is InnoDB. drop the table, recreate it, insert a dummy row with the auto-inc column set to the desired value minus 1, and delete that dummy row. > Thanks. > > Hassan Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, tra

Re: Shrinking innodb datafiles?

Lawrence, - Alkuperäinen viesti - Lähettäjä: "Lawrence Smith" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Sunday, February 01, 2004 1:03 PM Aihe: Re: Shrinking innodb datafiles?

Re: key constraint error on replace

NSERT, sometimes as a DELETE + INSERT, and sometimes as an UPDATE. The behavior with foreign key constraints is not very well predictable. You can get a detailed description of the latest FOREIGN KEY error with SHOW INNODB STATUS\G Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com For

Re: InnoDB Backups

t > backup or mysqldump? Also snapshot file systems, like the Veritas file system should work, though I have not tested them. > Thanks, > > Mauro Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup -

Re: Shrinking innodb datafiles?

Lawrence, - Original Message - From: "Lawrence Smith" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, January 31, 2004 6:47 PM Subject: Re: Shrinking innodb datafiles? > Heikki, > > thank

Re: Key locks on InnoDB

Hi! It depends on the isolation level whether locking reads set next-key locks (= lock the record AND the gap before it), or only lock the record itself. http://www.innodb.com/ibman.php#Set.transaction: " READ UNCOMMITTED This is also called dirty read: non-locking SELECTs are performed so that

Re: InnoDB Backups

> > If I am not using Automatic COMMITs then my backup will contain data = > up > to the last COMMIT (In other words, data since the last COMMIT will not > be included in the backup. Is this true? > > I appreciate any guidance...Thanks Much! > > Mauro Best regards, Heikk

Re: Shrinking innodb datafiles?

Lawrence, if you use MySQL-4.1.1, and specify innodb_file_per_table in my.cnf, then InnoDB places each table into its own .ibd file. That is a way to free the disk space to the OS if you drop a table. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and

InnoDB file format changes 2004 - 2005; Re: InnoDB development

Chris, InnoDB file format changes: 4.1.0 -> 4.1.1 introduced multiple tablespaces; 4.1.1 -> 4.1.2 or .3allow multiple charsets in the same database installation (currently only the default charset is used in InnoDB); 5.0.0 -> 5.0.x create all new InnoDB tables in a spa

Re: MySQL 3.23.58 seg faults occasionally

Michael, I guess the table is corrupt and its row contains a wrong trx id. InnoDB tries to retrieve an earlier version of the row, but the roll ptr in the row is garbage too, and it contains a nonexistent rollback segment id. " InnoDB: Error: trying to return an SQL NULL field in a non-null innoD

Re: CREATE TABLE

Jeremiah, if you are using a fairly recent version of MySQL, you can print with SHOW INNODB STATUS\G a detailed explanation of the latest foreign key error. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot

Re: Postponing Integrity Checking...

Matthew, sorry, InnoDB does not support deferred constraint checking. It is in the long-term TODO. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM

Re: InnoDB loading: add keys before or after

single transaction. Regards, Heikki - Original Message - From: "Keith Thompson" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 22, 2004 4:46 PM Subject: Re: InnoDB loading: add keys before or after &g

Re: InnoDB loading: add keys before or after

faster, but that is not the case for InnoDB. DISABLE KEYS has no effect on InnoDB. It is in the TODO to speed up index creation. Maybe in 2005 it will be faster to add the indexes afterwards :). Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row

Re: InnoDB locking 'non-existence' of a row

s a lengthy comment at the start of the file. And the full source code of the algorithms, too :). Papers by IBM researcher C. Mohan may also be of interest. > Thank you for your time, > > Alex Zeltser Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions

Re: Too slow recovering mysqldump files

backup taken with InnoDB Hot Backup, you do not need to import table dumps. Thus restoration is much faster than if you use table dumps as a backup (table dump = LOGICAL backup). Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MyS

Re: how to access iblog file?

se. i have trouble access iblog file. Anyone know > how to access iblog file ? What error message does mysqld print? > Thanks in advance. > > -M. Amrin- Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB

Re: InnoDB locking 'non-existence' of a row

If A holds an X-lock on gap1 and B holds an X-lock on gap2, and purge removes the delete_marked_record, then the gaps merge, and both A and B hold an X-lock on the gap. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB

Re: InnoDB key adding slowness

Keith, please see my reply to Mikel in thread 'Too slow recovering mysqldump files'. Since you are running a 64-bit version, you can set innodb_buffer_pool_size as high as 3 GB in your hardware. You can monitor the progress of the big ALTER TABLE with SHOW INNODB STATUS\G Best regard

Re: Too slow recovering mysqldump files

can squeeze a typical table to 1 / 4 the size of a normal InnoDB table. I believe the compressed format will be available in October 2004. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool

Re: Too slow recovering mysqldump files

Mikel, have you set the size of the InnoDB log files as recommended in the manual? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order

Re: MySQL 3.23.58 seg faults occasionally

Michael, the crashes below happen in independent areas of code. The 2 first are inside InnoDB, and the third inside MySQL. This looks like random thread crashes, or random memory corruption. I assume that you have my.cnf set so that the memory usage cannot approach 2 GB. You are running a relati

Re: Recreating InnoDB tables -WITHOUT- .frm

years ago. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order

Re: ON UPDATE CASCADE

orked. " I realize InnoDB should give an error if you try to create a cyclic ON UPDATE CASCADE constraint. Or even better, we should implement it so that also that would work! Though the behavior in the case where the constraint recurses to update the same row twice is problematic. Best regard

Re: foreign key contraints, on delete cascade not working?

Andrew, please check with SHOW VARIABLES LIKE '%innodb%'; that you really have InnoDB enabled. I tested the script below on Linux with 4.0.8 and 4.0.18, and it worked ok. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking

Re: consistency checking InnoDB tables

files). If InnoDB's crash recovery crashes or its internal cleaning processes crash because of database corruption, then you need to set set-variable = innodb_force_recovery=... in my.cnf to a value 1 ... 6. See http://www.innodb.com/ibman.php#Forcing_recovery for details. Best regards, Heikki

Re: innodb_buffer_pool_size / *_buffer_size relation

Roman, - Alkuperäinen viesti - Lähettäjä: "Roman Neuhauser" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Wednesday, January 07, 2004 8:05 PM Aihe: Re: innodb_buffer_pool_size / *_buffe

Re: MySQL 4.1 Production Release

ooner. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - F

Re: Binaries for 4.x

Kool, there are no longer GPL binaries of MySQL for SCO operating systems. Only commercial binaries that you have to buy from MySQL AB. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool

Re: Mysql error

Don, the InnoDB text below is only a help message, not an error, and is not dangerous. It is not associated with the timeout problems you have on Fedora. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup

Re: innodb_buffer_pool_size / *_buffer_size relation

yISAM type temporary tables when processing DISTINCT or ORDER BY. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical su

Re: mediumtext crash on strings > 1MB?

Chris, you should set max_packet_size in my.cnf. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https

Re: MYSQLDump loses connection on large dump.

Pete, what does SHOW VARIABLES LIKE '%timeout%'; say? Does the MNRD mysqld server crash? Anything in the .err log? What do you have as max_packet_size in my.cnf? Could row: 13154861 be bigger than that? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, tr

Re: innodb defragmentation question

Franky, you apparently have just the PRIMARY KEY defined on the table and no secondary indexes. I guess the fragmentation comes because you delete rows from in the middle with respect to the primary key ordering? Or do you also insert in random order? Anyway, you cannot do anything to prevent frag

Re: Lock Wait Timeout

Randy, that is expected: http://www.innodb.com/ibman.php#Locks_set_by_statements " If a FOREIGN KEY constraint is defined on a table, any insert, update, or delete which requires checking of the constraint condition sets shared record level locks on the records it looks at to check the constraint

Re: innodb defragmentation question

Franky, since MySQL performs ALTER TABLE ... TYPE = InnoDB; by totally rebuilding the table, it is very normal that the space usage temporarily doubles in ibdata files. But if it doubles also after an immediate SECOND rebuild, then that must be a bug. If you can reproduce that phenomenon, pleas

Re: Foreign Keys in CREATE TABLEs produced by mysqldump

Michael, - Alkuperäinen viesti - Lähettäjä: <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Monday, December 29, 2003 11:53 PM Aihe: Re: Foreign Keys in CREATE TABLEs produced by mysqldump > &

Re: MySQL/InnoDB-5.0.0 is released

Ramesh, - Alkuperäinen viesti - Lähettäjä: "Ramesh Vadlapatla" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Lähetetty: Monday, December 29, 2003 10:48 PM Aihe: Re: MySQL/InnoDB-5.0.0 is released > Hello Heikki, > >

Re: INNOB error and mysql won't start

art the MySQL server from a command prompt so that you see what is happening. " Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MyS

MySQL/InnoDB-5.0.0 is released

space saving table formats for InnoDB. IMPORTANT NOTE: if you upgrade to InnoDB-4.1.1 or higher (like to 5.0.0), you cannot downgrade to a version lower than 4.1.1 any more! That is because earlier versions of InnoDB are not aware of multiple tablespaces. Best regards, Heikki Tuuri Innobase Oy

Re: MySQL 5.0.0 has been released

ssentially the same as InnoDB-4.1.1. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order

Re: INNOB error and mysql won't start

Hi! What version of MySQL you are running? Is the output below ALL you get into the .err log? In >= 4.0 you can disbale InnoDB by putting the line skip-innodb to my.cnf. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for My

Re: relative performance between innodb and myisam

Bruce, InnoDB in most cases uses some more CPU time than MyISAM. But the main performance disadvantage of InnoDB is that tables in the InnoDB format typically require 50 % - 300 % more disk space than MyISAM format tables. Marko Mäkelä of Innobase Oy is writing a new InnoDB table format which wil

Re: Foreign Keys in CREATE TABLEs produced by mysqldump

Michael, - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, December 24, 2003 1:45 AM Subject: Foreign Keys in CREATE TABLEs produced by mysqldump > --=_alternative 008277CD88256E05_= > Content-Type: text/plain; charset="US-ASCII" > > Fir

Re: Innodb, Assertion failure in file log0log.c with 4.0.!7

ained in\n" "InnoDB: section 5 of http://www.innodb.com/ibman.php";, (ulong)srv_thread_concurrency); fprintf(stderr, "InnoDB: Cannot continue operation. Calling exit(1).\n"); exit(1); } Merry Christmas! Heikki T

Re: Database rollback doesn't work

Monica, I think there was no transaction support in MySQL-2.3.2. You should use MySQL-4.0 and an InnoDB or BDB type table. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB

Re: innodb questions (backup and transactions)

Russ, you can also use mysqldump --single-transaction to back up InnoDB type tables. The advantage of InnoDB Hot Backup over that method is that InnoDB Hot Backup takes binary backups of the ibdata files. Restoring a binary backup is much faster than a table dump. Best regards, Heikki Tuuri

Re: Replication Rollback

Karthikeyan, replication poses no problem here. MySQL does not write to the binlog transactions which are rolled back. Thus, a replication slave will never perform the steps in a transaction which is rolled back in the master. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign

Re: memory trap

Drago, you only had the default InnoDB buffer bool, that is 8 MB. InnoDB row locks CAN fill it in a big import if you have duplicate key errors in the inserted rowset. Also, tell us your MySQL version. Regards, Heikki - Original Message - From: <[EMAIL PROTECTED]> To: "H

Re: memory trap

Hi! What MySQL version you are running? Can you show us your my.cnf, so that we see how much memory you had allocated to the InnoDB buffer pool? Did you run some big DELETE, UPDATE, or SELECT ... FOR UPDATE, or SELECT ... LOCK IN SHARE MODE query at that time, so that you could really exhaust al

Re: transactions and create table (was Questions about MySQL implementation)

eation not being rolled back. > > I tried to RTFM. I did find a note on how transactions are treated for > CREATE TABLE SELECT..., but I wasn't > able to find a clear statement that CREATE TABLE will no longer force a > commit. > > > From: "Heikki Tuuri" <[EM

Re: [ MySQL: Problems with Innodb ]

Osvaneo, you probably forgot to move also ib_logfiles. > InnoDB: Starting log scan based on checkpoint at > InnoDB: log sequence number 7 1021600303 > InnoDB: Doing recovery: scanned up to log sequence number 7 1021600256 It cannot scan the current ib_logfiles at all! Best regards

Re: Innodb multiple tablespaces benchmark

n at the same time.", (gptr*) &innobase_open_files, (gptr*) &innobase_open_files, 0, GET_LONG, REQUIRED_ARG, 300L, 10L, ~0L, 0, 1L, 0}, Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot

Re: "Planned" transactions?

e SELECTs are 'consistent non-locking reads' (the default in InnoDB), then the first SELECT sets the snapshot timepoint of the transaction. Purge cannot remove history which is after that timepoint, until the transaction commits. It does not matter what tables and what rows

Re: Questions about MySQL implementation

performace? Any insights of similar type > for using MyISAM tables? I would just create several ibdata files and place them round-robin on different physical disks. Also, putting the ib_logfiles to a separate disk might be a good idea. For MyISAM, I would use symlinks to distribute big tables to d

Re: InnoDB lock in share mode problems

row_count OFFSET offset] [PROCEDURE procedure_name(argument_list)] [FOR UPDATE | LOCK IN SHARE MODE]] I think the clause LOCK IN SHARE MODE has to be the very last. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL

Re: foreign keys.

Mofeed, - Original Message - From: "Mofeed Shahin" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 12:47 AM Subject: Re: foreign keys. > On Thu, 18 Dec 2003

Re: Detecting locks (using connector/j)

Jonck, sorry, there is currently no way to detect InnoDB locks, except by setting globally innodb_lock_wait_timeout=1 in the [mysqld] section of my.cnf. Then your failing lock requests return with the error 'lock wait timeout'. Best regards, Heikki Tuuri Innobase Oy http://www.

Re: foreign keys.

Mofeed, - Original Message - From: "Mofeed Shahin" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 12:20 AM Subject: Re: foreign keys. > Hmmm, Thanks for that. > B

Re: MySQL 4.0.17 has been released

ables. On Windows the setting 1 is the default. " That is, the best solution for portability is to have the database and table names always in lower case. Setting globally set-variable=lower_case_table_names=1 is a convenient way to accomplish this. Best regards, Heikki Tuuri Innoba

Re: foreign keys.

Mofeed, if you are using a relatively recent version of 4.0, or 4.1.1, please look with SHOW INNODB STATUS\G what is the latest FOREIGN KEY error. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot

Re: Change the size of an InnoDB table field

Felix, I assume this is a MySQLCC bug. Can you perform the ALTER TABLE from using the mysql interactive SQL client program? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool for InnoDB

Re: Can I really have no_wait row-locks in MySQL+InnoDB?

Dmitry, we have to consider implementing NOWAIT and SKIP LOCKED clauses to SQL statements. The latter would be useful in implementing transactional queues. But there are lots of items in the TODO list. Do not expect these soon. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com

MySQL/InnoDB-4.0.17 is released

column to an alphabetically equivalent value, and rolled back your update, InnoDB failed to restore the field in the secondary index to its original value. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Back

Re: MySQL 4.0.16 64bit crash report

t; <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Thursday, December 11, 2003 2:29 AM Aihe: Re: MySQL 4.0.16 64bit crash report > > Hi Heikki, > > Heikki Tuuri wrote: > > > Don, > >

Re: MySQL 4.0.16 64bit crash report

you please send me your my.cnf. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com

Re: MySQL 4.1 Beta Release

able already. > Thanks, > > Puny Sen Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.m

MySQL/InnoDB-4.1.1 is released

new InnoDB Hot Backup version 2.0 which supports multiple tablespaces in 4.1.1 is already ready, but the binaries not yet built. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool for Inno

Re: on delete|update

e. The default behavior is RESTRICT, which performs the check. > With regards, > > Martijn Tonies > Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL > Server. > Upscene Productions > http://www.upscene.com Best regards, Heikki Tuuri Innobase

Re: Drop foreign key replication problem

Batara, thank you for the bug report. I have to fix this bug when I overhaul the foreign key constraint naming conventions. Yes, to fix the problem you can drop the foreign key constraint manually in the slave. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys

Re: InnoDB "lock in share mode" on union

Bill, I tested this on the latest 4.1.1 snapshot, and it worked ok: client 2 waited for client 1 to commit. Please test again. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - hot backup tool for InnoD

Re: Backup is Alphabetical

foreign keys for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL support from http://www.mysql.com/support/index.html - Alkuperäinen viesti - Lähettäjä: "Dwight Ian" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuu

Re: InnoDB caused crash and left me a log entry...

the table for more testing, and also your my.cnf. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from ht

BUG in 4.0.15 on Windows: all queries > 30 sec cause error 2013: upgrade to 4.0.16

uery". All users of 4.0.15 on Windows should upgrade. " The bug is not associated with InnoDB tables, but is in the mysql client. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool f

Re: installing 3.23.57 with InnoDB

ll CFLAGS="-DUNIV_MUST_NOT_INLINE" ./configure make in the /innobase subdir, so that the Makefile's get that flag in the compilation line. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup t

Re: row-level locking question...

le execution: BEGIN; SELECT v1 from t1 LOCK IN SHARE MODE; (do the computation of v2 based on v1) UPDATE t2 set v2=; COMMIT; > Is the above approach the way to go or is there a more > elegant/correct way of doing this? > > Thanks. > -- > Andre Charbonneau Best regards

Re: innodb-errors

as ibdata files. You can look at http://www.innodb.com/ibman.html#Forcing_recovery about emergency recovery using a recent MySQL-4.0 version. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool

Cannot create InnoDB table

Philip, the problem is probably that the table already exists in the InnoDB internal data dictionary. With 4.0.17, I get: mysql> CREATE TABLE ids (id varchar(255)) TYPE=InnoDB; ERROR 1005 (0): Can't create table './test/ids.frm' (errno: 121) mysql> Output to the .err log: 031112 17:48:3

Re: switch from gemini to innodb bottlnecks

-variable=query_cache_size=256M set-variable=query_cache_limit=2M set-variable=query_cache_type=1 " In 4.1.1, the query cache works also in the AUTOCOMMIT=0 mode. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB H

Re: Deadlock

nditions? This bug fix in 4.0.16 may have relevance: Fixed a bug: contrary to what was said in the manual, in a locking read InnoDB set two record locks if a unique exact match search condition was used on a multi-column unique key. For a single column unique key it worked right. > Re

Re: mySQL crash

Dear TS Wong, please send the whole .err log to me [EMAIL PROTECTED] What MySQL versions and what Linux kernel version you are running? Thank you, Heikki - Original Message - From: ""ts.wong"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, October 30, 2003 5:

Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

al. The same holds for DB2, Oracle, and MS SQL Server. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://or

Re: auto_increment with FOREIGN KEY UPDATE CASCADE courses Lost connection to MySQL server

t the child table. Because of MySQL's 'silent column specification changes' a fixed-length CHAR column can change internally to a VARCHAR and cause this error. " Below a test run with the latest 4.0 tree. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign ke

Re: InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1)

fered i/o. In Windows raw disk i/o, starting from 4.1.1, you can allocate a disk partition as a data file like this: innodb_data_home_dir= innodb_data_file_path=//./D::10Gnewraw " > - Gabriel Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking f

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

Hancock" <[EMAIL PROTECTED]> > > Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> > > Lähetetty: Monday, October 27, 2003 10:42 AM > > Aihe: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 > > > > > > > Heikki, > >

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

in MSSQL? What does it count? > Is there a way to turn ON/OFF auto-commit? SET AUTOCOMMIT={0 | 1} > And, are metadata operations under transaction control? CREATE TABLE, DROP TABLE, etc. form a transaction of their own. You cannot use ROLLBACK to roll them back. > With

Re: InnoDB errors

Shane, it is not an InnoDB error message. InnoDB messages are always prefixed with InnoDB: The error means that there is an inconsistent row in the db.MYD system table of MySQL. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for

Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1

Eduardo, - Alkuperäinen viesti - Lähettäjä: "Eduardo D Piovesam" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Lähetetty: Friday, October 24, 2003 6:17 PM Aihe: Re: MySQL/InnoDB-4.0.16 is released + sneak

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