Search through our group's posts (events, discussions, jobs, etc.) and their comments here. Results are displayed in order of post date. Use the pager below to browse results.
mysql-bin log making disk full
Since I got very useful and profound help in this board last time, I hope someone can help me with this issue:
Our hoster was complaining that our intranet (which we are developing on Drupal) is making the database running out of space. He attached a screenshot where it says that we are using 24GB (!) on the MySQL server (from 30GB total) (see screenshot below).

Simple but important performance check
I recently had quite a simple drupal site with only a few dozens of nodes and each page was taking 7+ seconds to load.
It turned out be because xdebugger and profiler were enabled in php.ini, pages are now <1 second.
Definitly one of those 'DOH!!' moments.
This does serve as a lesson to think outside the box a little when looking at performance.
Read moreNginx now properly supported in Aegir
It finally works as expected (well, almost - it's still alpha! :). You can try Provision available on GitHub: http://github.com/omega8cc/provision. It includes modified install script and hostmaster makefile to make your life easier.
[UPDATE: now it supports also SSL integration and apt-get Nginx versions, with Boost compatibility, but it should be at least nginx-0.6.36, so with Debian you need backports, and with Ubuntu you need at least Karmic or newer.]
Read moreaccess table in slow query log
Hi,
Hopefully this is an appropriate question for this group. Any ideas why this type of query would show up repeatedly in my slow query log? Is there something I can do to optimize this?
thanks.
Time: 100715 12:07:03
User@Host: drupal_db[drupal_db] @ localhost []
Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 12
SELECT 1 FROM access WHERE type = 'host' AND LOWER('67.218.116.166') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1;
Time: 100715 12:08:17
User@Host: drupal_db[drupal_db] @ localhost []
Read moreMemcache for storing Sessions
Hello everyone!
I'm rather new to this group and I need some advice.
I'm trying to build a high performance multisite in EC2 cloud and I have the following question: How can I use memcache for storing sessions and still mantain the "Who's online" functionality and session persistance.
There's a good article that talks about this (sorry I've lost the link) that propose a dump of memcache sessions to DB every N seconds, but I can't find an implementation and I'm thinking in implementing a kind of cron job to do it.
Read moreEfficiently Managing Many Drupal Sites - 3/4 Sep 2010, Bratislava - Cancelled
Dave Hall Consulting has teamed up with with Sven Creative to present an intensive 2 day workshop which teaches participants how to build, deploy and manage Drupal sites in a scalable way. Most sessions will involve an overview of a tool, then attendees will become familar with the tool by using it to complete a task. Time has been allocated to allow people to ask questions and share information about their own development workflows.
Read moreVery high page execution times and CPU spikes
Hi -
My drupal install is experiencing very high page execution times and the CPU spikes to 100% when I first load a page. Upon reloading that same page, things happen faster, but the execution times still are high and CPU often gets up to 60-70%. This is for authenticated users. For anonymous users, the site is performing well.
Server stats/info
php running as mod_php
Average daily page views is very modest - 400, peak 700
Running eAccelerator with 128MB
Running Boost 6.x-1.18
Who should we talk to about Pantheon?
We are getting ready to unveil what we've been building into Pantheon over the past couple of months. But before we do, we are reaching out to a number of Drupal free-lancers whom we see as the initial target market for our service.
Read moreBarracuda Aegir with Nginx Edition 0.4-HEAD-A12.D (Lucid, Karmic and Lenny compatible)
UPDATE: Barracuda and Octopus new home is on d.o, plus there is BOA group:
http://drupal.org/project/barracuda
http://drupal.org/project/octopus
http://groups.drupal.org/boa
UPDATE: After introducing dual-core Barracuda/Octopus Aegir Installer, this thread is continued also here: http://groups.drupal.org/node/89594.
Read moreDoes i18n Fail with Aggressive Caching?
If you're not a native English speaker doing Drupal, then the i18n module is probably the only way. This is why it seems very strange to me that the performance admin page says that i18n might not work with aggressive caching.
I find it hard to believe that multilingual drupal sites scale worst or harder than sites with one language.
scale worst/hard = scale without advanced caching
Is there anyone with experience using the i18n with aggressive caching?
Read more


