Alexandre,
Monday, June 03, 2002, 8:08:14 PM, you wrote:
AZ Maybe this thread has already been solved. If so im sorry for the disturb.
AZ Here is my problem:
AZ I want to use InnoDB transactionnal table types with mysql on Windows 2000 .
AZ I set my ini file correctly, start the console and
-Message d'origine-
De : Alexandre Zglav [mailto:[EMAIL PROTECTED]]
Envoyé : lundi, 3. juin 2002 19:05
À : mysql (Elektronikus levelek)
Objet : InnoDB and Windows
Hello all .
Nice to meet you.
Maybe this thread has already been solved. If so im sorry for the disturb.
Here is my
Jeremy,
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, May 30, 2002 8:43 PM
Subject: Re: innodb rollbacks
On Thu, May 30, 2002 at 12:16:28PM +0300, Heikki Tuuri wrote:
However, if there are lots
Hi!
Please check that you are using = 3.23.50.
I tested this on Win NT-4.0 with 3.23.52, and it worked:
mysql CREATE TABLE parent(id INT NOT NULL,
- PRIMARY KEY (id)) TYPE=INNODB;
Query OK, 0 rows affected (0.14 sec)
mysql CREATE TABLE child(id INT, parent_id INT,
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: Jeremy Zawodny [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, May 30, 2002 6:31 AM
Subject: Re: innodb
Arul,
do the equivalent of
mysqladmin variables | grep 'inno' | less
and check that innodb is up and running.
Thomas
--
sql, query
On Thu, 30 May 2002, Arul wrote:
Hi All
First of all i would like to know the basic difference between Inno DB and
My ISAM Table types..
I wanted mySQL
Arul,
Thursday, May 30, 2002, 2:05:52 PM, you wrote:
A First of all i would like to know the basic difference between Inno DB and
A My ISAM Table types..
Check the manual:
http://www.mysql.com/doc/T/a/Table_types.html
A I wanted mySQL to support AutoIncrement , Transactions,Foreign Key
A
On Thu, May 30, 2002 at 12:16:28PM +0300, Heikki Tuuri wrote:
However, if there are lots of updates, and the user has a dangling
uncommitted consistent read to the database for a long time, then the size
of the undo logs may become significant also in InnoDB. I have to consider
adding the
On Thu, May 30, 2002 at 10:43:58AM -0700, Jeremy Zawodny wrote:
: Heikki,
:
: That reminds me of an InnoDB wish-list item I have. I like the level
: of detail provided in the InnoDB monitor output. However, I'd really
: like to be available via MySQL rather than just in the logs. That
: will
On Thu, May 30, 2002 at 02:30:07PM -0500, Philip Molter wrote:
On Thu, May 30, 2002 at 10:43:58AM -0700, Jeremy Zawodny wrote:
: Heikki,
:
: That reminds me of an InnoDB wish-list item I have. I like the level
: of detail provided in the InnoDB monitor output. However, I'd really
: like
On Wed, May 29, 2002 at 12:13:49AM -0700, Jeremy Zawodny wrote:
Heikki,
After a good 6-8 hours of runnning, the server just restarted itself
(running the most recent build from the 3.23.xx tree, as you
suggested).
Just for the record, it happened again. So it's reproducable to a
dregree.
Jeremy,
I think this happens because the InnoDB transaction handle has already been
freed in end_thread when MySQL still writes one log item for the connection.
Please test the following patch. Replace the function
innobase_close_connection with the one below. I forgot to set innobase_tid
to
On Tue, May 21, 2002 at 10:41:51AM -0400, walt wrote:
Thanks for your reply Jeremy!
I'm an Oracle person, so I tend to think of things being in multiple
files/tablespaces.
Right.
Do you know if there is a way to view the rollback stats?
I checked the InnoDB monitor (details in the
Jeremy,
can you build your own 3.23.51? There is actually the same memory overwrite
bug in gethostname_r of glibc/Linux in .49a as in .50.
If you build mysqld yourself you can run it inside gdb and do bt full when
it crashes. That might help in tracing the bug.
The assertion failure below
On Tue, May 28, 2002 at 10:59:45PM +0300, Heikki Tuuri wrote:
Jeremy,
can you build your own 3.23.51? There is actually the same memory
overwrite bug in gethostname_r of glibc/Linux in .49a as in .50.
I'll install 3.23.51 tonight. I have been doing daily builds of the
3.23 and 4.0 tree for
On Tue, May 28, 2002 at 10:59:45PM +0300, Heikki Tuuri wrote:
Jeremy,
can you build your own 3.23.51? There is actually the same memory overwrite
bug in gethostname_r of glibc/Linux in .49a as in .50.
Come to think of it, if that's what caused the problem, wouldn't this
solve it for now in
, May 28, 2002 11:18 PM
Subject: Re: InnoDB crash on 3.23.49a...
On Tue, May 28, 2002 at 10:59:45PM +0300, Heikki Tuuri wrote:
Jeremy,
can you build your own 3.23.51? There is actually the same memory
overwrite
bug in gethostname_r of glibc/Linux in .49a as in .50.
Come to think
On Tue, May 28, 2002 at 01:16:28PM -0700, Jeremy Zawodny wrote:
On Tue, May 28, 2002 at 10:59:45PM +0300, Heikki Tuuri wrote:
Jeremy,
can you build your own 3.23.51? There is actually the same memory
overwrite bug in gethostname_r of glibc/Linux in .49a as in .50.
I'll install
Guys, i get the following error. What does this mean?
DBI-connect(myskycastle) failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2) at teamstats.pl line 16
-
Before posting, please
On Mon, May 27, 2002 at 01:33:30PM -0600, Sherzod B. Ruzmetov wrote:
Guys, i get the following error. What does this mean?
DBI-connect(myskycastle) failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2) at teamstats.pl line 16
Please *don't* hijack
, 2002 3:16 AM
Heikki Subject: Re: InnoDB, possible bug?
I am using mysql 4.0.1-alpha on Linux 2.4.18, the info you requested is:
select count(*) from newsentries10 where playerid=28575 and type=2;
+--+
| count(*) |
+--+
| 4218 |
+--+
1 row in set (13.81 sec)
mysql
On Mon, May 20, 2002 at 12:25:26PM -0400, walt wrote:
Does anyone know where rollbacks are stored for innodb tables? I
assume memory since I keep getting a table full error when trying to
drop an index. sql,query
I'm not exactly sure what you're asking, but the rollback information
needs
On Tuesday 21 May 2002 12:24 am, Jeremy Zawodny wrote:
On Mon, May 20, 2002 at 12:25:26PM -0400, walt wrote:
Does anyone know where rollbacks are stored for innodb tables? I
assume memory since I keep getting a table full error when trying to
drop an index. sql,query
I'm not exactly
Andrei,
how many rows in ne satisfy
(1) ne.playerid=28575,
(2) ne.type=2?
What version you are using? .48 was tuned to favor index searches over table
scans.
What does EXPLAIN SELECT say if you force the index usage with USE INDEX and
STRAIGHT JOIN clauses?
Best regards,
Heikki Tuuri
(0.00 sec)
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 21, 2002 12:40 PM
Subject: Re: InnoDB, possible bug?
Andrei,
how many rows in ne satisfy
(1) ne.playerid=28575,
(2) ne.type=2?
What
and latest news on InnoDB
- Original Message -
From: Andrei Cojocaru [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; Mysql List
[EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 3:16 AM
Subject: Re: InnoDB, possible bug?
I am using mysql 4.0.1-alpha on Linux 2.4.18, the info you requested
maxim wrote:
Hi? all
Can i use InnoDB tables in MySQL Max for Win9x ?
Thanks...
Hi Maxim,
Yes, if you use the -max version, you can.
--
--
\|/ __\|/
`@ / o . \ @' Microsoft? Por acaso é alguma nova
/___| \/ |___\
Daniel,
- Original Message -
From: Daniel Rand [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, May 13, 2002 5:24 PM
Subject: InnoDB Foreign Key Constraints
Hi,
Does anyone know if it's possible to set up a foreign key constraint where
one table references the
At 17:26 -0300 5/10/02, Edilson Vasconcelos de Melo Junior wrote:
Hi,
What versions of mysql support innodb tables? What about 3.23.45 or 3.23.47?
Both versions, but only if you
- Compile from source using the --with-innodb option when you configure MySQL
- Use a -max distribution, if you use a
is not mine :( How do i know if the source was compiled
with --with-innodb option?
Thank u very much,
Edilson.
-Mensagem original-
De: Paul DuBois [mailto:[EMAIL PROTECTED]]
Enviada em: sexta-feira, 10 de maio de 2002 17:47
Para: Edilson Vasconcelos de Melo Junior; MYSQL
Assunto: Re
Oren,
what MySQL version you are running? What OS?
Send me a copy of your my.cnf, the error log 'hostname'.err, and the exact
sequence of SQL statements you used to crash InnoDB, including the table
CREATE statements. Did InnoDB run out of tablespace?
Regarding the performance, did you set
as recommended in section
2 of http://www.innodb.com/ibman.html.
Regards,
Heikki
- Original Message -
From: Oren Zeev-Ben-Mordehai [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Sent: Tuesday, May 07, 2002 5:26 PM
Subject: RE: innodb tables problem
my.cnf
--
[mysqld
Hi,
We are currently facing the same problem (Deadlock found when trying to
get lock; Try restarting transaction)
in our production environnement. We are using InnoDB tables (mysqk
3.23.48-max) with
Jboss 2.4.4 and JDBC driver mm.mysql-2.0.11-bin.jar / RedHat 7.1.
Could you please tell me how to
On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri wrote:
Mark,
if you do not explicitly do
SET AUTOCOMMIT=0
then MySQL automatically calls COMMIT after every SQL statement.
Make that:
SET AUTOCOMMIT=1
Heikki is probably low on coffee. :-)
Jeremy
--
Jeremy D. Zawodny, [EMAIL
Jeremy,
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 9:37 AM
Subject: Re: InnoDB transactions with Connection Pooling
On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri wrote
Samim,
- Original Message -
From: Samim [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, April 22, 2002 11:31 AM
Subject: InnoDB, BDB
Hello,
This question is probably repeated each week, but I am an absolute
beginner
with MySQL. Sorry for that. I've installed the
Samim,
Monday, April 22, 2002, 11:20:48 AM, you wrote:
S This question is probably repeated each week, but I am an absolute beginner
S with MySQL. Sorry for that. I've installed the precompiled binaries for Win,
S and I am very satisfied with MySQL. The only thing I couldn't find is
S support
Ang,
Monday, April 22, 2002, 12:24:58 PM, you wrote:
AHK Quote from mysql online documentations:
AHK As of Version 4.0.1, MySQL can also perform boolean
AHK full-text
AHK searches using the IN BOOLEAN MODE modifierA
AHK boolean full-text
AHK search can also work even without a FULLTEXT
Jesper,
what may have happened is that InnoDB created the data files, but because
memory ran out, it did not have time to update the tablespace header to
reflect the size increase by those two data files.
Later when you added yet another data file, it increased the size stored in
the tablespace
Richard,
- Original Message -
From: Richard Harms [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, April 22, 2002 2:32 AM
Subject: InnoDB Error 150, MySQL 4.0.1 alpha 3.23.49
Hello,
When attempting to create some tables using the MySQL 4.0.1 alpha and
3.23.49,
Mark,
if you do not explicitly do
SET AUTOCOMMIT=0
then MySQL automatically calls COMMIT after every SQL statement.
If you set AUTOCOMMIT=0, then you should yourself call COMMIT after each
SELECT so that you do not leave a dangling transaction open in the database
and that you get a fresh
Rodrigo,
from the manual:
If the disk becomes full you may want to add another data file to another
disk, for example. Then you have to look the size of ibdata1, round the size
downward to the closest multiple of 1024 * 1024 bytes (= 1 MB), and specify
the rounded size of ibdata1 explicitly in
PROTECTED]
Sent: Friday, April 12, 2002 3:51 PM
Subject: Re: InnoDB
Rodrigo,
from the manual:
If the disk becomes full you may want to add another data file to another
disk, for example. Then you have to look the size of ibdata1, round the
size
downward to the closest multiple of 1024 * 1024
Rodrigo,
- Original Message -
From: Rodrigo Gonzalez [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]
Sent: Friday, April 12, 2002 10:27 PM
Subject: Re: InnoDB
You are right, I didnot see this section so well
BTW: I am really interested
Is just a tunning problem?Well, no problem, I continue testing
Regards.
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: Rodrigo Gonzalez [EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]
Sent: Friday, April 12, 2002 4:38 PM
Subject: Re: InnoDB
Rodrigo
On Tue, Apr 09, 2002 at 10:17:56AM +0200, Luke van Blerk wrote:
Hi everyone,
I've been reading up about InnoDB tables and they seem to have lots
of advantages. I'm particularly interested in using the foreign keys
as this will save me some much need time. In the benchmark tests on
the
Luke,
How exactly will the foreign keys save you time? Please explain.
Ric.
- Original Message -
From: Luke van Blerk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 9:17 AM
Subject: InnoDB tables
Hi everyone,
I've been reading up about InnoDB tables and
-
From: Richard Clarke [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 2:11 PM
Subject: Re: InnoDB tables
Luke,
How exactly will the foreign keys save you time? Please explain.
Ric.
- Original Message -
From: Luke van Blerk [EMAIL PROTECTED]
To: [EMAIL
Heiki,
I have a question concerning the new auto-extending function (which sounds
really cool by the way!). How does it handle the case where it runs out of
disk space while expanding? Will it gracefully handle this scenerio or will
some sort of recovery be necessary?
Carl McNamee
Systems
:53 PM
Subject: RE: InnoDB
Heiki,
I have a question concerning the new auto-extending function (which sounds
really cool by the way!). How does it handle the case where it runs out
of
disk space while expanding? Will it gracefully handle this scenerio or
will
some sort of recovery
it.
-JF
-Original Message-
From: Richard Clarke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 5:11 AM
To: [EMAIL PROTECTED]
Subject: Re: InnoDB tables
Luke,
How exactly will the foreign keys save you time? Please explain.
Ric.
- Original Message -
From
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
Hi,
Generally, an apache setup will kill a PHP enabled page when it has run for
30 seconds. Also, when a php script exits, all connections to the database
are closed, so somwhere you need to keep the results of your script somwhere
(hidden HTML variables, URI string), otherwise, when you change
Hi,
On Sat, Apr 06, 2002 at 03:57:39PM -0500, Victor wrote:
Suppose that a query begins with begin. Then a couple inserts happen but
before the commit statement is executed, the client hits stop in the
browser. What is going to do the rollback? If there is a persistent
connection, is it
Hi!
- Original Message -
From: Rodrigo Gonzalez [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, April 05, 2002 8:59 PM
Subject: InnoDB
First of all excuse my english...I hope someone can understand me
I am thinking in converting from MyIsam to InnoDb tables.
How can I download this version?
Regards
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 4:07 PM
Subject: Re: InnoDB
Hi!
- Original Message -
From: Rodrigo Gonzalez [EMAIL PROTECTED]
Newsgroups
At 01:54 PM 4/5/2002, you wrote:
I have seen many people saying that InnoDB is a great deal, that InnoDB
rocks, etc. and I am concerced about how much better InnoDB is compared to
MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB
have foreign keys support, but I deal
On Fri, 5 Apr 2002, BD wrote:
At 01:54 PM 4/5/2002, you wrote:
I have seen many people saying that InnoDB is a great deal, that InnoDB
rocks, etc. and I am concerced about how much better InnoDB is compared to
MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB
have
Hi!
- Original Message -
From: Eric S [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, April 06, 2002 2:10 AM
Subject: Re: InnoDB is better than MyISAM ?
On Fri, 5 Apr 2002, BD wrote:
At 01:54 PM 4/5/2002, you wrote:
I have seen many people saying that InnoDB
:10 AM
Subject: Re: InnoDB is better than MyISAM ?
On Fri, 5 Apr 2002, BD wrote:
At 01:54 PM 4/5/2002, you wrote:
I have seen many people saying that InnoDB is a great deal, that InnoDB
rocks, etc. and I am concerced about how much better InnoDB is compared
to
MyISAM tables. Can
Hi!
We apologize for the delay in releasing 3.23.50. InnoDB-3.23.50 has been
ready for 2 weeks now.
The problem is that Monty wants to compile on Linux the MySQL binaries with
gcc-3.0.4 and a rather new glibc version, and that combination does not seem
to produce stable binaries of MySQL. I
Graig,
I've been using mysql for about a year now on a linux machine and it has not
crashed or had any corrupted tables in that time. I believe mysql is just as
good in stability and safety of data has it is in speed.
Mike
- Original Message -
From: Scalper [EMAIL PROTECTED]
To: [EMAIL
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
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 25 March 2002 07:59
To: Sean O'Donnell
Subject: Re: InnoDB books
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one
Core MySQL
ISBN: 0130661902
http://shop.barnesandnoble.com/booksearch/isbnInquiry.asp?isbn=0130661902
[EMAIL PROTECTED] wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 25 March 2002 07:59
To: Sean O'Donnell
Subject: Re: InnoDB books
Your message
for the online manual and latest news on InnoDB
-Original Message-
From: Gabriel Ricard [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Monday, March 25, 2002 7:12 PM
Subject: Re: InnoDB books
Core MySQL
ISBN: 0130661902
http://shop.barnesandnoble.com/booksearch
Alex,
the assertion means that when InnoDB looks for a father node pointer to a
page in the B-tree, it ends up on a pointer which does not point to the
child page. In other words, the B-tree is corrupt.
I see that the lsn of your database is rather small. Did you do anything
special before the
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
Nico,
-Original Message-
From: Nico Sabbi [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Friday, March 15, 2002 1:42 PM
Subject: Innodb replication and Database renaming question
Hi,
I'm still using Mysql 3.23.46 because, as far as I remember, in .47 was
reintroduced the
We have the same problem as Victoria, and the --default-table-type option
does not work.
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 15, 2002 1:38 PM
Subject: innodb or Berkeley DB default for mysql max
Kemp,
Thursday,
Hi,
you can see the monitor's output in the logfile. In my case (mandrake linux), it is in
/var/lib/mysql and I do:
tail -f /var/lib/mysql/SERVERNAME.err
Also, where do I designate autocommit = 0;
Use SET AUTOCOMMIT = 0 as a SQL query. Just issue it where you do your SELECT,
UPDATE etc.
Hi,
does any1 know what is the earliest version of Mysql
for Solaris, with support for InnoDB?
If I am not mistaken, the version that we have is
3.23.32.
Can MySql Max be added or some patch be added?
This is not on a personal machine. It's on a server
in my department (computer's science)
On Wed, Mar 06, 2002 at 06:19:53AM +0100, Eberhard Lisse wrote:
Hi,
I run SuSe 7.2 and have upgraded to the current suse versions of
mysql.
Server version 3.23.41-Max-log
Protocol version10
Connection linux.lisse.na via TCP/IP
TCP port3306
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
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 of
At 04:18 2002-03-05, you wrote:
Tomasz,
are you running on Windows?
No, Linux 2.2.17
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
At 04:18 2002-03-05, you wrote:
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,
Re: 9.1: Well, can't find innodb* anywhere on the system
Re: 15.1: The second
Hi!
Tobias Hi!
Tobias I'm in the same position as Steve: Considering switching from MyISAM to InnoDB
because of the
Tobias row-level locking capabilities. My application has quite a lot of
updates/inserts mixed with
Tobias selects, and is starting to suffer from the table-locking policy...
Thanks - that would be great!
I'm sure a lot of people will find this very helpful.
Regards,
Tobias
- Original Message -
From: Michael Widenius [EMAIL PROTECTED]
To: Tobias Lind - Telia Internet [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, March 05, 2002 12:36 PM
Subject: Re
: [EMAIL PROTECTED]
Subject: Re: InnoDB frightens me...
Thanks - that would be great!
I'm sure a lot of people will find this very helpful.
Regards,
Tobias
- Original Message -
From: Michael Widenius [EMAIL PROTECTED]
To: Tobias Lind - Telia Internet [EMAIL PROTECTED]
Cc
on replication issues.
Steve Rapaport.
] -Original Message-
] From: Tobias Lind - Telia Internet [mailto:[EMAIL PROTECTED]]
] Sent: Tuesday, March 05, 2002 1:46 PM
] To: [EMAIL PROTECTED]
] Cc: [EMAIL PROTECTED]
] Subject: Re: InnoDB frightens me...
]
]
] Thanks - that would be great!
] I'm
On Tue, Mar 05, 2002 at 09:58:13PM +0100, Steve Rapaport wrote:
I sure would, thanks Monty and Tobias. In particular some sample
update/insert/delete db code for MyISAM vs. InnoDB, (especially in
the case where you're not adding transactions, just trying to take
advantage of row-locking.)
- Telia Internet; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: InnoDB frightens me...
On Tue, Mar 05, 2002 at 09:58:13PM +0100, Steve Rapaport wrote:
I sure would, thanks Monty and Tobias. In particular some sample
update/insert/delete db code for MyISAM vs. InnoDB, (especially in
the case
Hi!
I'm in the same position as Steve: Considering switching from MyISAM to InnoDB because
of the
row-level locking capabilities. My application has quite a lot of updates/inserts
mixed with
selects, and is starting to suffer from the table-locking policy...
And like Steve, I'm also scared! :)
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 03, 2002 6:46 AM
Subject: Re: InnoDB frightens me...
Steve,
I added an item to the TODO list at http://www.innodb.com/todo.html
..
May, 2002:
Make a data file auto-extendible. You can specify the last data file
On Mon, Mar 04, 2002 at 09:30:16AM -0500, Ken Menzel wrote:
Hi Heikki,
I don't know if this has been requested, but what about a tool to
'pre-create' dataspace? This tool would allow someone to create a
new dataspace, then a quick restart (After adding the name of the
space to 'my.cnf')
On Monday 04 March 2002 09:32 pm, you wrote:
On Mon, Mar 04, 2002 at 09:30:16AM -0500, Ken Menzel wrote:
Hi Heikki,
I don't know if this has been requested, but what about a tool to
'pre-create' dataspace? This tool would allow someone to create a
new dataspace, then a quick restart
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
Steve,
I added an item to the TODO list at http://www.innodb.com/todo.html
..
May, 2002:
Make a data file auto-extendible. You can specify the last data file in
innodb_data_file_path like this:
ibdata1:50Mautoextend
It will create a data file whose initial size is 50 MB, and InnoDB will
On Sat, Mar 02, 2002 at 11:14:42PM +0100, Steve Rapaport wrote:
I'm seriously considering switching to mysql-max so I can make my
session handling table an Innodb type. Currently the mysql locking
policy allows big traffic jams when several sessions are active
simultaneously, and it's the
On Sat, Mar 02, 2002 at 06:52:57PM -0800, Jeff Kilbride wrote:
I'm looking to make the move to InnoDB, too. All I've heard is positve.
Here's a reply I got on another list:
If you have a very busy read/write op database, MyISAM can't handle
it. It's very efficient
...
I may have posted the same question here, earlier. I'd appreciate any input.
Thanks,
--jeff
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Jeff Kilbride [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Saturday, March 02, 2002 7:11 PM
Subject: Re: InnoDB
Rick,
sorry, it is not mentioned in the manual that MySQL performs a CREATE INDEX
by doing an ALTER TABLE. And ALTER TABLE has the feature (= documented bug)
that it removes foreign key definitions.
You should define all your indexes within the table create statement, like
in:
CREATE TABLE
--- Heikki Tuuri [EMAIL PROTECTED] wrote:
Rick,
sorry, it is not mentioned in the manual that MySQL
performs a CREATE INDEX
by doing an ALTER TABLE. And ALTER TABLE has the
feature (= documented bug)
that it removes foreign key definitions.
Heikki:
Is there a fix planned for the alter
Science
757 S.Raymond
Pasadena, CA 91105
Tel: 626-584-5900
email: [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 2:26 PM
To: Demirchyan Oganes-AOD098
Subject: Re: InnoDB question
Your message cannot be posted
, February 25, 2002 2:34 PM
To: '[EMAIL PROTECTED]'
Subject: RE: InnoDB question
Hello everyone,
I have this database, I'm using InnoDB type tables. I wanted
to know the
following:
How can I manipulate the tables, so that db supports multiple
users trying
to access the same table
On Mon, Feb 25, 2002 at 02:44:45PM -0800, Eric Mayers wrote:
Oganes,
It sounds like what you want is row-level-locking. This is a
feature of InnoDB tables. It allows users to write to a table while
other users are reading from the same table. Of course, they cannot
read and write the
Hi Nilesh,
On Thu, 2002-02-21 at 15:14, Nilesh Deshpande wrote:
I am using MySQL database
I just wanted to use transaction.so as per manual i
have to make table type as Innodb.
Then i had set Innodb startup options as follows
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
At 21:14 20/02/2002 -0800, Nilesh Deshpande wrote:
Hi!
Very strange the printed messages you sent.
What MySQL release version are you using ? I did the test with
your start InnoDB set with 3.23.48 and got:
c:\mysql\binmysqld-max --standalone --console
InnoDB: The first specified data file
At 21:14 20/02/2002 -0800, Nilesh Deshpande wrote:
Hi,
Now I assume that the text you sent is from our documentation.
For to build an InnoDB table:
mysql create table table_name (id int)type=innodb;
Query OK, 0 rows affected (0.14 sec)
Regards,
Miguel
Dear sir,
I am using MySQL database
I
1301 - 1400 of 1574 matches
Mail list logo