Topic: MySQL Queries constantly locking

G'day Fellow PHPShop Developers,

I require the services of a PHPShop guru who has experience with optimising PHPShop queries and associated MySQL tables.

I currenlty have a PHPShop shopping centre that has reached breaking point and has been moved to it's own server at great cost to the client but provides little resolve when it comes to tables constantly locking or copying to tmp table etc.

There is no critical deadline on this project except that I must find a solution ASAP.

Please contact me urgently at phpshop@memedia.com.au . Remuneration will be based on a completed project basis and is by negotiation.

Regards,

Chris

  • erv
  • Moderator
  • Offline

Re: MySQL Queries constantly locking

what do U mean " reached breaking point " ??

what exactly is going wrong?

Re: MySQL Queries constantly locking

It sounds more like you just need some good MySQL tuning more than you do phpShop expertise.

You might try looking at the db cache and upping the limits there.

It could be that you might want to add a couple of more indexes to some of the tables as well.  Some of the tables here aren't index beyond the primary index.

Jeff Rader