MySQL

Hi,
There is this query in a loop for every logged in user.

SELECT dst FROM dp_url_alias WHERE src = 'user/62025'

It is consuming a lot of MySQL resources and slowing down the site. Is it the standard query? What does it do? What should I do to stop it or increase the interval?

The classical mysqldump is not enough to backup a drupal website.

With Snapshot, you can freeze your website and make a clean snapshot, mysql data and files. Different backup type can be done, simple copy, rsync and even rdiff-backup wich provide differential backup.

For now, only myIsam tables can be backuped. I follow percona work to handle innodb soon. Postgres must not be hard to handle.

For now, backup is local. Soon, distant copy will be handled with rsync, ftp and even S3.

Beta version is on github : http://github.com/athoune/Drupal-Snapshot/tree/master

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>

We are launching a newspaper website in the next couple of days. The site is in Drupal. Can any comments on the ini settings? Does the server conf enough for the load shown.

The site has to serve:
Number of visits 35,720
Pages 205,129
Hits 1929,027

The server configuration:
Processor: Quadcore 2.66 ghz * 2
Ram: 8GB
Harddisk: 146Gb * 5

My.ini configuration:
[mysqld]
datadir=/Drive1/database
socket=/var/lib/mysql/mysql.sock
set-variable = max_allowed_packet=64M
set-variable=max_connections=1000
log-bin = /Drive1/database/mysql-bin.log
binlog-do-db=cab
server-id=1

when I execute this command: mysql -u root smsu < /usr/share/doc/gnokii-smsd-mysql/sms.tables.mysql.sql

I'm getting "dlopen error: /usr/lib/smsd/libmysql.so: cannot open shared object file: no such file or directory!"

I tried to fix it by issuing this command: "ln -s /usr/share/smsd /usr/lib/smsd"

But still didn't work.

Please help and thanks in advance.

http://en.oreilly.com/mysql2009/public/cfp/38

Drupal and MySQL go together well. It would be great to have some Drupal presentations and not just a Drupal booth this year at MySQL Expo.

Kieran

I would like to know whether it is possible to import customer profiles from an external MYSQL database (ie, from another drupal site hosted on a different server) to my current drupal site to be used for running my applications and then export them back with some profile modifications?

I would like to keep the main database site separate from my application site and run it with only necessary data fetched from the main database. Will this system work? Is it something complicated to administer?

We have a database Server Configuration:
4GB RAM
600GB Hard Disk
Xeon Processor 1.3 Ghz.

We are barely able to have 100 concurrent users!!! What are we doing wrong.

I know I need to configure mysql_query cache, mysql_limit_size and table_cache. But what should be the formula, and how do we go about checking the same.

Below is the details of our my.ini file.

[mysqld]
datadir=/database/data
socket=/var/lib/mysql/mysql.sock
set-variable=max_connections=2000
set-variable = max_allowed_packet=64M
default-storage-engine = innodb
log-bin=/database/data/mysql-bin