Re: [Maria-discuss] MariaDB 5.1.42 has been released

[Alexandre Almeida]

Hi guys,

        SHOW ENGINES doesn't show innoDB.
	The interesting thing is: I simply compiled it again and it's running  
quite well.

	Which parameters do you recommend for best performance at mac os  
machines?

        Thanks,

Alex

<<inline: alexandre(jpg).jpg>>

Em 18/02/2010, às 14:04, Hakan Kuecuekyilmaz escreveu:

Hola,

On 18.02.2010, at 13:18, Alexandre Almeida wrote:

Hi guys,

	I have download it for the next DBA class next week. I am not  
using mysql at DBA class anymore.

        I am a MAC user, so, I have to download the sources and compile it.

        I just did the basics such as:

        configure --prefix=/usr/local/mariadb-5.1.42 --with-plugins=max
        make
        make install

	During the configure process I can read = innodb bla-bla-bla =  
YES, but, after mysqld starting I am getting have_innodb = NO WAY  
BUDDY!!! ;-)

	I am missing anything during configure process? Or do I have to  
include some line at my my.cnf?

What does "show engines" tell you? I just compiled 5.1.42 as you  
described and I get:

| InnoDB     | YES     | Supports transactions, row-level locking,  
and foreign keys

You can also try:
mysql> CREATE TABLE t1 (a int) Engine Innodb;
Query OK, 0 rows affected (0.05 sec)

mysql> show create table t1\G
*************************** 1. row ***************************
      Table: t1
Create Table: CREATE TABLE `t1` (
 `a` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

Best,

Hakan

--
Hakan Küçükyılmaz, QA/Benchmark Engineer, Stuttgart/Germany
Monty Program Ab, http://askmonty.org/
Skype: hakank_  Phone: +49 171 1919839



_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp