We are running MySQL on Red Hat Enterprise Linux 3, using the Red Hat-
supplied RPM file mysql-server-3.23.58-2.3. Our current MySQL
configuration has MyISAM as the default database file type. I would like
to change this such that InnoDB is the default. My understanding of the
documentation
-Original Message-
From: Carl Riches [mailto:[EMAIL PROTECTED]
Sent: lundi 25 avril 2005 19:26
To: mysql@lists.mysql.com
Cc: Carl Riches
Subject: Converting to InnoDB?
We are running MySQL on Red Hat Enterprise Linux 3, using the Red Hat-
supplied RPM file mysql-server-3.23.58-2.3. Our
-Original Message-
From: mathias fatene [mailto:[EMAIL PROTECTED]
Sent: lundi 25 avril 2005 19:33
To: 'Carl Riches'; 'mysql@lists.mysql.com'
Subject: RE: Converting to InnoDB?
Yes, but your myIsam Tables stay myisam ones.
After restarting, you must change them to innodb by :
Alter
On Mon, 25 Apr 2005, mathias fatene wrote:
Sorry,
Alter table toto ENGINE=innodb.
You don't must, you can. You can also have differents storage ENGINES in
the same mysql database.
With innodb, you will earn ROW level locking.
Best Regards
Mathias FATENE
Thanks, Mathias!
Carl
Hi list,
I have a question regarding mysql and innodb.
My current setup uses myisam and the db size is about 1.6 GB with two
table that each have about 500k rows. I perform alot of fulltext search
on these tables and they can sometimes take along time to finish and
when the table is locked
Fredrik Carlsson wrote:
Hi list,
I have a question regarding mysql and innodb.
My current setup uses myisam and the db size is about 1.6 GB with two
table that each have about 500k rows. I perform alot of fulltext search
on these tables and they can sometimes take along time to finish and
when
Roger Baklund wrote:
Fredrik Carlsson wrote:
Hi list,
I have a question regarding mysql and innodb.
My current setup uses myisam and the db size is about 1.6 GB with two
table that each have about 500k rows. I perform alot of fulltext
search on these tables and they can sometimes take along time
Fredrik Carlsson wrote:
Hi list,
I have a question regarding mysql and innodb.
My current setup uses myisam and the db size is about 1.6 GB with two
table that each have about 500k rows. I perform alot of fulltext search
on these tables and they can sometimes take along time to finish and
when