mysql

I am running 0.4-alpha7. I am trying to migrate a site from D6.14 to D6.16 and have encountered two problems:

<

ol>

This discussion got me thinking...
http://groups.drupal.org/node/56438#comment-160418

So I decided to create some code that will auto add indexes to your CCK fields where there are none. Works for me (using MySQL), may not work for you. Also at the bottom is code to add indexes elsewhere in Drupal.
<?php
$ret = array();
// Add indexes to CCK fields
$result = db_query("SHOW TABLES LIKE 'content_%'");
while ($table = db_result($result)) {
if ($table == 'content_group') {
db_add_index($ret, 'content_group', 'weight', array('weight'));

I'm trying to finalize a LAMP build on RHEL 5, PHP 5.2.11. What modules are absolutely necessary for future growth?

Currently I'm running:
core prefork
http_core
mod_so
mod_auth_basic
mod_auth_digest
mod_authn_file
mod_authn_alias
mod_authn_anon
mod_authn_dbm
mod_authn_default
mod_authz_host
mod_authz_user
mod_authz_owner
mod_authz_groupfile
mod_authz_dbm
mod_authz_default
util_ldap
mod_authnz_ldap
mod_include
mod_log_config
mod_logio
mod_env
mod_ext_filter
mod_mime_magic
mod_expires
mod_deflate
mod_headers
mod_usertrack

http://groups.drupal.org/node/41798
Ich gebe das mal weiter, da es nur auf München und Germany steht.

Ein frohes Neues Jahr Euch allen!

Unter HelpMySQL.org könnte Ihr eine Petition des MySQL-Gründer Monty Norman unterzeichnen gegen eine Übernahme des OpenSource-Datenbank-Systems, das auch eine Haupt-Grundlage von Drupal bildet, und für ein freies MySQLL. Einfach unterzeichnen/ausfüllen unter:

http://helpmysql.org/

Hello,

My website (shared hosting) is growing bigger.

Usually I backup using MySQLDumper (http://www.mysqldumper.net/)

It will backup fine, also no error when restoring. Then, when browse the site, some post will missing (not found), but the link to that missing posts still there. I have no idea whats going on. When looking at the database by checking the tables and compare it to the original database, it looks like no data loss, with same number of lines.

I dont really like idea of dump database. MySQLDumper is just best choice for shared hosting.

Hello.
I've created mysq version of database.mysql.inc to correctly work with mysql_pconnect to make available persistent connections.
The main problems were table locks and temporary tables - I've solved it using register_shutdown_function() for script.
Now looks like all working properly.(one project runs using this patched version)

But this patch is for case site using one database only. File is attached.

Today Amazon announced a provided service for hosting MySQL databases in the cloud: Amazon Relational Database Service. It starts at $0.11/hr, plus $0.10 per GB/month of storage and $0.10 per million I/O requests. The real interesting question is how these will perform. The instances come in many flavors:

• Small: 1.7 GB memory, 1 virtual core with 1 ECU. $0.11/hr
• Large: 7.5 GB memory, 2 virtual cores with 2 ECUs each. $0.44/hr
• Extra Large: 15 GB of memory, 4 virtual cores with 2 ECUs each. $0.88/hr
• Double Extra Large: 34 GB of memory, 4 virtual cores with 3,25 ECUs each. $1.55/hr
• Quadruple Extra Large: 68 GB of memory, 8 virtual cores with 3.25 ECUs each. $3.10/hr

That "Quadrupal XL" is pretty big! I'll be investigating this for Pantheon, but anyone else with experience/info, let's figure out how good these things really are!

Hey all,

I created a new handbook page with a short script, and I wanted folks to take a look and see what they thought. The script cycles through all the site nodes, loads them, then saves them.

http://drupal.org/node/559364

On our site we have a content type called product showcase. This content type was using to store information about products our company has certified. After awhile it became apparent that what I had developed wasn't good enough. We were constantly changing how the fields worked and things were getting sloppy.