教你如何恢复使用MEB备份的MySQL数据库
恢复使用MEB备份的MySQL数据库，执行一个普通备份
[root@testbin]#./mysqlbackup--defaults-file=/service/mysql5.5/my.cnf--socket=/data/mysql5.5/mysql.sock--user=root--backup-dir=/backup/5.5/normal--passwordbackup MySQLEnterpriseBackupversion3.8.2[2013/06/18] Copyright(c)2003,2012,Oracleand/oritsaffiliates.AllRightsReserved. mysqlbackup:INFO:Startingwithfollowingcommandline... ./mysqlbackup--defaults-file=/service/mysql5.5/my.cnf --socket=/data/mysql5.5/mysql.sock--user=root --backup-dir=/backup/5.5/normal--passwordbackup Enterpassword: mysqlbackup:INFO:MySQLserverversionis'5.5.25-log'. mysqlbackup:INFO:Gotsomeserverconfigurationinformationfromrunningserver. IMPORTANT:Pleasecheckthatmysqlbackupruncompletessuccessfully. Attheendofasuccessful'backup'runmysqlbackup prints"mysqlbackupcompletedOK!".
--------------------------------------------------------------------
ServerRepositoryOptions:
--------------------------------------------------------------------
datadir=/data/mysql5.5/ innodb_data_home_dir= innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir=/data/mysql5.5/ innodb_log_files_in_group=3 innodb_log_file_size=536870912 innodb_page_size=Null innodb_checksum_algorithm=innodb
--------------------------------------------------------------------
BackupConfigOptions:
--------------------------------------------------------------------
datadir=/backup/5.5/normal/datadir innodb_data_home_dir=/backup/5.5/normal/datadir innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir=/backup/5.5/normal/datadir innodb_log_files_in_group=3 innodb_log_file_size=536870912 innodb_page_size=16384 innodb_checksum_algorithm=innodb mysqlbackup:INFO:Uniquegeneratedbackupidforthisis13851351066141087 mysqlbackup:INFO:Usesposix_fadvise()forperformanceoptimization. mysqlbackup:INFO:Creating14bufferseachofsize16777216. 13112223:45:08mysqlbackup:INFO:FullBackupoperationstartswithfollowingthreads 1read-threads6process-threads1write-threads 13112223:45:08mysqlbackup:INFO:SystemtablespacefileformatisAntelope. 13112223:45:08mysqlbackup:INFO:Startingtocopyallinnodbfiles... 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/ibdata1(Antelopefileformat). 13112223:45:08mysqlbackup:INFO:Foundcheckpointatlsn3406087628. 13112223:45:08mysqlbackup:INFO:Startinglogscanfromlsn3406087168. 13112223:45:08mysqlbackup:INFO:Copyinglog... 13112223:45:08mysqlbackup:INFO:Logcopied,lsn3406087628. 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_global_qs_variables.ibd(Antelopefileformat). 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_global_script_report_data.ibd(Antelopefileformat). 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_global_split_column_names_table.ibd(Antelopefileformat). 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_global_sql_tokens.ibd(Antelopefileformat). 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_known_thread_states.ibd(Antelopefileformat). 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_named_scripts.ibd(Antelopefileformat). 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_script_statements.ibd(Antelopefileformat). 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_waits.ibd(Antelopefileformat). 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/help_content.ibd(Antelopefileformat). 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/metadata.ibd(Antelopefileformat). 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/numbers.ibd(Antelopefileformat). 13112223:45:08mysqlbackup:INFO:Copying/data/mysql5.5/zwc/t2.ibd(Antelopefileformat). mysqlbackup:ProgressinMB:200400 13112223:45:20mysqlbackup:INFO:Completingthecopyofinnodbfiles. 13112223:45:21mysqlbackup:INFO:Preparingtolocktables:Connectedtomysqldserver. 13112223:45:21mysqlbackup:INFO:Startingtolockallthetables... 13112223:45:21mysqlbackup:INFO:Alltablesarelockedandflushedtodisk 13112223:45:21mysqlbackup:INFO:Openingbackupsourcedirectory'/data/mysql5.5/' 13112223:45:21mysqlbackup:INFO:Startingtobackupallnon-innodbfilesin subdirectoriesof'/data/mysql5.5/' 13112223:45:21mysqlbackup:INFO:Copyingthedatabasedirectory'common_schema' 13112223:45:21mysqlbackup:INFO:Copyingthedatabasedirectory'mysql' 13112223:45:21mysqlbackup:INFO:Copyingthedatabasedirectory'performance_schema' 13112223:45:21mysqlbackup:INFO:Copyingthedatabasedirectory'test' 13112223:45:21mysqlbackup:INFO:Copyingthedatabasedirectory'zwc' mysqlbackup:ProgressinMB:600800 13112223:45:33mysqlbackup:INFO:Completingthecopyofallnon-innodbfiles. 13112223:45:35mysqlbackup:INFO:Acopieddatabasepagewasmodifiedat3406087628. (Thisisthehighestlsnfoundonpage) Scannedloguptolsn3406090810. Wasabletoparsetheloguptolsn3406090810. Maximumpagenumberforalogrecord315 13112223:45:35mysqlbackup:INFO:Alltablesunlocked 13112223:45:35mysqlbackup:INFO:AllMySQLtableswerelockedfor13.758seconds. 13112223:45:35mysqlbackup:INFO:FullBackupoperationcompletedsuccessfully. 13112223:45:35mysqlbackup:INFO:Backupcreatedindirectory'/backup/5.5/normal' 13112223:45:35mysqlbackup:INFO:MySQLbinlogposition:filenameZWC-TEST.000024,position16178 ------------------------------------------------------------- ParametersSummary ------------------------------------------------------------- StartLSN:3406087168 EndLSN:3406090810 ------------------------------------------------------------- mysqlbackupcompletedOK!
或者压缩备份
[root@testbin]#./mysqlbackup--defaults-file=/service/mysql5.5/my.cnf--socket=/data/mysql5.5/mysql.sock--user=root--backup-dir=/backup/5.5/compress--compress--passwordbackup MySQLEnterpriseBackupversion3.8.2[2013/06/18] Copyright(c)2003,2012,Oracleand/oritsaffiliates.AllRightsReserved. mysqlbackup:INFO:Startingwithfollowingcommandline... ./mysqlbackup--defaults-file=/service/mysql5.5/my.cnf --socket=/data/mysql5.5/mysql.sock--user=root --backup-dir=/backup/5.5/compress--compress--passwordbackup Enterpassword: mysqlbackup:INFO:MySQLserverversionis'5.5.25-log'. mysqlbackup:INFO:Gotsomeserverconfigurationinformationfromrunningserver. IMPORTANT:Pleasecheckthatmysqlbackupruncompletessuccessfully. Attheendofasuccessful'backup'runmysqlbackup prints"mysqlbackupcompletedOK!".
--------------------------------------------------------------------
ServerRepositoryOptions:
--------------------------------------------------------------------
datadir=/data/mysql5.5/ innodb_data_home_dir= innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir=/data/mysql5.5/ innodb_log_files_in_group=3 innodb_log_file_size=536870912 innodb_page_size=Null innodb_checksum_algorithm=innodb
--------------------------------------------------------------------
BackupConfigOptions:
--------------------------------------------------------------------
datadir=/backup/5.5/compress/datadir innodb_data_home_dir=/backup/5.5/compress/datadir innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir=/backup/5.5/compress/datadir innodb_log_files_in_group=3 innodb_log_file_size=536870912 innodb_page_size=16384 innodb_checksum_algorithm=innodb mysqlbackup:INFO:Uniquegeneratedbackupidforthisis13851352214073555 mysqlbackup:INFO:Usesposix_fadvise()forperformanceoptimization. mysqlbackup:INFO:Creating18bufferseachofsize16794070. 13112223:47:03mysqlbackup:INFO:CompressBackupoperationstartswithfollowingthreads 1read-threads6process-threads1write-threads 13112223:47:03mysqlbackup:INFO:SystemtablespacefileformatisAntelope. 13112223:47:03mysqlbackup:INFO:Startingtocopyallinnodbfiles... 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/ibdata1(Antelopefileformat). 13112223:47:03mysqlbackup:INFO:Foundcheckpointatlsn3406092146. 13112223:47:03mysqlbackup:INFO:Startinglogscanfromlsn3406091776. 13112223:47:03mysqlbackup:INFO:Copyinglog... 13112223:47:03mysqlbackup:INFO:Logcopied,lsn3406092146. 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_global_qs_variables.ibd(Antelopefileformat). 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_global_script_report_data.ibd(Antelopefileformat). 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_global_split_column_names_table.ibd(Antelopefileformat). 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_global_sql_tokens.ibd(Antelopefileformat). 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_known_thread_states.ibd(Antelopefileformat). 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_named_scripts.ibd(Antelopefileformat). 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_script_statements.ibd(Antelopefileformat). 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/_waits.ibd(Antelopefileformat). 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/help_content.ibd(Antelopefileformat). 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/metadata.ibd(Antelopefileformat). 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/common_schema/numbers.ibd(Antelopefileformat). 13112223:47:03mysqlbackup:INFO:Copying/data/mysql5.5/zwc/t2.ibd(Antelopefileformat). mysqlbackup:ProgressinMB:200400 13112223:47:11mysqlbackup:INFO:Completingthecopyofinnodbfiles. 13112223:47:14mysqlbackup:INFO:Preparingtolocktables:Connectedtomysqldserver. 13112223:47:14mysqlbackup:INFO:Startingtolockallthetables... 13112223:47:14mysqlbackup:INFO:Alltablesarelockedandflushedtodisk 13112223:47:14mysqlbackup:INFO:Openingbackupsourcedirectory'/data/mysql5.5/' 13112223:47:14mysqlbackup:INFO:Startingtobackupallnon-innodbfilesin subdirectoriesof'/data/mysql5.5/' 13112223:47:14mysqlbackup:INFO:Copyingthedatabasedirectory'common_schema' 13112223:47:14mysqlbackup:INFO:Copyingthedatabasedirectory'mysql' 13112223:47:15mysqlbackup:INFO:Copyingthedatabasedirectory'performance_schema' 13112223:47:15mysqlbackup:INFO:Copyingthedatabasedirectory'test' 13112223:47:15mysqlbackup:INFO:Copyingthedatabasedirectory'zwc' mysqlbackup:ProgressinMB:600800 13112223:47:26mysqlbackup:INFO:Completingthecopyofallnon-innodbfiles. 13112223:47:28mysqlbackup:INFO:Acopieddatabasepagewasmodifiedat3406092146. (Thisisthehighestlsnfoundonpage) Scannedloguptolsn3406095314. Wasabletoparsetheloguptolsn3406095314. Maximumpagenumberforalogrecord319 13112223:47:29mysqlbackup:INFO:Alltablesunlocked 13112223:47:29mysqlbackup:INFO:AllMySQLtableswerelockedfor14.330seconds. 13112223:47:29mysqlbackup:INFO:Compressed496MBofdatafilesto200577kbytes(compression60.51%). 13112223:47:29mysqlbackup:INFO:CompressBackupoperationcompletedsuccessfully. 13112223:47:29mysqlbackup:INFO:Backupcreatedindirectory'/backup/5.5/compress' 13112223:47:29mysqlbackup:INFO:MySQLbinlogposition:filenameZWC-TEST.000024,position24831 ------------------------------------------------------------- ParametersSummary ------------------------------------------------------------- StartLSN:3406091776 EndLSN:3406095314 ------------------------------------------------------------- mysqlbackupcompletedOK!
停止MySQL服务
[root@testmysql5.5]#/service/mysql5.5/bin/mysqladminshutdown-uroot-p
删除数据目录里的文件
[root@testmysql5.5]#rm-rfcommon_schema/mysql/performance_schema/test/zwc/
从备份中还原
[root@testbin]#./mysqlbackup--defaults-file=/service/mysql5.5/my.cnf--backup-dir=/backup/5.5/normalapply-log MySQLEnterpriseBackupversion3.8.2[2013/06/18] Copyright(c)2003,2012,Oracleand/oritsaffiliates.AllRightsReserved. mysqlbackup:INFO:Startingwithfollowingcommandline... ./mysqlbackup--defaults-file=/service/mysql5.5/my.cnf --backup-dir=/backup/5.5/normalapply-log IMPORTANT:Pleasecheckthatmysqlbackupruncompletessuccessfully. Attheendofasuccessful'apply-log'runmysqlbackup prints"mysqlbackupcompletedOK!".
--------------------------------------------------------------------
BackupConfigOptions:
--------------------------------------------------------------------
datadir=/backup/5.5/normal/datadir innodb_data_home_dir=/backup/5.5/normal/datadir innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir=/backup/5.5/normal/datadir innodb_log_files_in_group=3 innodb_log_file_size=536870912 innodb_page_size=16384 innodb_checksum_algorithm=innodb mysqlbackup:INFO:Usesposix_fadvise()forperformanceoptimization. mysqlbackup:INFO:Creating14bufferseachofsize65536. 13112223:59:39mysqlbackup:INFO:Apply-logoperationstartswithfollowingthreads 1read-threads1process-threads 13112223:59:39mysqlbackup:INFO:ibbackup_logfile'screationparameters: startlsn3406087168,endlsn3406090810, startcheckpoint3406087628. InnoDB:Doingrecovery:scanneduptologsequencenumber3406090810 mysqlbackup:INFO:InnoDB:Startinganapplybatchoflogrecordstothedatabase... InnoDB:Progressinpercent:0123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899Settinglogfilesizeto536870912 InnoDB:ProgressinMB:100200300400500 Settinglogfilesizeto536870912 InnoDB:ProgressinMB:100200300400500 Settinglogfilesizeto536870912 InnoDB:ProgressinMB:100200300400500 13112300:00:01mysqlbackup:INFO:Wewereabletoparseibbackup_logfileupto lsn3406090810. mysqlbackup:INFO:LastMySQLbinlogfileposition016178,filename./ZWC-TEST.000024 13112300:00:01mysqlbackup:INFO:Thefirstdatafileis'/backup/5.5/normal/datadir/ibdata1' andthenewcreatedlogfilesareat'/backup/5.5/normal/datadir' 13112300:00:01mysqlbackup:INFO:Apply-logoperationcompletedsuccessfully. 13112300:00:01mysqlbackup:INFO:Fullbackuppreparedforrecoverysuccessfully. mysqlbackupcompletedOK![root@testbin]#./mysqlbackup--defaults-file=/service/mysql5.5/my.cnf--backup-dir=/backup/5.5/normalcopy-back MySQLEnterpriseBackupversion3.8.2[2013/06/18] Copyright(c)2003,2012,Oracleand/oritsaffiliates.AllRightsReserved. mysqlbackup:INFO:Startingwithfollowingcommandline... ./mysqlbackup--defaults-file=/service/mysql5.5/my.cnf --backup-dir=/backup/5.5/normalcopy-back IMPORTANT:Pleasecheckthatmysqlbackupruncompletessuccessfully. Attheendofasuccessful'copy-back'runmysqlbackup prints"mysqlbackupcompletedOK!".
--------------------------------------------------------------------
ServerRepositoryOptions:
--------------------------------------------------------------------
datadir=/data/mysql5.5 innodb_data_home_dir=/data/mysql5.5 innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir=/data/mysql5.5 innodb_log_files_in_group=3 innodb_log_file_size=512M innodb_page_size=Null innodb_checksum_algorithm=innodb
--------------------------------------------------------------------
BackupConfigOptions:
--------------------------------------------------------------------
datadir=/backup/5.5/normal/datadir innodb_data_home_dir=/backup/5.5/normal/datadir innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir=/backup/5.5/normal/datadir innodb_log_files_in_group=3 innodb_log_file_size=536870912 innodb_page_size=16384 innodb_checksum_algorithm=innodb mysqlbackup:INFO:Usesposix_fadvise()forperformanceoptimization. mysqlbackup:INFO:Creating14bufferseachofsize16777216. 13112300:00:44mysqlbackup:INFO:Copy-backoperationstartswithfollowingthreads 1read-threads1write-threads 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/ibdata1. 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/common_schema/_global_qs_variables.ibd. 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/common_schema/_global_script_report_data.ibd. 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/common_schema/_global_split_column_names_table.ibd. 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/common_schema/_global_sql_tokens.ibd. 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/common_schema/_known_thread_states.ibd. 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/common_schema/_named_scripts.ibd. 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/common_schema/_script_statements.ibd. 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/common_schema/_waits.ibd. 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/common_schema/help_content.ibd. 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/common_schema/metadata.ibd. 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/common_schema/numbers.ibd. 13112300:00:45mysqlbackup:INFO:Copying/backup/5.5/normal/datadir/zwc/t2.ibd. mysqlbackup:ProgressinMB:200400 13112300:00:54mysqlbackup:INFO:Copyingthedatabasedirectory'common_schema' 13112300:00:55mysqlbackup:INFO:Copyingthedatabasedirectory'mysql' 13112300:00:55mysqlbackup:INFO:Copyingthedatabasedirectory'performance_schema' 13112300:00:55mysqlbackup:INFO:Copyingthedatabasedirectory'test' 13112300:00:55mysqlbackup:INFO:Copyingthedatabasedirectory'zwc' mysqlbackup:ProgressinMB:600800 13112300:01:06mysqlbackup:INFO:Completingthecopyofallnon-innodbfiles. 13112300:01:06mysqlbackup:INFO:Copyingthelogfile'ib_logfile0' mysqlbackup:ProgressinMB:100012001400 13112300:01:16mysqlbackup:INFO:Copyingthelogfile'ib_logfile1' mysqlbackup:ProgressinMB:16001800 13112300:01:27mysqlbackup:INFO:Copyingthelogfile'ib_logfile2' mysqlbackup:ProgressinMB:200022002400 13112300:01:38mysqlbackup:INFO:Copy-backoperationcompletedsuccessfully. 13112300:01:38mysqlbackup:INFO:Finishedcopyingbackupfilesto'/data/mysql5.5' mysqlbackupcompletedOK!
设置权限，启动MySQL服务
[root@testmysql5.5]#chown-Rmysql.mysql* [root@testmysql5.5]#/service/mysql5.5/bin/mysqld_safe--defaults-file=/service/mysql5.5/my.cnf--basedir=/service/mysql5.5--datadir=/data/mysql5.5--user=mysql& [1]6525 [root@testmysql5.5]#13112300:04:00mysqld_safeLoggingto'/data/mysql5.5/test.err'. 13112300:04:00mysqld_safeStartingmysqlddaemonwithdatabasesfrom/data/mysql5.5[root@testmysql5.5]#cattest.err 13112300:04:00mysqld_safeStartingmysqlddaemonwithdatabasesfrom/data/mysql5.5 1311230:04:00InnoDB:TheInnoDBmemoryheapisdisabled 1311230:04:00InnoDB:Mutexesandrw_locksuseGCCatomicbuiltins 1311230:04:00InnoDB:Compressedtablesusezlib1.2.3 1311230:04:00InnoDB:Initializingbufferpool,size=2.4G 1311230:04:00InnoDB:Completedinitializationofbufferpool 1311230:04:00InnoDB:highestsupportedfileformatisBarracuda. InnoDB:Logscanprogressedpastthecheckpointlsn3406091276 1311230:04:00InnoDB:Databasewasnotshutdownnormally! InnoDB:Startingcrashrecovery. InnoDB:Readingtablespaceinformationfromthe.ibdfiles... InnoDB:Restoringpossiblehalf-writtendatapagesfromthedoublewrite InnoDB:buffer... InnoDB:Doingrecovery:scanneduptologsequencenumber3406091710 1311230:04:01InnoDB:Startinganapplybatchoflogrecordstothedatabase... InnoDB:Progressinpercents:6263646566676869707172737475767778798081828384858687888990919293949596979899 InnoDB:Applybatchcompleted InnoDB:LastMySQLbinlogfileposition016178,filename./ZWC-TEST.000024 1311230:04:01InnoDB:Waitingforthebackgroundthreadstostart 1311230:04:02InnoDB:1.1.8started;logsequencenumber3406091710 1311230:04:02[Note]RecoveringafteracrashusingZWC-TEST 1311230:04:02[Note]Startingcrashrecovery... 1311230:04:02[Note]Crashrecoveryfinished. 1311230:04:02[Note]Serverhostname(bind-address):'0.0.0.0';port:30306 1311230:04:02[Note]-'0.0.0.0'resolvesto'0.0.0.0'; 1311230:04:02[Note]ServersocketcreatedonIP:'0.0.0.0'. 1311230:04:02[Warning]'user'entry'root@test'ignoredin--skip-name-resolvemode. 1311230:04:02[Warning]'user'entry'@test'ignoredin--skip-name-resolvemode. 1311230:04:02[Warning]'proxies_priv'entry'@root@test'ignoredin--skip-name-resolvemode. 1311230:04:02[Note]EventScheduler:Loaded0events 1311230:04:02[Note]/service/mysql5.5/bin/mysqld:readyforconnections. Version:'5.5.25-log'socket:'/data/mysql5.5/mysql.sock'port:30306ZWC 1311230:04:02[Note]EventScheduler:schedulerthreadstartedwithid1
数据库已经恢复
[root@testmysql5.5]#/service/mysql5.5/bin/mysql-uroot-p-Dzwc Enterpassword: WelcometotheMySQLmonitor.Commandsendwith;or\g. YourMySQLconnectionidis6 Serverversion:5.5.25-logZWC Copyright(c)2000,2011,Oracleand/oritsaffiliates.Allrightsreserved. OracleisaregisteredtrademarkofOracleCorporationand/orits affiliates.Othernamesmaybetrademarksoftheirrespective owners. Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement. root@linuxidc12:05:07>selectcount(*),now()fromt1; +----------+---------------------+ |count(*)|now()| +----------+---------------------+ |10000000|2013-11-2300:05:17| +----------+---------------------+ 1rowinset(0.04sec) root@linuxidc12:05:17>selectcount(*),now()fromt2; +----------+---------------------+ |count(*)|now()| +----------+---------------------+ |10000000|2013-11-2300:05:19| +----------+---------------------+ 1rowinset(2.91sec)