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!