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

Table Diagnostics

forums › forums › SQLyog › Using SQLyog › Table Diagnostics

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • June 16, 2003 at 11:48 pm #8038
      spc_123
      Member

      Cannot run table diagnostics against my db consisting of innodb tables. says handler does not support it.

    • June 17, 2003 at 2:09 am #14511
      Ritesh
      Member

      Which version of MySQL are you running? Can you paste the SQL from the History Window out here?

    • June 17, 2003 at 2:38 am #14512
      CalEvans
      Member

      I can't either

      3.23.56

      [9:36:42 PM][ 0 ms] optimize table `intranet`.`zipData`, `intranet`.`tradingPartner`, `intranet`.`sequence`, `intranet`.`sanno`, `intranet`.`roleList`, `intranet`.`role`, `intranet`.`queue`, `intranet`.`person_role`, `intranet`.`person`, `intranet`.`one`, `intranet`.`message`, `intranet`.`mailingList_account`, `intranet`.`mailingList`, `intranet`.`inventoryUpdateMessages`, `intranet`.`inventoryHolding`, `intranet`.`ediBatch`, `intranet`.`doNotMail`, `intranet`.`business`, `intranet`.`applicationParameters`

      =C=

    • June 17, 2003 at 3:01 am #14513
      Ritesh
      Member

      From the MySQL Docs –

      Quote:
      For the moment, OPTIMIZE TABLE works only on MyISAM and BDB tables. For BDB tables, OPTIMIZE TABLE is currently mapped to ANALYZE TABLE. See section 4.5.2 ANALYZE TABLE Syntax.

      You can get OPTIMIZE TABLE to work on other table types by starting mysqld with –skip-new or –safe-mode, but in this case OPTIMIZE TABLE is just mapped to ALTER TABLE.

      Guess…thats the problem 😀

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.