On Sat, Jul 17, 2010 at 7:34 AM, Andrés Tello <mr.crip...@gmail.com> wrote: > 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. >
Assuming that you actually built the innodb plugin (I have no experience building 5.5) the you should probably look at what you need to add to the cnf in order to use the plugin. http://www.innodb.com/doc/innodb_plugin-1.0/innodb-plugin-installation.html This is only a guess. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
