List:General Discussion« Previous MessageNext Message »
From:Andrés Tello Date:July 17 2010 2:34pm
Subject:mysql 5.5.3 and innodb from source.
View as plain text  
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.

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