marcelfb

Thanks for your suggestion. Traversing through the code base of these relatively large projects is probably beyond my scope.

However, I noticed that I hadn't turned on Drupal's built-in caching functionality. I suppose this should significantly reduce the database load, as most anonymous requests will now be served from the cache.

Do you know of any way that I can monitor the load that my site puts on the MySQL server?

Is it possible to get a warning before the site is abruptly suspended, as it's - well - in use, serving content. Frankly, it's quite stressful when it's suddenly shut down, although I certainly appreciate the quick response to reopen it in the support forums.

Thanks for your time.

Hi

I'm developing a website that has been suspended twice now for causing too high MySQL load. It's a Drupal 7 site with a few relatively common modules installed + CiviCRM, PHP software for NGO's to manage members, contacts, donations etc. CiviCRM has its own MySQL database and it also interacts directly with the Drupal MySQL database (AFAIK).

In the hope that it might help, I have updated Drupal and all modules to the most recent version (with the exception of CiviCRM). However I have no clue how/where I can see if the MySQL load has been reduced?

The technical details of the site are:

Before: Drupal 7.14, now Drupal 7.15

Modules installed as of today:

Administration menu 7.x-3.0-rc3

Chaos tool suite (ctools) 7.x-1.2

Date 7.x-2.6

Entity API 7.x-1.0-rc3

Entity reference 7.x-1.0-rc3

Relation 7.x-1.0-rc3

Views 7.x-3.5

Wysiwyg 7.x-2.1

CiviCRM 4.1.2

The theme is a sub theme of Bartik with minor changes.

Suggestions on how to analyse the problem and/or clues as to what might be causing them are very welcome.

Thanks

Username: flydende

Server: Stevie

Domain: flydendeby.heliohost.org

I'll move the account if I can just get access to the files and databases. Thanks for your assistance.

Thanks for reopening the account. Do you have any experience with Drupal 7 and/or CiviCRM causing this?

CiviCRM is PHP software designed for non-profits to manage constituents, donations, and memberships. It integrates with Drupal.

Username: flydende

Server: Stevie

Domain: flydendeby.heliohost.org

Hello!

I'm unable to import MySQLdb in Python 2.7 on Stevie. I believe I tried all Python versions and non worked. In version 2.7, using cgitb, I get the following error:

/home1/flydende/public_html/cgi-bin/build/bdist.linux-x86_64/egg/_mysql.py in () /home1/flydende/public_html/cgi-bin/build/bdist.linux-x86_64/egg/_mysql.py in __bootstrap__()

<type 'exceptions.ImportError'>: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory

args = ('libmysqlclient_r.so.15: cannot open shared object file: No such file or directory',)

message = 'libmysqlclient_r.so.15: cannot open shared object file: No such file or directory'

I hope you'll be able to fix this.

Thanks for providing this community/volunteer driven service. It's appreciated. (well, at least if we get it working (: )

Marcel

Hello!

I'm unable to import MySQLdb in Python 2.7 on Stevie. I believe I tried all Python versions and non worked. In version 2.7, using cgitb, I get the following error:

/home1/flydende/public_html/cgi-bin/build/bdist.linux-x86_64/egg/_mysql.py in () /home1/flydende/public_html/cgi-bin/build/bdist.linux-x86_64/egg/_mysql.py in __bootstrap__()

<type 'exceptions.ImportError'>: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory

args = ('libmysqlclient_r.so.15: cannot open shared object file: No such file or directory',)

message = 'libmysqlclient_r.so.15: cannot open shared object file: No such file or directory'

I hope you'll be able to fix this.

Thanks for providing this community/volunteer driven service. It's appreciated. (well, at least if we get it working (: )

Marcel