mysql

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

I setup a MySQL 5.0 Cluster on a spare server with multiple Xen VMs and discovered that Drupal 6 (and most likely D7 as wel) as it exists today cannot function properly under the MySQL NDBCLUSTER engine. It seems that under the NDBCLUSTER engine (also known as NDB), D6 has a table called menu_router that fails to be converted.

I posted a bug report about it under the D6 platform as it is rather detailed, but I have an idea this will affect D7 as well.
http://drupal.org/node/391130

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>

Its about drupal installation
I have have uploaded the drupal 6.3
but facing problems in database commands as i am new to mysql and drupal as well
will it be possible for anyone to give few minutes if i forward my account info.
Regards.
gitesh