This is perhaps not a direct answer to your question, but another suggestion. It is possible that some of the finds in your site's code are not built well. I'd encourage you debug out the results of the slow queries and see how much data is being returned. It could be that your query is requesting too much unnecessary data that is causing the load problems, not the performance of MySQL.
Jeremy Burns jeremybu...@me.com On 12 May 2010, at 19:35, Ephs wrote: > Hello, > > About two years ago I had someone make a website for me, and he used > CakePHP. Now, I'm slowly learning how cakephp works in order to make > updates (I know PHP fairly well). I'm having some mysql problems > server load problems, and believe that upgrading to the newest version > might help solve the issue (such as using mysql_free_result() on every > query, not just the last one). > > The version in version.txt currently shows 1.1.19.6305, so it seems I > have a fairly old version. How would I go about updating to a newer > version? What do I need to know before I begin? What version can I > upgrade to? I just don't want the functionality of the website to mess > up. > > Any help is appreciated. > > Thanks a lot. > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group at > http://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
