Dowly's missing token

Onkel Neal · 02-03-10, 12:30 AM

I know, but I am having ZERO luck finding an SQL technician to hire.

danlisa · 02-03-10, 04:07 AM

Quote:

Originally Posted by Neal Stevens

I know, but I am having ZERO luck finding an SQL technician to hire.

Ohh, can't really help there.

I suspect your technicians have already suggested the following but it's worth saying it.

As the crashes are (nearly) daily and at the same time, it has to be a scheduled task. Either a Db backup job or a Log Flush, which incidentally has caused similar problems with many SQL Db in the past.

I'm not sure of the platform OS this is all running on but if we assume that the crashes occur @ 10am GMT, that should be 3am US. That is the normal time for OS automatic updates.

I know next to nothing about SQL coding etc but I do know that 'experts' will always look for the hardest and most in depth issues possible, as if trying to prove their e-manliness.

They never check the obvious.

Onkel Neal · 02-03-10, 09:29 AM

Yes, my thinking too:

Quote:

Originally Posted by server techs

We checked the logs, and found that the logs are missing between 7.00 AM and 7.50AM. But the cron set for running mysql backup seems to have got completed long before that. This indicates that the root cause of the server down was not backup, but something else.

Daily backups are good idea for MySQL databases. Especially if they are being updated constantly. The backup run at 4:00am CST, have you experienced any slow response times from the server around this time? If not, they are not stressing the server and you can leave it as it is.

I have modified the backups to occur weekly, so we shall see if the problem continues on the backup day.

Hitman · 02-03-10, 09:32 AM

Quote:

I am having ZERO luck finding an SQL technician to hire

So much for capitalism and the market solving all problems of supply and demand

Dowly · 02-03-10, 10:12 AM

Quote:

Originally Posted by Hitman

So much for capitalism and the market solving all problems of supply and demand

LMAO!

Onkel Neal · 02-03-10, 10:51 AM

Quote:

Originally Posted by Hitman

So much for capitalism and the market solving all problems of supply and demand

Haha! Yeah, or maybe the demander needs to get smarter about finding the supply

02-03-10, 12:30 AM	#1
Onkel Neal Born to Run Silent Join Date: Jan 1997 Location: Cougar Trap, Texas Posts: 21,385 Downloads: 541 Uploads: 224	I know, but I am having ZERO luck finding an SQL technician to hire. __________________ SUBSIM - 26 Years on the Web