Jump to content


Photo

MTC Server Speed/performance Feedback


  • Please log in to reply
1099 replies to this topic

#1081 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 03 October 2019 - 08:56 PM

Increasing web server php-fpm capacity back to high levels... to catch peak viewership times...



#1082 Justiin13

Justiin13

    Lover

  • (06) Chronic Poster
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,017 posts
  • Location:Valenzuela

Posted 04 October 2019 - 09:29 AM

everything seems well! thanks for the fix



#1083 vinsanity23

vinsanity23

    Chaser

  • (04) Casual
  • PipPipPipPip
  • 52 posts
  • Gender:Male

Posted 04 October 2019 - 11:38 AM

Yes, I can confirm that it seems to be working fine now. Thanks for your help, babymaker!



#1084 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 05 October 2019 - 10:20 AM

Increased php-fpm children to 340

let's see this baby fly.



#1085 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 07 October 2019 - 10:00 AM

Added more RAM to the VM, was swapping.  High load.



#1086 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 07 October 2019 - 08:57 PM

Made optimizations in the logs.



#1087 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 07 October 2019 - 11:06 PM

Made adjustments to the nginx timeouts.

 

Also to buffer sizes.



#1088 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 15 October 2019 - 03:06 AM

Moved this virtual machine to a new dedicated server.

Faster, more cpus, more memory.

Let's see and wait for it to stabilize and be optimized.

 

------

 

higher max connections

Increased php-fpm children to 440



#1089 shadow_lord_supreme

shadow_lord_supreme

    Cutie

  • (05) Regular
  • PipPipPipPipPipPip
  • 255 posts
  • Gender:Male
  • Interests:Living life to the fullest

Posted 23 October 2019 - 01:05 PM

Hello!

 

Have been encountering "internal server error 500" more times than usual the past 4 - 5 days, especially in the hours between 4:00 AM - 6:00 AM...

 

I hope all is well with the system...

 

Thank you...



#1090 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 24 October 2019 - 08:24 AM

Hello!

 

Have been encountering "internal server error 500" more times than usual the past 4 - 5 days, especially in the hours between 4:00 AM - 6:00 AM...

 

I hope all is well with the system...

 

Thank you...

 

Database backup times.

Will hope to eliminate that soon in the next server upgrade with new technology.

 

https://royal.pingdom.com/zfs-backup/

 

-------

 

Adjusted nginx for max connections 5000


Edited by babymaker, 24 October 2019 - 08:57 AM.


#1091 shadow_lord_supreme

shadow_lord_supreme

    Cutie

  • (05) Regular
  • PipPipPipPipPipPip
  • 255 posts
  • Gender:Male
  • Interests:Living life to the fullest

Posted 24 October 2019 - 01:08 PM

 

Database backup times.

Will hope to eliminate that soon in the next server upgrade with new technology.

 

https://royal.pingdom.com/zfs-backup/

 

-------

 

Adjusted nginx for max connections 5000

I see . . . Thank you very much for the info . . .



#1092 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 29 October 2019 - 12:30 PM

New database server... we might revert to the old one.

Testing to see if this will stabilize.



#1093 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 29 October 2019 - 03:05 PM

Converted some tables to innodb.

Was always waiting for lock.



#1094 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 30 October 2019 - 09:13 AM

Sorted message posts to innodb.

Sorry for the long wait.

There will be a last myisamdb that will be converted to innodb.



#1095 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 30 October 2019 - 02:35 PM

Converted mtc_message_topic_user_map to innodb

 

this is seen waiting for table locks



#1096 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 30 October 2019 - 02:58 PM

Added more cpus and more memory

and assigned more memory to innodb



#1097 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 30 October 2019 - 08:06 PM

mtc_reputation_index converted to innodb.

hopefully less waiting for table locks



#1098 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 30 October 2019 - 10:28 PM

Less memory for MyISAM 4G

More memory for Innodb 14G



#1099 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 31 October 2019 - 02:00 AM

mtc_attachments converted to innodb


Edited by babymaker, 31 October 2019 - 02:19 AM.


#1100 babymaker

babymaker

    ProLife

  • (11) Wyld
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 1,824 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 01 November 2019 - 07:13 AM

converted mtc_reputation_totals to innodb.

lots of waiting for table locks eliminated.






1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users