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
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
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
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
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
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
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
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
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
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
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
Joe,
this is a serious bug, because it can also spoil recovery from a backup.
What MySQL version and Linux kernel you are running? Do you use RAID or NFS?
How much RAM, how much swap partition of Linux?
What do the corrupt binlog file names look like? Please show us all binlog
files names, and
Jose,
if this occurs in an SQL query of type
... ORDER BY primarykey DESC
then this is probably the bug which is fixed in upcoming 4.0.4.
I hope 4.0.4 will be released in a few days.
Best regards,
Heikki
Innobase Oy
- Original Message -
From: jesus [EMAIL PROTECTED]
Newsgroups:
Rafa,
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, September 23, 2002 10:54 AM
Subject: optimizer bug in selecting fields that don´t belong to the index
used by mysql/innodb
Description:
Hello,
I wrote the following text in my
) thread schedulers may solve this problem.
Adrian Liang
Em: [EMAIL PROTECTED]
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
-max-nt.exe as a service.
M@
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
limit 2 GB.
key_buffer is global, not per-thread.
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
Best regards,
Heikki Tuuri
- Original Message -
From: Yuri [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, September 18, 2002 12:37 AM
Subject: Marketing materials ??
Hi,
I may get in position to protect
my choice of MySQL being confronted
by completely non-technical
management.
about
the first official 4.1 release? Any estimates?
My guess is December 15, 2002.
My previous guesses in the past 4 months have been 3 weeks too optimistic,
on the average :).
Best regards,
Iikka
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking
mysqld ended
Any idea of what could be causing this? Shouldn´t that library be
statically linked?
please download the latest MySQL-4.0.3. That should have the libraries
statically linked.
Many thanks and best regards,
Richard.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL
Rafa,
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, September 10, 2002 1:46 PM
Subject: MySql/InnoDB crashes after a Select...order by DESC... LIMIT...
Hello,
I am working with mysqld-max-nt under windows 2000 and unsing
Yuri,
ADD COLUMN should not affect a SELECT concurrently running on the table. I
tested this with a 3 million row InnoDB table.
Can you repeat that unexpected behavior?
Regards,
Heikki
Innobase Oy
Copied message:
...
Subject: Schema changes affect regular select?
From: Yuri
Date:
Duane,
yes, you can change the last data file as auto-extending.
Shut down mysqld, edit the my.cnf file, and start mysqld again.
Another solution is just to add another file ibdata2:
innodb_data_file_path = ibdata1:1000M;ibdata2:10M:autoextend
Best regards,
Heikki
Innobase Oy
Copied
? Or anything in the mysql logs?
Don't see any cores... here is the error log entry
mysqld got signal 10;
I think that in the manual, in the changelog of 4.0.4, it says that this bug
is fixed.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https
mysqld.exe from an MS-DOS prompt:
C:\mysql\bin mysqld --console
What does it print?
Use mysql.exe and mysqladmin.exe from an MS-DOS prompt to query and
administer the server. These have better diagnostics than graphical tools.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB
*/
FALSE, /* Initial state nonsignaled */
name);
ut_a(event);
return(event);
Thanks,
Neil Malkani
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
Alexander,
- Original Message -
From: Varshavchick Alexander [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 10:08 AM
Subject: RE: Performance Problems with InnoDB Row Level Locking...
Hi Heikki,
one more question please
Joe,
- Original Message -
From: Joe Shear [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 2:13 AM
Subject: Re: Performance Problems with InnoDB Row Level Locking...
Hi,
On a side note, are there any plans to backport the spurious insert
deadlock
using InnoDB tables on Linux 2.4.3 SMP
(Intel libc6)
(I should probably upgrade to 4.0.3)
yes, this bug was fixed in 4.0.2 I think. You may still get warnings to the
error log, but they are not fatal.
Amy
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https
of.
Thx.
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
Alex,
- Original Message -
From: Varshavchick Alexander [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 11:49 AM
Subject: Re: Performance Problems with InnoDB Row Level Locking...
Heikki, thank you for the answer. So
Wouter,
the Lock Monitor output tells that trx 370099 has been committed or rolled
back by the user. That is why the locks have disappeared.
Have you taken into account the following:
8.5 When does MySQL implicitly commit or rollback a transaction?
a.. MySQL has the autocommit mode switched
Query SELECT [t0.columns] FROM REQUEST t0 WHERE
t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION DATE ASC
14:47:09 22 Query commit
23 Quit
14:47:283 Query DROP TABLE innodb lock monitor
---End Query Log
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED
some help,
Wouter Zelle
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
Michael,
- Original Message -
From: Michael T. Babcock [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 05, 2002 5:15 PM
Subject: Bad table conversion
I was using phpMyAdmin to do some user management and since it was
fairly slow, decided to try
Michael,
- Original Message -
From: Michael T. Babcock [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Heikki Tuuri [EMAIL PROTECTED]
Sent: Thursday, September 05, 2002 6:03 PM
Subject: Re: Bad table conversion
Heikki Tuuri wrote:
what version you are using?
mysql Ver 11.18 Distrib
Michael,
- Original Message -
From: Michael T. Babcock [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 05, 2002 6:37 PM
Subject: Re: Bad table conversion
Victoria Reznichenko wrote:
Michael, MySQL privilege tables MUST be MyISAM:
Alexander,
- Original Message -
From: Varshavchick Alexander [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, September 05, 2002 6:51 PM
Subject: Re: Performance Problems with InnoDB Row Level Locking...
Heikki, one little question
Steve,
- Original Message -
From: Orr, Steve [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 05, 2002 9:49 PM
Subject: RE: Performance Problems with InnoDB Row Level Locking...
Hello again Heikki and thanks for your informative reply
take some time if Jane's
mugshot is large. If Bill's query starts before Jane's transaction commits,
Bill won't see Jane at all on his new-users page, even if Jane's insertion
into some of the tables is complete.
Regards,
Heikki
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED
Steve,
- Original Message -
From: Orr, Steve [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]
Sent: Thursday, September 05, 2002 11:04 PM
Subject: RE: Performance Problems with InnoDB Row Level Locking...
Heikki,
You wrote...
You are getting so many deadlocks that some
Steve,
- Original Message -
From: Orr, Steve [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 1:23 AM
Subject: RE: Performance Problems with InnoDB Row Level Locking...
Heikki,
Next-key locking in InnoDB allows you
= the number of indexes, if you have defined a primary key.
Since there are max 4 billion pages in the tablespace, you can calculate the
max number of tables from this formula. We can say InnoDB supports up to 4
billion tables.
Thanks,
José Lourenço
Best regards,
Heikki Tuuri
Innobase Oy
Javier,
- Original Message -
From: Javier Diaz [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] (E-mail) [EMAIL PROTECTED]
Sent: Tuesday, September 03, 2002 12:32 PM
Subject: RE: Inno DB Question
Heikki,
Thanks for your answer. I was yesterday making
Sekhar,
do your updates have good indexes through which they can access only the
rows they are going to update?
From section 8.4 of http://www.innodb.com/ibman.html:
UPDATE ... SET ... WHERE ... : sets an exclusive next-key lock on every
record the search encounters
From section 8.5:
a..
transaction and releases all locks.
You should check the return value of your queries and look if they are
reporting lock wait timeouts or other errors.
I would really appreciate some help,
Wouter Zelle
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https
Javier,
it may be that the dbExpress interface is still lagging behind MySQL
development.
If I recall right, people have complained loudly in Borland newsgroups that
dbExpress created a new connection for each SQL query it issues to MySQL.
That makes the use of transactions impossible with it.
Yuri,
looks like InnoDB was trying to allocate 4 GB + 232 bytes.
A major bug in the 64-bit version was fixed in 3.23.52:
July 20, 2002: On 64-bit computers updating rows whichcontained the SQL NULL
in some column could cause theundo log andthe ordinary log to become
corrupt. Fixed in 3.23.52.
Steven,
I assume you are running on Linux, since you were able to resolve the stack
traces. Which distro: rpm or .tar.gz?
I am right now running all my stress tests on 4.0.3 on the .tar.gz distro on
a 4-way Linux-2.4.16-64GB-SMP, and it seems to work.
Your bug is probably query- or
regards,
Heikki Tuuri
Innobase Oy
---
http://www.innodb.com, download MySQL/InnoDB from http://www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Harald Fuchs writes:
In article 007401c24e65$83a49520$a1f6d5d4@omnibook,
Heikki Tuuri [EMAIL PROTECTED] writes:
Full changelogs are shown below. Compared to 4.0.2, also all the changes
of
3.23.52 are included in 4.0.3.
[ Lots of good stuff deleted ]
Heikki,
I think there's something missing
Dan,
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Harald Fuchs [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 6:10 PM
Subject: Re: MySQL/InnoDB-4.0.3 is released
In the last episode (Aug 28), Harald Fuchs said:
I think
,
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
mysqldump will dump tables in the wrong order, it seems to dump
tables sorted alphabetically.
How-To-Repeat
(FALSE);
}
thanks for your help,
Joe
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
Hi!
My guess is that 4.0.3-beta will be released on August 30, 2002.
I guess 4.0 will be labeled as stable in March 2003.
I guess 4.1 will be released as a binary in December 2002.
Let us see how these guesses fare :). Users can speed up stabilization by
using 4.0 and submitting detailed bug
Hi!
Like the manual states, CREATE TABLE, INSERT etc. database operations are
blocked when 'newraw' is specified. That is a safety measure. You must not
forget 'newraw' to my.cnf, as that will wipe over the partition at the next
startup.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: Massimo Petrini [EMAIL PROTECTED]
Sent: Monday, August 19, 2002 12:52 PM
Subject: Re: new command in 3.23.52 - innodb database schema dump
Massimo,
it was changed to
SET FOREIGN_KEY_CHECKS = 0;
Please look
, reporting an internal error 17. Fixed in 3.23.49 and 4.0.2.
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: áÌÅËÓÁÎÄÒ
allocation in my.cnf.
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: spiros [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
, then probably your
network library is buggy. In Compaq Alpha C and C++ variables have to be
aligned to machine addresses divisible by 4 or 8, which is not required in
Intel x86. Looks like some variable in the library is not aligned.
Anyone knows the solution?
Thanx,
Yuri.
Best regards,
Heikki Tuuri
Yuri,
- Original Message -
From: Yuri [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, August 17, 2002 5:13 PM
Subject: Re: InnoDB on FreeBSD-Alpha problem
Heikki,
I get the mysqld compiling/running
ok. DB dump is restored ok locally
Eric,
try using the mysqlbinlog program from some other version, maybe 4.0.0, or
3.23.xx.
I noticed a similar bug a while ago. mysqlbinlog seg faulted on a binlog
file.
I am forwarding this bug report to our replication expert.
Best regards,
Heikki
...
Hi,
I deleted a db I
.
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-mail [EMAIL
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: Serge Paquin [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, August 16
a MySQL shop I suggest you look at the
business reasons why and use those reasons to argue your case for you.
Technical coolness or altruistic support of the open source movement doesn't
cut it with most managers. Productivity, cost, and support usually does.
John Griffin
Best regards,
Heikki Tuuri
Hi!
- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 7:16 PM
Subject: Re: MySQL vs. Oracle (not speed)
Hi,
Does the MySQL-4.1 development tree publicly available (if so, on which
port
Mary,
you could try downloading MySQL-Max-3.23.52 for Windows and converting your
tables to the InnoDB format.
Your tables maybe take some 500 MB of space in InnoDB. If you have a
reasonably big Windows server with 500 MB RAM, they will fit completely in
the buffer pool if you configure it big
is recommended because 4.0.1 is an alpha version, and
already 8 months old.
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
Jacob,
- Original Message -
From: Devore, Jacob [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 12:20 AM
Subject: RE: Losing data
can one change a table from MyISAM tables into something else on the fly?
ALTER TABLE tablename TYPE = sometype
databases? If yes, please check the manual about the exact behavior in
such cases. Also check the changelogs after 3.23.49.
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
Lutz,
- Original Message -
From: Lutz Maibach [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Sent: Tuesday, August 13, 2002 5:09 PM
Subject: Re: Rename Table in Replication failed / command missing in slave
log
Hi Heikki,
Lutz' problem looks like somethig different
254 38 Helsingborg, Sweden
Direct: +46 42 389918
Phone: +46 42 389900
e-mail: [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
Julian,
the crash probably means the table is corrupt. That is a very basic query
you run. Difficult to believe in any bug in SQL itself.
Please dump your tables.
Then upgrade to MySQL-Max-3.23.51. It is best to use an official binary.
Then run CHECK TABLE on the table statcache. What does it
William,
- Original Message -
From: William R. Mussatto [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, August 12, 2002 10:29 PM
Subject: Re: Found cause of crash - simple SQL statement.
Pardon my ignorance, what Linux table corruption and what
that is a
different binary and does not help too much in resolving a stack trace from
the .tar.gz distro.
Thank you for the bug report! It is essential that the .sym file is good in
a distribution so that we can find the bugs.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row
,
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 posting, please check:
http://www.mysql.com
, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 3.23.51: up 63 days, processed 1,335,360,828 queries (241/sec. avg)
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com
Colin,
what version of MySQL you are running and on what OS?
The assertion means there is an attempt to reference a pointer which does
not point to the buffer pool. It might be memory corruption or table
corruption.
If you have updated to new disk drives in Linux, best to check if there are
operation MySQL spins off a transaction which is
separate from the current user transaction. Also most other DBMS brands do
not provide rollback on CREATE TABLE or DROP TABLE, for example.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support
Ben,
I have added the following item to the TODO list of September 2002. I guess
it will appear only in the MySQL-4.0 branch, as 4.0 will be the new stable
branch within a few months.
...
September, 2002:
Add a global MySQL my.cnf option autocommit_default=0.
...
Best regards,
Heikki Tuuri
Ben,
- Original Message -
From: Ben Goswami [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 29, 2002 4:40 PM
Subject: Re: how to set autocommit
Heikki ,
Thanks for your reply. So what should I do in the mean time. Is there a
work around
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
Copied message from Miguel:
...
At 19:07 25/7/2002 -0700, Bhavin Vyas wrote:
Hi,
From what
901 - 1000 of 1597 matches
Mail list logo
