The Energon Pub

News Credits: 10 · by **Agamemnon** » Fri Oct 16, 2015 11:53 am

Seibertron wrote:
fenrir72 wrote:Question of the ignorant, this was due to hardware failure of the server?

I don't think so. The server seibertron.com is on is pretty good. This is the longest we've ever been on 1 server before, which I think is due to it being a raid server.

I'm pretty sure this is ultimately just related to the database. To be honest though, I think I'm at the end of my abilities as an amateur server administrator. I know enough to be dangerous, enough to fix problems and enough to run Seibertron.com on a dedicated server for the past 13 years, but I'm not a database administrator. There's no silver bullet to fix the MySQL settings but I'm out of ideas. The database is still has an extreme amount of CPU usage but I'm out of ideas because it seems like nothing I'm changing is solving the problem. If anyone out there is a DBA, I'd love to talk about some suggestions and/or solutions!

I know I've mentioned my IT Background previously, but it is mostly in infrastructure admin/support, so I am limited in DB, and most of my knowledge comes from SQL, not PHP/MySQL. (I have some second hand anecdotes from that realm, but they are dated....like ten years dated.)

The only advice I could offer right now is basic DB admin. Does MySQL offer database defragmentation? In SQL, I believe the DB has to be taken offline during this process. The DBAs I know usually find an off-peak window monthly (or even weekly for one of my larger companies) to do this maintenance task. This could be of help, if you didn't already know about it. (If you do, sorry for the redundancy as I did not want to assume knowledge level.) Also, are you running the DB on a single server with RAID? A public or private cloud option might be a possibility which would offer some redundancy in clustering with fail-over. But this could transition the cost from a single capital expense (the cost of the server setup) to a subscription based cost with a monthly fee.

When I have some free time I'll see if I can reach out to some friends who have a bit more MySQL experience to ask some of these basic questions. From a hardware guy perspective, I suspect the high CPU use has to do with the size of the DB and number of records to maintain. But, that is just a suspicion.

Happy admining! :-D

News Credits: 100 · by **-Kanrabat-** » Wed Oct 21, 2015 7:06 pm

The Kremzeek dance party will go on for how long?
:KREMZEEK:

News Credits: 226 · by **Burn** » Wed Oct 21, 2015 7:14 pm

Agamemnon wrote:
Seibertron wrote:
fenrir72 wrote:Question of the ignorant, this was due to hardware failure of the server?

I don't think so. The server seibertron.com is on is pretty good. This is the longest we've ever been on 1 server before, which I think is due to it being a raid server.

I'm pretty sure this is ultimately just related to the database. To be honest though, I think I'm at the end of my abilities as an amateur server administrator. I know enough to be dangerous, enough to fix problems and enough to run Seibertron.com on a dedicated server for the past 13 years, but I'm not a database administrator. There's no silver bullet to fix the MySQL settings but I'm out of ideas. The database is still has an extreme amount of CPU usage but I'm out of ideas because it seems like nothing I'm changing is solving the problem. If anyone out there is a DBA, I'd love to talk about some suggestions and/or solutions!

I know I've mentioned my IT Background previously, but it is mostly in infrastructure admin/support, so I am limited in DB, and most of my knowledge comes from SQL, not PHP/MySQL. (I have some second hand anecdotes from that realm, but they are dated....like ten years dated.)

The only advice I could offer right now is basic DB admin. Does MySQL offer database defragmentation? In SQL, I believe the DB has to be taken offline during this process. The DBAs I know usually find an off-peak window monthly (or even weekly for one of my larger companies) to do this maintenance task. This could be of help, if you didn't already know about it. (If you do, sorry for the redundancy as I did not want to assume knowledge level.) Also, are you running the DB on a single server with RAID? A public or private cloud option might be a possibility which would offer some redundancy in clustering with fail-over. But this could transition the cost from a single capital expense (the cost of the server setup) to a subscription based cost with a monthly fee.

When I have some free time I'll see if I can reach out to some friends who have a bit more MySQL experience to ask some of these basic questions. From a hardware guy perspective, I suspect the high CPU use has to do with the size of the DB and number of records to maintain. But, that is just a suspicion.

Happy admining!

