Jump to content


Photo

MTC Server Speed/performance Feedback


  • Please log in to reply
891 replies to this topic

#881 babymaker

babymaker

    ProLife

  • Admin
  • 1511 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 22 May 2017 - 11:01 PM

Made enormous tweaks.

Then discovered a database table corruption.

Fixed it.

Stopped using persistent connections.

Saw a lot of table locking waits.

Lowered query cache size to minimize on waiting for table locks.

 

Let's see if the performance is now consistently fast.



#882 babymaker

babymaker

    ProLife

  • Admin
  • 1511 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 22 May 2017 - 11:58 PM

After optimizing and fixing the database...

 

...I am now observing long table locks.

This is a myisam table limitation.

Looks like we will have to convert to innodb if we are to solve this limitation.



#883 babymaker

babymaker

    ProLife

  • Admin
  • 1511 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 24 May 2017 - 06:35 AM

Ok na.  Maayos na.  

Feedback please.

Starting today.

May 24, 2017.



#884 kelotz

kelotz

    He Missed By A Mile

  • (05) Regular
  • PipPipPipPipPipPipPipPipPipPipPip
  • 716 posts
  • Gender:Male

Posted 25 May 2017 - 01:56 AM

so far so gooooooooooood @babymaker ;-)



#885 Lorca

Lorca

    Captain

  • Prime Mover
  • 10503 posts
  • Gender:Male

Posted 25 May 2017 - 05:14 PM

madulas na madulas, EDWIN! smmooootthhh.



#886 FleurDeLune

FleurDeLune

    Jedi Haijin

  • Moderator
  • 3944 posts
  • Gender:Female
  • Location:Land of Nod

Posted 26 May 2017 - 07:15 PM

FYI This occurs for the nth time already today. Please check. Thanks.

 

SQL Error
An error occured with the SQL server:

 

This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above.

← Return to the index

 



#887 babymaker

babymaker

    ProLife

  • Admin
  • 1511 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted 28 May 2017 - 06:33 AM

The 3-4am backup?

What time?

What were you doing?

Is it still happening now?



#888 FleurDeLune

FleurDeLune

    Jedi Haijin

  • Moderator
  • 3944 posts
  • Gender:Female
  • Location:Land of Nod

Posted 28 May 2017 - 09:17 AM

Daytime.

 

Nearly 10 times.

 

Moderating.

 

Not at the moment yet. 



#889 FleurDeLune

FleurDeLune

    Jedi Haijin

  • Moderator
  • 3944 posts
  • Gender:Female
  • Location:Land of Nod

Posted 29 May 2017 - 09:22 AM

I've experienced that again around 1 am today.



#890 jacuzzi

jacuzzi

    Wanton

  • (05) Regular
  • PipPipPipPipPipPipPipPipPipPipPip
  • 753 posts

Posted 29 May 2017 - 10:47 AM

Is MTC complying with the more secure https service? New browser updates are now implementing warning nags for sites that are not yet https compliant.



#891 kelotz

kelotz

    He Missed By A Mile

  • (05) Regular
  • PipPipPipPipPipPipPipPipPipPipPip
  • 716 posts
  • Gender:Male

Posted 28 July 2017 - 11:01 PM

IPS Community Suite 4.2.1
Released 07/26/2017


#892 alvin1232

alvin1232

    Devirginized

  • (02) Sinless
  • PipPip
  • 17 posts
  • Gender:Male

Posted 05 November 2017 - 11:28 PM

Twice ko na encounter yung sql error this month




2 user(s) are reading this topic

0 members, 2 guests, 0 anonymous users