Performance Issues MySQL

Discussion in 'MySQL' started by swapshop, Dec 8, 2008.

  1. #1
    I have a site that some days runs well and others like crap

    Trying to work out the performance issues with it

    Host has forced me to VPS thats fine

    What the VPS solution has done is made me look harder at the issue

    Is it ok to have mutiple open connections to the db rather than just one?

    I have the classifeds+sep diretory+ million pixel+ support+ chat so you see my point? better to get the additional scripts to use a separate db right?

    Anyone give me some good advice?
     
    swapshop, Dec 8, 2008 IP