Pages

Wednesday, February 6, 2013

Mysql: Waiting for table metadata lock

While trying to execute alter table commands; lately it has started taking lot of time and hangs the server. It keeps executing the query and doesn't show any error. It took me a day to figure out a fix for this issue.

If you happen to get similar error then try doing the following:


  1. Run the command "show processlist";
  2. Run  'kill id" which shows this statement running.
This will terminate the command. But this is not the end of solution. Now while running the "Alter table" command; do the following:

  1. Run "show processlist".
  2. Check for all open mysql connections.
  3. Make sure you close all the connection except the one which you are connected by running kill id command.
  4. Now execute the "alter table" command
This worked for me and  I hope this will fix your problem of "waiting for table metadata lock" error.

Monday, February 4, 2013

Maintain Session across subdomain

To maintain your session variable across the subdomains in cakephp you need to do the following:

  1. Open app/config/bootstrap.php
  2. Add "ini_set('session.cookie_domain', '.domain.com');" 
By default Cake is creating a cookie for each domain. With this you can use same sessions across subdomains.