CFMX7 - MySQL 4.0 - INNODB table type

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default CFMX7 - MySQL 4.0 - INNODB table type

    I have tried without success to use the INNODB table type with MySQL 4.0, it locks up my server. If I switch back to the MyISAM table type everything works fine.

    Any one have any luck with this?
    drmaves Guest

  2. Similar Questions and Discussions

    1. How to backup and recovery MySQL database cluster using InnoDB table?
      Hi, How to backup and recovery MySQL database cluster using InnoDB table? I have searched in the internet but not found any solution. Can you...
    2. Question on MySQL 5 and innodb
      Hi... I have a question on using innodb with MySQL 5.0. I already have 2-databases running on a mysql instance. I want to add a third...
    3. MySQL: What Table Type are you ?>
      Which is better: MyISAM or INNODB ?? All the apps I've written thus far are MyISAM; however, INNODB offers our dear friend `referential...
    4. [PHP] mysql_errror bug on innodb table
      ok i managed to set the generated error screen to a variable, do the rollback then die
    5. mysql_errror bug on innodb table
      hi there i have noticed a bug where mysql_error is not returned on a transaction, why is this ?
  3. #2

    Default Re: CFMX7 - MySQL 4.0 - INNODB table type

    What exactly are you trying to do? I've been using InnoDB talbes for some years now with no problem.
    cf_menace Guest

  4. #3

    Default Re: CFMX7 - MySQL 4.0 - INNODB table type

    I'm not trying to do anything special. What I intended to take advantage of was
    the transaction processing and the ability to designate foreign keys but I
    don't even get a chance before the server starts locking up.

    I am running both CF and MySQL on the same server, which I think may be the
    problem.

    Are you running MySQL on a dedicated database server?

    drmaves Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139