I've had the high CPU usage problem here at work. It was being caused by the Sophos SQL database which in turn was playing havoc with all the other SQL databases (which our main piece of software runs on) so much so the entire network was crashing.

Once I stop Sophos, it's all good.

News Credits: 3597 · by **Seibertron** » Wed Oct 21, 2015 9:29 pm

A ton of changes were made yesterday and today to various configuration files. Thanks to my brother-in-law for coming over to help me look through everything yesterday for about 10 hours or so. Spent probably another full day of working on changes to the server today. Seems to be working much better after the past two days. Hopefully things are OK for the time being. Fingers crossed!

Also made a new error page for when the database doesn't connect properly instead of the scraplets error message. Something a little more visual for those dreaded moments.

http://www.seibertron.com/errors/kremzeek.php

News Credits: 1642 · by **D-Maximal_Primal** » Wed Oct 21, 2015 9:32 pm

Seibertron wrote:A ton of changes were made yesterday and today to various configuration files. Thanks to my brother-in-law for coming over to help me look through everything yesterday for about 10 hours or so. Spent probably another full day of working on changes to the server today. Seems to be working much better after the past two days. Hopefully things are OK for the time being. Fingers crossed!

Also made a new error page for when the database doesn't connect properly instead of the scraplets error message. Something a little more visual for those dreaded moments.

http://www.seibertron.com/errors/kremzeek.php

We appreciate the creativity! :KREMZEEK:

News Credits: 3597 · by **Seibertron** » Thu Oct 22, 2015 2:48 pm

Aside from a brief slow down about 40 minutes ago that may have been addressed by yet another round of minor changes, how has the site's speed been today for you guys?

by **Riot Riverman** » Thu Oct 22, 2015 3:18 pm

Seibertron wrote:Aside from a brief slow down about 40 minutes ago that may have been addressed by yet another round of minor changes, how has the site's speed been today for you guys?

Speed looks good, but now my Norton toolbar suspects the site of phishing which has never happened before.

News Credits: 3597 · by **Seibertron** » Thu Oct 22, 2015 3:24 pm

Riot Riverman wrote:
Seibertron wrote:Aside from a brief slow down about 40 minutes ago that may have been addressed by yet another round of minor changes, how has the site's speed been today for you guys?

Speed looks good, but now my Norton toolbar suspects the site of phishing which has never happened before.

That's odd. Can you add Seibertron.com to a whitelist to keep norton from doing that?

by **Riot Riverman** » Thu Oct 22, 2015 3:55 pm

Seibertron wrote:
Riot Riverman wrote:
Seibertron wrote:Aside from a brief slow down about 40 minutes ago that may have been addressed by yet another round of minor changes, how has the site's speed been today for you guys?

Speed looks good, but now my Norton toolbar suspects the site of phishing which has never happened before.

That's odd. Can you add Seibertron.com to a whitelist to keep norton from doing that?

No list to speak of, but there is a review page at https://safeweb.norton.com/, a place for site owners: https://safeweb.norton.com/help/site_owners, and I can just click "go to page anyway" when it blocks the path.

News Credits: 41 · by **Cobotron** » Fri Oct 23, 2015 10:33 am

Hey Boss, I know you're busy.

A couple things I've noticed last night and this morning.
No e-mail notifications are going through.
Site is really sluggish.
And apparently the **** swear filters are on the fritz. :shock:

Hope you haven't pulled out all your hair.
Good luck.

News Credits: 3597 · by **Seibertron** » Fri Oct 23, 2015 11:02 am

****

News Credits: 3597 · by **Seibertron** » Fri Oct 23, 2015 11:03 am

**** ****

News Credits: 3597 · by **Seibertron** » Fri Oct 23, 2015 11:07 am

Cobotron wrote:Hey Boss, I know you're busy.

A couple things I've noticed last night and this morning.
No e-mail notifications are going through.
Site is really sluggish.
And apparently the **** swear filters are on the fritz.

Hope you haven't pulled out all your hair.
Good luck.

Thanks for keeping me posted about how things are going on your end.

I fixed the word censor filter (somehow they were lost along the way, but were restored from a backup I had locally).

