Forum Settings
Forums
New
This topic has been locked and is no longer available for discussion.
Pages (7) « 1 [2] 3 4 » ... Last »
Mar 26, 2011 12:01 AM

Offline
Nov 2010
608
Xinil said:
Last week, as many of you probably have noticed, MAL received a huge server hardware upgrade. We also changed our MySQL databases to Innodb. This puts us on a path to sustainability for the short-mid future. We're looking at more options to make sure we stay ahead of the performance problems. I know this has been an extremely long time coming, and I deeply apologize for the delays in getting these much needed hardware changes done.

One down side to switching to Innodb is our lack of fulltext indexing. Thus, we had to lose search in the forums. We're planning on adding it back in once we're able to implement an efficient solution. I don't have an estimate on when it will be back.

User anime/manga, signature, and series stats should now running without issue now as well. I've added a prioritization queue, so if the server is inundated with stat requests, the person who has waited longest will get updated first.

Sorry for the delayed announcement. I wanted to post when we made the server changes, but we wanted to monitor performance first.

Expect some more bug fixes and enhancements in the near future. Now that our performances issues are largely resolved (for now), I can focus on the ridiculously growing/embarrassing bug/feature request list.
Admin? I love you :3 can you be President of the United States? I'll fund your campaign in Mario Coin lol
Mar 26, 2011 1:38 AM

Offline
Sep 2009
1570
I'm another person who is feeling the loss of the Search feature.

If it's at the cost of not waiting literally 26 hours for my list to update....fuck. I can't really complain.
But it would be loved if it could come back in some form or another one day.

EDIT:
And not having my posts "Not existing" for a few hours. Thats another bonus.
SabinleroseMar 26, 2011 1:45 AM
Mar 26, 2011 3:08 AM

Offline
Jan 2011
34
this is fantastic, thanks Xinil!!
Mar 26, 2011 3:11 AM
Mar 26, 2011 4:48 AM

Offline
Aug 2010
1286
So that's why updates have been fast these past few days. (& my animelist stats on my profile was finally updated). Thanks so much for your effort! :D
Mar 26, 2011 6:55 AM

Offline
Mar 2010
181
Thanks for your hard work. I hope it will bring even more users to this excellent site :)
But if the arrow is straight
And the point is slick
It can pierce through dust
No matter how thick...
Mar 26, 2011 8:29 AM

Offline
Jul 2007
2780
Brand said:
Yes, I got to say I am very happy stuff is in more working order now.


Indeed
Mar 26, 2011 8:55 AM

Offline
Apr 2010
278
Thx for having to spend your own time for the pleasure of others :D :D :D
Mar 26, 2011 9:13 AM

Offline
Dec 2009
64
Ty! I'm so happy my stats updated! :D (But I "have" 65534 new messages and 2 new club invitations)
junpetMar 26, 2011 9:19 AM
Mar 26, 2011 9:58 AM

Offline
Jun 2010
132
Amazing job, now this working well ^^
Mar 26, 2011 10:22 AM

Offline
Nov 2008
7012
Does this mean we can have club mass messaging back now? I know of a few clubs which would become much more active if it returned.

