Jump to content


Photo

MTC Server Speed/performance Feedback


  • Please log in to reply
933 replies to this topic

#881 babymaker

babymaker

    ProLife

  • Admin
  • 1534 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
  • 1534 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
  • 1534 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
  • 720 posts
  • Gender:Male

Posted 25 May 2017 - 01:56 AM

so far so gooooooooooood @babymaker ;-)



#885 Mark Santos

Mark Santos

    Bizman

  • Prime Mover
  • 10539 posts
  • Gender:Male

Posted 25 May 2017 - 05:14 PM

madulas na madulas, EDWIN! smmooootthhh.



#886 FleurDeLune

FleurDeLune

    Chienne Počte

  • Moderator
  • 4374 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
  • 1534 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

    Chienne Počte

  • Moderator
  • 4374 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

    Chienne Počte

  • Moderator
  • 4374 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
  • 755 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
  • 720 posts
  • Gender:Male

Posted 28 July 2017 - 11:01 PM

IPS Community Suite 4.2.1
Released 07/26/2017


#892 alvin1232

alvin1232

    Devirginized

  • (04) Casual
  • PipPip
  • 21 posts
  • Gender:Male

Posted 05 November 2017 - 11:28 PM

Twice ko na encounter yung sql error this month

#893 babymaker

babymaker

    ProLife

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

Posted 26 February 2018 - 05:33 PM

Testing the file upload problem.

 

Attached Files



#894 Stephen A.

Stephen A.

    God of Lust

  • (14) Tera Poster
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 15422 posts
  • Gender:Male
  • Location:Cavite

Posted 28 February 2018 - 08:48 AM

There are times that I cannot upload pictures.

#895 babymaker

babymaker

    ProLife

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

Posted 13 March 2018 - 11:25 AM

Let's' try uploading pics

 

Attached Files



#896 babymaker

babymaker

    ProLife

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

Posted 13 March 2018 - 10:40 PM

Uploading now fixed.

We ran out of space.

Added 200 GB of disk space for uploads.



#897 FleurDeLune

FleurDeLune

    Chienne Počte

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

Posted 14 March 2018 - 10:27 AM

Yes, it's working now. 



#898 Barenaked-NoMre

Barenaked-NoMre

    Authentic N Amazing

  • (12) Mega Poster
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 8397 posts
  • Gender:Female
  • Location:Manila, Philippines
  • Interests:GREAT books, movies, food and REFRESHING drinks

    smart, funny and down-to-earth people ... ESPECIALLY the MEN who are VERY NAUGHTY! ;)

Posted 17 March 2018 - 04:42 PM

Just HAD to post ... regarding "uploading of files".

 

Back to normal. Much appreciated ... from not just moi, but the rest of those who have encountered such or CUM-plained about it.

 

 

Attached Files



#899 SiPrinceAli

SiPrinceAli

    Teitoku dōri!

  • (05) Regular
  • PipPipPipPipPipPipPip
  • 320 posts
  • Gender:Male
  • Location:Urbs Manilensis
  • Interests:I'm a man of taste, and I'll be damned if I'm not working to get the wealth part.

Posted 19 March 2018 - 04:16 PM

Testing the search function using my own username, and I've been having this for some time now.

 

Is that normal?

 

Also, I'm refreshing to rule out other issues.

Attached Files



#900 babymaker

babymaker

    ProLife

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

Posted 09 April 2018 - 10:49 AM

That is weird. 

When I search for my username it comes out somewhat like that.

Must be a program bug.

Searching for other things is fine.






3 user(s) are reading this topic

0 members, 3 guests, 0 anonymous users