Jooglar Logo
 Pathway : Home
Register. Lost Password?
Home
Download
Products
Help & Support
Sitemap
Other
 
 
InnoDB tables in MySQL
Wednesday, 16 April 2008

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

 
Next >