Site speed should be all good for now. I have a larger post about that I'll make soon after keeping an eye on things. Let me know how it's working for you now.

I'll look into the email notifications not going through. I'm not sure what's causing that problem yet.

News Credits: 3597 · by **Seibertron** » Fri Oct 23, 2015 12:09 pm

Cobotron wrote:No e-mail notifications are going through.

Fixed! I had to reinstall the mail server along with a few other things. I've already been receiving notifications, hopefully you will receive this one from my reply. Thanks again for standing by and supporting Seibertron.com, Cobotron!

News Credits: 41 · by **Cobotron** » Fri Oct 23, 2015 1:39 pm

Seibertron wrote:
Cobotron wrote:No e-mail notifications are going through.

Fixed! I had to reinstall the mail server along with a few other things. I've already been receiving notifications, hopefully you will receive this one from my reply. Thanks again for standing by and supporting Seibertron.com, Cobotron!

Loud and clear!
And thanks for the edit on my OG post. I'd planned on cleaning that up once you'd seen it.

Keep it up. You're doing great!
Thanks

News Credits: 3597 · by **Seibertron** » Fri Oct 23, 2015 1:46 pm

Cobotron wrote:
Seibertron wrote:
Cobotron wrote:No e-mail notifications are going through.

Fixed! I had to reinstall the mail server along with a few other things. I've already been receiving notifications, hopefully you will receive this one from my reply. Thanks again for standing by and supporting Seibertron.com, Cobotron!
Loud and clear!
And thanks for the edit on my OG post. I'd planned on cleaning that up once you'd seen it.

Keep it up. You're doing great!
Thanks

I didn't need to clean up anything, my friend! phpBB does it all on its own.

News Credits: 3597 · by **Seibertron** » Fri Oct 23, 2015 1:48 pm

Now that the problem with phpBB is finally out of the way, I'm able to more clearly see what code of mine might need to be adjusted. How are the galleries loading for you guys now? Here's an example ...

http://www.seibertron.com/transformers-toys/gallery/exclusives/g2-starscream/3868/1/

News Credits: 1642 · by **D-Maximal_Primal** » Fri Oct 23, 2015 1:51 pm

Seibertron wrote:Now that the problem with phpBB is finally out of the way, I'm able to more clearly see what code of mine might need to be adjusted. How are the galleries loading for you guys now? Here's an example ...

http://www.seibertron.com/transformers-toys/gallery/exclusives/g2-starscream/3868/1/

Everything is going good as of this moment. All is loading at speed and no crashes yet

News Credits: 41 · by **Cobotron** » Fri Oct 23, 2015 1:59 pm

Seibertron wrote:I didn't need to clean up anything, my friend! phpBB does it all on its own.

Good! Now I can stop chasing down potty mouths. :lol:

And that gallery loaded faster than the speed a light.

News Credits: 3597 · by **Seibertron** » Fri Oct 23, 2015 5:20 pm

There still seems to be an issue with the forum sessions database table. I can't figure out what the problem is yet. Sorry I had to log all of you out. I had to clear out all of the sessions to sync up these two tables to eliminate that as an issue.

News Credits: 60 · by **fenrir72** » Fri Oct 23, 2015 9:30 pm

Just a heads up, kept getting an SQL error yesterday. And a post (which I reposted in the TAV again) didn't register. It had nothing controversial in it so I don't think it was a mod who deleted it, just a request for payment of an available product.

Maybe kremzeek is active again?

News Credits: 3597 · by **Seibertron** » Sat Oct 24, 2015 4:37 am

i **** hate all of these goddamn server problems!!!!!!!!!!!!!!!! i want my life back!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

News Credits: 100 · by **-Kanrabat-** » Sat Oct 24, 2015 6:36 am

Sigh... Here we go again. Not only lately I keep getting logged out, but I no longer receive notifications for threads anymore.

by **wilcosu35** » Sat Oct 24, 2015 6:59 am

Hadn't spotted this thread before. I've already sent a message, but i'll report it here too.
When i access the Toys Discussion forum, i won't be logged in and when i log in and access it, it will log me out.
I don't have this problem with the other forums i frequent (general, non-tf). When i access those pages from outside or inside Seibertron, i stay logged in