Innodb

Discussion in 'Databases' started by deriklogov, Jul 12, 2009.

0
  1. #1
    Today I switch one of the tables from MyISAM to INNODB and after executing simple query " SELECT * FROM xxxx WHERE 1" I got results approximate. with following:

    May be approximate. See FAQ 3.11

    So every time I got query I am getting different number of results with ~ symbol in front of number ? What is that, is that the way INNODB working ?
     
    deriklogov, Jul 12, 2009 IP
  2. deriklogov

    deriklogov Well-Known Member

    Messages:
    1,078
    Likes Received:
    22
    Best Answers:
    0
    Trophy Points:
    130
    #2
    Any ideas please
     
    deriklogov, Jul 12, 2009 IP
  3. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Can you give an example of the response you get and the response you expect.
    P.S. Could it be you expect the response in a specific order, because the order of the response is not defined unless you use the order keyword.
     
    chisara, Jul 13, 2009 IP
  4. nvidura

    nvidura Well-Known Member

    Messages:
    1,780
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    150
    #4
    Why did you change your storage to InnoDB? It requires only if you need Foreign keys etc...
     
    nvidura, Jul 16, 2009 IP