Andrea
10 de Septiembre del 2004

Hola a todos, seg煤n lo que he leido MySQL soporta tablas innodb desde la versi贸n 3.23, mi pregunta es la siguiente: tengo instalado MySQL 3.23 y cuando le digo "SHOW VARIBLES like '%innodb%' me se帽ala que la variable: have_innodb est谩 deshabilitada ¿c贸mo puedo habilitar esta variable?
Gracias por cualquier ayuda que me puedan brindar.

Chaoo.

sphinx101
10 de Septiembre del 2004

checa la documentacion de mysql hay un capitulo donde habla de como configurar innodb para las versiones 3.2x

pilar
10 de Septiembre del 2004

estoy buscando exactamente esa respuesta.

Javier
10 de Septiembre del 2004

Busquen en http://dev.mysql.com/doc/mysql/en/InnoDB_in_MySQL_3.23.html

Amigo
10 de Septiembre del 2004

Parte de la tarea de configuraci贸n es habilitar el soporte de InnoDB, configurando cada una de las variables de acuerdo a lo propuesto en 3.2, desde luego los aspectos m谩s importantes ser谩n los buffers

# Example mysql config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# a important part and systems up to 128M very MySQL is used together with
# other programs (like a web server)
#
# You can copy this file to
# /etc/mf.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /centia01/develop/database/mysql/var) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=64M
set-variable = max_allowed_packet=256M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=16M
set-variable = max_connections=500
set-variable = interactive_timeout=604800
set-variable = wait_timeout=604800
log-bin
server-id = 1
set-variable=default_table_type=innodb
# Point the following paths to different dedicated disks
tmpdir = /var/tmp/
#log-update = /centia01/final/database/mysql/var/log-catarina
# Uncomment the following if you are using BDB tables
set-variable = bdb_cache_size=4M
set-variable = bdb_max_lock=10000
# Uncomment the following if you are using Innobase tables
innodb_data_file_path = ibdata1:30G:autoextend
innodb_data_home_dir = /database/mysql/innodb
innodb_log_group_home_dir = /database/mysql/innodb
innodb_log_arch_dir = /database/mysql/innodb
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=16M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=256M
set-variable = innodb_additional_mem_pool_size=256M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
#set-variable = innodb_force_recovery=3
[mysqldump]
quick
set-variable = max_allowed_packet=256M
[mysql]
prompt=(u) [d]>_
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout


Archivo de Configuraci贸n my.cnf, my.ini

Fernando Poblete Arrau
10 de Septiembre del 2004

Hola, hay alguna forma de habilitar las innoDB desde el myqladmin ?