Configuracion innodb xampp
Si utiliza phpmyadmin para crear tablas, éstas se generán de forma predeterminada con el motor MYISAM.
Para establecer por defecto que se creen conINNODB busque dentro del directorio de instalación de xampp, el archivo my.ini y agregue la línea :
default-storage-engine=innodb
al final de las instrucciones para innodb. El archivo quedaría como semuestra a continuación.
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M – 64M) where MySQL plays
# an important part, or systems up to 128M whereMySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (inthis
# installation this directory is @localstatedir@) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to knowwhich options a program supports, run the program
# with the “–help” option.
# The following options will be passed to all MySQL clients
[client]
#user = your_username
#password =your_password
host = .
port = 3306
socket = “MySQL”
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
basedir = “C:/xampp/mysql/”datadir = “C:/xampp/mysql/data/”
port = 3306
socket = “MySQL”
skip-locking
key_buffer = 16M
max_allowed_packet = 1Mtable_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
default-time-zone =“UTC”
log_error = “C:/xampp/mysql/data/mysql.err”
pid_file = “mysql.pid”
general_log = 0
general_log_file = “C:/xampp/mysql/data/mysql.log”
slow_query_log =...
Regístrate para leer el documento completo.