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
Ca
nswer
-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 t
Yes, but your myIsam Tables stay myisam ones.
After restarting, you must change them to innodb by :
Alter table toto storage=innodb.
For new tables, they will have innodb storage.
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-
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 t
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 t
