nerdcore's picture

Posted by nerdcore on March 11, 2013 at 3:29pm

I am curious to know if anyone has advice on tweaking the out-of-the-box my.cnf specifically for Drupal?

The organization I work for typically hosts multisite installations, and may have numerous disparate sites running on a single web server using a single MySQL server... Given that there is a wide range of sites with varying purposes (some more anonymous viewing, some more authenticated content generation), are there any Drupal-specific changes to my.cnf which might be appropriate?

Read more

2 comments ⋅ Categories: mysql configuration, optimization, performance

bflora's picture

Posted by bflora on April 22, 2009 at 10:36pm

A note from the developer who oversees one of my Drupal sites. We could use your help.

Hello,

I have a rather burly Drupal based site that seems to be causing some
problems, today we had a major outage. There are many slow queries
and also mysql related iowait that causes server processes to hang, at
least that is the theory.

Here you can examine some of the stats on the server:
http://andric.us/load/localdomain/localhost.localdomain.html

You can see my iowait stats here, which are pretty high:
http://andric.us/load/localdomain/localhost.localdomain-cpu.html

Read more

1 comment ⋅ Categories: drupal 5, module, mysql, performance, scaling, drupal 5, module, mysql, performance, scaling

markus_petrux's picture

Posted by markus_petrux on January 25, 2009 at 9:40am

Reading the MySQL Performance Blog I've found that they have released a new storage engine that's based on InnoDB with a few performance additions. I thought it could be of interest to some of you.

Here's a few links about it:

<

ul>

Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB (2008年12月16日)

Read more

2 comments ⋅ Categories: innodb, mysql, performance, storage engines

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: