Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [root@mylab mysql]# ./bin/mysqld -V
- ./bin/mysqld Ver 5.7.8-rc-enterprise-commercial-advanced for linux-glibc2.5 on x86_64 (MySQL Enterprise Server - Advanced Edition (Commercial))
- [root@mylab mysql]# cat /tmp/my.cnf
- [mysqld]
- datadir=/tmp/mysqldata
- innodb_undo_log_truncate=ON
- innodb-undo-tablespaces=32
- innodb-undo-logs=64
- [root@mylab mysql]# ./bin/mysqld --defaults-file=/tmp/my.cnf --initialize
- ... [snip]
- [root@mylab mysql]# ls /tmp/mysqldata/
- auto.cnf client-cert.pem ibdata1 mysql public_key.pem sys undo003 undo006 undo009 undo012 undo015 undo018 undo021 undo024 undo027 undo030
- ca-key.pem client-key.pem ib_logfile0 performance_schema server-cert.pem undo001 undo004 undo007 undo010 undo013 undo016 undo019 undo022 undo025 undo028 undo031
- ca.pem ib_buffer_pool ib_logfile1 private_key.pem server-key.pem undo002 undo005 undo008 undo011 undo014 undo017 undo020 undo023 undo026 undo029 undo032
- [root@mylab mysql]# ./bin/mysqld --defaults-file=/tmp/my.cnf --port=3377 --socket=/tmp/mysqltmp.sock --user=mysql &
- [2] 6088
- 2015-08-28T15:59:37.995416Z 0 [Note] ./bin/mysqld (mysqld 5.7.8-rc-enterprise-commercial-advanced) starting as process 6088 ...
- ...
- 2015-08-28T15:59:38.019596Z 0 [Note] InnoDB: Opened 32 undo tablespaces
- 2015-08-28T15:59:38.019605Z 0 [Note] InnoDB: 31 undo tablespaces made active
- 2015-08-28T15:59:38.133603Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
- 2015-08-28T15:59:38.133653Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
- 2015-08-28T15:59:38.305626Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
- 2015-08-28T15:59:38.307018Z 0 [Note] InnoDB: 32 redo rollback segment(s) found. 32 redo rollback segment(s) are active.
- 2015-08-28T15:59:38.307030Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
- ...
- 2015-08-28T15:59:38.421146Z 0 [Note] ./bin/mysqld: ready for connections.
- Version: '5.7.8-rc-enterprise-commercial-advanced' socket: '/tmp/mysqltmp.sock' port: 3377 MySQL Enterprise Server - Advanced Edition (Commercial)
- [root@mylab mysql]# ls /tmp/mysqldata/
- auto.cnf client-key.pem ib_logfile1 performance_schema server-key.pem undo003 undo007 undo011 undo015 undo019 undo023 undo027 undo031
- ca-key.pem ib_buffer_pool ibtmp1 private_key.pem sys undo004 undo008 undo012 undo016 undo020 undo024 undo028 undo032
- ca.pem ibdata1 mylab.pid public_key.pem undo001 undo005 undo009 undo013 undo017 undo021 undo025 undo029
- client-cert.pem ib_logfile0 mysql server-cert.pem undo002 undo006 undo010 undo014 undo018 undo022 undo026 undo030
- [root@mylab mysql]# mysql -p --socket=/tmp/mysqltmp.sock
- Enter password:
- ...
- mysql> set password="test";
- Query OK, 0 rows affected (0.00 sec)
- mysql> show global variables like "datadir";
- +---------------+-----------------+
- | Variable_name | Value |
- +---------------+-----------------+
- | datadir | /tmp/mysqldata/ |
- +---------------+-----------------+
- 1 row in set (0.00 sec)
- mysql> show global variables like "innodb_undo%";
- +--------------------------+-------+
- | Variable_name | Value |
- +--------------------------+-------+
- | innodb_undo_directory | ./ |
- | innodb_undo_log_truncate | ON |
- | innodb_undo_logs | 64 |
- | innodb_undo_tablespaces | 32 |
- +--------------------------+-------+
- 4 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement