1.    The first start
110112 10:13:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/
110112 10:13:21 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic built-ins    (### which mean new lock and mutex methods)
InnoDB: Compressed tables use zlib 1.2.3                (### use compressed tech zlib1.2.3)
110112 10:13:21  InnoDB: Using Linux native AIO          (### use native aio replace old aio)
110112 10:13:21  InnoDB: Initializing buffer pool, size = 1.0G 
110112 10:13:21  InnoDB: Completed initialization of buffer pool (### can configure as multi buffer pools and new dirth flushing methods)
InnoDB: The first specified data file /usr/local/mysql/data/ibdata1 did not exist:
InnoDB: a new database to be created!
110112 10:13:21  InnoDB: Setting file /usr/local/mysql/data/ibdata1 size to 200 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
110112 10:13:26  InnoDB: Log file /usr/local/mysql/arch/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /usr/local/mysql/arch/ib_logfile0 size to 100 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
110112 10:13:29  InnoDB: Log file /usr/local/mysql/arch/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /usr/local/mysql/arch/ib_logfile1 size to 100 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
InnoDB: Doublewrite buffer not found: creating new   (### create double buffer cache)
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.      (### 127 rollback segments replace old 1 rollback segment)
InnoDB: Creating foreign key constraint system tables 
InnoDB: Foreign key constraint system tables created
110112 10:13:32  InnoDB: 1.1.4 started; log sequence number 0   (### innodb version upgrade 1.1)
110112 10:13:32 [Note] Event Scheduler: Loaded 0 events
110112 10:13:32 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.8-log'  socket: '/usr/local/mysql/data/mysql.sock'  port: 3306  MySQL Community Server (GPL)  (### version: 5.5.8)
2.    Shutdown
110112 10:17:14 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

110112 10:17:14 [Note] Event Scheduler: Purging the queue. 0 events
110112 10:17:14  InnoDB: Starting shutdown...
110112 10:17:15  InnoDB: Shutdown completed; log sequence number 1595668
110112 10:17:15 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

110112 10:17:15 mysqld_safe mysqld from pid file /usr/local/mysql/data/hqd-alertsdb-01.pid ended

3.    Second startup  (### the startup will be so simply as the first startup)
110112 10:17:28 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/
110112 10:17:29 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
110112 10:17:29  InnoDB: Using Linux native AIO
110112 10:17:29  InnoDB: Initializing buffer pool, size = 1.0G
110112 10:17:29  InnoDB: Completed initialization of buffer pool
110112 10:17:29  InnoDB: highest supported file format is Barracuda.
110112 10:17:29  InnoDB: 1.1.4 started; log sequence number 1595668
110112 10:17:29 [Note] Event Scheduler: Loaded 0 events
110112 10:17:29 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.8-log'  socket: '/usr/local/mysql/data/mysql.sock'  port: 3306  MySQL Community Server (GPL)

4.    Upgrade (###has removed the scripts mysql_fix_privilege_tables) from 5.1.53 to 5.5.8
[mysqladmin@hqd-alertsdb-01 bin]$ mysql_upgrade -u root -p
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/usr/local/mysql/data/mysql.sock'
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/usr/local/mysql/data/mysql.sock'
alerts.qrtz_blob_triggers                          OK
alerts.qrtz_calendars                              OK
alerts.qrtz_cron_triggers                          OK
alerts.qrtz_fired_triggers                         OK
alerts.qrtz_job_details                            OK
alerts.qrtz_job_listeners                          OK
alerts.qrtz_locks                                  OK
alerts.qrtz_paused_trigger_grps                    OK
alerts.qrtz_scheduler_state                        OK
alerts.qrtz_simple_triggers                        OK
alerts.qrtz_trigger_listeners                      OK
alerts.qrtz_triggers                               OK
alerts.temp                                        OK
alerts.tn_feedback                                 OK
alerts.tn_feedback_comment_type_def                OK
alerts.tn_feedback_comments                        OK
alerts.tn_feedback_data                            OK
alerts.tn_scheduled_alerts                         OK
alerts.tn_telenav_feedback                         OK
ecax.qrtz_blob_triggers                            OK
ecax.qrtz_calendars                                OK
ecax.qrtz_cron_triggers                            OK
ecax.qrtz_fired_triggers                           OK
ecax.qrtz_job_details                              OK
ecax.qrtz_job_listeners                            OK
ecax.qrtz_locks                                    OK
ecax.qrtz_paused_trigger_grps                      OK
ecax.qrtz_scheduler_state                          OK
ecax.qrtz_simple_triggers                          OK
ecax.qrtz_trigger_listeners                        OK
ecax.qrtz_triggers                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
tntreport.qrtz_blob_triggers                       OK
tntreport.qrtz_calendars                           OK
tntreport.qrtz_cron_triggers                       OK
tntreport.qrtz_fired_triggers                      OK
tntreport.qrtz_job_details                         OK
tntreport.qrtz_job_listeners                       OK
tntreport.qrtz_locks                               OK
tntreport.qrtz_paused_trigger_grps                 OK
tntreport.qrtz_scheduler_state                     OK
tntreport.qrtz_simple_triggers                     OK
tntreport.qrtz_trigger_listeners                   OK
tntreport.qrtz_triggers                            OK
tntreport.tntreport_datasource                     OK
tntreport.tntreport_status                         OK
Running 'mysql_fix_privilege_tables'...
WARNING: NULL values of the 'db_collation' column ('mysql.proc' table) have been updated with default values. Please verify if necessary.
OK

5.    Verify default engine
mysql> show variables like 'have_innodb';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb   | YES   |
+---------------+-------+
1 row in set (0.00 sec)

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |
| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)

mysql>