mysql-5.5.8 start & stop & upgrade process
1. The first start110112 10:13:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/
110112 10:13:21 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:21InnoDB: Using Linux native AIO (### use native aio replace old aio)
110112 10:13:21InnoDB: Initializing buffer pool,> 110112 10:13:21InnoDB: 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:21InnoDB: Setting file /usr/local/mysql/data/ibdata1> InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
110112 10:13:26InnoDB: 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> InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
110112 10:13:29InnoDB: 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> 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:32InnoDB: 1.1.4 started; log sequence number 0 (### innodb version upgrade 1.1)
110112 10:13:32 Event Scheduler: Loaded 0 events
110112 10:13:32 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.8-log'socket: '/usr/local/mysql/data/mysql.sock'port: 3306MySQL Community Server (GPL)(### version: 5.5.8)
2. Shutdown
110112 10:17:14 /usr/local/mysql/bin/mysqld: Normal shutdown
110112 10:17:14 Event Scheduler: Purging the queue. 0 events
110112 10:17:14InnoDB: Starting shutdown...
110112 10:17:15InnoDB: Shutdown completed; log sequence number 1595668
110112 10:17:15 /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 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:29InnoDB: Using Linux native AIO
110112 10:17:29InnoDB: Initializing buffer pool,> 110112 10:17:29InnoDB: Completed initialization of buffer pool
110112 10:17:29InnoDB: highest supported file format is Barracuda.
110112 10:17:29InnoDB: 1.1.4 started; log sequence number 1595668
110112 10:17:29 Event Scheduler: Loaded 0 events
110112 10:17:29 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.8-log'socket: '/usr/local/mysql/data/mysql.sock'port: 3306MySQL Community Server (GPL)
4. Upgrade (###has removed the scripts mysql_fix_privilege_tables) from 5.1.53 to 5.5.8
$ 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> | 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>
页:
[1]