Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 142 Next 30 Older Entries

Displaying posts with tag: drupal (reset)

Fast paging in the real world
+0 Vote Up -2Vote Down

This blag was originally posted at http://cafuego.net/2010/05/26/fast-paging-real-world

Some time ago I attended the “Optimisation by Design” course from Open Query¹. In it, Arjen teaches how writing better queries and schemas can make your database access much faster (and more reliable). One such way of optimising things is by adding appropriate query hints or flags. These hints are magic strings that control how a server executes a query or how it returns results.

An example of such a hint is SQL_CALC_FOUND_ROWS. You use it in a select query with a LIMIT clause. It instructs the server to select a limited numbers of rows, but also to calculate the total number of rows that would have been returned without the limit clause in place. That total number of rows is stored in a

  [Read more...]
fast paging in the real world
+0 Vote Up -0Vote Down

Some time ago I attended the "Optimisation by Design" course from Open Query¹. In it, Arjen teaches how writing better queries and schemas can make your database access much faster (and more reliable). One such way of optimising things is by adding appropriate query hints or flags. These hints are magic strings that control how a server executes a query or how it returns results.

An example of such a hint is SQL_CALC_FOUND_ROWS. You use it in a select query with a LIMIT clause. It instructs the server to select a limited numbers of rows, but also to calculate the total number of rows that would have been returned without the limit clause in place. That total number of rows is stored in a session variable, which can be retrieved via SELECT FOUND_ROWS();  That simply reads the variable and clears it on the server, it doesn't actually have to look at any table or

  [Read more...]
451 CAOS Links 2010.04.23
+0 Vote Up -0Vote Down

The White House contributes to OSS. Growth for Pentaho and MuleSoft. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# The White House released some of the custom code it has developed for whitehouse.gov as open source.

# Pentaho reported 229% bookings growth and 177% Enterprise Edition customer growth in Q2.

# MuleSoft grew bookings by 140% in Q1.

# The beta of Red Hat Enterprise Linux 6 is now available, without Xen.

# OpenCandy


  [Read more...]
Loadays CFP
+0 Vote Up -0Vote Down

I would like to point the crowd to the Call For Presentaions of Loadays. , the Linux Open Administration Days .


The Linux Open Administration days 2010 will be the first edition of a new conference focusing on Linux and Open Administration, we are trying to fill a gap for System Engineers and Administrators using Open Source technologies"

More details on the Linux Open Administration Days site

I'll probably be there .. given the fact that the event will be 5 minutes from where I live .

Technorati Tags: antwerpen cfp conference
  [Read more...]
Fosdem 2010
+0 Vote Up -0Vote Down

Fosdem 2010 was my 10th fosdem Edition (including the first OSDEM)
As every year Fosdem suffered even more from it's own success.

On Friday evening ther was the obligatory Beer event... however as people need to eat to .. the Devops crowd fled the scene

I had made reservations for a 20 something group and with the CentOS crowd joining us (as there was some overlap anyhow) we were 25 when we arrived in the restaurant .

Dinner and Discussions were great .. I learned about some new projects and we had some insightfull dicussions on how fat your thin foil should be ...

After dinner we went back to the Beer Event were lots of Free Beer was tasted ...

Saturday was the first full day of Fosdem, as usual Fosdem was the victim of it's own success , too much interresting stuff to see .. too little



  [Read more...]
Friendlist Graph Module for Drupal
+2 Vote Up -1Vote Down

At DrupalSouth 2010 (Wellington) after LCA2010, Peter and I implemented a Drupal module as a practical example of how the OQGRAPH engine can be used to enable social networking trickery in any website. The friendlist_graph module (available from GitHub) extends friendlist, which implements basic functionality of friends (2-way) and fans (1-way) for Drupal users.

The friendlist_graph module transposes the friendlist data using an OQGRAPH table, allowing you to query it in new and interesting ways. By adding some extra Drupal

  [Read more...]
MySQL & Friends Meetup @ Fosdem
+1 Vote Up -0Vote Down

Fosdem is coming up again .. It's going to be the 10th edition already So it's going to be 2 days and nights of fun, tech and geek stuff

Lenz already posted the announcement , but allow me to recapitulate.

The MySQL & Friends meetup is on saturday evening , we'll meet around 1900 in front of the under the big tree in front of the AW building...

As with the Devops Meetup you can once again vote for your preferred food

The crowd voted and Favoured an Italian place , so I've made reservations for a 15+ persons group at Sogno d'Italia which is walking

  [Read more...]
