Side Channel

  • home
  • resources
Home › Blogs › angch's blog

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.
  • angch: tc qdisc htb activated on the mirror, and mirror reactivated. Hope nothing melts now.
  • angch: Hmmm, tbf doesn't work as advertised. htb does. #qos #linux
  • angch: @yoonkit me thinks #lucid is a much better tag than #lynx
  • angch: Great, you broke the dc's net and they disconnected us. Running to tpm from shah alam
more

mysql tuning

angch's picture

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


Creative Commons License

  • home
  • resources

Standard Disclaimer.