Pink Poogle Toy Forum

The official community of Pink Poogle Toy		 Main Site
NeoDex
It is currently Sun Oct 06, 2024 12:28 pm

View unanswered posts | View active topics


Board index » Pink Poogle Toy » Forum Discussion

All times are UTC




Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 
  Previous topic | Next topic 
Author Message
Blue
 Post subject: mySQL System Tweaks
PostPosted: Tue Aug 13, 2024 10:02 pm 
Administrator
Administrator
User avatar

Posts: 8209
Joined: Fri Jun 09, 2006 6:53 pm
Location: Out there somewhere... or is it here?
Favorite Cheese: Mozzerella String Cheese
With the increasing number of SQL errors visiting the pages, such as "SQL server went away", "table marked as crashed", etc. I tweaked a few settings a few minutes ago.

Ideally, things will start running faster and smoother with less hiccups. But, perhaps not.

Feel free to post under this topic to let me know what you are seeing.

ETA: After just an hour or so after making a few tweaks to the setup, the CPU load of MySQL is phenomenally lower. 8)

Image
Top
 Profile  
 
Siniri
 Post subject: Re: mySQL System Tweaks
PostPosted: Wed Aug 14, 2024 12:51 pm 
Way Beyond Godly
Way Beyond Godly
User avatar

Posts: 8778
Joined: Sat Apr 22, 2006 2:32 pm
Location: Georgia
Gender: Female
I haven't had any SQL issues since you tweaked this, and the site seems to be loading faster. Thanks, Blue!

Image
Blue graffitied on my signature... But it made me laugh, so it's all good!
Top
 Profile  
 
Pickles
 Post subject: Re: mySQL System Tweaks
PostPosted: Wed Aug 14, 2024 4:05 pm 
Honorary Member
Honorary Member
User avatar

Posts: 8709
Joined: Tue Mar 13, 2007 6:46 am
Location: Dodging Giant Ice-Cream Scoops
Gender: Female
Ditto here!

Image
Set by KiTeNcHeTu!
Find me at WGF, where werewolf rocks!
Top
 Profile  
 
Blue
 Post subject: Re: mySQL System Tweaks
PostPosted: Mon Sep 30, 2024 9:06 pm 
Administrator
Administrator
User avatar

Posts: 8209
Joined: Fri Jun 09, 2006 6:53 pm
Location: Out there somewhere... or is it here?
Favorite Cheese: Mozzerella String Cheese
Wed Aug 14, 2024 1:03 pm
Thanks! The CPU load for mysql has continued to be substantially lower since the tweaks. Now to fix a new issue (unrelated to the forums)

Wed Sep 25, 2024 4:51 p
Have been seeing increasing amounts of "SQL Server has gone away" Errors. Tweaked the max packet settings... We shall see if that helps.

ETA:
With the continued frequent "SQL ERROR [ mysql4 ] MySQL server has gone away [2006]" errors, I reverted back to April 2024 settings and then tweaked different things... Let's see how this goes.

Image
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 

Board index » Pink Poogle Toy » Forum Discussion

All times are UTC


Who is online

Users browsing this forum: No registered users and 101 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Switch to mobile style
cron
Powered by phpBB® Forum Software © phpBB Group