MySQL

DataSphere Technologies is a recent Seattle-area startup backed by Ignition Partners and other investors. We have spent the last three years building a set of highly scalable technologies to power some of the most immersive Web experiences in the Media, Real Estate and ecommerce spaces. We power all or part of over 250 Web sites and we expect to grow this number at an ever increasing rate. We are looking for a seriously solid high-end Drupal Technologist to begin the next phase of our platform.

I have drupal website with ~500,000 nodes and I have problem with this query:

SELECT node.nid nid
FROM node FORCE INDEX(node_created), term_node, node_counter
WHERE node.nid = term_node.nid
AND term_node.nid = node_counter.nid
AND node.created > 1244565947
AND tid =170
AND node.nid NOT IN (218892)
AND node.status=1
AND type = 'akhbar'
ORDER BY node_counter.totalcount DESC LIMIT 0 , 4

Can anyone help ?

if I don't use "FORCE INDEX(node_created)" the query is 10 times slower.

Looking for a freelance developer that loves clean code and wants to make some extra side income by helping with development for one of our web projects. The site is already up and running, what we need is someone that can carry out some additional work and upgrades. This is a fun project for the entertainment industry.

Must have have strong familiarity and experience with:
- Standards compliant code
- MySQL & PHP
- RSS
- Custom module development

If you're interested, please contact me at: bsamii@inmotionrealestate.com

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.

We are running RHEL5.1, Apache2, MySql5, PHP5 and have run into an issue. Our site runs find with normal usage, but if you hold the refresh (F5) key, then the site will crash. We have gotten it to the point that it will not crash the server, but it will take a while before the page responds (for any user). I know that this does not happen on other sites, so we are most likely missing a configuration setting somewhere. Here is what we have:

Apache

KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 2
StartServers 8
MinSpareServers 5
MaxSpareServers 20

Does Drupal support connection pooling,
transaction control,
connect and disconnect connections??

Any thoughts on:
http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connec...