From: Andrés Tello
Date: July 17 2010 2:34pm
Subject: mysql 5.5.3 and innodb from source.
List-Archive: http://lists.mysql.com/mysql/222236
Message-Id: <AANLkTim7cS4vlBO9muidirYRiHMsc5lzSS-A5dJZABeX@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=00c09f93d6202f7eee048b963d9d

--00c09f93d6202f7eee048b963d9d
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Who you build mysql 5.5.3 with innodb suport?

I made
sh configure.am --with-plugins=3Dall
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    =3D/mysql5/mysql5.err
socket     =3D /mysql5/mysql.sock
port       =3D 3308
pid-file   =3D /mysql5/mysql5.pid
datadir    =3D /mysql5/data

tmpdir=3D/tmpfs

binlog_cache_size=3D64M #tama=F1o de la transaccion a cachear
bulk_insert_buffer_size=3D256M #cache de insert por thread
delay_key_write=3DOFF #detiene la creacion de llaves? No, no nos conviene p=
or
integridad.

max_allowed_packet=3D256M
table_cache=3D4096
join_buffer_size=3D256M
tmp_table_size=3D1024M
sort_buffer_size=3D1024M
thread_cache_size=3D64
#default_storage_engine=3DINNODB
query_cache_size=3D1024M
query_cache_limit=3D256M
innodb_file_per_table


innodb_data_home_dir =3D /mysql5/innodb
innodb_data_file_path =3D ibdata/innodb:2000M:autoextend
innodb_buffer_pool_size=3D512M
innodb_flush_method=3Dfdatasync #ls opciones son fdatasync (default), O_DSY=
NC,
(lento?) O_DIRECT
innodb_locks_unsafe_for_binlog=3D1 #solo usa indices
innodb_additional_mem_pool_size=3D512M
innodb_log_file_size=3D2000M
innodb_log_buffer_size=3D32M
innodb_max_dirty_pages_pct=3D95
innodb_max_purge_lag=3D0
innodb_flush_log_at_trx_commit=3D1
innodb_lock_wait_timeout=3D50
innodb_thread_concurrency=3D200

max_heap_table_size=3D4G


what I'm doing wrong? Please advice.
Thanks.

--00c09f93d6202f7eee048b963d9d--