MySQL 多实例安装

2024-07-24 12:59:44

字体：大中小

来源：转载

供稿：网友

MySQL 多实例安装测试环境：OS：CentOS 6.5（开发包全部安装）Mysql：5.6.28安装mysql两个实例，3306、3303端口1：创建用户、相关目录[root@mysql3 opt]# mkdir -p /mysql3306/data[root@mysql3 opt]# mkdir -p /mysql3306/logs[root@mysql3 opt]# mkdir -p /mysql3306/temp[root@mysql3 opt]# mkdir -p /mysql3307/data[root@mysql3 opt]# mkdir -p /mysql3307/logs[root@mysql3 opt]# mkdir -p /mysql3307/temp[root@mysql3 opt]# groupadd mysql[root@mysql3 opt]# useradd -g mysql mysql[root@mysql3 opt]# chown -R mysql:mysql /mysql3306/*[root@mysql3 opt]# chown -R mysql:mysql /mysql3307/*2：下载、解压、安装Mysql[root@mysql3 local]# cd /opt[root@mysql3 opt]# tar -zxvf mysql-5.6.28-linux-glibc2.5-x86_64.tar.gz[root@mysql3 opt]# mv mysql-5.6.28-linux-glibc2.5-x86_64 /usr/local/[root@mysql3 opt]# cd /usr/local/[root@mysql3 local]# ln -s mysql-5.6.28-linux-glibc2.5-x86_64 mysql[root@mysql3 local]# chown -R mysql:mysql /usr/local/mysql3：编辑参数文件[root@mysql3 opt]# vi /etc/mysql3306.cnf[mysqld]# GENERAL #user = mysqlport = 3306socket = /tmp/my3306.sockpid_file = /mysql3306/temp/mysql3306.piddatadir = /mysql3306/datatmpdir = /mysql3306/templog_bin = /mysql3306/logs/mysql3306-binrelay-log = /mysql3306/logs/mysql3306-relay-binlog_error = /mysql3306/logs/error.logslow_query_log_file = /mysql3306/logs/slow-queries.loglong_query_time=1sync_binlog = 0expire_logs_days = 7back_log=1024skip-name-resolveskip-slave-startskip-external-lockingskip-character-set-client-handshakeexplicit_defaults_for_timestamp=truedefault_storage_engine = InnoDBbind-address=0.0.0.0#lower_case_table_names = 0myisam_recover = FORCE,BACKUPtransaction-isolation = READ-COMMITTEDtable_definition_cache = 4096table_open_cache = 4096# connection #max_connections = 1100max_user_connections = 1000max_connect_errors = 1000# timeout #wait_timeout = 100interactive_timeout = 100lock_wait_timeout = 3connect_timeout = 20slave-net-timeout = 30# character # character-set-server=utf8init-connect='SET NAMES utf8'# disabled query cache #query_cache_type = 0query_cache_size = 0# replication #server_id=233306gtid_mode=ONenforce-gtid-consistencylog-slave-updatesbinlog-format=rowslave-parallel-workers=6master-info-repository=TABLErelay-log-info-repository=TABLEsync_master_info = 10000slave_sql_verify_checksum=1skip-slave-start# session #key_buffer_size = 128Mtmp_table_size = 32Mmax_heap_table_size = 32Mmax_allowed_packet = 32Mbulk_insert_buffer_size = 32Msort_buffer_size = 128Kread_buffer_size = 1Mread_rnd_buffer_size = 1Mjoin_buffer_size = 128Kmyisam_sort_buffer_size = 32Mtmp_table_size = 32Mmax_heap_table_size = 64Mthread_cache_size = 64#thread_concurrency = 32thread_stack = 192K# INNODB #innodb_flush_method = O_DIRECTinnodb_data_home_dir = /mysql3306/datainnodb_data_file_path = ibdata1:1024M:autoextend#redo loginnodb_log_group_home_dir=/mysql3306/logsinnodb_log_files_in_group = 3innodb_log_file_size = 1G#innodb performanceinnodb_flush_log_at_trx_commit = 0innodb_file_per_table = 1innodb_buffer_pool_instances = 8innodb_io_capacity = 2000innodb_lock_wait_timeout = 30binlog_error_action = ABORT_SERVERinnodb_buffer_pool_size = 512Minnodb_max_dirty_pages_pct=90innodb_file_format=Barracuda innodb_support_xa = 0innodb_buffer_pool_dump_at_shutdown = 1innodb_buffer_pool_load_at_startup = 1[root@mysql3 opt]# cp /etc/mysql3306.cnf /etc/mysql3307.cnf[root@mysql3 opt]# vi /etc/mysql3307.cnf [mysqld]# GENERAL #user = mysqlport = 3307socket = /tmp/my3307.sockpid_file = /mysql3307/temp/mysql3307.piddatadir = /mysql3307/datatmpdir = /mysql3307/templog_bin = /mysql3307/logs/mysql3307-binrelay-log = /mysql3307/logs/mysql3307-relay-binlog_error = /mysql3307/logs/error.logslow_query_log_file = /mysql3307/logs/slow-queries.loglong_query_time=1sync_binlog = 0expire_logs_days = 7back_log=1024skip-name-resolveskip-slave-startskip-external-lockingskip-character-set-client-handshakeexplicit_defaults_for_timestamp=truedefault_storage_engine = InnoDBbind-address=0.0.0.0#lower_case_table_names = 0myisam_recover = FORCE,BACKUPtransaction-isolation = READ-COMMITTEDtable_definition_cache = 4096table_open_cache = 4096# connection #max_connections = 1100max_user_connections = 1000max_connect_errors = 1000# timeout #wait_timeout = 100interactive_timeout = 100lock_wait_timeout = 3connect_timeout = 20slave-net-timeout = 30# character #character-set-server=utf8init-connect='SET NAMES utf8'# disabled query cache #query_cache_type = 0query_cache_size = 0# replication #server_id=233307gtid_mode=ONenforce-gtid-consistencylog-slave-updatesbinlog-format=rowslave-parallel-workers=6master-info-repository=TABLErelay-log-info-repository=TABLEsync_master_info = 10000slave_sql_verify_checksum=1skip-slave-start# session #key_buffer_size = 128Mtmp_table_size = 32Mmax_heap_table_size = 32Mmax_allowed_packet = 32Mbulk_insert_buffer_size = 32Msort_buffer_size = 128Kread_buffer_size = 1Mread_rnd_buffer_size = 1Mjoin_buffer_size = 128Kmyisam_sort_buffer_size = 32Mtmp_table_size = 32Mmax_heap_table_size = 64Mthread_cache_size = 64#thread_concurrency = 32thread_stack = 192K# INNODB #innodb_flush_method = O_DIRECTinnodb_data_home_dir = /mysql3307/datainnodb_data_file_path = ibdata1:1024M:autoextend#redo loginnodb_log_group_home_dir=/mysql3307/logsinnodb_log_files_in_group = 3innodb_log_file_size = 1G#innodb performanceinnodb_flush_log_at_trx_commit = 0innodb_file_per_table = 1innodb_buffer_pool_instances = 8innodb_io_capacity = 2000innodb_lock_wait_timeout = 30binlog_error_action = ABORT_SERVERinnodb_buffer_pool_size = 512Minnodb_max_dirty_pages_pct=90innodb_file_format=Barracudainnodb_support_xa = 0innodb_buffer_pool_dump_at_shutdown = 1innodb_buffer_pool_load_at_startup = 14：初始化初始化3306端口实例：[root@mysql3 scripts]# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --defaults-file=/etc/mysql3306.cnfInstalling MySQL system tables...2016-07-18 02:00:53 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.28-log) starting as PRocess 2243 ...OKFilling help tables...2016-07-18 02:01:15 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.28-log) starting as process 2282 ...OKTo start mysqld at boot time you have to copysupport-files/mysql.server to the right place for your systemPLEASE REMEMBER TO SET A PASSWord FOR THE MySQL root USER !To do so, start the server, then issue the following commands: /usr/local/mysql/bin/mysqladmin -u root password 'new-password' /usr/local/mysql/bin/mysqladmin -u root -h 192.168.1.23 password 'new-password' ......看见两个OK，就是正常完成初始化初始化3307端口实例：[root@mysql3 scripts]# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --defaults-file=/etc/mysql3307.cnfInstalling MySQL system tables...2016-07-18 02:02:59 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.28-log) starting as process 2313 ...OKFilling help tables...2016-07-18 02:03:19 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.28-log) starting as process 2335 ...OKTo start mysqld at boot time you have to copysupport-files/mysql.server to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following commands: /usr/local/mysql/bin/mysqladmin -u root password 'new-password' /usr/local/mysql/bin/mysqladmin -u root -h 192.168.1.23 password 'new-password'......看见两个OK，就是正常完成初始化5：启动启动3306端口实例[root@mysql3 scripts]# /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/mysql3306.cnf &[1] 2366[root@mysql3 scripts]# 160718 02:08:32 mysqld_safe Logging to '/mysql3306/logs/error.log'.160718 02:08:32 mysqld_safe Starting mysqld daemon with databases from /mysql3306/data

