Dear Dan,
> I have a database that, I now realize, could use the benefits of
> row-locking and non-blocking SELECTs. So, I guess I need to change over
> to InnoDB tables. How do I convert my existing data structures (and the
> data they contain) into InnoDB tables?
ALTER TABLE mytable TYPE=innodb
Hi!
> I am getting real interested too. :) I took a look at the manual, but I
did
> not see answers to a simple question like whether innodb files are
> compatible (query-wise) with MyISAM tables, for instance, or whether I
need
> to rewrite all queries. Perhaps a guru here could explain this.
Y
- Original Message -
From: "Sherzod Ruzmetov" <[EMAIL PROTECTED]>
To: "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]>; "MYSQL"
<[EMAIL PROTECTED]>
Sent: Saturday, May 18, 2002 12:29 AM
Subject: Re: MyISAM -> Innodb
> I he
L PROTECTED]>
Sent: Friday, May 17, 2002 11:49 PM
Subject: Re: MyISAM -> Innodb
> In the last episode (May 17), Sherzod Ruzmetov said:
> > I heard about Innodb here a lot, but where can i find more info about
> > it. I search mysql manuals, but no results.
>
> T
In the last episode (May 17), Sherzod Ruzmetov said:
> I heard about Innodb here a lot, but where can i find more info about
> it. I search mysql manuals, but no results.
Try the mysql manual :)
Chapter "MySQL Table Types", Section "InnoDB Tables"
http://www.mysql.com/doc/I/n/InnoDB.html
--
I heard about Innodb here a lot, but where can i find more info about
it. I search mysql manuals, but no results.
Any resources?
> Hi,
>
> I have a lot of MyISAM table that i wanna convert ot Innodb.
They don't
> have any foreign keys nor BLOB or TEXT column as index. How should i
do
I heard about Innodb here a lot, but where can i find more info about
it. I search mysql manuals, but no results.
Any resources?
> Hi,
>
> I have a lot of MyISAM table that i wanna convert ot Innodb.
They don't
> have any foreign keys nor BLOB or TEXT column as index. How should i
do
I heard about Innodb here a lot, but where can i find more info about
it. I search mysql manuals, but no results.
Any resources?
> Hi,
>
> I have a lot of MyISAM table that i wanna convert ot Innodb.
They don't
> have any foreign keys nor BLOB or TEXT column as index. How should i
do
On Wed, Dec 26, 2001 at 04:23:46PM -0600, Philip Molter wrote:
> Are there guides out there for configuring these things? What is
> a "big enough" log file? Honestly, on a lot of stuff, I'm just
> guessing, but it takes a lot of time to fiddle with values, clean
> out the database, and then shov
Weaver
Bozeman, Montana
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 26, 2001 3:19 PM
To: [EMAIL PROTECTED]
Subject: Re: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking
question
Walt,
thank you for the test!
>This post
Philip,
>On Thu, Dec 27, 2001 at 12:18:38AM +0200, Heikki Tuuri wrote:
>: The MyISAM table obviously fit in the OS file cache, otherwise 1750 inserts
>: per second would not be possible. Did the table fit in the buffer pool of
>: InnoDB or the SGA of Oracle? Did you commit each insert individuall
On Thu, Dec 27, 2001 at 12:18:38AM +0200, Heikki Tuuri wrote:
: The MyISAM table obviously fit in the OS file cache, otherwise 1750 inserts
: per second would not be possible. Did the table fit in the buffer pool of
: InnoDB or the SGA of Oracle? Did you commit each insert individually in
: InnoDB
Walt,
thank you for the test!
>This post is partially a reply to a request to share my MyISAM/InnoDB/Oracle
>comparison testing with you guys. In addition, I have a question about
>locking mechanisms in InnoDB which I'll ask at the end of the post.
>
>I've been comparison testing MyISAM, InnoDB,
13 matches
Mail list logo