Hi,
I run old version of mysql (3.23)....I am planning on upgrading it here soon. I have a script which does left join on 4 tables and it runs efficiently for 80% of time.
However, the rest 20% the mysql server tends to hang up on a single search and ends up locking lots of processes. It might be because one of the tables I do join on is frequently updated and it might be case of thread locking.
I could post my join in here for review but if there are any other areas that I need to look at first, please let me know.
I run old version of mysql (3.23)....I am planning on upgrading it here soon. I have a script which does left join on 4 tables and it runs efficiently for 80% of time.
However, the rest 20% the mysql server tends to hang up on a single search and ends up locking lots of processes. It might be because one of the tables I do join on is frequently updated and it might be case of thread locking.
I could post my join in here for review but if there are any other areas that I need to look at first, please let me know.