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

MySQL optimize queries

Posted by hypertext200 on July 7, 2009 at 5:25pm

MySQL load balance

Posted by hypertext200 on July 9, 2009 at 4:28am

Hi
I have MySQL server running in as local, but I see a server load is very high and queuing all processes, I have about 100,000 rows in node table and taxonomy + 200,000 users. When less than 30 online registered users can handle server well, but when it become over 30 server load is increasing as a hell. I hope having dedicated MySQL server will solve this, is it effect to me? having dedicated MySQL server?.

I'm using APC with cache router.

How to benchmark website?

Posted by daemon on July 9, 2009 at 4:03pm

I would like to test some caching configuration for my site. Could someone recommend me some tools to test the effectiveness of the site?

Also, if there are known configurations that work for a site with only anonymous users, please let me know! (currently using eAccelerator and Boost).

Thanks!

Project Mercury: Pre-configured Drupal+Varnish AMI

Posted by joshk on July 10, 2009 at 9:31pm

Inspired by my own work over the past year with Amazon EC2 and this great post from Eric Hammond at Alestic on how to bundle public AMIs, today I released my first public machine image. I call the project "mercury," and the goal is to combine the power of Varnish and Pressflow Drupal in one easy-to-run package.

Why is this important? Because Varnish fills the same role as the Boost module, except it can handle 1000s of requests per second. Your constrained resources are going to be network and bandwidth. Getting it working well takes a bit of doing, but thanks to PressFlow and support from davidstrauss and DamZ, I've gotten a vanilla system working.

Squid on top of Apache on same machine

Posted by jax on July 11, 2009 at 2:43pm

During a recent talk by Mr. Tournoud he said that it is beneficial to run squid on the same machine as apache2 since connections that linger keep a thread and a DB connection busy. Putting squid on port 80 and apache2 on 8080 would also give you the ability to serve files directly from squid and apache2 would have less connections.

Compression -- Drupal side or Apache side or both?

Posted by Swampcritter on July 16, 2009 at 2:23pm

Which would produce a better compression rate -- using mod_deflate on the Apache instance side for css/js files and/or using Gzip for Javascript/CSS on the Drupal side?

I am looking for overall site performance aspects as well (i.e. additional CPU time, memory allocation, etc).

PHP memory implication on increasing the number of Global variables.

Posted by navaneeth_r on July 17, 2009 at 11:21am

Creating Related links todispaly with in the comment.tpl

We are repositioning our related links custom block form ( result fro a view, by passing taxonomy as argument) within node.tpl to comment.tpl. We want to store the taxonomy id for the node in the global variable and use it to generate related links in the comment.tpl section by passing this taxonomy global variable to the view. This is instead of reloading the node to obtaining the taxonomy id.

Suggestions for commercial streaming media hosting providers

Posted by chipk on July 17, 2009 at 3:08pm

Looking for suggestions for an affordable media hosting service to deploy our streaming video. ( http://www.gazettenet.com )

We have been using YouTube/Vimeo so far, but have requirements now for commercial content that is outside of the licensing for those free services.

Thanks.

General advices for high performance mySQL ?

Posted by fakemark on July 20, 2009 at 7:50am

Hello,

I would like to know what are your general advices regarding to a multiserver Drupal website that has to deal with a lot of mySQL queries ? What could be the best architecture for heavy load mySQL deployement ?

I think about a mySQL master/slave configuration, with separate hardware. But I heard that Drupal isn't ready to use a real master/slave configuration, and the slave should only be used as fail-over. Could you confirm this ?

I attached my planned architecture with this post.

Thanks a lot for your time

locale::performance::how could i make locale module more faster?

Posted by haojiang on July 20, 2009 at 5:12pm

enable locale:
Executed 82 queries in 198.59 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 474.06 ms.
disable locale:
Executed 450 queries in 312.01 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 750.68 ms.

Subscribe with RSS