Disappearing Databases (Now you see them, now you don't!)

[Riverside]

I'm in developing stages of a Joomla-based site.

About an hour ago, my databases vanished. What I mean by this is that suddenly I could not open my home page at all, then eventually got a Joomla messages stating that Joomla couldn't find the databases. I opened MySql and sure enough, they weren't there either.

This is the second time this has happened in a week, and the first time after about twenty minutes or so, they magically reappeared, so I didn't panic. They did reappear this time as well.

I don't remember what I was doing the first time it happened, but this time I was testing a Joomla component called Zoom Gallery. I was trying to upload image files and the uploads were failing repeatedly (a problem I will address on ZG's forum). While poking around Cpanel I accidentally stumbled onto some error report I've never seen before and noticed repeated errors related to the operation I was trying to get working. Date and time of the errors was just before the databases vanished.

I'm betting that my databases disappearing is something I ought to be concerned about. I'm not talking in terms of my site's reliability. My site is only in testing mode right now, and I will get the problem solved before it goes live, or it won't go live.

My real concern right now is that some of the testing I'm doing is pretty intensive, and I'm somewhat concerned about overtaxing the server. I've already read in several places on this forum that that isn't a place I want to go with HM.

I already know that Open Source can cause a lot of errors and sometimes send never ending tasks to the CPU.

So my question is, has anyone else ever had their databases play hide-and-seek?

What other kinds of things can cause this? Are any of the things that cause this things that might cause serious resource overload?

I'm not overly concerned with site uptime reliability yet. As I said, I'm in testing and expect to see strange things but I would like to know if this is an indication of a serious problem that could get me shut down.

What d'y'all think?:cool:

[sjlplat]

I would talk to support and ask them about the status of the MySQL server anytime this occurs. Check your running processes as well, to verify that you aren't running too many services simultaneously.

[Riverside]

I would talk to support and ask them about the status of the MySQL server anytime this occurs. Check your running processes as well, to verify that you aren't running too many services simultaneously.

Thanks sjlplat, but now many is "too many?"

I will talk to support if it happens again. The last time it happened was after repeated attempts to upload some images through the front end of a Joomla component there is a problem with configuration, and the uploads kept failing and logging me out of the site.

I think it may have been causing some sort of wacked requests and denials the server didn't like. They did show in the error reports. Maybe I'll have them look at those reports.

[sjlplat]

I experienced problems when I ran about 15 services at once. I would suggest keeping it under 10.


Thanks sjlplat, but now many is "too many?"

I will talk to support if it happens again. The last time it happened was after repeated attempts to upload some images through the front end of a Joomla component there is a problem with configuration, and the uploads kept failing and logging me out of the site.

I think it may have been causing some sort of wacked requests and denials the server didn't like. They did show in the error reports. Maybe I'll have them look at those reports.