Performance Tuning Your Database From Drupal
+1 Vote Up -0Vote Down

I began porting the dba module to Drupal 7 as an opportunity to learn more about the new database abstraction layer. In this upcoming Drupal release, our database layer is now built upon the PHP Data Objects (PDO) data-access abstraction layer, introducing new syntax and symantecs into writing queries with Drupal. A powerful new query builder makes it possible to easily write queries that run on any database type supported by Drupal, currently including MySQL, PostgreSQL and SQLite.

The dba module was always intended to be a useful tool for any database administrator, and toward that end I have recently merged in mysqlreport functionality which utilizes MySQL's server statistics to offer an overview of server health and

  [Read more...]
Tag1 is Hiring!
+0 Vote Up -1Vote Down

Join the leading Drupal performance and scalability company. We architect infrastructures, optimize code and database queries, tune the applications serving web pages, and stay current with the latest performance and reliability technologies. We employee some of the leading contributers to the Drupal framework, including core contributors and contrib maintainers, as well as key members of the Drupal.org infrastructure team. We strive to continuously share our growing knowledge and contribute back performance patches to the larger open source community.

read more

Speaking, speaking, speaking: Dubai-Sydney-Wellington
+5 Vote Up -0Vote Down


(*)
From January 12th to 27th I will be traveling to the Southern Hemisphere and speaking at two user groups and two conferences.
The schedule (see below) is almost scary. I will be talking about Partitioning (Dubai and Wellington), MySQL Sandbox (Sydney and Wellington), Gearman (Wellington), and some general topics now and then.

The complete schedule and location follows:







  [Read more...]
Option D
+3 Vote Up -1Vote Down

Lots of people writing about Snorkle again today ,Monty Says, help saving MySQL

He gives us different options, a , b or c .. but I , and some others, want an option d

No I don't trust Oracle, it's not like they have been a very good Open Source Citizen, yes they contribute to the kernel and other projects but my feeling says it's only because they have to (Kernel, Xen and others ) not because they Want to (thinking about Unfakable etc) , if they would really want to they probably would work with the CentOS community more etc, and as Monty mentions their InnoDB track record could be better.

But on the other hand I don't think the EU should block the deal because Monty wants his baby back , cheap , as honestly imvho that's what they really want, be able to buy MySQL back for a nice price, either beceause Oracle

  [Read more...]
MySQL user groups in Dubai and Sydney, on my way to NZ
+3 Vote Up -0Vote Down



In January 2010 I will attend Linux.Conf.Au, which this year is held in Wellington, New Zealand.
It's a long way from Europe to New Zealand, and so I will take a few stops.
On January 13 I will be in Dubai, UAE. If you are around, I would love to organize a MySQL meeting. I haven heard back from the local user group and it seems that a meeting will take place. Stay tuned for more.
On January 15th I will be in Sydney. The organizers are already at work. We will





  [Read more...]
Simplenews Mass Subscribe
+0 Vote Up -0Vote Down

Simplenews is a quick and easy way to set up and manage newsletters on Drupal, but if you add it to a site which already has users, you might want a way to quickly subscribe all your users to your newsletter.

Rather than click through all users and manually subscribe them - which can be a little bit boring if you have thousands of users - you can run a few SQL queries to mass-subscribe everyone in one go.

Each user that is subscribed to ANY newsletter has an entry in the simplenews_subscriptions table, which contains their user id, their email address and an assigned subscription id. In addition to that, a user has a discrete entry in the simplenews_snid_tid table for each separate newsletter they're subscribed to.

The latter basically links the unique ID from the subscriptions table to the term ID from the

  [Read more...]
NoSQL and SQL
+0 Vote Up -0Vote Down
Topic: DrupalMySQL

Have a look at this video of Brian Aker's great 10 minute lightning talk about NoSQL. NoSQL is a database movement which promotes non-relational data stores that do not need a fixed schema.

With the exception of Memcached, the Drupal world is very SQL driven -- and for all the right reasons. However, both at Mollom and Acquia we have to deal with some big data volumes and have been using some of the NoSQL technologies like Hadoop,

  [Read more...]
Operating a Drupal Site behind a Reverse Proxy Server (Apache)
Employee +0 Vote Up -4Vote Down
It's often not desirable to expose your Drupal server directly to the end users. This document describes how to “hide” a Drupal server behind a reverse proxy server. This is typically done for a number of reasons:
  • protection: the topology of the server, the database server can be hidden from the front end

  • caching: The proxy server take away load from the backend system through caching

  • flexibility: the topology behind the reverse proxy can be changed more easily

  • scalability: the proxy server can be used for future load balancing

