Search

_{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.}

Drupal performance with over 1 million users

Posted by joblogs83 on December 8, 2009 at 9:49pm

Hi everyone,

I work on a Drupal 6.13 site that is current storing the details of 750k users, expecting to grow to over 1 million in the next 6 months. I'm wondering if anyone else has made a Drupal site scale to this level and if so, what issues (if any) you might have come across?

The biggest issues I'm noticing now include:

Custom users > taxonomy term table (a basic structure of uid, tid, vid) using MyISAM has over 15 million rows. Simple querying is fine, but reporting is impossible.

Problems with APC fragmentation Drupal 6 sites

Posted by wxman on December 11, 2009 at 4:48pm

I'm using the latest Drupal 6.x version for several sites on my server. I'm getting a lot of fragmentation after setting up APC, but I can't figure out why it's happening, and how to stop it.

New cache modules for Drupal

Posted by crea on December 16, 2009 at 6:45pm

Hello everyone,
Recently I released 2 new caching modules for Drupal: Advanced Panels Cache, and Namespice. Check them out. Feedback is welcome!

Do you use Cacherouter Memcached (note the trailing "d") engine ?

Posted by crea on December 21, 2009 at 3:43am

Anyone here using Cacherouter Memcached backend (which depends on libmemcached) here ? I don't want to discuss PECL memcached itself, let's just say it's stable enough to be considered on par with memcache.
I'm more interested in Cacherouter Memcached engine code, stability, issues, etc.

Big MySQL database, what is the best practice to backup (VPS/Dedicated)?

Posted by Rockland Steel on December 23, 2009 at 5:45am

Hello,

My website (shared hosting) is growing bigger.

Usually I backup using MySQLDumper (http://www.mysqldumper.net/)

It will backup fine, also no error when restoring. Then, when browse the site, some post will missing (not found), but the link to that missing posts still there. I have no idea whats going on. When looking at the database by checking the tables and compare it to the original database, it looks like no data loss, with same number of lines.

I dont really like idea of dump database. MySQLDumper is just best choice for shared hosting.

What Apache2 modules can be disabled?

Posted by Rockland Steel on December 26, 2009 at 4:44pm

Hello,

I think many Apache2 unused modules loaded. I'm going to disable some of them.

But I just want some "do & don't", which one can be disabled, which one is needed for a Drupal website?

Thanks in advance

By the way, this is list of my loaded modules:

Merging best practices together - need insight / advice

Posted by steveadamo on December 29, 2009 at 3:09am

first of all, thanks for putting together this group, it has definitely opened my eyes to some great methods for squeezing the most performance out of a Drupal site... :)

im at the tail end of a 12 month development cycle, and have finally gotten around to setting up my hosting environment... ive taken the plunge, and after more research than i care to recall, have decided on creating and managing my own setup with Linode.com...

need help/suggestion for performance in business directory site

Posted by tantan.wijaya on January 1, 2010 at 1:59pm

Hi all..
i'll develop my website project and i choose to use drupal 6.14.
this website is directory business like and have a large database.
it's have 600.000 for company records and about 9.000.000 for product listing records.
But I have questions and doubts to use drupal, can drupal handle it with a good performance?
And what should i do to make this site have a good performance and fast loading?
For search module will use fuzzy logic,Are any suggestions for that in fast query searching?

Migration of large amount of data - worried about `node` overhead and performance

Posted by Mike_Waters on January 1, 2010 at 9:49pm

I need to write a quick web frontend for an existing gui app that just displays information about a large quantity of image data; this data is in a myslq db currently. I would like to use Drupal if I can.

The image data model would work fine translated as nodes, I am just worried about query performance due to the overhead of storing this data as nodes; there will be 250K and a million images.

What is the basic Memory size for a clean installation?

Posted by Bensbury on January 3, 2010 at 5:46am

Hi,

I am having a discussion with my friend Derrick here over the minimum requirements for Drupal...

He is reducing the amount of memory drupal is using and is not happy about this error message as he thinks it is too much for a clean install.

Fatal error: Allowed memory size of 262144 bytes exhausted (tried to allocate 30720 bytes) in /XXXXXX/ includes/bootstrap.inc on line 254

In the .htaccess file we have set the

php_value_memory_limit to 32m

Reading the drupal site, a guy said that 32m is not equal to 32mb, but we don't think this is true.

Subscribe with RSS