So I've finally delved into tuning up my aging Drupal 6 site using NewRelic and like most I'm amazed at what their product has to offer. Very useful for honing in on problem areas. However, being new to this I'm not fully sure what the correct actions are to fix my particular problem.Read more
I think these urls are good guides for improving front-end performance:
I have noticed (I think) a strange thing. My cache_get times are excessive compared to rest of queries consistently. E.g on front page for logged in user I am seeing these numbers through devl module
203.92 1 cache_get SELECT data, created, headers, expire FROM main_cache WHERE cid = 'locale:mr'
172.59 1 cache_get SELECT data, created, headers, expire FROM main_cache_menu WHERE cid = '1:mr'
41.89 1 eval SELECT COUNT(uid) AS number FROM main_users WHERE status=1
25.56 1 drupal_lookup_path SELECT dst FROM main_url_alias WHERE src = 'front_page1'
I've run into what seems to be a problem with memcache. Memcache has a gig of memory and generally sits at around 85% full with over 50% cache misses. The site has been hit with some traffic spikes of around 40k+ visitors per hour (mostly anonymous visits) and this has been enough to take it down (with the additional traffic to another Drupal site running on the same servers). There are two fairly powerful web servers and I think that if memcache were working properly, things would be fine.Read more
MySQL AB and KernelTrap.org's Jeremy Andrews are partnering up to offer an online presentation titled "Achieving Optimal MySQL Performance For Drupal". Aiming to provide a better understanding of how to properly monitor and tune your MySQL database, the online Webinar will take place on Thursday, January 31st, 2008, at 16:00 UTC (11:00 am EST). The presentation will last 45 minutes, followed by 15 minutes for questions and answers. You can sign up for the free event here.Read more
Here's a couple of tools that may help in monitoring MySQL performace:
- mysqlresources script - Measuring resources for a MySQL server on Linux (looking at /proc)
- innotop script - MySQL and InnoDB monitor (requires InnoDB)
Anyone using similar scripts to monitor high performance mysql servers?
Hi, I recently switched from phpbb to drupal. (http://drupal.org/node/44368)
Here is my configuration
- web server: Dual Xeon 3.0Ghz (32bit), 2G RAM, SATA HDD
- db server: same as web server (physically different server)
- software: apache 1.3.34, php 5.1.2, mysql 5.0.18
- total number of nodes: 70,000+
- total number of comments: 330,000+
- total number of users: 25,000+
- Usually there are 150+ anonymous users and 50+ registered users (by checking Who's online block)
- Modules: most core modules (4.7) except archive, book, drupal, legacy, ping with contributed modules (adsense, codefilter, favorite_nodes, google_analytics, logintobaggan, nmoderation, subscription, taxomony_access, urlfilter, votingapi, comment_upload, tagadelic)