Guido,
Sorry I can't help you with this, but I have posted a similar a question about the grading in the Workshop Module (click here to read my post), and got no answer. Unfortunately it seems the Workshop Module is in need of a maintainer, so it seems there is no one out there at the moment that can help with these kind of Workshop problems.
Please let me know if you discover an answer.
Peter Ruthven-Stuart
Oqallisissiat Peter Ruthven-Stuart-imit allatat
Moodle in English -> General help -> Optimizing connections to the database? -> Re: Optimizing connections to the database?
Peter Ruthven-Stuart-mit -
Martin, thanks for the reply. I have switched to
$CFG->dbpersist = true;
as you suggest. Also, it occurs to me that the database overload problem could be due to auto-linking to rather large student generated glossaries; about 700 entries in two glossaries, one in each of my two online courses. I have posted a message in the Glossary forum to see if anyone has any suggestions.
I let you know how things work out after my next class.
$CFG->dbpersist = true;
as you suggest. Also, it occurs to me that the database overload problem could be due to auto-linking to rather large student generated glossaries; about 700 entries in two glossaries, one in each of my two online courses. I have posted a message in the Glossary forum to see if anyone has any suggestions.
I let you know how things work out after my next class.
Moodle in English -> General help -> Optimizing connections to the database?
Peter Ruthven-Stuart-mit -
Last week I posted a message about the appearance of the following error message when students tried to access my moodle site:
Error: Database connection failed.
It is possible that the database is overloaded or otherwise not running properly.
The site administrator should also check that the database details have been correctly specified in config.php
It is possible that the database is overloaded or otherwise not running properly.
The site administrator should also check that the database details have been correctly specified in config.php
Click here to see the original posting.
The site went back online after a few hours, but yesterday when a class of 44 students tried to access the site they kept on getting the same error message.
I have checked config.php and persistent connections are off ($CFG->dbpersist = false;). I contacted my hosting company (Bluehost), and was told that there is a limit of 10 simultaneous database connections. I was assured that this was quite enough and anyway it couldn't be increased. He then went on to say that I "should optimize the connection to the database", and that this could probably done by making some changes to the config.php file.
So, is it correct that a limit of 10 simultaneous database connections is enough and indeed normal? Furthermore, can the problems my students are having accessing my site be solved by 'optimizing the connection to the database? If so, how can this be done?
Any suggestions will be greatly appreciated.
Moodle version: moodle 1.4.3 + (2004083131)
MySQL 4.0.24-standard
The site went back online after a few hours, but yesterday when a class of 44 students tried to access the site they kept on getting the same error message.
I have checked config.php and persistent connections are off ($CFG->dbpersist = false;). I contacted my hosting company (Bluehost), and was told that there is a limit of 10 simultaneous database connections. I was assured that this was quite enough and anyway it couldn't be increased. He then went on to say that I "should optimize the connection to the database", and that this could probably done by making some changes to the config.php file.
So, is it correct that a limit of 10 simultaneous database connections is enough and indeed normal? Furthermore, can the problems my students are having accessing my site be solved by 'optimizing the connection to the database? If so, how can this be done?
Any suggestions will be greatly appreciated.
Moodle version: moodle 1.4.3 + (2004083131)
MySQL 4.0.24-standard
When my classes (at least 40 students) all try to access my moodle site they often see this error message:
I have made a post about this message in the General problems forum: click here to see the message.
I believe the the problem is that there are too many simultaneous connections to the database. The hosting company told me that there is a limit of 10 simultaneous connections, that this was plenty, and that it could not be increased.
It has just occurred to me that the cause of this problem may be that the auto-linking function of the glossary is causing too many connections to the database. Is this possible?
In both my online courses there are student created glossaries. The idea is that as English language students they add 'difficult' words and phrases they come across in the online course material. This has been very successful; after a month of classes there are already 700 or so entries in each glossary. All these entries are automatically linked. I have installed the 'Glossary Only First' filter, but this doesn't stop the error message appearing.
So, can auto-linking overload the database to the point that it exceeds the allowed number of simultaneous connections? If yes, is there a solution other than turning off auto-linking during classes?
Any hints, ideas or help will be enormously appreciated.
Error: Database connection failed.
It is possible that the database is overloaded or otherwise not running properly.
The site administrator should also check that the database details have been correctly specified in config.php
It is possible that the database is overloaded or otherwise not running properly.
The site administrator should also check that the database details have been correctly specified in config.php
I have made a post about this message in the General problems forum: click here to see the message.
I believe the the problem is that there are too many simultaneous connections to the database. The hosting company told me that there is a limit of 10 simultaneous connections, that this was plenty, and that it could not be increased.
It has just occurred to me that the cause of this problem may be that the auto-linking function of the glossary is causing too many connections to the database. Is this possible?
In both my online courses there are student created glossaries. The idea is that as English language students they add 'difficult' words and phrases they come across in the online course material. This has been very successful; after a month of classes there are already 700 or so entries in each glossary. All these entries are automatically linked. I have installed the 'Glossary Only First' filter, but this doesn't stop the error message appearing.
So, can auto-linking overload the database to the point that it exceeds the allowed number of simultaneous connections? If yes, is there a solution other than turning off auto-linking during classes?
Any hints, ideas or help will be enormously appreciated.
Moodle in English -> General help -> Error: Database connection failed -> Re: Error: Database connection failed
Peter Ruthven-Stuart-mit -
Howard,
Thank you very much for that. Since writing my above request for help my moodle has gone back online
http://moodle.petesweb.org/
but not because of anything I did. I checked the data base process list - i.e. clicked on 'Show processes' in phpmyadmin, as you suggested, and saw this:
This does not look like much of a list to me, and as you can imagine I didn't like the idea of clicking on a link that said 'Kill'.
I also checked config.php to see if persistent database connections were off. They appear to be off:
$CFG->dbpersist = false;
So, that leaves a possible limit on simultaneous database connections. I have contacted the hosting company and await their reply.
I'll reply to this discussion once I get an answer from them, since judging by the number of people that get a 'Database connection failed' error, there may be some interest in the cause / solution to this problem.
Thanks for putting me on the right track.
Thank you very much for that. Since writing my above request for help my moodle has gone back online
http://moodle.petesweb.org/
but not because of anything I did. I checked the data base process list - i.e. clicked on 'Show processes' in phpmyadmin, as you suggested, and saw this:
This does not look like much of a list to me, and as you can imagine I didn't like the idea of clicking on a link that said 'Kill'.
I also checked config.php to see if persistent database connections were off. They appear to be off:
$CFG->dbpersist = false;
So, that leaves a possible limit on simultaneous database connections. I have contacted the hosting company and await their reply.
I'll reply to this discussion once I get an answer from them, since judging by the number of people that get a 'Database connection failed' error, there may be some interest in the cause / solution to this problem.
Thanks for putting me on the right track.