MySQL Bugs: #50209: InnoDB plugin 1.06 dont start?

Bug #50209	InnoDB plugin 1.06 dont start?
Submitted:	10 Jan 2010 11:03	Modified:	11 Jan 2010 9:35
Reporter:	Hernando Gonzalez	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	Mysql 5.1.42	OS:	Linux (RHEL 5.4)
Assigned to:		CPU Architecture:	Any

Description:
Hello, 

I Recently install MySQL 5.1.42 and, aparently everything is fine, i only dont know if this is ok?

When i start mysql show this:

100110 05:46:16 mysqld_safe mysqld from pid file /var/lib/mysql/server-1.localhost.pid ended
100110 05:47:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100110  5:47:05 [Note] Plugin 'FEDERATED' is disabled.
100110  5:47:06  InnoDB: Started; log sequence number 26 1081419957
100110  5:47:06 [Note] Event Scheduler: Loaded 0 events
100110  5:47:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.42-community-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)

but, my before version show something like. "InnoDB Plugin 1.04 Started: log sequence number".. etc etc etc... 

Is a bug? dont load the innodb plugin?? is ok?

Thanks.

How to repeat:
Restart Mysql.

Thank you for the report.

Please provide output of SHOW PLUGINS and SHOW ENGINES.

[root@server ~]# mysql -v
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 121492
Server version: 5.1.42-community-log MySQL Community Server (GPL)

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

------------------------------------------------------------------
SHOW PLUGINS;

binlog 	ACTIVE 	STORAGE ENGINE 	(NULL) 	GPL
partition 	ACTIVE 	STORAGE ENGINE 	(NULL) 	GPL
ARCHIVE 	ACTIVE 	STORAGE ENGINE 	(NULL) 	GPL
BLACKHOLE 	ACTIVE 	STORAGE ENGINE 	(NULL) 	GPL
CSV 	ACTIVE 	STORAGE ENGINE 	(NULL) 	GPL
FEDERATED 	DISABLED 	STORAGE ENGINE 	(NULL) 	GPL
MEMORY 	ACTIVE 	STORAGE ENGINE 	(NULL) 	GPL
InnoDB 	ACTIVE 	STORAGE ENGINE 	(NULL) 	GPL
MyISAM 	ACTIVE 	STORAGE ENGINE 	(NULL) 	GPL
MRG_MYISAM 	ACTIVE 	STORAGE ENGINE 	(NULL) 	GPL

-----------------------------------------------------------
SHOW ENGINES;

InnoDB 	YES 	Supports transactions, row-level locking, and foreign keys 	YES 	YES 	YES
MRG_MYISAM 	YES 	Collection of identical MyISAM tables 	NO 	NO 	NO
BLACKHOLE 	YES 	/dev/null storage engine (anything you write to it disappears) 	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
FEDERATED 	NO 	Federated MySQL storage engine 	(NULL) 	(NULL) 	(NULL)
ARCHIVE 	YES 	Archive storage engine 	NO 	NO 	NO
MyISAM 	DEFAULT 	Default engine as of MySQL 3.23 with great performance 	NO 	NO 	NO

Thank you for the feedback.

Output of SHOW PLUGINS and SHOW ENGINES clearly shows builtin InnoDB is up and running:

InnoDB 	ACTIVE 	STORAGE ENGINE 	(NULL) 	GPL
...
InnoDB 	YES 	Supports transactions, row-level locking, and foreign keys

To start InnoDB Plugin follow instructions at http://dev.mysql.com/doc/refman/5.1/en/innodb.html started from "To use the InnoDB Plugin, you must disable the built-in version of InnoDB"

Yes, i see know, my typo.

Thanks you very much.