Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 1 post (of 1 total)
  • Author
    Posts
  • May 25, 2010 at 8:12 pm in reply to: Number Of Tables Created #30879
    jestep
    Member

    MySQL 5.1.45, and Monyog version is 2.82

    mysql> SHOW GLOBAL STATUS LIKE 'Created_tmp_tables';

    +

    +

    +

    | Variable_name | Value |

    +

    +

    +

    | Created_tmp_tables | 18931 |

    +

    +

    +

    1 row in set (0.00 sec)

    Monyog shows: 31379. Clicking on the link, the formula is 'Com_create_table'.

    mysql> SHOW GLOBAL STATUS LIKE 'Com_create_table';

    +

    +

    +

    | Variable_name | Value |

    +

    +

    +

    | Com_create_table | 31379 |

    +

    +

    +

    1 row in set (0.00 sec)

    As far as the database, all user created databases are InnoDB. The only MyISAM tables are in information_schema and mysql. Platform is CentOS 5.5×64.

  • Author
    Posts
Viewing 1 post (of 1 total)