Side Channel

  • home
  • resources
Home

User login

What is OpenID?
  • Log in using OpenID
  • Cancel OpenID login
  • Create new account
  • Request new password

Navigation

  • Books
  • Feed aggregator

Recent blog posts

  • Ubuntu mirrors up and improved!
  • Google-jstemplate: Iterate object with unknown properties
  • nginx https proxypass for php apps
  • sugarcrm & memcache: Doing it Wrong
  • subversion and https in Ubuntu Karmic
  • Drupal: Views block delta converted to md5 hash
  • Ubuntu Server install requires PAE
  • Installing Drupal from command line
  • Drupal: Handling form field weight through CCK
  • minify javascript using Google Closure Compiler
more

angch's location

angch twitter

  • angch: Heading to Brunei. Business class for a change.
more

mysql

angch's picture

Drupal: PostgreSQL vs MySQL

angch — Thu, 26/03/2009 - 19:11

Let's get this out of the way first: MySQL beats PostgreSQL for Drupal sites in terms of raw performance. See this benchmark

But the real question is the how and why, and also how to make sites even faster and more scalable?

  • drupal
  • mysql
  • performance
  • postgresql
  • angch's blog
  • Add new comment
  • Read more
angch's picture

mysql tuning

angch — Wed, 05/11/2008 - 16:13

Random note, Ubuntu Hardy, mysql/innodb tuning (more like frobbing).

[mysqld]
query_cache_limit = 2M; was 1M
query_cache_size = 32M; was 16M
innodb_file_per_table
innodb_buffer_pool_size=128M
innodb_log_file_size=32M
innodb_log_buffer_size=12M

default-table-type=innodb

Dump/restore required, nuke the orig log file first before restarting

  • innodb
  • mysql
  • ubuntu
  • angch's blog
  • Add new comment
Syndicate content


Creative Commons License

  • home
  • resources

Standard Disclaimer.