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