Thanks for the fixes you have already done. I appreciate it.
Current FAL Ranking + Previous best::
[
Mar 26, 2011 10:23 AM

Offline
Nov 2009
186
The performance issues were so disturbing that I was about to leave this community. It's working pretty good now. It's great to have a working MAL back. Good job!
And slowly, you come to realize... It's all as it should be...
Mar 26, 2011 10:24 AM

Offline
Jun 2007
2292
Great news! Thank you very much!
Mar 26, 2011 10:27 AM

Offline
Dec 2009
2368
Thanks for the update! I was scared that MAL would get all laggy again cause it just suddenly got faster one day. xD
Mar 26, 2011 11:16 AM

Offline
Jul 2008
7808
Great news in a long time. Emphasis on long time.
Mar 26, 2011 11:30 AM

Offline
May 2009
615
Thanks for the updates I've been waiting for them for a long time..even though I noticed this recently that my list has been updating more efficiently.

Thanks for the hard work
Mar 26, 2011 11:31 AM

Offline
Mar 2005
3806
should toss in a google search widget in the meantime for the forum (unless our traffic is already high enough that we'd cost money?). but good stuff, glad to hear it's things are moving along.
Mar 26, 2011 11:37 AM
Offline
Mar 2010
476
Everything seems to be running really fast for me so far.
Good job guys ^^
Mar 26, 2011 11:57 AM
Offline
Sep 2007
145
Thanks so much for taking the time to repair the problem! :)
Mar 26, 2011 12:28 PM

Offline
Dec 2010
61
Thanks, I'm glad that the site is updating fast now and I can see my stats. :)
Though I hope the inbox problem is gonna be fixed soon.^^
Mar 26, 2011 12:44 PM

Offline
Jul 2010
1148
Praise to the anime gods.
Mar 26, 2011 1:34 PM

Offline
Jul 2010
857
<3

Thanks.

And please don't apologize. Your doing us a service, it is not the other way around.
Signature removed. Please follow the signature rules, as defined in the Site & Forum Guidelines.
Mar 26, 2011 4:09 PM
Offline
Aug 2009
1567
Thank you very much for your hard work!
And:
gregory003 said:
please don't apologize. Your doing us a service, it is not the other way around.
Mar 26, 2011 4:31 PM

Offline
May 2008
69
Awesome. Thank you good sir!
Mar 26, 2011 4:48 PM
Offline
Feb 2010
1762
Is it my imagination or did the site have a massive slow-down for the last 4 hours?
Mar 26, 2011 5:24 PM

Offline
Jul 2007
6105
Great stuff, works great. I notice a huge significant change to updating entries now in my MAL database.



Mar 26, 2011 5:48 PM

Offline
Jan 2008
61
Thanks for the update, Xinil.

MAL is such a useful website and the speed boost has really helped make it feel polished again.
Mar 26, 2011 5:51 PM

Offline
Jul 2008
7808
nerb said:
Is it my imagination or did the site have a massive slow-down for the last 4 hours?
Same here. I'm guessing it's for the better? :)
Mar 26, 2011 8:00 PM

Offline
Apr 2010
49
Thank you !
Mar 26, 2011 8:05 PM

Offline
May 2009
368
Alipio said:
nerb said:
Is it my imagination or did the site have a massive slow-down for the last 4 hours?
Same here. I'm guessing it's for the better? :)

Yup i had it too... but now it's good to go
Mar 26, 2011 8:12 PM

Offline
Jun 2010
116
Thank you for your hardwork!
i'm thankful to see my anime stats to be updated much better now! :)
Mar 26, 2011 8:16 PM

Offline
Mar 2011
375
I think they should delete the x-rated pages to make the site more faster. This is MyAnimeList, not My*****List. Just my opinion.

Mar 26, 2011 9:20 PM
Offline
Sep 2009
1
With MySQL, Sphinx is probably the easiest thing to use:

http://sphinxsearch.com/

Many consider it better than fulltext indexes anyway. It can be fairly easy to implement, here are some docs:

http://sphinxsearch.com/docs/current.html#sphinxql (use like SQL)
http://sphinxsearch.com/docs/current.html#sphinxse (use like a VIEW)

Also note that you can use mixed tables (some MyISAM) to retain fulltext indexes, as long as you're not modifying the indexed data often (keep in mind MyISAM is much faster than InnoDB, but MyISAM can't handle simultaneous updates/deletes.)

