Site Speedup

News about StepMania Online.
houkouonchi
Site Admin
Posts: 156
Joined: Sun Sep 16, 2012 1:12 pm

Site Speedup

Postby houkouonchi » Thu Dec 06, 2012 2:53 pm

I enabled some MySQL optimization which has sped up the site quite a bit =). Anyone notice the speed increase?

User avatar
Izzy
Moderator
Posts: 531
Joined: Thu Sep 27, 2012 3:03 pm
Location: Leawood, Kansas
Contact:

Re: Site Speedup

Postby Izzy » Thu Dec 06, 2012 3:47 pm

Yes, by a factor of at least 5.

What did you change? Different indexing?

houkouonchi
Site Admin
Posts: 156
Joined: Sun Sep 16, 2012 1:12 pm

Re: Site Speedup

Postby houkouonchi » Thu Dec 06, 2012 3:51 pm

Izzy wrote:Yes, by a factor of at least 5.

What did you change? Different indexing?


I did add some indexes on some columns in some tables but the biggest thing was enabling query cache for the tons of queries that are constantly being ran. I thought it was already enabled but I found it was not. This increases memory usage but decreases load/cpu usage and increases load time by a ton in most cases.


Return to “StepMania Online News”

Who is online

Users browsing this forum: No registered users and 1 guest