You can define the storage engine at the time of creation of a table. http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html
You can change the storage engine at the run time with an "alter table". You can also define it at table creation in sqlalchemy. http://www.sqlalchemy.org/docs/07/dialects/mysql.html#storage-engines So most likely there is a way to do it TG, too. But I do not know it yet. tamas rajasekhar911 wrote:
Hi guys, I am trying to use innodb as storage engine. But i dont want to set the engine to innodb for all databases (in my.cnf). i can set the storage engine at the time of setup-app by executing the command set storage_engine='innodb' through the sa_engine. tables were created with innodb as engine. how do i set the engine at the run time? i tried to set it in init_model in __init__.py in model but it does not seem to work. also will this effect when TG is initializing connection pool? or is there any other way i can specify the engine in development.ini ? or in URL ? --- thanks
-- Tamas Hegedus, PhD Membrane Research Group | phone: (36) 1-459 1500/60233 Hungarian Academy of Sciences | fax: (36) 1-266 6656 Tuzolto utca 37-47 | mailto:[email protected] Budapest, 1094, Hungary | http://www.hegelab.org -- You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/turbogears?hl=en.