[root@mysql3 scripts]#

查看error.log：[root@mysql3 logs]# tail -200f /mysql3306/logs/error.log 2016-07-18 02:00:53 2243 [Note] InnoDB: Using atomics to ref count buffer pool pages2016-07-18 02:00:53 2243 [Note] InnoDB: The InnoDB memory heap is disabled2016-07-18 02:00:53 2243 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2016-07-18 02:00:53 2243 [Note] InnoDB: Memory barrier is not used2016-07-18 02:00:53 2243 [Note] InnoDB: Compressed tables use zlib 1.2.32016-07-18 02:00:53 2243 [Note] InnoDB: Using Linux native AIO2016-07-18 02:00:53 2243 [Note] InnoDB: Not using CPU crc32 instructions2016-07-18 02:00:53 2243 [Note] InnoDB: Initializing buffer pool, size = 512.0M2016-07-18 02:00:53 2243 [Note] InnoDB: Completed initialization of buffer pool2016-07-18 02:00:53 2243 [Note] InnoDB: The first specified data file /mysql3306/data/ibdata1 did not exist: a new database to be created!2016-07-18 02:00:53 2243 [Note] InnoDB: Setting file /mysql3306/data/ibdata1 size to 1024 MB2016-07-18 02:00:53 2243 [Note] InnoDB: Database physically writes the file full: wait...InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 10002016-07-18 02:00:56 2243 [Note] InnoDB: Setting log file /mysql3306/logs/ib_logfile101 size to 1024 MBInnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 10002016-07-18 02:01:03 2243 [Note] InnoDB: Setting log file /mysql3306/logs/ib_logfile1 size to 1024 MBInnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 10002016-07-18 02:01:09 2243 [Note] InnoDB: Setting log file /mysql3306/logs/ib_logfile2 size to 1024 MBInnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 10002016-07-18 02:01:13 2243 [Note] InnoDB: Renaming log file /mysql3306/logs/ib_logfile101 to /mysql3306/logs/ib_logfile02016-07-18 02:01:13 2243 [Warning] InnoDB: New log files created, LSN=457822016-07-18 02:01:13 2243 [Note] InnoDB: Doublewrite buffer not found: creating new2016-07-18 02:01:13 2243 [Note] InnoDB: Doublewrite buffer created2016-07-18 02:01:13 2243 [Note] InnoDB: 128 rollback segment(s) are active.2016-07-18 02:01:13 2243 [Warning] InnoDB: Creating foreign key constraint system tables.2016-07-18 02:01:13 2243 [Note] InnoDB: Foreign key constraint system tables created2016-07-18 02:01:13 2243 [Note] InnoDB: Creating tablespace and datafile system tables.2016-07-18 02:01:13 2243 [Note] InnoDB: Tablespace and datafile system tables created.2016-07-18 02:01:13 2243 [Note] InnoDB: Waiting for purge to start2016-07-18 02:01:13 2243 [Note] InnoDB: 5.6.28 started; log sequence number 02016-07-18 02:01:13 7fe12cf34700 InnoDB: Loading buffer pool(s) from /mysql3306/data/ib_buffer_pool2016-07-18 02:01:13 7fe12cf34700 InnoDB: Cannot open '/mysql3306/data/ib_buffer_pool' for reading: No such file or directory2016-07-18 02:01:13 2243 [Warning] Bootstrap mode disables GTIDs. Bootstrap mode should only be used by mysql_install_db which initializes the MySQL data directory and creates system tables.2016-07-18 02:01:14 2243 [Note] Binlog end2016-07-18 02:01:14 2243 [Note] InnoDB: FTS optimize thread exiting.2016-07-18 02:01:14 2243 [Note] InnoDB: Starting shutdown...2016-07-18 02:01:14 7fe12cf34700 InnoDB: Dumping buffer pool(s) to /mysql3306/data/ib_buffer_pool2016-07-18 02:01:14 7fe12cf34700 InnoDB: Buffer pool(s) dump completed at 160718 2:01:142016-07-18 02:01:15 2243 [Note] InnoDB: Shutdown completed; log sequence number 16258102016-07-18 02:01:15 2282 [Note] InnoDB: Using atomics to ref count buffer pool pages2016-07-18 02:01:15 2282 [Note] InnoDB: The InnoDB memory heap is disabled2016-07-18 02:01:15 2282 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2016-07-18 02:01:15 2282 [Note] InnoDB: Memory barrier is not used2016-07-18 02:01:15 2282 [Note] InnoDB: Compressed tables use zlib 1.2.32016-07-18 02:01:15 2282 [Note] InnoDB: Using Linux native AIO2016-07-18 02:01:15 2282 [Note] InnoDB: Not using CPU crc32 instructions2016-07-18 02:01:15 2282 [Note] InnoDB: Initializing buffer pool, size = 512.0M2016-07-18 02:01:15 2282 [Note] InnoDB: Completed initialization of buffer pool2016-07-18 02:01:16 2282 [Note] InnoDB: Highest supported file format is Barracuda.2016-07-18 02:01:16 2282 [Note] InnoDB: 128 rollback segment(s) are active.2016-07-18 02:01:16 2282 [Note] InnoDB: Waiting for purge to start2016-07-18 02:01:16 2282 [Note] InnoDB: 5.6.28 started; log sequence number 16258102016-07-18 02:01:16 7f4a2d621700 InnoDB: Loading buffer pool(s) from /mysql3306/data/ib_buffer_pool2016-07-18 02:01:16 2282 [Warning] Bootstrap mode disables GTIDs. Bootstrap mode should only be used by mysql_install_db which initializes the MySQL data directory and creates system tables.2016-07-18 02:01:16 7f4a2d621700 InnoDB: Buffer pool(s) load completed at 160718 2:01:162016-07-18 02:01:16 2282 [Note] Binlog end2016-07-18 02:01:16 2282 [Note] InnoDB: FTS optimize thread exiting.2016-07-18 02:01:16 2282 [Note] InnoDB: Starting shutdown...2016-07-18 02:01:16 7f4a2d621700 InnoDB: Dumping buffer pool(s) to /mysql3306/data/ib_buffer_pool2016-07-18 02:01:16 7f4a2d621700 InnoDB: Buffer pool(s) dump completed at 160718 2:01:162016-07-18 02:01:18 2282 [Note] InnoDB: Shutdown completed; log sequence number 1625820160718 02:08:32 mysqld_safe Starting mysqld daemon with databases from /mysql3306/data2016-07-18 02:08:37 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.28-log) starting as process 3431 ...2016-07-18 02:08:38 3431 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.2016-07-18 02:08:38 3431 [Note] Plugin 'FEDERATED' is disabled.2016-07-18 02:08:38 3431 [Note] InnoDB: Using atomics to ref count buffer pool pages2016-07-18 02:08:38 3431 [Note] InnoDB: The InnoDB memory heap is disabled2016-07-18 02:08:38 3431 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2016-07-18 02:08:38 3431 [Note] InnoDB: Memory barrier is not used2016-07-18 02:08:38 3431 [Note] InnoDB: Compressed tables use zlib 1.2.32016-07-18 02:08:38 3431 [Note] InnoDB: Using Linux native AIO2016-07-18 02:08:38 3431 [Note] InnoDB: Not using CPU crc32 instructions2016-07-18 02:08:38 3431 [Note] InnoDB: Initializing buffer pool, size = 512.0M2016-07-18 02:08:38 3431 [Note] InnoDB: Completed initialization of buffer pool2016-07-18 02:08:38 3431 [Note] InnoDB: Highest supported file format is Barracuda.2016-07-18 02:08:38 3431 [Note] InnoDB: 128 rollback segment(s) are active.2016-07-18 02:08:38 3431 [Note] InnoDB: Waiting for purge to start2016-07-18 02:08:38 3431 [Note] InnoDB: 5.6.28 started; log sequence number 16258202016-07-18 02:08:38 7fc7c4dfa700 InnoDB: Loading buffer pool(s) from /mysql3306/data/ib_buffer_pool2016-07-18 02:08:38 3431 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 7c77185a-4c49-11e6-8450-000c29c7b3d5.2016-07-18 02:08:38 7fc7c4dfa700 InnoDB: Buffer pool(s) load completed at 160718 2:08:382016-07-18 02:08:38 3431 [Note] Server hostname (bind-address): '0.0.0.0'; port: 33062016-07-18 02:08:38 3431 [Note] - '0.0.0.0' resolves to '0.0.0.0';2016-07-18 02:08:38 3431 [Note] Server socket created on IP: '0.0.0.0'.2016-07-18 02:08:38 3431 [Warning] 'user' entry 'root@mysql3' ignored in --skip-name-resolve mode.2016-07-18 02:08:38 3431 [Warning] 'user' entry '@mysql3' ignored in --skip-name-resolve mode.2016-07-18 02:08:38 3431 [Warning] 'proxies_priv' entry '@ root@mysql3' ignored in --skip-name-resolve mode.2016-07-18 02:08:38 3431 [Note] Event Scheduler: Loaded 0 events2016-07-18 02:08:38 3431 [Note] /usr/local/mysql/bin/mysqld: ready for connections.Version: '5.6.28-log' socket: '/tmp/my3306.sock' port: 3306 MySQL Community Server (GPL)启动3307端口实例[root@mysql3 scripts]# /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/mysql3307.cnf &[2] 3464[root@mysql3 scripts]# 160718 02:11:50 mysqld_safe Logging to '/mysql3307/logs/error.log'.160718 02:11:50 mysqld_safe Starting mysqld daemon with databases from /mysql3307/data[root@mysql3 logs]# tail -200f /mysql3307/logs/error.log 2016-07-18 02:02:59 2313 [Note] InnoDB: Using atomics to ref count buffer pool pages2016-07-18 02:02:59 2313 [Note] InnoDB: The InnoDB memory heap is disabled2016-07-18 02:02:59 2313 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2016-07-18 02:02:59 2313 [Note] InnoDB: Memory barrier is not used2016-07-18 02:02:59 2313 [Note] InnoDB: Compressed tables use zlib 1.2.32016-07-18 02:02:59 2313 [Note] InnoDB: Using Linux native AIO2016-07-18 02:02:59 2313 [Note] InnoDB: Not using CPU crc32 instructions2016-07-18 02:02:59 2313 [Note] InnoDB: Initializing buffer pool, size = 512.0M2016-07-18 02:02:59 2313 [Note] InnoDB: Completed initialization of buffer pool2016-07-18 02:02:59 2313 [Note] InnoDB: The first specified data file /mysql3307/data/ibdata1 did not exist: a new database to be created!2016-07-18 02:02:59 2313 [Note] InnoDB: Setting file /mysql3307/data/ibdata1 size to 1024 MB2016-07-18 02:02:59 2313 [Note] InnoDB: Database physically writes the file full: wait...InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 10002016-07-18 02:03:02 2313 [Note] InnoDB: Setting log file /mysql3307/logs/ib_logfile101 size to 1024 MBInnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 10002016-07-18 02:03:07 2313 [Note] InnoDB: Setting log file /mysql3307/logs/ib_logfile1 size to 1024 MBInnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 10002016-07-18 02:03:12 2313 [Note] InnoDB: Setting log file /mysql3307/logs/ib_logfile2 size to 1024 MBInnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 10002016-07-18 02:03:17 2313 [Note] InnoDB: Renaming log file /mysql3307/logs/ib_logfile101 to /mysql3307/logs/ib_logfile02016-07-18 02:03:17 2313 [Warning] InnoDB: New log files created, LSN=457822016-07-18 02:03:17 2313 [Note] InnoDB: Doublewrite buffer not found: creating new2016-07-18 02:03:17 2313 [Note] InnoDB: Doublewrite buffer created2016-07-18 02:03:17 2313 [Note] InnoDB: 128 rollback segment(s) are active.2016-07-18 02:03:17 2313 [Warning] InnoDB: Creating foreign key constraint system tables.2016-07-18 02:03:17 2313 [Note] InnoDB: Foreign key constraint system tables created2016-07-18 02:03:17 2313 [Note] InnoDB: Creating tablespace and datafile system tables.2016-07-18 02:03:17 2313 [Note] InnoDB: Tablespace and datafile system tables created.2016-07-18 02:03:17 2313 [Note] InnoDB: Waiting for purge to start2016-07-18 02:03:17 2313 [Note] InnoDB: 5.6.28 started; log sequence number 02016-07-18 02:03:17 7f040bb4c700 InnoDB: Loading buffer pool(s) from /mysql3307/data/ib_buffer_pool2016-07-18 02:03:17 7f040bb4c700 InnoDB: Cannot open '/mysql3307/data/ib_buffer_pool' for reading: No such file or directory2016-07-18 02:03:17 2313 [Warning] Bootstrap mode disables GTIDs. Bootstrap mode should only be used by mysql_install_db which initializes the MySQL data directory and creates system tables.2016-07-18 02:03:18 2313 [Note] Binlog end2016-07-18 02:03:18 2313 [Note] InnoDB: FTS optimize thread exiting.2016-07-18 02:03:18 2313 [Note] InnoDB: Starting shutdown...2016-07-18 02:03:18 7f040bb4c700 InnoDB: Dumping buffer pool(s) to /mysql3307/data/ib_buffer_pool2016-07-18 02:03:18 7f040bb4c700 InnoDB: Buffer pool(s) dump completed at 160718 2:03:182016-07-18 02:03:19 2313 [Note] InnoDB: Shutdown completed; log sequence number 16258102016-07-18 02:03:19 2335 [Note] InnoDB: Using atomics to ref count buffer pool pages2016-07-18 02:03:19 2335 [Note] InnoDB: The InnoDB memory heap is disabled2016-07-18 02:03:19 2335 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2016-07-18 02:03:19 2335 [Note] InnoDB: Memory barrier is not used2016-07-18 02:03:19 2335 [Note] InnoDB: Compressed tables use zlib 1.2.32016-07-18 02:03:19 2335 [Note] InnoDB: Using Linux native AIO2016-07-18 02:03:19 2335 [Note] InnoDB: Not using CPU crc32 instructions2016-07-18 02:03:19 2335 [Note] InnoDB: Initializing buffer pool, size = 512.0M2016-07-18 02:03:19 2335 [Note] InnoDB: Completed initialization of buffer pool2016-07-18 02:03:19 2335 [Note] InnoDB: Highest supported file format is Barracuda.2016-07-18 02:03:19 2335 [Note] InnoDB: 128 rollback segment(s) are active.2016-07-18 02:03:19 2335 [Note] InnoDB: Waiting for purge to start2016-07-18 02:03:19 2335 [Note] InnoDB: 5.6.28 started; log sequence number 16258102016-07-18 02:03:19 7f8cd97fb700 InnoDB: Loading buffer pool(s) from /mysql3307/data/ib_buffer_pool2016-07-18 02:03:19 2335 [Warning] Bootstrap mode disables GTIDs. Bootstrap mode should only be used by mysql_install_db which initializes the MySQL data directory and creates system tables.2016-07-18 02:03:19 7f8cd97fb700 InnoDB: Buffer pool(s) load completed at 160718 2:03:192016-07-18 02:03:20 2335 [Note] Binlog end2016-07-18 02:03:20 2335 [Note] InnoDB: FTS optimize thread exiting.2016-07-18 02:03:20 2335 [Note] InnoDB: Starting shutdown...2016-07-18 02:03:20 7f8cd97fb700 InnoDB: Dumping buffer pool(s) to /mysql3307/data/ib_buffer_pool2016-07-18 02:03:20 7f8cd97fb700 InnoDB: Buffer pool(s) dump completed at 160718 2:03:202016-07-18 02:03:21 2335 [Note] InnoDB: Shutdown completed; log sequence number 1625820160718 02:11:50 mysqld_safe Starting mysqld daemon with databases from /mysql3307/data2016-07-18 02:11:54 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.28-log) starting as process 4517 ...2016-07-18 02:11:54 4517 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.2016-07-18 02:11:54 4517 [Note] Plugin 'FEDERATED' is disabled.2016-07-18 02:11:54 4517 [Note] InnoDB: Using atomics to ref count buffer pool pages2016-07-18 02:11:54 4517 [Note] InnoDB: The InnoDB memory heap is disabled2016-07-18 02:11:54 4517 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2016-07-18 02:11:54 4517 [Note] InnoDB: Memory barrier is not used2016-07-18 02:11:54 4517 [Note] InnoDB: Compressed tables use zlib 1.2.32016-07-18 02:11:54 4517 [Note] InnoDB: Using Linux native AIO2016-07-18 02:11:54 4517 [Note] InnoDB: Not using CPU crc32 instructions2016-07-18 02:11:54 4517 [Note] InnoDB: Initializing buffer pool, size = 512.0M2016-07-18 02:11:54 4517 [Note] InnoDB: Completed initialization of buffer pool2016-07-18 02:11:54 4517 [Note] InnoDB: Highest supported file format is Barracuda.2016-07-18 02:11:54 4517 [Note] InnoDB: 128 rollback segment(s) are active.2016-07-18 02:11:54 4517 [Note] InnoDB: Waiting for purge to start2016-07-18 02:11:54 4517 [Note] InnoDB: 5.6.28 started; log sequence number 16258202016-07-18 02:11:54 7f48e19d2700 InnoDB: Loading buffer pool(s) from /mysql3307/data/ib_buffer_pool2016-07-18 02:11:54 7f48e19d2700 InnoDB: Buffer pool(s) load completed at 160718 2:11:542016-07-18 02:11:54 4517 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: f185c404-4c49-11e6-8453-000c29c7b3d5.2016-07-18 02:11:54 4517 [Note] Server hostname (bind-address): '0.0.0.0'; port: 33072016-07-18 02:11:54 4517 [Note] - '0.0.0.0' resolves to '0.0.0.0';2016-07-18 02:11:54 4517 [Note] Server socket created on IP: '0.0.0.0'.2016-07-18 02:11:54 4517 [Warning] 'user' entry 'root@mysql3' ignored in --skip-name-resolve mode.2016-07-18 02:11:54 4517 [Warning] 'user' entry '@mysql3' ignored in --skip-name-resolve mode.2016-07-18 02:11:54 4517 [Warning] 'proxies_priv' entry '@ root@mysql3' ignored in --skip-name-resolve mode.2016-07-18 02:11:54 4517 [Note] Event Scheduler: Loaded 0 events2016-07-18 02:11:54 4517 [Note] /usr/local/mysql/bin/mysqld: ready for connections.Version: '5.6.28-log' socket: '/tmp/my3307.sock' port: 3307 MySQL Community Server (GPL)[root@mysql3 scripts]# ps -ef|grep mysqlroot 2366 1774 0 02:08 pts/0 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/mysql3306.cnfmysql 3431 2366 1 02:08 pts/0 00:00:06 /usr/local/mysql/bin/mysqld --defaults-file=/etc/mysql3306.cnf --basedir=/usr/local/mysql --datadir=/mysql3306/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/mysql3306/logs/error.log --pid-file=/mysql3306/temp/mysql3306.pid --socket=/tmp/my3306.sock --port=3306root 3464 1774 0 02:11 pts/0 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/mysql3307.cnfmysql 4517 3464 2 02:11 pts/0 00:00:04 /usr/local/mysql/bin/mysqld --defaults-file=/etc/mysql3307.cnf --basedir=/usr/local/mysql --datadir=/mysql3307/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/mysql3307/logs/error.log --pid-file=/mysql3307/temp/mysql3307.pid --socket=/tmp/my3307.sock --port=33076：连接测试连接3306端口实例：[root@mysql3 scripts]# /usr/local/mysql/bin/mysql -S /tmp/my3306.sock Welcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is 1Server version: 5.6.28-log MySQL Community Server (GPL)Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql>[root@mysql3 scripts]# /usr/local/mysql/bin/mysql -S /tmp/my3307.sock Welcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is 1Server version: 5.6.28-log MySQL Community Server (GPL)Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.

MySQL>

From http://blog.csdn.net/zhanglei_16/article/details/51955081

上一篇：史上最方便快速的mysql安装教程

下一篇：CentOS 7.2 安装 MySQL 5.7.13