Tuning

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.

OpenCraft hosted a 3.5 hour seminar that I presented on Drupal performance tuning and optimization. You can find the slides from the presentation there, which can be useful to some of you.

Hi,

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?

Cheers

<

blockquote>
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)