Since posts are not updated often, just created, those may be fine as MyISAM (just note that if you use mixed tables, it's true you have to dedicate a bit more ram, some to InnoDB, some to MyISAM.) In contrast, pretty much everything else definitely needs to be InnoDB.

(not sure if Xinil will see this, I presume he doesn't read messages either...)

-[Unknown]
Mar 26, 2011 9:29 PM

Offline
Aug 2010
71
Thank you so much. Seems to be working almost perfectly. Updates basically instantly. Better than I have probably ever seen it, so thanks again. I love the site and it's nice to have it working properly.
よ!僕はジェフです。エンジニアです。日本語が下手です。もっと勉強しなきゃいけない!
Mar 26, 2011 11:28 PM

Offline
Oct 2010
367
Thanks Xinil. MAL was petty slow now it has been improved a lot.
Thank you.
Mar 27, 2011 12:47 AM

Offline
Nov 2010
160
Speak o the devil, the lag time was really becoming an eyesore,

Mar 27, 2011 1:50 AM
Offline
Nov 2008
18019
Great, now if you fix everything else we'd be good to go. Oh wait, it's not fixed, it's just a band-aid. I'll enjoy MAL's intended performance for another 4-6 months, until we hit the next inevitable bog.

You essentially just put a brand new V6 engine inside of an old clunker.
Mar 27, 2011 2:30 AM

Offline
Nov 2010
277
thanks to all staff members!

Mar 27, 2011 2:33 AM

Offline
Sep 2009
924
there's still hope lol
Mar 27, 2011 2:40 AM

Offline
May 2008
3861
This is great! Thanks Xinil :D
Mar 27, 2011 2:42 AM

Offline
Oct 2008
2949
Thanks a lot!
It was bothering me to find posts from 12 hours before lol but now it's brilliant!
Mar 27, 2011 5:40 AM

Offline
Apr 2010
9538
Thanks for the update the site performance has improved allot because of it.

The search function for the forum not working is something i can live with it might be a bit bothersome at times but that the Myanimelist is running perfect again is great.
Mar 27, 2011 7:31 AM
Offline
Aug 2007
152
Thank you so much! Keep up the good work!

Mar 27, 2011 8:07 AM

Offline
Aug 2008
1595
Thank you for the fix! My anime stats are in your debt :D
Mar 27, 2011 8:24 AM

Offline
Nov 2010
26
GREAT!!! no more lag...

bye-bye...
Mar 27, 2011 9:26 AM

Offline
Aug 2009
538
Thank you so much for fixing the lag! Everything runs so smoothly now, it's so much better! Thank you! :)
Mar 27, 2011 9:52 AM
Offline
Sep 2007
145
Don't know if anyone else is having this problem. I just updated one of the shows I'm watching. I'm currently at episode 20 but for some reason, it says watching at - of -. :/ Another thing I'm having issues with is MAL logging me out suddenly even though I've checked the keep me logged in button. Not to mention, some of my posts mysteriously disappear. MAL is just super buggy atm.
Mar 27, 2011 11:53 AM

Offline
Oct 2008
930
@Xinil

Thanks! The only complaint I had about the site was the slow updating of the forums and profile preferences. Thanks for the update and the fixes!
Mar 27, 2011 5:01 PM
Offline
Jan 2009
1426
Thanks for all the hard work you've been putting in!
This topic has been locked and is no longer available for discussion.
Pages (7) « 1 [2] 3 4 » ... Last »

More topics from this board

» [Challenge] You Should Read This Manga 2024 ( 1 2 3 4 5 )

Kineta - Feb 23

208 by hawkpelt5 »»
3 hours ago

» Try MAL's New Mobile Site! ( 1 2 3 4 5 ... Last Page )

Xinil - Feb 15, 2015

423 by RED-clover12 »»
Apr 24, 10:19 AM

» Planned 5hr Maintenance, Thursday April 25 @ 1am-6am PT

Kineta - Apr 22

0 by Kineta »»
Apr 22, 8:10 PM

» New Site Update: Peak Anime 🗻 ( 1 2 3 4 5 )

Kineta - Mar 31

213 by Lancelot73 »»
Apr 21, 4:28 AM

» Heavenly Easter Delusion: Devil and Dolce ( 1 2 3 4 5 ... Last Page )

Kineta - Mar 27

3331 by Terra_strong »»
Apr 17, 8:26 PM
It’s time to ditch the text file.
Keep track of your anime easily by creating your own list.
Sign Up Login