Jump to content


Photo

MySQL optimiziation

MySql database unit testing optimization

  • Please log in to reply
3 replies to this topic

#1 windsor

windsor

    Advanced Member

  • Moderators
  • 272 posts
  • LocationTampa, Florida USA

Posted 04 August 2013 - 02:00 PM

During unit testing on 2.0.2 under Win7 Xampp

 

I ran the MySql "status" report from phpmyadmin while executing '...DesignerSuperUserWalkthroughTest'

and got this result:

 

 

2qsm72v.png

I did already read the manual and it is somewhat vague about how to calculate the optimum settings.

 

Any ideas?



#2 raysto

raysto

    Zurmo Team

  • Administrators
  • 1,973 posts

Posted 06 August 2013 - 11:59 AM

Can we chat about this during the Dev Session?


Ray Stoeckicht
Zurmo Team
Try Zurmo Pro


#3 windsor

windsor

    Advanced Member

  • Moderators
  • 272 posts
  • LocationTampa, Florida USA

Posted 06 August 2013 - 08:52 PM

What we learned in the dev session today, is that unit tests don't represent the actual load on the database. In addition the 2.2 release scheduled this week will include changes that will dramatically improve the performance of tests and also the auto-build and updateSchema process(es).  It may still be interesting to see the difference in performance after the changes, so I'll post back after I upgrade for those who have an interest, and see how things changed.



#4 raysto

raysto

    Zurmo Team

  • Administrators
  • 1,973 posts

Posted 07 August 2013 - 12:23 AM

OK, great. I can tell you that we are about 1 week behind on 2.2 so don't hold your breath. When you do get up to 2.2, I look forward to you testing the performance.


Ray Stoeckicht
Zurmo Team
Try Zurmo Pro






Also tagged with one or more of these keywords: MySql, database, unit testing, optimization

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users