|
To check if your MySQL is using the InnoDB engine visit this link: http://dev.mysql.com/doc/refman/5.0/en/show-engines.html To make your MySQL use the InnoDB tables, you can do two things: 1.- Probably, your hosting provider will have the InnoDB tables active but if it isn't, If you don't have access to the .ini files of the site, just ask them to activate it. 2.- On your localhost site, you have to look for the file my.ini (in appserv) or my.cnf (in xampp) and add/change this lines: #added for InnoDB#################### #CHANGE THE PATHS TO YOURS!!! innodb_data_home_dir = C:\AppServ/mysql/data/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = C:\AppServ/mysql/data/ innodb_log_arch_dir = C:\AppServ/mysql/data/
set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 set-variable = innodb_lock_wait_timeout=50
|