in the future when I have
time to implement them.
If you readers of the MySQL mailing list have comments or questions
about this, I would be pleased to receive feedback on this mailing list.
Best regards,
Heikki Tuuri
Innobase Oy
Helsinki, Finland
try to mould the list according to what people
feel is the most relevent thing to do.
Best regards,
Heikki Tuuri
Innobase Oy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
, HP-UX and all different Unix flavors.
From the progress we can give an estimate that the interfacing is done
3 weeks from now. But a distribution version requires MySQL 4.0 source,
and that may still be farther out.
Regards,
Heikki Tuuri
Innobase Oy
Helsinki, Finland
must call UNLOCK TABLES before issuing another LOCK TABLES, because
there is no deadlock detection in MySQL itself.
The MySQL mailing list is currently the only place to discuss the Innobase
table handler. You can also send me email directly, I will be happy to reply!
Regards,
Heikki Tuuri
[...]. Currently, in MySQL
you must call UNLOCK TABLES before issuing another LOCK TABLES, because
there is no deadlock detection in MySQL itself.
I believe a LOCK TABLES does an automatic atomic UNLOCK TABLES of any
that were locked before if it's able to get the requested locks.
Tim.
Philippe,
did you try to do the insert and select on the same database page?
In BDB there is page level locking used, and the behavior you
describe sounds like that the select has placed a page level lock
on the page where you try to insert. Then it is correct behavior
of the database that your
the
new distribution should be ready at the latest on that day.
Currently, Intel NT and Intel Linux versions have been tested.
We will compile and test Solaris 32-bit and Linux Alpha 64-bit
versions this weekend.
Regards,
Heikki Tuuri
Innobase Oy
Helsinki, Finland
with no interference from locks, because Innobase
does in a select a consistent non-locking read, in the style of Oracle.
But MySQL/Innobase is not available yet, it will come out in
MySQL 3.23.3x in a few days (see my posting a couple of hours ago).
Regards,
Heikki Tuuri
Innobase Oy
Helsinki, Finland
Hi Jeremy!
Very cool!
I see the change log entries in the on-line manual already, but the
source tarball isn't on SourceForge yet. :-(
Anyone have one yet?
No, we are still busy working on the distribution, and no one has
it yet.
I just 15 minutes ago got the Solaris version running :).
Peter,
I guess you mean the source tree at www.bitkeeper.com? The interface
file ha_innobase.cc can be found there, but not yet the Innobase
source, I think. Then it cannot yet be compiled from the source tree,
because it needs Innobase header files.
But we should have the source out by
will report to the mailing list tomorrow what is the release status
then :).
Best regards,
Heikki Tuuri
Innobase Oy
Helsinki, Finland
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
64-bit, and Solaris Sparc 32-bit. On FreeBSD there
are still problems.
I will tell more as there is progress.
Regards,
Heikki Tuuri
Innobase Oy
Helsinki, Finland
-
Before posting, please check:
http://www.mysql.com
ECTED]
Best regards,
Heikki Tuuri
Innobase Oy
Helsinki, Finland
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this t
Hi!
There were more questions about Innobase:
Here is the comming question - can you speak some more about apace
allocation consepts used in innobase. For example how would it like to
work with huge number (10.000+ of the tables) and how space allocation
The data dictionary is hashed, a huge
page at www.innobase.fi (innobase.com
and innobase.net were already reserved).
Stephen L. Faustino
Senior Software Engineer
SecureLogix Corporation
Direct/Vmail (210)402-9669x949
mailto:[EMAIL PROTECTED]
Regards,
Heikki Tuuri
Innobase Oy
Helsinki, Finland
. Stored procedures and triggers are in the TODO
list for MySQL, but I do not know the timetable.
LPhil Daintree - Dux Industries Ph:+64 (04) 567 8900 Fax: +64 (04) 567 8904
Regards,
Heikki Tuuri
Innobase Oy
Helsinki, Finland
email: [EMAIL PROTECTED]
website: www.innobase.fi
, March 12th, 2001
Heikki Tuuri
Innobase Oy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
Hi Rick,
In my C code, I use SQL statements, but I use the mySQL C API to pass on the
SQL statements, check for errors, number of rows returned, and access the
results. I would assume that this will still work; they still work with BDB
tables.
ok, it should work like for BDB. There may be
Rick,
Everything you wrote sounds good, except for one thing. I use the result
count from a select or delete for logical branching within my code. I.e. I
perform a select and if rowcount is zero, then I can do an update. That is
a problem.
Any thoughts?
The basic rowcount functionality
er now :), I can help you
tomorrow if you report the next problems you encounter.
Best regards,
Heikki Tuuri
Innobase Oy
Best regards,
Lutz
--
Lutz Jaenicke [EMAIL PROTECTED]
BTU Cottbus http://www.aet.TU-Cottbus.DE/personen/jaenicke/
Leh
Joshua,
I hope you can also use MySQL dump, in which case, you don't have to shut
down, right?
yes, you can use mysqldump without shutting down. It did not come to my
mind that actually mysqldump is a kind of online backup mechanism :).
Since Innobase is multiversioned, you will get consistent
Lutz,
I think you have found the problem.
Ok, let's try to narrow things down: I have switched to GCC for the time
being and got a similar compile error:
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-O6 -DDBUG_OFF
-DHPUX -I/opt/dce/include -DHAVE_BROKEN_SNPRINTF -c
Lutz,
I looked at the pthread header file which is, by the way, 52000 lines long :).
It seems that pthread_attr_t and pthread_t are not pointers like in some
other Unixes, but structs of three fields:
struct {
field1; /* this is a pointer */
field2; /* a short int */
by default follow the ANSI spec.
Regards,
Heikki Tuuri
Innobase Oy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
Rick,
I tried to build from source the latest MySQL 3.23.34a and I found the
following problems:
1) The Makefile in the 'pars' and 'mem' directory have missing ../include/
paths on some dependencies.
Do you mean that when you compile, on the compiler line there is not the
flag -I../include?
Peter,
could you ftp your binary (compiled with -g option) to
support.mysql.com directory /pub/mysql/Incoming
I can then try to run the ATIS test on your binary on our SMP Linux.
One possible reason for the errors you get is that your version
of GCC is buggy in inlining of code, but that is
or alterations. Fixed in 3.23.45.
The bug could cause an assertion failure in fil0fil.c.
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
Johannes B
Hi!
InnoDB seems to have created the database and started ok. This does not look
like an InnoDB bug.
I think gethostbyaddr asks from a connection the hostname, and subsequent
code checks that the host has access rights to mysqld.
For some reason gethostbyaddr_r crashes.
Hmm.. if you could run
on a transactional database.
Thanks
Eric Mayers
Software Engineer
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
gives the error number 1005 from a CREATE TABLE statement, and the
error message string refers to errno 150, then the table creation failed
because a foreign key constraint was not correctly formed.
.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support
to the binlog, so that people would
not see partial transactions on the slave server. I am sending a carbon copy
of this message to Sasha.
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
so that it gives an error in CREATE TABLE if
the integer type signedness is not consistent in the foreign key
declarations.
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
should be available also on 4.0.1.
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
Gurupartap Davis wrote in message ...
I'm using MySQL 4.0, trying
://www.innodb.com/ibman.html ) to print the contents of the internal
data dictionary, and compare it to the .frm files you have for the tables.
Please send the output to the mailing list.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http
TABLE MONITOR OUTPUT
==
-Original Message-
From: Harald Fuchs [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Friday, February 08, 2002 3:50 PM
Subject: Re: InnoDB foreign keys crash MySQL
In article
Hi!
I just tried with 3.23.48 on Linux-2.4.16-SMP-64GB (ext2 I think), and a
5000 MB data file was created.
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
DATA_VARCHAR columns.
The fix probably makes it to upcoming MySQL-4.0.2, if Monty has not yet
frozen the 4.0.2 codebase.
It will also be in 3.23.49.
Best regards,
Heikki
Innobase Oy
-Original Message-
From: Harald Fuchs [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Date: Saturday, February
fixed in 4.0.2.
Please send your my.cnf or my.ini to this mailing list, and post the exact
sequence of SQL statements which in your opinion produces a wrong response.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http
as the default character set in my.cnf. A source code patch to this is
available at http://www.innodb.com/foreign.txt.
In the MySQL layer of code there were also some minor bug fixes. Please
consult the MySQL-3.23.48 release note about those.
Best regards,
Heikki Tuuri
Innobase Oy
should be available also on 4.0.1.
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
Gurupartap Davis wrote in message ...
I'm using MySQL 4.0, trying
://www.innodb.com/ibman.html ) to print the contents of the internal
data dictionary, and compare it to the .frm files you have for the tables.
Please send the output to the mailing list.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http
TABLE MONITOR OUTPUT
==
-Original Message-
From: Harald Fuchs [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Friday, February 08, 2002 3:50 PM
Subject: Re: InnoDB foreign keys crash MySQL
In article
Hi!
I just tried with 3.23.48 on Linux-2.4.16-SMP-64GB (ext2 I think), and a
5000 MB data file was created.
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
so that it gives an error in CREATE TABLE if
the integer type signedness is not consistent in the foreign key
declarations.
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
to the binlog, so that people would
not see partial transactions on the slave server. I am sending a carbon copy
of this message to Sasha.
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
DATA_VARCHAR columns.
The fix probably makes it to upcoming MySQL-4.0.2, if Monty has not yet
frozen the 4.0.2 codebase.
It will also be in 3.23.49.
Best regards,
Heikki
Innobase Oy
-Original Message-
From: Harald Fuchs [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Date: Saturday, February
as the default character set in my.cnf. A source code patch to this is
available at http://www.innodb.com/foreign.txt.
In the MySQL layer of code there were also some minor bug fixes. Please
consult the MySQL-3.23.48 release note about those.
Best regards,
Heikki Tuuri
Innobase Oy
Hi!
-Original Message-
From: David Felio [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Date: Tuesday, February 12, 2002 12:47 AM
Subject: Re: Static or Dynamic rows -- which is faster?
On Monday, February 11, 2002, at 12:12 PM, Heikki Tuuri wrote:
for InnoDB 'dynamic rows
be
a better option.
I guess also for MyISAM dynamic rows are usually faster, because you win in
smaller disk i/o.
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
to the binlog, so that people would
not see partial transactions on the slave server. I am sending a carbon copy
of this message to Sasha.
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
Eric,
MySQL is very pessimistic about key accesses: it assumes many of them cause
a random disk read.
Please print
EXPLAIN SELECT * FROM Syslog WHERE datestamp ...
to see how it accesses the table.
I have tuned the optimization in 3.23.48 so that it would favor index
searches more often.
Eric,
print what
EXPLAIN SELECT * FROM Syslog USE INDEX(ds_index) WHERE ...
says.
Please also show what the InnoDB monitor prints.
Regards,
Heikki
-Original Message-
From: Eric Mayers [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
[EMAIL PROTECTED]
Date
. That will mislead the estimator.
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: Eric Mayers [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL
buffer
records were merged in 700 000 merges: on the average 13 records were
inserted at a time. Deleting these records will use more disk i/o because
there is no similar optimization in deletes.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https
,
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
Lou Picciano wrote in message ...
Dear Listers:
In configuring for a 4.0.1 compile, all goes well.
The compiler, however
Eric,
-Original Message-
From: Eric Mayers [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Date: Friday, February 15, 2002 1:10 AM
Subject: RE: Does delete from .. where (condition) use an index?
Heikki,
I thought I'd bring this off the list to reduce list traffic (if you
think
in 3.23.50.
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
Richard R. Harms wrote in message ...
The create table command included at the end of this message gives
to be InnoDB type and there must be an index where the
foreign key and the referenced key are listed as the first columns. InnoDB
does not auto-create indexes on foreign keys or referenced keys: you have to
create them explicitly.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL
. ERROR_PATH_NOT_FOUND
Error number 3 means you have not created the InnoDB data or log
directories. Please use the MS-DOS mkdir command to create the directories.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http
doesn't have this problem.
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
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: Nick Wilson [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Wednesday
).
thank you. I am honored.
--
Regards
Peng
--
Peng Zhao [EMAIL PROTECTED]
http://www.cs.ualberta.ca/~pengzhao
TEL (Lab): (780)492-3725 Lab: CSC251
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http
states.
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, please check
Oops,
the syntax is
SELECT ... FROM ... WHERE .. LOCK IN SHARE MODE;
Heikki
-Original Message-
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, February 21, 2002 9:27 AM
Subject: Re: Fake interval data type
Hi!
Its kind of a subtle point
.
See http://www.innodb.com/userstories.html.
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
thread
implementations in FreeBSD.
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]
Newsgroups
Jonathan,
the bug is probably the SHOW CREATE TABLE bug which was fixed in 3.23.48.
Please upgrade to 3.23.49a.
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
1200 inserts/second. Also the popular
Internet news site Slashdot.org runs on InnoDB tables.
For more information on InnoDB, please see the InnoDB website
http://www.innodb.com.
Best regards,
Heikki Tuuri
CEO
Innobase Oy
parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id),
FOREIGN KEY (parent_id) REFERENCES parent(id))
TYPE=INNODB;
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https
Boris,
thank you for the bug report! This is the only currently known bug in
MySQL/InnoDB-3.23.49:
February 15, 2002:
If a CREATE TABLE statement contains the string 'foreign' anywhere, and that
is succeeded by a non-space character, then the CREATE TABLE fails,
reporting errno 150. Fixed in
the database span these 3
ibdata files for an aggregate of 6G?
Someone please enlighten me.
Trying to get this right the first time, so sql development can start.
Ron Arenas
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up
Hi!
-Original Message-
From: j.random.programmer [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Saturday, March 02, 2002 5:21 AM
Subject: Re: Innodb tables lose foreign keys after creating an index...
--- Heikki Tuuri [EMAIL PROTECTED] wrote:
Heikki:
Is there a fix
will
automatically extend it in units of 10 MB when the data file becomes full.
..
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up adding of features to MySQL/InnoDB through support contracts
See http://www.innodb.com
creation
again. It is best to start the MySQL server from a command prompt so that
you see what is happening.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up adding of features to MySQL/InnoDB through support contracts
See http
Tomasz,
are you running on Windows?
Please use innodb_table_monitor as explained in section 9.1 of
http://www.innodb.com/ibman.html, and also look into section 15.1.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up adding
Wendell,
InnoDB writes a checksum to a database page when it is written to disk. If
the checksum does not correspond to the page contents when the page is read
back in, you get the below error. Below page 36819 in table
registrydb_tn/TBL_AllNames appears to be corrupt, like it says. The checksum
' foreign key definitions is to
call SHOW TABLE STATUS FROM ... which prints them in the table comments.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up adding of features to MySQL/InnoDB through support contracts
See http
definitions.
In versions 3.23.50 the only way to 'dump' foreign key definitions is to
call SHOW TABLE STATUS FROM ... which prints them in the table comments.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up adding of features
Bob,
thank you!
I believe 3.23.50 will be out in two weeks. It is a stable version. The
changes in foreign keys were actually rather small. I hope they do not
degrade .50 to the beta category.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https
Philip,
-Original Message-
From: Philip Molter [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: Bob McLaughlin [EMAIL PROTECTED]; MySQL Mailing List
[EMAIL PROTECTED]
Date: Tuesday, March 12, 2002 4:21 PM
Subject: Re: Foreign keys in mysqldump?
On Tue, Mar 12, 2002 at 11:50
also list the foreign key constraints for a table T with
SHOW TABLE STATUS FROM yourdatabasename LIKE 'T'
The foreign key constraints are listed in the table comment of the output.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up
Hi!
You should add a new data file as explained in section 5 of
http://www.innodb.com/ibman.html.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up adding of features to MySQL/InnoDB through support contracts
See http
David,
a Solaris version of InnoDB Hot Backup is planned, as well as a FreeBSD
version.
Currently I am working with beta testers trying to get the Large file
support on Linux to work :).
Regards,
Heikki Tuuri
Innobase Oy
-Original Message-
From: David Felio [EMAIL PROTECTED
Hi!
Where did you read that? That text should be updated!
At least InnoDB supports indexes on columns which can have a NULL value.
Regards,
Heikki Tuuri
Innobase Oy
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Wednesday, March
Tomasz,
are you sure you are running 4.0.1? In the rpm of 4.0.0 there were no
foreign keys.
I tested this on mysql-max-4.0.1, and it worked.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up adding of features to MySQL/InnoDB
in dict0crea.c, reporting an internal error 17.
might be the root of your problem with 4.0.1.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up adding of features to MySQL/InnoDB through support contracts
See http://www.innodb.com
www.mysql.com
and test it with a freshly created InnoDB database. .49a is the recommended
stable version.
Regards,
Heikki
-Original Message-
From: Tomasz Korycki [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, March 14, 2002 5:52 PM
Kannan,
error 101 used to mean a lock wait timeout. In 4.0.1 and later 3.23
versions that has been replaced by a new clear-English error code.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com
the RENAME TABLE
commands from the .frm files.
I will appreciate any suggestion,
Thanks,
Nico
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
to be a correct procedure, or I've messed up something?
please look in section 5 of http://www.innodb.com/ibman.html about adding a
new data file.
Regards
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
Best regards,
Heikki Tuuri
Innobase Oy
---
Order
/ibman.html about forcing
recovery.
Regards,
Heikki Tuuri
Innobase Oy
-Original Message-
From: BAUMEISTER Alexandre [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; Michael Widenius
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, March 19, 2002 11:51 AM
Subject
Innobase Oy
-Original Message-
From: BAUMEISTER Alexandre [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; Michael Widenius
[EMAIL PROTECTED]
Date: Tuesday, March 19, 2002 12:18 PM
Subject: Re: InnoDB: Assertion failure in thread 10 in file btr0btr.c line
574
Bonjour,
BA We have
Alex,
616e647265747469 andretti
616e6472e9737069 andr.spi
there is a character e9 in your string. It is not an ordinary character and
can cause an error in the sorting order between InnoDB-.41 and InnoDB-.49.
-Original Message-
From: BAUMEISTER Alexandre [EMAIL PROTECTED]
To: Heikki
Alex,
-Original Message-
From: BAUMEISTER Alexandre [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: Michael Widenius [EMAIL PROTECTED]; [EMAIL PROTECTED]
[EMAIL PROTECTED]
Date: Tuesday, March 19, 2002 5:14 PM
Subject: Re[4]: InnoDB: Assertion failure in thread 10 in file
Rick,
this is fixed in 3.23.50. I changed InnoDB so that it ignores foreign key
checks on keys containing SQL NULL values.
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
and embedded license prices for these versions.
InnoDB version numbers are the same as MySQL version numbers, because new
versions appear as part of MySQL distributions. There is currently no
standalone version of InnoDB available.
Best regards,
Heikki Tuuri
CEO
Innobase Oy
---
InnoDB - transactions
.
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 PROTECTED] [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date
Hi!
Please look in section 9.1 of http://www.innodb.com/ibman.html
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
aspect in InnoDB is transactions and multiversion
concurrency control, and those are close to Oracle, some general SQL books
which are aware of Oracle might also help.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com
question (id_question))
type=Inn
oDB;
Query OK, 0 rows affected (0.88 sec)
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
..
hi,
I've
1 - 100 of 1597 matches
Mail list logo