Database

Useful DB Queries for Drupal Applications

Submitted by system on Wed, 03/08/2023 - 13:04
Technologies: 
Database
MySQL
Commands
Command Line

Show grouped node counts based on OG group ids for nodes created after a particular time stamp

select gid, count(*) from og_membership inner join node on og_membership.etid = node.nid and node.created >=  1678127400 group by gid;

Show node type specific node count list

select type,count(*) from node group by type;

Show group membership wise node counts

Memcached Config For Drupal On Ubuntu

Submitted by system on Wed, 10/08/2014 - 00:38
Technologies: 
Memcache
Database
Performance
Optimization
Configuration
Memcached
Linux

Memcached is a free & open source, high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load

Memcached is used in Drupal mostly for caching Database queries in memory to improve authenticated user experience and reduce load on database. Primarily cache tables are swapped to have a memcached backend.