I've been having problems with my database for 2 weeks now! What makes me mad is that Tera-byte.com won't solve the problem! Every time I send them an e-mail about my database problem, I get an e-mail back saying that they've restarted MySQL. Restarting MySQL won't solve the problem! The database will work fine after they've restarted it, but then a couple of hours later I'll have problems again.

I do NOT understand why Tera-byte.com has such a good reputation around here! Hope some of the guys at Tera-byte.com are reading this because this may be the only way that they will try to solve the problem!

What exactly is the problem, are you sure its terabyte's and not your scripts?

What exactly is the problem, are you sure its terabyte's and not your scripts?

I'm sure it's their problem. I use the command

if (!@mysql_connect("localhost","username","password"))
{
// can't get in!
}

to check if the database is accessible. Some times I get in, especially when they restart MySQL, but must time I don't get in!

Just noting that you can't connect to MySQL isn't horribly useful. You might want to log exactly why you can't get in.

That said, I'd bet money that if you're on a shared server you can't get in because of "too many connections". That means the other people on your server are hogging up all the MySQL connections.

If this is the case you can ask them to either 1) look into who is hogging the connections and disable them or 2) put you on another server with a lighter load. Another approach would be to change how you're doing things and keep around persistant connections. That'll depend on how you're using MySQL.

Ultimately however I don't think you can realiably use MySQL on a shared server. The reason is that it's pretty common for a host to put 200 or more accounts on a shared server. MySQL in it's default configuration can handle only 100 connections. Even if you bump up the number of connections it's too easy for 200 accounts to eat up the max. As far as I know, MySQL has no provisions to limit the number of connections by user.

If you really need MySQL for critical stuff I think you have to use at least a VPS. You might try to get a handfull of people to share a dedicated machine too.

If this is the case you can ask them to either 1) look into who is hogging the connections and disable them or 2) put you on another server with a lighter load. Another approach would be to change how you're doing things and keep around persistant connections. That'll depend on how you're using MySQL.

It's their job to look for a solution me, it's not up to me to suggest a solution!

By the way, they've just sent me an e-mail saying that I can get in now. I bet they've just restarted MySQL, so tomorrow I'll have to send them an e-mail AGAIN!

<<MOD EDIT:>>
Oooops! This isn't the Advertising/Offers Forum!
<</MOD EDIT>>

It's their job to look for a solution me, it's not up to me to suggest a solution!

They can only spend so much time finding a solution for you. If hosts spent 30 minutes fixing each problem nothing would ever get completed. When you sign up for hosting with anyone you have to realize there are going to be problems at one point or another that they may not be able to fix. I'd suggest to you that you listen to the other people have replied and try suggesting your own solution to Tera-Byte. It doesn't take more than a couple minutes of your time and can save you so much more from e-mailing back and forth for support.

It also helps a great deal if you specify what you're doing and what's going wrong and what you have tried to fixed it etc
in stead of just saying my database doesn't work, fix it.
tera-byte is not going to use your scripts to find out what's the problem.

Also, when you have problems, have you tried using other scripts to connect to the database. Big chance the script is just failing, there lots of scripts out there put together by someone who thinks he knows what he's doing.

Also, when you have problems, have you tried using other scripts to connect to the database. Big chance the script is just failing, there lots of scripts out there put together by someone who thinks he knows what he's doing.

Believe me, I know what I'm doing! It's not my script! Do you guys think I'm some kind of newbie or something? Why do you people keep defending Tera-byte.com? The problem lies at Tera-byte.com I tell you!

P.S. I received an e-mail from Tera-byte.com after I made this post. They said that I can connect to the database now. I tried and I was able to connect. Let's see how long that will last.

Originally posted by dektong
<<MOD EDIT:>>
Oooops! This isn't the Advertising/Offers Forum!
<</MOD EDIT>>

As I said, I have no way of emailing him/her ... So I told him if he would be interested to have shared hosting, please email me! What's so wrong with that? I can't just say 'please email me' then I offer him hosting (if he thinks I was going to help him, then this will be considered spam on behalf of me)! Tell me how I should email him, my dear Chicken! Dang, I am not even a webhost!

cheers,
:beer:

<<MOD NOTE:>>
If you would like to offer FREE hosting (I'm assuming) to a member, we can forward that offer to them. Note that the person did not ask for offers and that they have a problem with their host (a common posted topic), and he needs advice as to what the problem is, or what to do about it.
<</MOD NOTE>>

Originally posted by dektong


As I said, I have no way of emailing him/her ... So I told him if he would be interested to have shared hosting, please email me! What's so wrong with that? I can't just say 'please email me' then I offer him hosting (if he thinks I was going to help him, then this will be considered spam on behalf of me)! Tell me how I should email him, my dear Chicken! Dang, I am not even a webhost!

cheers,
:beer:

Hello dektong,

My personal thought of your case would be...

Did the thread starter ask people to offer web hosting?

If no, then you can't really offer whether you are a web host or not even if you email the thread starter... this would be considered SPAM also ;)

Don't throw stones at me... I am just speaking my mind :D

Regards,
Choon

What the hell is dektong talking about? Is he posting in the wrong thread again?

Originally posted by DeNasio


Believe me, I know what I'm doing! It's not my script! Do you guys think I'm some kind of newbie or something? Why do you people keep defending Tera-byte.com? The problem lies at Tera-byte.com I tell you!

P.S. I received an e-mail from Tera-byte.com after I made this post. They said that I can connect to the database now. I tried and I was able to connect. Let's see how long that will last.


Hi buddy, I understand your problem ,

Free PHP/MYSQL scripts out there like phpnuke , phorum etc. aren't designed good enough. Most of them generate persistent connection using this function

mysql_pconnect()

When someone other than you run this kind of script in shared hosting , a lot of mysql process will be generated and left in the server that couldn't be get rid of unless mysql was restarted. But after a restart it will happen a again. The problem from mysql_pconnect() is that it will prevent other user from generating new PHP connection. It's as worst as getting spammed.

What you have to do is check that this situation really occurs with you using this simple query.


<?
mysql_connect("host","user","pass");
echo "<table border=1>" ;
$result = mysql_query("SHOW PROCESSLIST");
while($fields=mysql_fetch_array($result)) {
echo "<tr>
<td>$fields[Id] </td>
<td>$fields[User] </td>
<td>$fields[Host] </td>
<td>$fields[Command] </td>
<td>$fields[Time] </td>
<td>$fields[State] </td>
<td>$fields[Info] </td>
</tr>";
}
echo "</table>";
?>


If there're many rows of Sleep process left for a long time , then this is Tera-byte failed action. You must point them to see this result and tell them to request all users who run persistent connection to modidy their php scripts by changing

mysql_pconnect() to mysql_connect()

This will solve all problem ,but if tera-byte still failed to listen to your request , just move to other host.