Comment 7 for bug 1441908

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

I can not reproduce this with upstream 5.6.24, maybe I am doing something wrong:

[openxs@chief 5.6]$ bin/mysql -uroot test -e"show variables like 'table_defin%'"
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| table_definition_cache | 20000 |
+------------------------+-------+
[openxs@chief 5.6]$ bin/mysql -uroot test -e"select count(*) from information_schema.tables"
+----------+
| count(*) |
+----------+
| 120505 |
+----------+
[openxs@chief 5.6]$ bin/mysql -uroot test -e"show variables like 'performance_schema'"
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| performance_schema | ON |
+--------------------+-------+
[openxs@chief 5.6]$ bin/mysql -uroot test -e"show variables like 'version%'" +-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| version | 5.6.24 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+------------------------------+
[openxs@chief 5.6]$ tail -100 data/chief.err
...
2015-05-27 13:42:23 5229 [Note] /home/openxs/dbs/5.6/bin/mysqld: Shutdown complete

150527 13:42:23 mysqld_safe mysqld from pid file /home/openxs/dbs/5.6/data/chief.pid ended
150527 13:42:26 mysqld_safe Starting mysqld daemon with databases from /home/openxs/dbs/5.6/data
2015-05-27 13:42:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-05-27 13:42:27 0 [Note] /home/openxs/dbs/5.6/bin/mysqld (mysqld 5.6.24) starting as process 5333 ...
2015-05-27 13:42:27 5333 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2015-05-27 13:42:27 5333 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)

2015-05-27 13:42:27 5333 [Note] Plugin 'FEDERATED' is disabled.
2015-05-27 13:42:27 5333 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-27 13:42:27 5333 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-27 13:42:27 5333 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-05-27 13:42:27 5333 [Note] InnoDB: Memory barrier is not used
2015-05-27 13:42:27 5333 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-27 13:42:27 5333 [Note] InnoDB: Using Linux native AIO
2015-05-27 13:42:27 5333 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-27 13:42:27 5333 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-27 13:42:27 5333 [Note] InnoDB: Completed initialization of buffer pool
2015-05-27 13:42:27 5333 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-27 13:42:28 5333 [Note] InnoDB: 128 rollback segment(s) are active.
2015-05-27 13:42:28 5333 [Note] InnoDB: Waiting for purge to start
2015-05-27 13:42:28 5333 [Note] InnoDB: 5.6.24 started; log sequence number 68190540
2015-05-27 13:42:28 5333 [Note] Server hostname (bind-address): '*'; port: 3306
2015-05-27 13:42:28 5333 [Note] IPv6 is available.
2015-05-27 13:42:28 5333 [Note] - '::' resolves to '::';
2015-05-27 13:42:28 5333 [Note] Server socket created on IP: '::'.
2015-05-27 13:42:28 5333 [Note] Event Scheduler: Loaded 0 events
2015-05-27 13:42:28 5333 [Note] /home/openxs/dbs/5.6/bin/mysqld: ready for connections.
Version: '5.6.24' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)

So, it does not take long time to start.