Kannan,
please upgrade to 3.23.49a or 4.0.1.
101 used to mean lock wait timeout. It has been replaced by a
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 for the online manual
William,
- Original Message -
From: William R. Mussatto [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, April 01, 2002 6:29 PM
Subject: Re: mysql innodb error
I thought the 4.0 series was still Beta?
yes, 4.0.1 is beta or alpha, depending
remove mysql max can i remove this files ?
yes, you can remove the ib* files if you did not create any InnoDB tables
and wnat to keep them.
I remove
Thanks.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com
: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 54 days, processed 1,508,679,843 queries (319/sec.
avg)
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL
asked Monty today to downgrade to
earlier versions, but he did not want to give up yet.
We will consider making a source release of MySQL-Max-3.23.50 if the
problems with the compiler continue.
Best regards,
Heikki Tuuri
Innobase Oy
- Original Message -
From: Chandran Richard Honour [EMAIL
Brawley
Arthur Fuller
Best 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, e
that mysqldump and other GPL tools work also with
InnoDB tables.
Is there something I'm missing?
Steve
Regards,
Heikki Tuuri
Innobase Oy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
-3.23.50 will solve your problem. No
need to preallocate tablespace any more.
I think the following formula usually gives a rough estimate of the needed
size: 1.5 x size of the .MYD file + 5 x size of .MYI file.
Regards,
Rodrigo Gonzalez.
sql,query
Best regards,
Heikki Tuuri
Innobase Oy
goes down after part of a
transaction is sent to the slave, you get a partially committed
transaction on the slave. How critical this is depends on the
application, and still is no worse than MyISAM which has no transactions
to begin with.
I think Heikki Tuuri has mentioned plans to get
Patrick,
- Original Message -
From: Patrick Hsieh [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, April 06, 2002 10:43 AM
Subject: Re: InnoDB is better than MyISAM ?
Hello Heikki Tuuri [EMAIL PROTECTED],
Where can I find InnoDB Hot Backup
Jeremy, Jocelyn,
can you try the following this patch?
The flag which bans MySQL using a descending cursor to calculate
column LIKE 'jhghj%' ORDER BY column DESC
queries was apparently put to the wrong place in ha_innodb.h. The assertion
I had added to 4.0.4 revealed this hidden bug.
The
flag.
- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, September 25, 2002 9:04 PM
Subject: Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...
Hi Heikki,
The query doesn't
into kkk(b) values (104);
Query OK, 1 row affected (0.00 sec)
mysql commit;
Query OK, 0 rows affected (0.00 sec)
mysql
---
regards,
IOD
---
--
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http
read performance of the Windows
2000 and XP file cache is to blame.
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: Dyego Souza
Hi!
Could you send me the file /mysql/sql/ha_innodb.cc so that I could check
what assertion fails in your snapshot of the source tree?
Thank you,
Heikki
Innobase Oy
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 26, 2002 12:37
Jocelyn,
- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 26, 2002 9:53 PM
Subject: Re: InnoDB
publication of benchmarks
without a permission from the vendor.
/PROVOCATIVE RANT
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 Message
Frank,
- Original Message -
From: Dr. Frank Ullrich [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 27, 2002 11:18 AM
Subject: Re: MyISAM or InnoDB
Heikki,
Heikki Tuuri schrieb:
Hi!
- Original Message -
From: Orr
Jungsu,
- Original Message -
From: Heo, Jungsu [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, September 28, 2002 9:34 AM
Subject: Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY..
Hello.
I have a problem on ALTER TABLE ... ADD FOREIGN KEY.
I'm using
into kkk(b) values (104);
Query OK, 1 row affected (0.00 sec)
mysql commit;
Query OK, 0 rows affected (0.00 sec)
mysql
---
regards,
IOD
---
--
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup
queries of type WHERE indexedcolumn LIKE 'abc%'
ORDER BY indexedcolumn DESC may return only rows where indexedcolumn='abc'.
Will be fixed in 4.0.5.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download
please guide me as to how to set up InnoDB and BDB to
work properly?
Thanks,
Paul
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
in 4.0.2, the
query cache, multi-table delete and update, and complex ORDER BY DESC
queries. Below it says col LIKE 'abc%' ORDER BY col DESC from InnoDB tables
contains a bug. But there may be other bugs still.
Thanks and best regards
Peter
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB
MySQL-Max-3.23.MyISAM + InnoDB + BDB
MySQL-Classic-4.0: (only available under a commercial non-GPL license):
MyISAM
MySQL-Pro-4.0: MyISAM + InnoDB
MySQL-Max-4.0: MyISAM + InnoDB + BDB
Thanks,
Scott Hathaway
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking
Philip,
- Original Message -
From: Philip Molter [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 02, 2002 4:16 PM
Subject: Re: MySQL/InnoDB-4.0.4 is released
On Wed, Oct 02, 2002 at 02:12:23PM
Puiu,
- Original Message -
From: Puiu Hrenciuc [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; Philip Molter
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 1:46 AM
Subject: Re: MySQL/InnoDB-4.0.4 is released
I hoped
Gelu,
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Puiu Hrenciuc [EMAIL PROTECTED]; Heikki Tuuri
[EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 2:40 PM
Subject: Re: MySQL
: Heikki Tuuri [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]; Puiu Hrenciuc [EMAIL PROTECTED];
Philip Molter [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 6:07 PM
Subject: Re: MySQL/InnoDB-4.0.4 is released
Gelu,
- Original
Gelu,
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; Puiu Hrenciuc
[EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 7:48 PM
Subject: Re: MySQL
and what queries could have been involved?
Do you have very many tables?
Does SHOW TABLE STATUS take long?
Are you sure you ran innodb_monitor and not innodb_lock_monitor?
Can you repeat the bug?
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https
, ... output truncated!\n);
+
return;
}
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:09 PM
Subject: Re: InnoDB hard lockup
Wayne,
please send me the whole MySQL error log.
Looks like some thread, which had
replication if a duplicate key error in the master is
propagated to the slave.
Thanks!
-James
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
of the table may be cached in the key_buffer of
the mysqld process.
--
Shane Allen [EMAIL PROTECTED]
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
Hi!
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Dyego Souza do Carmo [EMAIL PROTECTED]
Cc: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October 07, 2002 10:10 PM
Subject: Re: The secure mode in InnoDB
On Mon, Oct 07, 2002 at 01:53:25PM -0300
to REPEATABLE READ. You can then lower the InnoDB isolation
level by the command
SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL ...
Users porting from Oracle and other databases will find READ COMMITTED a
useful level.
-Mark
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row
(0.00 sec)
mysql commit;
Query OK, 0 rows affected (0.00 sec)
mysql select * from zhao;
++--+
| a | b|
++--+
| 10 | 20 |
++--+
1 row in set (0.00 sec)
mysql
- Original Message -
From: Jianliang Zhao [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED
... WHERE autoinccolumn 100 AND autoinccolumn =
110
?
Heo, Jungsu Mr.
SimpleX Internet. http://www.simplexi.com
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
Thanks!
nickg
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
sql query
-
Before posting
Rafa,
I fixed the optimization of the ORDER BY ... LIMIT 50 query on the generated
'clientes' table you sent in September. The fix is in 3.23.53. It will favor
index range scans even more over full index scans.
But the underlying problem is in the MySQL optimizer. It does not realize
that it
Owen,
- Original Message -
From: Owen Scott Medd [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: Nicholas Gaugler [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 09, 2002 5:44 PM
Subject: Re: mysqld Threads with Innobase
[ start stupid question ]
Does setting
Rafa,
it looks like the tuning I did to 3.23.53 fixes the optimization also in the
'albaranes' case below.
Lenz starts building of 3.23.53 this week. With good luck 3.23.53 is
available around Oct 17, 2002.
Best regards,
Heikki
Innobase Oy
heikki@hundin:~/mysql/client mysql test
Welcome to
Stephan,
- Original Message -
From: Stephan Hendl [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, October 11, 2002 12:16 PM
Subject: mysql-3.23.52 on hpux 11 with innodb
Hallo,
does anybody build a runtime version of mysql-3.23.52 with innodb on an
hp/ux 11.0, 64
/kernel combinations.
The following is the configuration of the cpu that runs mysql :
OS : Linux (Mandrake 8.2) kernel 2.4.3-20
Mysql : 4.0.4
CPU : Pentium III 800
RAM : 127 Mb
Best Regards
Andrea Forghieri
Emmegi S.p.A.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB
to search by the first field.
Regards,
Lourdes.
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
)
but it seems that it's not affected.
I have tried FOR UPDATE and LOCK IN SHARE MODE, the lock seems not
affected,
why ? thanks in advanced !
did you remember to
SET AUTOCOMMIT = 0
in the session of user A?
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key
System Administrator
National Electronic Attachment
Atlanta, Georgia
1-800-782-5150 ext. 1608
If it's not broketweak it
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
Shilline,
- Original Message -
From: Shilline Lee [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Sent: Monday, October 14, 2002 4:08 AM
Subject: Re: ROW LEVEL Locking not affected
And then ? please tell me the detail :)
if I SET AUTOCOMMIT = 0 in the session of user
at srv0srv.c, line 1621.
* Fixed a bug: SHOW INNODB STATUS on Unix always reported average file read
size as 0 bytes.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
-
Before posting, please check:
http://www.mysql.com
Kees,
thank you for notifying us.
I downloaded mysql-max-3.23.53-pc-linux-gnu-i686.tar.gz from ftp.sunsite.dk.
It does not contain InnoDB. It looks like The MySQL AB build master or the
web team have made an error. The error will be corrected as soon as
possible.
Regards,
Heikki Tuuri
Walt,
- Original Message -
From: walt [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 5:56 PM
Subject: Re: innodb not using correct index
Heikki Tuuri wrote:
Walt,
- Original Message -
...
Heikki,
Thanks
Mikhail,
- Original Message -
From: Mikhail Entaltsev [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October 21, 2002 2:34 PM
Subject: Re: Timestamp field in the InnoDB table
Heikki,
thank you for your response.
Is this a big problem?
Well
Mikhail,
- Original Message -
From: Mikhail Entaltsev [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October 21, 2002 1:11 PM
Subject: Timestamp field in the InnoDB table
Hi,
I have found one unclear place for me regarding to the timestamp field
Massimo,
- Original Message -
From: Massimo Petrini [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Sent: Tuesday, October 22, 2002 8:32 AM
Subject: foreign key
There is a way to verify the foreign key ?
If I put in my dump then instruction
SET FOREIGN_KEY_CHECKS=0;
I can
PROTECTED]
525 Camino de los Marquez, Ste 6 http://www.predict.com
Santa Fe, NM 87505
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
sql query
Christian,
- Original Message -
From: Christian Lizell [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, October 24, 2002 6:18 PM
Subject: Database in path to foreign key references
Hello!
Is there any way to get rid of the database name in the path to the
From: Heikki Tuuri
To: Serdioukov Edouard
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 29, 2002 7:23 PM
Subject: Re: InnoDB, Foreign Key
Edouard,
I tested this on Linux using mysql-max-3.23.51, the .tar.gz distro. It
worked ok.
Are you sure you were using 3.23.51? Starting from 3.23.50, InnoDB
Don,
- Original Message -
From: Don Arnett [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]
Sent: Tuesday, October 29, 2002 8:12 PM
Subject: logging
I'm new to this list. I couldn't find a search facility for searching
previous answers. If there is one, please let me know
Peter,
InnoDB does not allow the index name to be specified in a foreign key
constraint:
The syntax of a foreign key constraint definition in InnoDB:
[CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...)
REFERENCES table_name (index_col_name, ...)
[ON DELETE
Jannie,
- Original Message -
From: Jannie Qu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 29, 2002 10:18 AM
Subject: Create child table question
sql, query, mysql
Hi, all,
I met a problem with creating the following table: pub_user.
-- Parent table
CREATE TABLE
in the index.
Thanks in advance,
Rafa
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
How-To-Repeat:
Select Ped from Pedidos where
Rafa,
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, November 05, 2002 11:00 AM
Subject: DeadLock bug using mysql/Innodb
Description:
Hi Heikki,
In your case:
CREATE TABLE t (a INT NOT NULL, PRIMARY KEY (a)) TYPE = INNODB;
INSERT
).
Any ideas?
if you have on tape old images of ibdata files and ib_logfile's, you can try
crash recovery from them, possibly using innodb_force_recovery=6.
--
Michael T. Babcock
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http
Michael,
- Original Message -
From: Michael T. Babcock [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, November 07, 2002 4:36 PM
Subject: Re: InnoDB recovery
Heikki Tuuri wrote:
if you have on tape old images of ibdata files and ib_logfile's
was
released. Some of them might fix the problem.
Can you repeat the crash if you manually create temporary tables on the
master?
-JF
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
was
released. Some of them might fix the problem.
Can you repeat the crash if you manually create temporary tables on the
master?
-JF
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
Jon,
- Original Message -
From: Jon Frisby [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, November 09, 2002 12:17 AM
Subject: RE: Replication and temp tables...
Hrm, upon further digging it seems that this may be the offending query
offset of
a dump taken with mysqldump. Blocking all activity in the server with table
level locks is a way to force some binlog offset to your dumps.
Thank you,
Jing
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http
Mike,
thank you very much for a repeatable bug report!
This revealed an embarrasing bug in InnoDB SELECTs: if you selected with the
full value of a primary key, and the row which matched to it was
delete-marked, then InnoDB could in some cases return the NEXT row.
Since purge cleans off
manually, and did not let InnoDB to create
them and write them full? If yes, that explains why the tablespace size in
the tablespace header was not updated.
Thanks!
--shak
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http
. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
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
[EMAIL PROTECTED] | http://jeremy.zawodny.com
, and eventually dies without any
error
messages (except that the socket file doesn't exist - i.e. crash).
can you send me the error log
yourhostname.err
from the datadir of MySQL?
I could try to resolve stack traces from it if any.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL
Matt,
since you are using InnoDB, you cannot call server_end() and server_init()
again during the lifetime of the process. InnoDB does not clean up its
internal data structures in server_end().
Is there some special reason you would need to shut down the server and
open it again?
Regards,
Heikki
record, InnoDB could erroneously
return the NEXT record.
* Outstanding bugs: in 4.0.4 two bugs were introduced to AUTO_INCREMENT.
REPLACE can cause the counter to be left 1 too low. A deadlock or a lock
wait timeout can cause the same problem.
Best regards,
Heikki Tuuri
Innobase Oy
http
Dyego,
- Original Message -
From: Dyego Souza do Carmo [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, November 19, 2002 1:35 PM
Subject: The Error in InnoDB upgrading from 3.23.53 to 4.0.5
The log put this error :
InnoDB: Error: table ./wnotas25/ITEMREC has no
Dyego,
- Original Message -
From: Dyego Souza do Carmo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, November 19, 2002 2:33 PM
Subject: Bug on MySQL4.0.5 with InnoDB+TEMPORARY TABLES ?
Hello !
I recent migrate from 3.23 to 4.0.5 version and
in my
SQL SQL SQL SQL SQL SQL SQL
: Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com
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
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
sql query
...
Subject: Intermitent join problems
From: Frank Tuvell
Date: Tue, 19 Nov 2002 19:54:46
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
sql query
...
Subject: Intermitent join problems
From: Frank Tuvell
Date: Tue, 19 Nov 2002 19:54:46
.
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
..
Subject: innodb and table_cache
From: Rafal Jank
Date: Fri, 15 Nov 2002 13:44:14
David,
- Original Message -
From: David Mechner [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 20, 2002 1:59 PM
Subject: Re[2]: delete where column = null
Ok, so it seems to be a bug. What's the procedure for reporting it (or
do the developers read this
is around December 31th, 2002.
But I would encourage people to grab and compile the public 4.1 source tree
and test 4.1, especially the SQL subqueries in it. If you look at the bugs
mailing list, Jocelyn Fournier is doing an excellent job in alpha-testing
4.1.
Thanks,
Daniel
Best regards,
Heikki
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
-
Before posting, please check:
http
? ( this is very
important for me :( )
sql,query
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support
) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
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
sql query
register
mysqld-max-nt.exe as a 'service' in those operating systems, as explained in
the MySQL manual. You can then choose the service startup profile
(automatic/manual/disabled) from the Services section of the Control Panel.
Thanks in advance
Best regards,
Heikki Tuuri
Innobase Oy
---
Order
and perform updates?
a user can connect to slaves and perform any modifications to the data he
likes.
Carl McNamee
Systems Administrator
Billing Concepts
(210) 949-7282
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com
as a service. When I put it under
[WinMySQLadmin], the service starts but does not appear to have any
effect.
Any suggestions?
unfortunately, this is not possible in 3.23 or 4.0.
Version 4.1 will contain a feature which allows this.
Kindly,
Peter Boivin
[EMAIL PROTECTED]
Best regards,
Heikki
it be that mysql_data_home starts to point into some random
location?
I am forwarding this bug report to MySQL developers who know the mysqld
option processing best.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com
FOREIGN_KEY_CHECKS=1;
again. Then add the pages.
Bye,
sql,query
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support
Andrew,
could Jon Frisby's datadiff
http://freshmeat.net/projects/datadiff/?topic_id=66%2C822%2C836%2C861
help here?
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
computer to see if I can repeat this bug.
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
sql query
...
BBCi at http://www.bbc.co.uk
| a |
+---+---+
| 2 | 1 |
| 3 | 2 |
| 1 | 3 |
+---+---+
3 rows in set (0.01 sec)
mysql
...
I have found the simple solution, before the query I do this: SET
FOREIGN_KEY_CHECKS = 0. But it's not a good solution. Maybe you have
better solution.
Thanks.
ML
Best regards,
Heikki Tuuri
Innobase Oy
---
Order
?
:query
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub http://www.sayclub.com
NeoWiz http://www.neowiz.com
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
|
+---+---
--+
1 row in set (0.00 sec)
mysql
Paul Vincent Craven
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot
= ibdata1:50M:autoextend
autoextend is only available starting from 3.23.50. Please upgrade to
3.23.53a, as your MySQL version is very old!
...
Bruce A R Kuppers
B.Sc.(Hons), M.Sc., Ph.D.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See
are not modified or flushed out of the buffer pool, then there should be
hash searches.
Difficult to say anything in this case because I do not know the query load
nor EXPLAIN SELECTs.
Tony chen
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support
, or delete to release its next-key lock.
...
Thanks,
Joao.
sql, query.
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
have to use the following trick to init the auto-inc
counter to 100:
INSERT INTO table (99, ...);
DELETE FROM table WHERE yourautoinccolumn = 99;
Thank you,
Stefan Sturm
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
we use? 3.23.53 or 4.0.x? Which is the
best Version for InnoDB-Tables?
if you do not use replication or the new features in 4.0, then 4.0.5a is
probably the stablest InnoDB version already. Thus, 4.0 is the right
development platform.
Thanks for your help,
Stefan Sturm
Best regards,
Heikki
,
Sekhar
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
sql query
-
Before posting, please
101 - 200 of 1597 matches
Mail list logo