not so sure now...
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" <[EMA
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 efficie
;[EMAIL PROTECTED]>
To: "Steve Rapaport" <[EMAIL PROTECTED]>
Cc: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, March 02, 2002 6:19 PM
Subject: Re: InnoDB frightens me...
> On Sat, Mar 02, 2002 at 11:14:42PM +0100, Steve Rapaport
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 t
--- 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 th
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 pare
Hi!
>From http://www.innodb.com/ibman.html :
"
Note that InnoDB does not create directories: you have to create them
yourself. Use the Unix or MS-DOS mkdir command to create the data and log
group home directories. Check also that the MySQL server has the rights to
create files in the directorie
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
; Sent: Monday, 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
Life 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 p
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 &
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\bin>mysqld-max --standalone --console
InnoDB: The first specified data file c:\
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
>
Hi Heikki,
OK! Thanks for the clarification.
-- Prabhu
On Mon, 31 Dec 2001, Heikki Tuuri wrote:
> Date: Mon, 31 Dec 2001 17:26:57 +0200
> From: Heikki Tuuri <[EMAIL PROTECTED]>
> To: Rajarajeswaraprabhu <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject
Hi!
It is a bug in the FOREIGN KEY syntax parser. It is confused by the column
name
e_foreigncurrency
The bug appears if the string 'foreign' is succeeded by a non-space
character in a CREATE TABLE statement.
Workaround: change the column name to e_currencyforeign, for example.
Fixed in 3.23.
Mysql Row Locking
On Wed, 13 Feb 2002 [EMAIL PROTECTED] wrote :
> 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 of the following words in your message:
>
> sql,query
>
> If you just repl
te: Saturday, February 09, 2002 3:59 PM
Subject: Re: InnoDB foreign keys crash MySQL
>> Harald,
>
>Hi, Heikki!
>
...
>
>> I tested now with the official Linux binary of 4.0.1 (not -max) and it
>> worked ok on our dual Xeon Linux-2.4.16-SMP-64GB. I did not define any
>
Yes, I saw that before...My filesize was limited to 2GB before, but now with
a 2.4 kernel and reiserfs I _should_ be allowed to create a 20GB data file
now, right?
So something's wrong... as I said before, I have successfully created a 9GB
file on this machine before, so the filesystem isn't to b
://www.mysql.com
-Original Message-
From: Gurupartap Davis <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Saturday, February 09, 2002 2:32 AM
Subject: Re: InnoDB File Size
>Yes, I saw that before...My filesize was limited t
ages 1
FIELDS: t2id id
FOREIGN KEY CONSTRAINT 0_17: test/t3 ( t2id )
REFERENCES test/t2 ( id )
---
END OF INNODB TABLE MONITOR OUTPUT
==
-Original Message-
From: Harald Fuchs <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc:
In article <003b01c1b0a4$351665f0$540ec5c2@omnibook>,
"Heikki Tuuri" <[EMAIL PROTECTED]> writes:
> Harald,
> I tested the below with 3.23.48, and it worked ok.
> Could it be that you have not used DROP TABLE or DROP DATABASE to remove
> InnoDB tables? Then the internal data dictionary may be out
Harald,
I tested the below with 3.23.48, and it worked ok.
Could it be that you have not used DROP TABLE or DROP DATABASE to remove
InnoDB tables? Then the internal data dictionary may be out-of-sync from the
.frm files of your tables.
Please use innodb_table_monitor (section 9.1 in
http://www.
Hi!
>From http://www.innodb.com/ibman.html :
MySQL/InnoDB-3.23.44, November 2, 2001
You can define foreign key constraints on InnoDB tables. An example: FOREIGN
KEY (col1) REFERENCES table2(col2).
You can create > 4 GB data files in those file systems that allow it.
Thus > 4 G files
te: Saturday, February 09, 2002 3:59 PM
Subject: Re: InnoDB foreign keys crash MySQL
>> Harald,
>
>Hi, Heikki!
>
...
>
>> I tested now with the official Linux binary of 4.0.1 (not -max) and it
>> worked ok on our dual Xeon Linux-2.4.16-SMP-64GB. I did not define any
>
://www.mysql.com
-Original Message-
From: Gurupartap Davis <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Saturday, February 09, 2002 2:32 AM
Subject: Re: InnoDB File Size
>Yes, I saw that before...My filesize was limited t
On Friday 08 February 2002 16:32, Gurupartap Davis wrote:
> Yes, I saw that before...My filesize was limited to 2GB before, but now
> with a 2.4 kernel and reiserfs I _should_ be allowed to create a 20GB
> data file now, right?
>
> So something's wrong... as I said before, I have successfully crea
Yes, I saw that before...My filesize was limited to 2GB before, but now with
a 2.4 kernel and reiserfs I _should_ be allowed to create a 20GB data file
now, right?
So something's wrong... as I said before, I have successfully created a 9GB
file on this machine before, so the filesystem isn't to b
ages 1
FIELDS: t2id id
FOREIGN KEY CONSTRAINT 0_17: test/t3 ( t2id )
REFERENCES test/t2 ( id )
---
END OF INNODB TABLE MONITOR OUTPUT
==
-Original Message-
From: Harald Fuchs <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc:
Harald,
I tested the below with 3.23.48, and it worked ok.
Could it be that you have not used DROP TABLE or DROP DATABASE to remove
InnoDB tables? Then the internal data dictionary may be out-of-sync from the
.frm files of your tables.
Please use innodb_table_monitor (section 9.1 in
http://www.
Hi!
>From http://www.innodb.com/ibman.html :
MySQL/InnoDB-3.23.44, November 2, 2001
You can define foreign key constraints on InnoDB tables. An example: FOREIGN
KEY (col1) REFERENCES table2(col2).
You can create > 4 GB data files in those file systems that allow it.
Thus > 4 G files
On Thursday 07 February 2002 11:07, Tibor Radvanyi wrote:
> Hi Everyone,
>
> I'm newbie with MySQL with some programming experience.
> I'm about to implement an Internet shop. I would like to serve my
> customers at a high level with, amongst other features, making sure that
> every successful ord
Martin,
use VARCHAR(255) instead of CHAR(255) to save space. Otherwise, InnoDB uses
the full 255 bytes to store the field.
There is however an exception to this: if you define any single column as
VARCHAR in the table, then MySQL silently changes all long CHAR column to
VARCHAR. These "silent co
2002 11:18 AM
To: Chetan Lavti
Cc: [EMAIL PROTECTED]
Subject: RE: InnoDB help !!
Hi,
On Wed, 2002-01-30 at 15:19, Chetan Lavti wrote:
> It seems, you suggesting that after setting changes in the
configuration
> file the "Show variable." will list out the 'YES' in f
-Original Message-
From: Arjen Lentz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 11:18 AM
To: Chetan Lavti
Cc: [EMAIL PROTECTED]
Subject: RE: InnoDB help !!
Hi,
On Wed, 2002-01-30 at 15:19, Chetan Lavti wrote:
> It seems, you suggesting that afte
Hi,
On Wed, 2002-01-30 at 15:19, Chetan Lavti wrote:
> It seems, you suggesting that after setting changes in the configuration
> file the "Show variable." will list out the 'YES' in front of
> 'have_innodb' (in table below). right ??
Indeed.
> The second thing is that, how do I test for
cifically whether it is making the my database memory-resident or
not.
Thank u very much once again.
regards,
Chetan Lavti
-Original Message-
From: Arjen Lentz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 3:11 AM
To: Chetan Lavti
Cc: [EMAIL PROTECTED]
Subject: RE: InnoDB
Hi,
On Wed, 2002-01-30 at 00:06, Chetan Lavti wrote:
> thanks for your quick reply !!
>
> that's fine !! I have done the max.RPM installation part.
> but what is "fix up the startup scripts so that
> binary will be the one started."
>
> When I am trying "show variables like "have_%";
> +---
Chetan,
Tuesday, January 29, 2002, 4:06:30 PM, you wrote:
CL> thanks for your quick reply !!
CL> that's fine !! I have done the max.RPM installation part.
CL> but what is "fix up the startup scripts so that
CL> binary will be the one started."
CL> When I am trying "show variables like "have_%"
Chetan,
Tuesday, January 29, 2002, 7:02:18 AM, you wrote:
CL> thanks for reply,
CL> but I have installed MySQL on Linux using the RPM files and while using
CL> RPM files should I have to give the option while installing? As while
CL> using the RPM files there is no compilation.
CL> It is no whe
Matthew,
Tuesday, January 29, 2002, 6:37:32 AM, you wrote:
MW> You can only do this while compiling it from source.
MW> Matthew Walker
MW> Ecommerce Project Manager
MW> Mountain Top Herbs
MW> -Original Message-
MW> From: Chetan Lavti [mailto:[EMAIL PROTECTED]]
MW> Sent: Monday, Janua
d show after installing
the max.RPM. shouldn't it ??
Please, help me as much you can !! I have been stuck at this place.
Thanks and regards,
Chetan Lavti
-Original Message-
From: Arjen Lentz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 10:42 AM
To: Chetan Lavti
Cc: [E
Hi,
On Tue, 2002-01-29 at 14:10, Chetan Lavti wrote:
> I have downloaded and installed MySQL ( rpm's). Now, I want to configure
> it with InnoDB option, as given in the manual,
> but can't see the below configure file anywhere.
> // cd /path/to/source/of/mysql-3.23.37
>./configure --with-in
details.
Thanks and regards,
Chetan Lavti
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 10:08 AM
To: Chetan Lavti; [EMAIL PROTECTED]
Subject: RE: InnoDB help !!
You can only do this while compiling it from source.
Matthew Walker
You can only do this while compiling it from source.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Chetan Lavti [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 9:11 PM
To: [EMAIL PROTECTED]
Subject: InnoDB help !!
hi,
I have downloaded
On Mon, Jan 28, 2002 at 09:30:59AM -0600, ryc wrote:
> > Hello,
> >
> > is possible "on the fly" change size of innodb tables ??
> >
> > i create table 1G large but is small and i need enlarge it. Can i
> > change number in my.cnf or something else ?
>
> Just add another file entry to my.cnf sep
Just add another file entry to my.cnf seperated by commas... You can add as
many seperate files as you like... (within reason of course, eventually if
the line length gets longer than 1024 or so you cant add anymore). Once you
edit the file, restart mysql and innobase will detect the new file entr
Jeremy,
look at http://www.innodb.com/ibman.html and http://www.innodb.com/todo.html
about InnoDB isolation levels.
Currently, SET TRANSACTION ISOLATION LEVEL does not have any effect on
MyISAM, BDB, or InnoDB.
The standard isolation level of InnoDB is REPEATABLE READ (you can also call
that RE
Hi!
> "HeikkiiH" == Heikki Tuuri <[EMAIL PROTECTED]> writes:
HeikkiiH> Ken,
HeikkiiH> the 'connection lost' error suggests some bug in the client or
HeikkiiH> communication. Since you are running 4.0.1-alpha, it could be something with
HeikkiiH> the query cache. I think Sanja has already fi
L PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc: Philip Molter <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Friday, January 25, 2002 10:22 AM
Subject: Re: innoDB confusion
>On Tue, Jan 15, 2002 at 08:36:16PM +0200, Heikki Tuuri wrote:
>> >
On Tue, Jan 15, 2002 at 08:36:16PM +0200, Heikki Tuuri wrote:
> >
> >This brings up an interesting point. If you've lost your .frm
> >files, are you totally screwed, or does InnoDB contain enough
> >information to restore those .frm files? It's not a big deal if
>
> With some work, yes. innodb_
On Mon, Jan 21, 2002 at 10:50:10PM +0200, Heikki Tuuri wrote:
>
> this is a known 'feature' which is also mentioned in the
> manual. SHOW TABLE STATUS will set an exclusive lock to the end of
> table to look at the current auto-inc column value, which SHOW TABLE
> STATUS has in its output. Since
Chris,
>Hi there,
>
>I've been experimenting with InnoDB and replication and now have a few
>questions...Firstly, is it a known bug that "SHOW TABLE STATUS" screws up
InnoDB
>transactions? To insert data into my innoDB table I've been using:
>set autocommit=0;
>INSERT ...
>INSERT ...
>...
>comm
On Fri, 19 Jan 2001, Byron Albert wrote:
> Hello,
>
> I have a few questions. First I work on a very high traffic site that
> uses vbulletin 1.1 to run its bb. The bb is very high traffic around
> 60-200 concurrent users. We are starting to run into some serious
> locking issues, and I am t
I work for vBulletin and have some input on this. First off, you really
should look into upgrading to version 2.2.x, as not only are there many
new features, but there have been a number of performance enhancements
done that may help your situation. You also might want to take a look
at the vBul
I've had a similar error when creating innodb tables, using a 4.0.1 client,
and a .47 server, if I loaded my create statement from a text file, the
innodb table wouldn't create. Change the type to myisam and it worked fine.
If I wound up creating it line by line, it worked fine. This might g
Ken,
the 'connection lost' error suggests some bug in the client or
communication. Since you are running 4.0.1-alpha, it could be something with
the query cache. I think Sanja has already fixed some bugs there since 4.0.1
was released. The query cache is suspect since the error did not crash the
Hi!
On Jan 17, Alexei V. Alexandrov wrote:
> Hello everyone,
>
> I`m running mysql version 4.0.0-alpha under FreeBSD 4.3-STABLE on a
> dual pentium 4 x 1Ghz with a total memory of 1.5Gb and a scsi hard
> drive with a volume about 50Gb. The problem is in the InnoDB startup
> option innodb
Cool. Thanks, John.
--Walt
-Original Message-
From: John Kemp [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1:06 PM
To: Weaver, Walt
Cc: [EMAIL PROTECTED]
Subject: Re: innoDB confusion
Walt,
It'll go to the database_machine_name.err file on that machine.
John
W
fused In Bozeman
>
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 11:18 AM
> To: [EMAIL PROTECTED]
> Subject: Re: innoDB confusion
>
>
> Hi!
>
> "Weaver, Walt" wrote in message ...
>
m confused as to how I capture this.
I'm running on Linux Redhat 6.2 with the 2.4 kernel, mysql 3.23.44.
Thanks,
-- Confused In Bozeman
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 11:18 AM
To: [EMAIL PROTECTED]
Subject: Re: innoDB
12:24 PM
To: [EMAIL PROTECTED]
Subject: Re: innoDB confusion
Aaron,
"Rutledge, Aaron" wrote in message ...
>
>Woah...
>
>Heikki Tuuri wrote:
>"With some work, yes. innodb_table_monitor prints the internal schema
of
>InnoDB. There are fewer column types inside I
Aaron,
"Rutledge, Aaron" wrote in message ...
>
>Woah...
>
>Heikki Tuuri wrote:
>"With some work, yes. innodb_table_monitor prints the internal schema of
>InnoDB. There are fewer column types inside InnoDB than in MySQL. For
>example, a DATE column will appear as an integer."
>
>Now I am confused
Woah...
Heikki Tuuri wrote:
"With some work, yes. innodb_table_monitor prints the internal schema of
InnoDB. There are fewer column types inside InnoDB than in MySQL. For
example, a DATE column will appear as an integer."
Now I am confused again. Do you only have access to column types
specifi
Molter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 11:24 AM
To: Heikki Tuuri
Cc: [EMAIL PROTECTED]
Subject: Re: innoDB confusion
On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heikki Tuuri wrote:
: Hi!
:
: "Weaver, Walt" wrote in message ...
: >Do a "show table status&qu
Hi!
-Original Message-
From: Philip Molter <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, January 15, 2002 8:24 PM
Subject: Re: innoDB confusion
>On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heik
On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heikki Tuuri wrote:
: Hi!
:
: "Weaver, Walt" wrote in message ...
: >Do a "show table status" at the mysql prompt. Under "type" you should see
: >InnoDB.
:
: Yes, and in really problematic situations, where you have lost your .frm
: files, for example, y
>From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 15, 2002 10:57 AM
>To: Mysql List (E-mail)
>Subject: RE: innoDB confusion
>
>
>One final question, and I am done. You have helped me
>tremendously--thank you. Wow, I really didn't expect the develop
lespace? Aaron
>
>
>
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 10:43 AM
> To: Rutledge, Aaron
> Cc: [EMAIL PROTECTED]
> Subject: Re: innoDB confusion
>
>
> Aaron,
>
> -Original
Do a "show table status" at the mysql prompt. Under "type" you should see
InnoDB.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 10:57 AM
To: Mysql List (E-mail)
Subject: RE: in
ssage-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 10:43 AM
To: Rutledge, Aaron
Cc: [EMAIL PROTECTED]
Subject: Re: innoDB confusion
Aaron,
-Original Message-
From: Rutledge, Aaron <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Date:
Aaron,
-Original Message-
From: Rutledge, Aaron <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Date: Tuesday, January 15, 2002 7:13 PM
Subject: RE: innoDB confusion
>Thank You Heikki,
> That information helps a lot. A couple quick questions if you dont
&g
Aaron,
please look at http://www.innodb.com/features.html,
http://www.innodb.com/division.html, and 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 la
Heikki,
Thanks very muich for the explanation. That's an interesting question
for the connection modules in Apache/PHP/DBI etc. Perhaps this is a
problem with the way the connections are opened by those programs. I
hadn't thought of that, so it would definitely be a good thing to test
before
Hi!
It is a bug if the sleeping connection is in the auto-commit mode. But we
need more information of the problem. If you encounter it, please send the
exact sequence of SQL commands which leads to the problem.
You may also test
SET AUTOCOMMIT=1
explicitly in your program.
Note that LOCK TAB
Message-
> From: John Kemp [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 09, 2002 1:40 PM
> To: Heikki Tuuri
> Cc: [EMAIL PROTECTED]
> Subject: Re: InnoDB : Lock wait timeout exceeded; Try restarting
> transaction
>
>
> Heikki,
>
> Hmm. That's intere
ss, of course, autocommit is on.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: John Kemp [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 1:40 PM
To: Heikki Tuuri
Cc: [EMAIL PROTECTED]
Subject: Re: InnoDB : Lock wait timeout exceeded; Try restarting
transaction
https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
-Original Message-
From: John Kemp <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, January 09, 2002 10
Heikki,
Hmm. That's interesting. So if you do a single command, say
INSERT INTO Table1 (X, Y, Z) VALUES ( A, B, C) ;
You actually need to write (I'm not sure of the exact transactional
syntax for Mysql) -
BEGIN ; --begin a transaction
INSERT INTO Table1 (X, Y, Z) VALUES ( A, B, C) ;
COMMIT ;
Hi!
Looks like your are not committing your transactions. Every UPDATE and
INSERT automatically sets row level locks, which are only removed when you
do a COMMIT or ROLLBACK.
Or you have set innodb_lock_wait_timeout too small in my.cnf.
InnoDB does not set table level locks. Only LOCK TABLES se
Hi SAm,
I actually had a similar problem myself, but was unable to prove it was
the persistent connection itself causing this. I'm wondering if this
means that INNODB thinks that a connection that is now 'sleeping' (ie.
where a connection was created, used, but is now unused but still open)
m
Hi!
-Original Message-
From: Peter Zaitsev <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Saturday, January 05, 2002 10:35 PM
Subject: Innodb/Replication problems.
>Hello mysql,
>
> I'm using mysql 3.23.47 with Innodb and t
Hi!
>On Thu, Dec 27, 2001 at 06:56:03PM +0200, Heikki Tuuri wrote:
>> * Recovery has been made more resilient to corruption of log files.
>
>Can I ask what you mean here? If the log files are corrupt, is
>recovery still possible then? Or are the log files themselves less
>likely to get corrup
On Thu, Dec 27, 2001 at 06:56:03PM +0200, Heikki Tuuri wrote:
> * Recovery has been made more resilient to corruption of log files.
Can I ask what you mean here? If the log files are corrupt, is
recovery still possible then? Or are the log files themselves less
likely to get corrupted? I'm a
available
for row level privileges.
Thanks,
Prabhu
On Mon, 31 Dec 2001, Heikki Tuuri wrote:
> Date: Mon, 31 Dec 2001 17:26:57 +0200
> From: Heikki Tuuri <[EMAIL PROTECTED]>
> To: Rajarajeswaraprabhu <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: InnoDB in MySQL-4
-Original Message-
From: Rajarajeswaraprabhu <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, December 28, 2001 6:53 AM
Subject: Re: InnoDB in MySQL-4.0.1
>Hi Keikki,
>
> I would like to know if
Innobase allows you to specify multiple data files and will use them
automatically. So to keep under the 2gb limit just keep adding 2gb files as
needed. You can see how much space is left in the innobase data files by
doing the following query: "show table status from 'dbname' like
'tablename'".
Hi Keikki,
I would like to know if row level privileges can be set in mysql.
Eg:-
In user table, the user shall be allowed to edit only his record.
In a table for task report, only assignee of the task shall be
allowed to edit the specific record.
-- Prabhu
On Thu, 27 Dec 2001,
On Tue, Dec 18, 2001 at 11:19:06PM +0200, Heikki Tuuri wrote:
: Philip,
:
: I recommend using the MySQL STRAIGHT JOIN and USE INDEX clauses to manually
: force the best plan.
I'd love to, but I also have to maintain a spec of database
agnosticism (which I could do in code, of course, but I shoul
Philip,
I recommend using the MySQL STRAIGHT JOIN and USE INDEX clauses to manually
force the best plan.
You could also use innodb_table_monitor to check that the key value set
cardinality estimates are approximately right for the tables h, pt, and p.
But to put it the other way, how could the
Forwarded message:
>Return-Path: <[EMAIL PROTECTED]>
>From: "Mehalick, Richard RE SITI-ITPSCA" <[EMAIL PROTECTED]>
>To: 'Heikki Tuuri' <[EMAIL PROTECTED]>
>Subject: RE: Innodb Win2000 error
>Date: Tue, 18 Dec 2001 11:41:45 -0600
>
>Thank
On Mon, Dec 17, 2001 at 10:03:58PM -0600, Philip Molter wrote:
: Is there any upcoming fix for this recurring problem? The table
: handler is just giving poor data to the optimizer and the optimizer
: is making bad decisions because of it. It appears to come and go,
: depending on data that is i
PROTECTED]>
Sent: Saturday, December 08, 2001 10:22 AM
Subject: RE: innodb won't allocate the memory i ask it to
> If you are running FreeBSD, there is an inner limit, which doesn't allow
> malloc() calls greater then 500MB. You need to reconfigure the kernel
> sources an
Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 08, 2001 4:58 AM
To: [EMAIL PROTECTED]
Subject: Re: innodb won't allocate the memory i ask it to
Rich,
>I have a system with 1gig of ram and i am trying to get the innodb buffer
to
>be about 750megs. Whenever I set the value
Rich,
>I have a system with 1gig of ram and i am trying to get the innodb buffer to
>be about 750megs. Whenever I set the value in the database config file it
>won't start with an error along the lines of,
>
>011207 21:02:42 mysqld started
>InnoDB: Fatal error: cannot allocate 67108864 bytes of
Ah, I finally found mention of this in the manual.
Sorry to bother everyone.
Thanks.
---
Hello,
To use InnoDB you have to put how large of a file MySQL is allowed to make by putting
an entry in /etc/my.cnf such as the one I used:
innodb_data_home_dir =
Hi!
On Dec 04, Gurupartap Davis wrote:
> I'm converting a table to innodb from myisam in mysql 4.0 and I was
> wondering why it takes sooo long to do a SELECT COUNT(*)
MyISAM stores total number of rows in MYI file header.
It's read into memory when table is opened.
So for SELECT COUNT(*) FROM
Heikki Tuuri wrote:
>
> Chris,
>
> what is your my.cnf or my.ini like? Do you have a big enough
> innodb_buffer_pool_size?
set-variable = innodb_buffer_pool_size=300M
big enough?
Chris
database, sql, query, table (just to keep the stoopid list software from
whinging..)
-
Chris,
what is your my.cnf or my.ini like? Do you have a big enough
innodb_buffer_pool_size?
Regards,
Heikki
http://www.innodb.com
--
Order commercial MySQL/InnoDB support at https://order.mysql.com/
[EMAIL PROTECTED] wrote:
>
> Your message cannot be posted because it appears to be either s
[EMAIL PROTECTED] wrote:
>
> 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 of the following words in your message:
>
> database,sql,query,table
>
> If you just reply to this message, and incl
Joe Ellis wrote:
>
> Just For My Info: does it take long for one insert. if so, what does
> the insert statement look like. the reason i ask is becuase i use
> InnoDB and inserted a few records and it was pretty quick. but maybe
> thats becuase my statement was:
> insert into table (user,email
1401 - 1500 of 1607 matches
Mail list logo