| We're going to be performing heavy database maintenance on all the MyAnimeList servers at 10am on June 7th. I wanted to give everyone a heads up as this will result in the entire site coming offline. Downtime is expected to last no more than an hour. We're trying to make things run smoother for everyone, and this is just one of the first steps of many we're taking to accomplish that goal. Thanks for understanding! Edit: I meant to put June 7th. Sorry! |
XinilJun 7, 2010 1:54 PM
| 10am was 2 and a half hours ago (pst). Do you mean 10pm? anyways, good luck, hopefully this'll help things out. |
 |
| i can't wait but it is almost 1pm PST so i'll just assume that you meant 10pm PST thanks for finally giving us an update |
 |
| Sounds good Xinil, take all the time you need man. We understand, and appreciate all the hard work you put into this site! :) |
| I, too, live in PST time, so maybe he did mean 10 pm? At least we're getting an update! |
| sounds like great news to me |
 I am a banana. |
| Translate that to Queen's TeaTime please. |
"I'm starting to think mal is run by Xinil generating electricity on a bicycle." - idklol |
| Well GMT is around 7 hours ahead of PST. So 10pm PST June 6th should be around 6am June 7th in London. |
 |
| Good news! The lag is annoying. |
| Hopefully this will fix all the problems we've been having recently. |
| what problems? |
 |
| Thanks for notice. |
 |
| I'm sure users won't mind if it fixes many problems. :) |
| Oops. I meant June 7th, Monday. Sorry for the mix up everyone. |
| Sounds good to me =) |
 |
| >10 am This time exists? What is this "10 am"?! (Thanks for the heads up as usual~) |
| Alright then good thing to know. |
 |
| thx bro. |
| GMT please...-_- |
"Your taste is shit cause you like what I hate. Believe me I have 1000 cartoons that I rated with less than 5."  |
Cashdaxxx said: GMT please...-_- PST is GMT -8. |
    |
Avarice said: Cashdaxxx said: GMT please...-_- PST is GMT -8. then what will be the time if it would be +8?? 10pm?? |
| "Your taste is shit cause you like what I hate. Believe me I have 1000 cartoons that I rated with less than 5." |
Cashdaxxx said: Avarice said: Cashdaxxx said: GMT please...-_- PST is GMT -8. then what will be the time if it would be +8?? 10pm?? That will be an additional 15 hours to Xinil's timezone: June 8th, 1 AM in your timezone. Edit: I forgot to take into account Daylight saving time, so it's 15 hours, not 16. |
avrcJun 6, 2010 11:39 PM
|
Cashdaxxx said: 5pm GMTGMT please...-_- PST is at GMT-7 atm |
I am a banana. |
| Thanks for the notice... |
 Member Card Collectors (M.C.C.) Badge ❤~ Voting Stadium ~❤ 5 Centimeters Per Second Badge |
