Jump to content


Photo

MTC Server Speed/performance Feedback


  • Please log in to reply
882 replies to this topic

#881 babymaker

babymaker

    ProLife

  • Admin
  • 1507 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
  • 1507 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
  • 1507 posts
  • Gender:Male
  • Location:NCR, Philippines
  • Interests:Doing good things.

Posted Today, 06:35 AM

Ok na.  Maayos na.  

Feedback please.

Starting today.

May 24, 2017.






1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users