mysql 5.5.3 and innodb from source.

--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--

Re: mysql 5.5.3 and innodb from source.

On Sat, Jul 17, 2010 at 7:34 AM, Andr=E9s Tello wrot=
e:
> 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 an=
d
> do a
>
> show engines;
>
>
> I only have this:
>
> +--------------------+---------+---------------------------- -------------=
------------------+--------------+------+------------+
> | Engine =A0 =A0 =A0 =A0 =A0 =A0 | Support |
> Comment =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | Transactions |
> XA =A0 | Savepoints |
> +--------------------+---------+---------------------------- -------------=
------------------+--------------+------+------------+
> | MRG_MYISAM =A0 =A0 =A0 =A0 | YES =A0 =A0 | Collection of identical MyIS=
AM
> tables =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | NO =A0 =A0 =A0 =A0 =A0 |=
NO =A0 | NO =A0 =A0 =A0 =A0 |
> | PERFORMANCE_SCHEMA | YES =A0 =A0 | Performance
> Schema =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0| NO =A0 =A0 =A0 =A0 =A0 | NO =A0 |
> NO =A0 =A0 =A0 =A0 |
> | CSV =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| YES =A0 =A0 | CSV storage
> engine =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0| NO =A0 =A0 =A0 =A0 =A0 | NO =A0 |
> NO =A0 =A0 =A0 =A0 |
> | MEMORY =A0 =A0 =A0 =A0 =A0 =A0 | YES =A0 =A0 | Hash based, stored in me=
mory, useful for
> temporary tables | NO =A0 =A0 =A0 =A0 =A0 | NO =A0 | NO =A0 =A0 =A0 =A0 |
> | MyISAM =A0 =A0 =A0 =A0 =A0 =A0 | DEFAULT | Default engine as of MySQL 3=
..23 with great
> performance =A0 =A0| NO =A0 =A0 =A0 =A0 =A0 | NO =A0 | NO =A0 =A0 =A0 =A0=
|
> +--------------------+---------+---------------------------- -------------=
------------------+--------------+------+------------+
>
>
> my my.cnf...
>
> skip-name-resolve
> log_error =A0  =/mysql5/mysql5.err
> socket =A0 =A0 =3D /mysql5/mysql.sock
> port =A0 =A0 =A0 =3D 3308
> pid-file =A0 =3D /mysql5/mysql5.pid
> datadir =A0  = /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=
por
> 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_D=
SYNC,
> (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.
>

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-in stallation.html

This is only a guess.

--=20
Rob Wultsch
wultsch@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg