Configuring INNODB Engine with XAMPP in Windows

InnoDB MySQL database storage engine is not enabled in the my.cnf
configuration file of XAMPP.
I have configured successfully Innodb engine with XAMPP latest version.
To enable the support of MySQL server on InnoDB storage engine, locate
the “my.cnf” config file (normally in /installation_path/xampp/mysql/
bin/ directory), and edit the my.cnf with any text editor.
Search and locate each of the following lines (except the lines in
italic where they’re comments):
– Comment the following line to unskip and use InnoDB
skip-innodb
– Uncomment the following options for InnoDB database if you are
using InnoDB tables.
#innodb_data_home_dir = C:/xampp/xampp/mysql/data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:/xampp/xampp/mysql/data/
#innodb_log_arch_dir = C:/xampp/xampp/mysql/data/
– Uncomment the lines and set innodb_buffer_pool_size up to 50% –
80% of RAM for optimization of InnoDB databases, try not to memory
usage too high.
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
– Uncomment the lines and set innodb_log_file_size to 25% of
InnoDB buffer pool size for optimisation.
#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
After modification, the code for each lines should look like this:
# skip-innodb
innodb_data_home_dir = C:/xampp/xampp/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = C:/xampp/xampp/mysql/data/
innodb_log_arch_dir = C:/xampp/xampp/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

 

http://tapos.wordpress.com/2008/01/03/configuring-innodb-engine-with-xampp-in-windows/

相关推荐

magento 2.3 nginx 安装

在网上看了许多中文的magento2的安装教程,大多数都没有完整的安装步骤,本教程将教会你怎么使用和安装magento2.3 …

Magento忘记密码怎么办

如果你忘记 Magento 用户名和(或)密码无法登陆后台,并且forgot your password链接无法给你发送找回密码邮件,这 …

magento backend dashboard can’t log in – session error

可能很多朋友有同样的经历,magento在服务器中配置域名是可以正常的访问了,但是在本地配置后却无法登录后台,账号密码登录的时候发现出现空白,无法跳转到后台,本文章向大家介绍两种解决本地magento后台无法登录的方法,需要的朋友可以参考下

暂无评论

发表评论

微信扫一扫,分享到朋友圈

Configuring INNODB Engine with XAMPP in Windows