Hi John,

I think the entry "MaxNoOfConcurrentOperations= 10000" under the section [ndbd 
default] is for MySQL-Clustering. 

Normally there should also exist a MySQL configuration file under 
"/etc/mysql/my.cnf" (so for example under Linux) !

The files "my-small.cnf", "my-medium.cnf" and "my-large.cnf" are predefined 
configuration files for MySQL.
This files are predefined for different RAM-Sizes of your computer. Take a look 
into the different files and read the explanation at the top of the files.
Please also read 
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-config-file.html !

If you find the "my.cnf" file on your computer and there is no entry 
"max_connections = 300" in the [mysqld] section, then create it.
For example:
   [mysqld]
   max_connections = 300

If I remember it correct, "max_connections = 100" is the default value for 
MySQL and is (maybe) therefore not placed in the my.cnf file.

Best regards
Knut

  ----- Original Message ----- 
  From: John Barrett 
  To: CF-Newbie 
  Sent: Tuesday, August 19, 2008 8:03 AM
  Subject: Re: database error?


  Hi Knut,

  Thanks so much for your help:)
  There was nothing checked in the CF Admin under advanced settings.
  I also looked in the file 
/usr/local/mysql-5.0.51a-osx10.4-powerpc/support-files/ndb-config-2-node.ini
  It had:
  [ndbd default]
  NoOfReplicas= 2
  MaxNoOfConcurrentOperations= 10000
  DataMemory= 80M
  IndexMemory= 24M
  TimeBetweenWatchDogCheck= 30000
  DataDir= /var/lib/mysql-cluster
  MaxNoOfOrderedIndexes= 512

  the only files that were close to what you had was my-small.cnf or 
my-medium.cnf or my-large.cnf. These files were all commented out. The 
file(above) was I am guessing the config file for MySQL. the line 
"MaxNoOfConcurrentOperations= 10000" means that 10,000 connections can able to 
access is denied? Is this set too high? Should I set it to 300 as you say ere?

  This problem vanished when I went home, but I spend some time trying to 
figure out why this happen, so I can prevent this from happening again.
  Thanks again for all your help,
  John



        

  

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3931
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15

Reply via email to