Who you build mysql 5.5.3 with innodb suport? I made sh configure.am --with-plugins=all I see the makefile at innodb subdir being created. I build the system correctly but when I log in to the mysql 5 instance and do a
show engines; I only have this: +--------------------+---------+-----------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------------------+---------+-----------------------------------------------------------+--------------+------+------------+ | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | +--------------------+---------+-----------------------------------------------------------+--------------+------+------------+ my my.cnf... skip-name-resolve log_error =/mysql5/mysql5.err socket = /mysql5/mysql.sock port = 3308 pid-file = /mysql5/mysql5.pid datadir = /mysql5/data tmpdir=/tmpfs binlog_cache_size=64M #tamaño de la transaccion a cachear bulk_insert_buffer_size=256M #cache de insert por thread delay_key_write=OFF #detiene la creacion de llaves? No, no nos conviene por integridad. max_allowed_packet=256M table_cache=4096 join_buffer_size=256M tmp_table_size=1024M sort_buffer_size=1024M thread_cache_size=64 #default_storage_engine=INNODB query_cache_size=1024M query_cache_limit=256M innodb_file_per_table innodb_data_home_dir = /mysql5/innodb innodb_data_file_path = ibdata/innodb:2000M:autoextend innodb_buffer_pool_size=512M innodb_flush_method=fdatasync #ls opciones son fdatasync (default), O_DSYNC, (lento?) O_DIRECT innodb_locks_unsafe_for_binlog=1 #solo usa indices innodb_additional_mem_pool_size=512M innodb_log_file_size=2000M innodb_log_buffer_size=32M innodb_max_dirty_pages_pct=95 innodb_max_purge_lag=0 innodb_flush_log_at_trx_commit=1 innodb_lock_wait_timeout=50 innodb_thread_concurrency=200 max_heap_table_size=4G what I'm doing wrong? Please advice. Thanks.