saka said: Of course, we are currently on BST, and BST is GMT +1, so it's actually 6pm, not 5pm for us Brits, hence why I can post this message right now.Cashdaxxx said: 5pm GMTGMT please...-_- PST is at GMT-7 atm |
Current FAL Ranking + Previous best::  [ |
| Here's to hoping that less posts will be eaten up and the lag will be somewhat fixed. |
| The maintenance is over, but that annoying glitch which means you can't see the bottom of a database entry unless you refresh a lot is still there. Let's hope the lag is fixed at least. EDIIT: (21:04 BST) Sigh... There's still lag here. MAL seems to be lagging by about 4 minutes at the moment. Hopefully it won't be too bad. Better luck next time, Xinil. |
Rosa_FOEtidaJun 7, 2010 1:06 PM
| Current FAL Ranking + Previous best:: [ |
| Yeah, Uh "Forums Recent Posts | My Watched Topics | My Ignored Topics | Search There was a MySQL Error. The staff has been notified and is looking in to it. We apologize for the inconvenience. Query ID: 1038 There was a MySQL Error. The staff has been notified and is looking in to it. We apologize for the inconvenience. Query ID: 1039 General Discussion MyAnimeList.net Forum »» General Discussion There was a MySQL Error. The staff has been notified and is looking in to it. We apologize for the inconvenience. Query ID: 1040 Create New Topic | Ignore Board Pages (221) [1] 2 3 » ... Last » There was a MySQL Error. The staff has been notified and is looking in to it. We apologize for the inconvenience. Query ID: 1011 Topic Replies Last Post No posts for this board were found" Cool. and I also just had to fix 65** messages in my inbox Maybe something else was fixed or this is one change of many. |
Xinil said: We're trying to make things run smoother for everyone, and this is just one of the first step of many we're taking to accomplish that goal. I wonder what that one thing was fixed and what other steps are left.. |
| Honestly.. It was better before this maintenance. |
 |
Alipio said: Xinil said: We're trying to make things run smoother for everyone, and this is just one of the first step of many we're taking to accomplish that goal. I wonder what that one thing was fixed and what other steps are left.. I second this. |
| I knew that the maintenance happened.. but did anything actually change or get maintenanced? o.o Because I really didn't notice a different and I'm usually lurking on MAL most of the time. >.> |
Life is really simple, but we insist on making it complicated.~ |
| Someone list the changes on this maintenance... |
| "Your taste is shit cause you like what I hate. Believe me I have 1000 cartoons that I rated with less than 5." |
Cashdaxxx said: afaik they only work on optimizing the database replication.... so there should be very little noticable... except that you'll have less database and editing errors.Someone list the changes on this maintenance... however it still isn't perfect, as I still need to refresh my signature settings twice before they register. It does feel a little snappier though... maybe they just added another server and didn't change the replication much. |
I am a banana. |
| We just pushed online a 4th database server. Let's cross our fingers for performance increase! |
Xinil said: *fingers crossed*We just pushed online a 4th database server. Let's cross our fingers for performance increase! |
 |
aero said: Xinil said: *fingers crossed*We just pushed online a 4th database server. Let's cross our fingers for performance increase! |
Xinil said: *prays for hope*We just pushed online a 4th database server. Let's cross our fingers for performance increase! |
 |
| Well, I think there has been a performance increase, but it doesn't solve the issue. In fact, you're more likely to get 'bad id' and non-existent posts now since you only have a 1/4 chance instead of a 1/3 chance of getting the same server you posted to.... it's a race condition whether your post replicates to the other servers before your next request. I think use of sessions would fix it though. |
I am a banana. |
The data apart from "Currently Watching/Reading" is coming back sometime right? |
 |
| I hadn't seen this and was like: Oh my god, what's going on?! o.O xD EDIT: Oops, seems that I'm wrong... |
SisseltongJul 8, 2010 5:45 AM
†     |
| cool that it's getting maintenced, but it's July, not June. |
 |
animedark said: cool that it's getting maintenced, but it's July, not June. That's because the maintenance was on the 7th June, that wasn't a typo. |
Music is about enjoying sound~
saka said: I'm pretty sure Xenil has it setup so there's one write master and the other 3 are read slaves. That's the most efficient scaling option for the current setup that I can guess with out further knowledge. The reason for this is because there's usually very very little writes, compared to reads (particularly for a site like this). Well, I think there has been a performance increase, but it doesn't solve the issue. In fact, you're more likely to get 'bad id' and non-existent posts now since you only have a 1/4 chance instead of a 1/3 chance of getting the same server you posted to.... it's a race condition whether your post replicates to the other servers before your next request. I think use of sessions would fix it though. However it does seem you have the entire site on these 4 databases. While I can't say for sure, I'm somehow speculating that it would probably be better if the major bottlenecks are split between two or more server groups, instead of shared between all 4. As I see it adding a extra server in a setup is where everything is fully shared, criples caching more, requires more resources for sharing data, while offering very little in return. Doubt you'll get any speed increase unless the previous servers were close to breaking point. |
 |
| I see that the server is faster than before... but can I know when the "My Messages" will be active again? D: |
  |
| For fuck's sake why is it so difficult to have a functioning forum and database? What century are we living in? This must be the only forum on the entire internet that doesn't bloody work properly. I don't mind maintenance down time but what's the point if nothing is fixed when we're back up again!? Just leave the site down otherwise MAL will lose all its users, they're already migrating to other sites as I type. |
"I'm starting to think mal is run by Xinil generating electricity on a bicycle." - idklol |
WingedWolf24 said: but can I know when the "My Messages" will be active again? D: yeah, me too... I hate when my mail box is broken... :/ |
    |
More topics from this board
» [Challenge] You Should Read This Manga 2024 ( 1 2 3 4 5 )Kineta - Feb 23 |
201 |
by EverySportsAnime
»»
8 hours ago |
|
» New Site Update: Peak Anime 🗻 ( 1 2 3 4 5 )Kineta - Mar 31 |
213 |
by Destinesia
»»
10 hours ago |
|
» Heavenly Easter Delusion: Devil and Dolce ( 1 2 3 4 5 ... Last Page )Kineta - Mar 27 |
3340 |
by Terra_strong
»»
Apr 17, 8:26 PM |
|
» MAL Game "Fantasy Anime League" Opens for Spring 2024 ( 1 2 3 )Kineta - Mar 17 |
144 |
by The_real_maomao
»»
Apr 9, 4:26 PM |
|
» English Titles Added to Desktop; Moving Towards a Romanized/English Toggle ( 1 2 3 )Kineta - Feb 12, 2020 |
121 |
by Vaturna
»»
Apr 4, 5:31 AM |