Search This Blog

09/10/2010

09/10/2010 Gtdroid 1.1.5 WIP and mysql Copying to tmp table problem

Today after almost a week without working on Gtdroid I manage to find 4 hours to work on it.
I worked on version 1.1.5. It now use the api and SYNC is really fast: less than 10 seconds for my nozbe account with 40+ project 100+ actions.
Next step is to write the done/undone, star/unstar, create/edit/delete of action.

After the fun part (gtdroid) I got to solve a mysql problem for a client of mine who just migrate from physical to cloud 2 of his production servers. An application server report 200+ connection to the mysql while on the old platform 30 was enough.
After some search I found out that some queries where stuck on the "copying to tmp table" and blocked all other queries.

my.cfg was not filled in with the right value for this kind of load, really it's was just empty!
I use the following page as a good start and configure my.cfg the -almost- right way.

A bientot

No comments:

Post a Comment