neutron.db.migration.migrate_to_ml2 mysql status

[root@gpu2 neutron]# mysql -u root -p -h gpu4
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 109
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show engine innodb status;
[...]
| Type   | Name | Status
| InnoDB |      |
=====================================
150420 18:15:14 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 8 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 700, signal count 696
Mutex spin waits 0, rounds 1308, OS waits 25
RW-shared spins 1229, OS waits 614; RW-excl spins 60, OS waits 59
------------------------
LATEST FOREIGN KEY ERROR
------------------------
150420 18:06:04 Error in foreign key constraint of table ovs_quantum/ml2_network_segments:
FOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE
):
Cannot find an index in the referenced table where the
referenced columns appear as the first columns, or column types
in the table and the referenced table do not match for constraint.
Note that the internal storage type of ENUM and SET changed in
tables created with >= InnoDB-4.1.12, and such columns in old tables
cannot be referenced by such columns in new tables.
See http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
for correct foreign key definition.
------------
TRANSACTIONS
------------
Trx id counter 0 2832769
Purge done for trx's n:o < 0 2832752 undo n:o < 0 0
History list length 36
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 20992, OS thread id 140106691450624
MySQL thread id 109, query id 67233 gpu2.east.isi.edu 10.0.1.2 root
show engine innodb status
---TRANSACTION 0 2832735, not started, process no 20992, OS thread id 140106689853184
MySQL thread id 108, query id 67118 gpu2.east.isi.edu 10.0.1.2 nova
---TRANSACTION 0 2832674, not started, process no 20992, OS thread id 140106693048064
[...]
MySQL thread id 74, query id 66364 gpu2.east.isi.edu 10.0.1.2 keystone
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio writes: 0,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
1566 OS file reads, 10588 OS file writes, 7431 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 1.00 writes/s, 0.75 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 17393, node heap has 2 buffer(s)
2.62 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 0 398379270
Log flushed up to   0 398379270
Last checkpoint at  0 398379029
0 pending log writes, 0 pending chkp writes
5297 log i/o's done, 0.50 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 22272674; in additional pool allocated 1048320
Dictionary memory allocated 1085320
Buffer pool size   512
Free buffers       1
Database pages     509
Modified db pages  3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 2087, created 1548, written 5935
0.00 reads/s, 0.00 creates/s, 0.37 writes/s
Buffer pool hit rate 1000 / 1000
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 20992, id 140106705135360, state: sleeping
Number of rows inserted 6428, updated 4157, deleted 6, read 35231
0.00 inserts/s, 0.37 updates/s, 0.00 deletes/s, 2.62 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
[...]

mysql> use ovs_quantum;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show index from networks;
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table    | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| networks |          0 | PRIMARY  |            1 | id          | A         |           1 |     NULL | NULL   |      | BTREE      |         |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
1 row in set (0.00 sec)

mysql> quit;
Bye