Re: Why can't I kill the query cache?

2009-05-30 Thread Baron Schwartz
I had heard of that trick but never looked it up. 'man proc' tells me /proc/sys/vm/drop_caches (since Linux 2.6.16) Writing to this file causes the kernel to drop clean caches, dentries and inodes from memory, causing that memory to become fr

Re: Left join query

2009-05-30 Thread Shiv
Hi, Along with tables, you should also provide details on how they are related. Assuming "Code" is unique in both tables and left joined on Airport table, you can do something like this SELECT A.Code, C.Code, A.SlNo, C.SlNo, A.Name, C.Location, A.status, C.status, C.type FROM Airport A LEFT OU

Looking for a developer, Adelaide, Australia

2009-05-30 Thread Frank J Bruzzaniti
I'm looking to engage a developer with php / mysql experience in Adelaide, Australia for full time employment or contract basis. Please email me if you are interested. Regards, Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.