List:General Discussion« Previous MessageNext Message »
From:Rob Wultsch Date:July 18 2010 7:08pm
Subject:Re: mysql 5.5.3 and innodb from source.
View as plain text  
On Sat, Jul 17, 2010 at 7:34 AM, Andrés Tello <mr.criptos@stripped> 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
wultsch@stripped
Thread
mysql 5.5.3 and innodb from source.AndrĂ©s Tello17 Jul
  • Re: mysql 5.5.3 and innodb from source.Rob Wultsch18 Jul