Pink Poogle Toy Forum

The official community of Pink Poogle Toy
Main Site
NeoDex
It is currently Thu Nov 07, 2024 10:46 am

All times are UTC




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: mySQL System Tweaks
PostPosted: Tue Aug 13, 2024 10:02 pm 
Administrator
Administrator
User avatar

Posts: 8284
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  
 
 Post subject: Re: mySQL System Tweaks
PostPosted: Wed Aug 14, 2024 12:51 pm 
Way Beyond Godly
Way Beyond Godly
User avatar

Posts: 8853
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  
 
 Post subject: Re: mySQL System Tweaks
PostPosted: Wed Aug 14, 2024 4:05 pm 
Honorary Member
Honorary Member
User avatar

Posts: 8761
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  
 
 Post subject: Re: mySQL System Tweaks
PostPosted: Mon Oct 14, 2024 7:27 pm 
Administrator
Administrator
User avatar

Posts: 8284
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.

ETA:
Seeing a lot more "table crashed" errors lately. Until I can figure out the cause, I added a system task to run my "fix it" script each hour to fix the top troublesome tables.... :roll:


Image


Top
 Profile  
 
 Post subject: Re: mySQL System Tweaks
PostPosted: Mon Oct 14, 2024 7:30 pm 
Way Beyond Godly
Way Beyond Godly
User avatar

Posts: 8853
Joined: Sat Apr 22, 2006 2:32 pm
Location: Georgia
Gender: Female
Thanks for keeping us up and running, Blue! This seems like a lot of tediousness to figure out. Hopefully it stops giving you trouble soon.


Image
Blue graffitied on my signature... But it made me laugh, so it's all good!


Top
 Profile  
 
 Post subject: Re: mySQL System Tweaks
PostPosted: Mon Oct 14, 2024 7:39 pm 
Administrator
Administrator
User avatar

Posts: 8284
Joined: Fri Jun 09, 2006 6:53 pm
Location: Out there somewhere... or is it here?
Favorite Cheese: Mozzerella String Cheese
My pleasure. Really.

It seems to be time to upgrade the server, operating system, etc. This will also mean a new version of PHP (on which most of the served sites work, including this here forum). I have hesitated, because the wonderful look and feel of PinkPT Forums might need to change since this specific theme is not so much supported on the newest version of the forum software. I did see someone had hacked/ported this specific theme to work... we shall see. I know I have done a ton of custom tweaks to the forum, some long enough ago that I have forgotten what they are. Meh. We shall persevere!


Image


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC


Who is online

Users browsing this forum: Bing [Bot] and 12 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:  
Powered by phpBB® Forum Software © phpBB Group