The technical problem isn't new. It has been solved before. I had however problems finding a solution in a single document.

The configuration is

  [Read more...]
Got Interviewed
+0 Vote Up -0Vote Down

by @botchagalupe
on Virtualization, Open Source tools and DNS Problems

Technorati Tags: dnsproblem drupal ha heartbeat linux-ha mysql pacemaker puppet virtualization xen
  [Read more...]
Aspects and benefits of distributed version control systems (DVCS)
Employee +2 Vote Up -0Vote Down

This blog post is a by-product of my preparation work for an upcoming talk titled "Why you should be using a distributed version control system (DVCS) for your project" at SAPO Codebits in Lisbon (December 3-5, 2009). Publishing these thoughts prior to the conference serves two purposes: getting some peer review on my findings and acting as a teaser for the actual talk. So please let me know — did I cover the relevant aspects or did I miss anything? What's your take on DVCS vs. the centralized approach? Why do you prefer one over the other? I'm looking forward to your comments!

Even though there are several distributed alternatives available for some years now (with

  [Read more...]
Some friendly advice for bootstrapping your OSS project
Employee +4 Vote Up -0Vote Down

So you're a small startup company, ready to go live with your product, which you intend to distribute under an Open Source License. Congratulations, you made a wise decision! Your developers have been hacking away frantically, getting the code in good shape for the initial launch. Now it's time to look into what else needs to be built and setup, so you're ready to welcome the first members of your new community and to ensure they are coming back!

Keep the following saying in mind, which especially holds true in the Open Source world: "You never get a second chance to make a first impression!". While the most important thing is of course to have a compelling and useful product, this blog post is an attempt to highlight some other aspects about community building and providing

  [Read more...]
451 CAOS Links 2009.10.27
+0 Vote Up -0Vote Down

Red Hat invests in EnterpriseDB. The White House goes open source. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

In other news…

# EnterpriseDB confirmed Red Hat investment, partnership.

# Whitehouse.gov migrated to Drupal, as well as Linux, Apache,


  [Read more...]
A DTrace Quick Start Guide
Employee +1 Vote Up -0Vote Down
Alta Elsta & I just completed the DTrace Quick Start Guide: Observing Native and Web Applications in Production mini-book. If you need a hardcopy let me know but if you are like me and would love to save a few trees you can click on the picture below to download the pdf version.

We talk about why DTrace is so different from any observation tools you may have seen. We cover basic DTrace concepts and some details on writing d-scripts. We also have a lot of sample scripts. Sections on using DTrace to observe MySQL and Drupal are included.

The examples from the book have also been added to a wiki page for easier copy & paste.





  [Read more...]
Thoughts on the Whitehouse.gov switch to Drupal
+2 Vote Up -0Vote Down

Yesterday, the new media team at the White House announced via the Associated Press that whitehouse.gov is now running on Drupal, the open source content management system. That Drupal implementation is in turn running on a Red Hat Linux system with Apache, MySQL and the rest of the LAMP stack. Apache Solr is the new White House search engine.


This move is obviously a big win for open source. As John Scott of Open Source for America (a group advocating open source adoption by government, to which I am an advisor) noted in an email to me: "This is great news not only for the use of open


  [Read more...]
Tag1 Now Hiring Interns
+0 Vote Up -1Vote Down

At the beginning of 2009, I was hired by Tag1 Consulting as Jeremy Andrews' full time partner. A decidedly questionable decision on his part, but a great change for me! I used to work at the Open Source Lab at Oregon State University and I am currently the sysadmin for drupal.org. Working at the OSL and drupal.org spoiled me, I'll be completely honest about that. I got used to working with interesting new technologies and consistently pushing the limits of my knowledge.

read more

MySQL > YourSQL
+0 Vote Up -0Vote Down

Since I started doing the occasional consulting job for Open Query, I've seen a lot of MySQL servers that have been installed once and then forgotten about. This gave me the idea to do a short presentation about some basic MySQL server configuration. The first go was at DrupalCampMelbourne and I recently tried (and failed) to cram it into a three minute lightning talk slot at the LUV September meeting.

The title of the talk is (now) MySQL > YourSQL. I chose this not because I think that MySQL is better than the $other_database you use or because I may or may not run a newer version of MySQL on better hardware, but because I use InnoDB and not MyISAM as the default table

  [Read more...]
"Idle"
+0 Vote Up -0Vote Down

For those who wonder why my blogging is so low these days (apart from today) .. I`m actually writing more Lines of Code than Blog Entries the last couple of weeks:)

And when I`m not writing code I`m reading :) Either proofreading an upcoming book on Zabbix or reading some of the other books Packt sent me.

Next to that I`m busy preparing my T-Dose presentation

Oh and did I mention a 40 something questions questionnaire about some merger ?

Technorati Tags:   [Read more...]
451 CAOS Links 2009.09.11
+0 Vote Up -2Vote Down

CodePlex, patents and Linux code. An interesting few days for Microsoft open source.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

CodePlex, CodePlex, CodePlex!

Microsoft launched the CodePlex Foundation to facilitate open source contributions, and confirmed the departure of Sam Ramji.

Patents, Patents, Patents!
The OIN confirmed the acquisition of 22 patents formerly owned by Microsoft, prompting





  [Read more...]
451 CAOS Links 2009.09.04
+0 Vote Up -0Vote Down

Red Hat round-up. EC to review Oracle-Sun. Dedicated Ubuntu support. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

Red Hat announcements round-up
Red Hat announced a whole heap of products and projects this week. They should have organized an event to coincide with all the announcements. Or something. The biggest news was probably the launch of Red Hat Enterprise Linux 5.4 including KVM and other virtualization capabilities, while Red Hat and HP partnered to optimize Red Hat Enterprise Virtualization for HP BladeSystem Matrix. The company also revealed that Red Hat Network


  [Read more...]
T-Dose 2009 CFP,
+0 Vote Up -0Vote Down

Dear MySQL and Drupal , Plone and other Open Source folks, you might want to be interrested in giving a talk at T-Dose 2009 ,

Jean Paul pinged me with the following mail :

Maybe it escaped your attention that the Call For Papers for T-DOSE 2009 is already out. It has been announced on 12th of June 2009. Below you will find the original announcement.

Call for Papers and Projects
Fri, 06/12/2009 - 13:57 — jpsaman

T­-DOSE is a free and yearly event held in The Netherlands to promote use and development of Open Source Software. During this event Open Source projects, developers and visitors can exchange ideas and knowledge. It is held at the Fontys University of Applied Science on 3 and 4 October 2009.

Speakers can send ideas and abstracts to the organisation at abstracts _AT_ t-dose.org. The e­mail should contain a short biography of the speaker and


  [Read more...]
451 CAOS Links 2009.07.31
+0 Vote Up -0Vote Down

When open source goes bad. Is open source a success or failure? And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

When open source goes bad

The H reported on the apparent turmoil at the CentOS project, while Jay Lyman offered the CAOS perspective. Meanwhile Slashdot reported that Alan Cox has quit as Linux TTY subsystem maintainer.

Success or failure?
Danny Windham, Digium CEO, responded to Peter Yared’s





  [Read more...]
Site upgrade, throwing in new Drupal modules
+1 Vote Up -0Vote Down

I've been enjoying a nice vacation - the Sun is shining, so to speak :-). But a couple of days I've enjoyed upgrading www.openlife.cc to a newer drupal version, and also adding some much delayed blogging and Web2.0 enhancments.

Notes about the upgrade process (Drupal 4.7 to 6)

I had never upgraded openlife.cc, so I had to go through 2 major version upgrades. To do this, I created a staging site on my laptop so I could spend several days fixing things that would and did break when upgrading.

read more

Ladies and gentlemen, check your assumptions
+1 Vote Up -0Vote Down

I spent some time earlier this week trying to debug a permissions problem in Drupal.

After a lot of head-scratching, it turned out that Drupal assumes that when you run INSERT queries sequentially on a table with an auto_increment integer column, the values that are assigned to this column will also be sequential, ie: 1, 2, 3, …

This might be a valid assumption when you are the only user doing inserts on a single MySQL server, but unfortunately that is not always the situation in which an application runs.

I run MySQL in a dual-master setup, which means that two sequential INSERT statements will never return sequential integers.  The value will always be determined by the  auto_increment_increment and auto_increment_offset settings in the configuration file.

In my case, one master will only assign even numbers, the other only uneven ones.

My

  [Read more...]
Previous 30 Newer Entries Showing entries 31 to 60 of 142 Next 30 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.