Enable mysql slow_query_log on the fly, no reboot required
I always forget how to do this, so finally decided to write it down (I’m talking about mysql 5.1):
- Login to mysql with administrator rights
-
Inspect current variables before changing those (optional):
mysqlshow variables like 'long_query_time' \G; ...
Percona mysql install problem with Chef on Linode – be aware!
###BAH!
Fresh Linode instance of Ubuntu 12.04 LTS.
Super simple recipe ( stripped down for debugging ).
include_recipe "apt" include_recipe "ohai" include_recipe "mysql::percona_repo" include_recipe "mysql::server"
I tested installation numerous times with the same OS version with Vagrant with no problems, …
Moving single MySQL database to tmpfs
Recently I had a problem running Drupal Simpletest on my new i7 dev box. It took couple minutes to execute a set of relatively simple tests and as a developer you probably know how annoying that could be. The problem was largely due to InnoDB storage engine and it slowness caused by creating / removing tables (compared to let say MyISAM). …
How I solved MySQL I/O problems during cache purges in Drupal
Recently I’ve built pretty powerful workstation with I7 CPU and lots of RAM, but noticed very poor performance during devel/cache/clear operations in Drupal. In fact this operation was 5 times slower than on my 3yrs old dev box.
Initially I thought there was a problem with my hardrive (defected?). …