Performance: I just call...

Performance: I just call...

- Maik Riecken の投稿
返信数: 7
to say

MySQL-Stats

I love you. And I mean it from the bottom of my heart. On October, 22nd, I upgraded to moodle 1.8.3+. Take a look at the number of queries before and after...

thanks,

Maik


Maik Riecken への返信

Re: Performance: I just call...

- Michael Spall の投稿
画像 Core developers 画像 Testers
What was the version and date of the code that you were upgrading from? That graph does say it all. Or as Napoleon Dynamite would say, "Sweet!"
Maik Riecken への返信

Re: Performance: I just call...

- Petr Skoda の投稿
画像 Core developers 画像 Documentation writers 画像 Particularly helpful Moodlers 画像 Peer reviewers 画像 Plugin developers
Petr Skoda への返信

Re: Performance: I just call...

- Maik Riecken の投稿
Oh - I've got more of this. It is the munin package of debian. So If you are interested in RAM-usage...

I spend a long time to optimize the MySQL-settings to get this cache hitrate.

Maik
Maik Riecken への返信

Re: Performance: I just call...

- Michael Spall の投稿
画像 Core developers 画像 Testers
Well since you are offering, what is your best advice for optimizing the MySQL settings?
Michael Spall への返信

Re: Performance: I just call...

- Maik Riecken の投稿
It heavily depends on your installation and your users. A good point to start is the following link (tuning_primer.sh):

http://day32.com/MySQL/

Another hint is to turn any engine og MySQL off, you won't need, especially InnoDB to save memory.

We use lighttpd instead of apache - this saves much memory - but no one seems to have tested this on high load environments. I've got 30% more performance since using lighttpd/fastCGI.

Maik

Maik Riecken への返信

Re: Performance: I just call...

- Petrus 4 の投稿
Hi Maik,

I am wondering what your max concurrent users are when using lighttpd/fastcgi. Perhaps a good option for us.
Whan you speak of performance what do you mean exactly, faster response time on pages, or less load on the server?