bad query, locking the server

2005-01-20 Thread Mojtaba Faridzad
Hi, sometimes I run a query with LEFT JOIN on a big table and that causes 100% CPU usage on our windows 2003 server. during that nobody has access to the server (very very very slow), even when I wanted to kill MySQL process, it took about 5 min.s just to show the task manager window. after 20

bad query, locking the server

2005-01-20 Thread Mojtaba Faridzad
Hi, sometimes I run a query with LEFT JOIN on a big table and that causes 100% CPU usage on our windows 2003 server. during that nobody has access to the server (very very very slow), even when I wanted to kill MySQL process, it took about 5 min.s just to show the task manager window. after 20

bad query, locking the server

2005-01-20 Thread Mojtaba Faridzad
Hi, sometimes I run a query with LEFT JOIN on a big table and that causes 100% CPU usage on our windows 2003 server. during that nobody has access to the server (very very very slow), even when I wanted to kill MySQL process, it took about 5 min.s just to show the task manager window. after 20