• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] create mysql table with innodb engine

#1 2009-12-28 17:50:22

MartinWessel
New member
Registered: 2009-11-27
Posts: 2

[resolved] create mysql table with innodb engine

I would like to create a MySql table that uses the InnoDB engine and not the default engine MyISAM.
Currently I don't see a way to do this using the tCreateTable component.

Offline

#2 2009-12-29 05:41:39

shong
Talend team
Registered: 2007-08-29
Posts: 10310
Website

Re: [resolved] create mysql table with innodb engine

Hello
The default storage engine can be changed at server startup or at runtime:

    * The default storage engine can be specified at server startup with the --default-storage-engine option.
    * For a running server, an administrator who has the SUPER privilege can change the default storage engine globally for all clients by setting the global storage_engine system variable:

Code:

      SET GLOBAL storage_engine = engine_name;

Setting the storage engine this way affects any client that connects after the statement executes. Clients that are connected at the time of statement execution are unaffected.
    * Any client can change its own default storage engine by issuing either of these statements:

Code:

      SET SESSION storage_engine = engine_name;

or
 

Code:

SET storage_engine = engine_name;

In talend, you can use tMysqlRow to execute a sql statement and change the storage engine at the runtime before tCreateTable.
"SET SESSION storage_engine = InnoDB"

Best regards

         shong


Uploaded Images


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2009-12-29 12:48:18

MartinWessel
New member
Registered: 2009-11-27
Posts: 2

Re: [resolved] create mysql table with innodb engine

Thanks for the description. It works perfect!

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] create mysql table with innodb engine

Board footer

Powered by FluxBB