rgds
Prakash

Unfortunately they do not currently fill the tables, they just cause InnoDB to dump all of the information to MySQL’s error log:

“InnoDB will then dump the tablespace information to either the error log, or the console (if started without log-error).”

However, this will be changing very soon - in the new 5.5.5-m3 release, there are a number of new tables available within the INFORMATION_SCHEMA database:

mysql> show tables like ‘innodb_sys%’;
+——————————————–+
| Tables_in_information_schema (innodb_sys%) |
+——————————————–+
| INNODB_SYS_FIELDS |
| INNODB_SYS_INDEXES |
| INNODB_SYS_TABLESTATS |
| INNODB_SYS_COLUMNS |
| INNODB_SYS_FOREIGN_COLS |
| INNODB_SYS_FOREIGN |
| INNODB_SYS_TABLES |
+——————————————–+
7 rows in set (0.00 sec)

mysql> select * from innodb_sys_tables;
+———-+——————+——+——–+——-+
| TABLE_ID | NAME | FLAG | N_COLS | SPACE |
+———-+——————+——+——–+——-+
| 11 | SYS_FOREIGN | 0 | 7 | 0 |
| 12 | SYS_FOREIGN_COLS | 0 | 7 | 0 |
| 13 | test/t1 | 1 | 4 | 1 |
+———-+——————+——+——–+——-+
3 rows in set (0.00 sec)

mysql> select * from innodb_sys_indexes;
+———-+—————–+———-+——+———-+———+——-+
| INDEX_ID | NAME | TABLE_ID | TYPE | N_FIELDS | PAGE_NO | SPACE |
+———-+—————–+———-+——+———-+———+——-+
| 11 | ID_IND | 11 | 3 | 1 | 302 | 0 |
| 12 | FOR_IND | 11 | 0 | 1 | 303 | 0 |
| 13 | REF_IND | 11 | 0 | 1 | 304 | 0 |
| 14 | ID_IND | 12 | 3 | 2 | 305 | 0 |
| 15 | GEN_CLUST_INDEX | 13 | 1 | 0 | 3 | 1 |
+———-+—————–+———-+——+———-+———+——-+
5 rows in set (0.00 sec)

etc.

I am new to mysql db. As you mentioned above I have created two tables (innodb_moniter and innodb_tablespace_moniter), but giving select statement to those table I am not getting any result as u mentioned above. Can you please guide me here.

How I will enable both table and table space moniter in my database. as you mentioned by creating table of both type (from ur blog). How I will see the contents from those table.

Thanks
Prakash

Just because dolphins didn’t evolve physical forms like we have, like arms, fingers, legs and such, doesnt mean that they didn’t evolve mentally. They probably have progressed mentally much further than us, to learn such things as love and forgiveness. We kill them at the hundreds, yet dolphins still retain the ability to love and to defend thier land-based forms, the humans.

anyway, I own two cats and believe that thier lives should be full with stimulation. I see them as my equal, my animal side that just comprehends the world in a unique way that might not be possible for me to see. But just because I don’t see it, doesn’t mean that it can’t be.