PDA

View Full Version : problem accessing my database on mysql09


johnny_o_neill
6-30-05, 01:42 PM
I was wondering if some could help me, I having a great deal of trouble accessing my database that is located on mysql09. I currently have two different database, the other one on mysql05 is working just fine. I recently added a script that access multiple tables in my database, but any of the scripts that were working before no longer work either. I also tried customizing my php.ini file, and i'm thinking that might be the problem. Here are the changes that i made to the php.ini file, i was just wondering if this would improve my sites preformance:

$contents .= "register_globals = Off \n";
$contents .= "session.save_path = /www/*/******/temp \n";
$contents .= "upload_tmp_dir = /www/*/*****/temp \n";
$contents .= "upload_max_filesize = 4M \n";
$contents .= "post_max_size = 10M \n";

I have since deleted the php.ini file from my directory. Here is the site i am talking about http://wrestling.johnny-o.net/ and the script is the bio.php script that you access by clicking on a wrestlers name. I would appreciate anyone's help, knowing me, i might have done something stupid :)

bidcore
6-30-05, 02:59 PM
I know what you mean, I am having the same problems on Server 08!

I keep getting this error

1030 - Got error 12 from storage engine

After looking it up, it seems to be the fault of the Host/Server, not of the customer.

Of course this means Powweb is log jamming its customers all onto the same servers. This doesnt seem to be a problem, and theyll tell you its not, except at peak times when many people are trying to access the same information/server space.

Please relieve us of this pain and order more server space. Thank you. Amen

johnny_o_neill
6-30-05, 03:17 PM
I acutally getting nothing, no messages what so ever, it's just not accessing the database. any script that calls for a retrieval from the database is returning nothing, as if the database was blank, but i know it's not, I can see it in PHPAdmin page on the powweb server. sometimes when i refresh the page it's displayed correctly sometimes i can't get anything at all.

mitchind
6-30-05, 03:23 PM
After looking it up, it seems to be the fault of the Host/Server, not of the customer.

Of course this means Powweb is log jamming its customers all onto the same servers.

The error comes from using up the memory allocated to the MySQL server - which, in that sense, is indeed a host error. But how do you take the giant leap from that to "jamming too many customers all on to the same servers"??? :confused:

It's most likely one or two customers that have poorly formed queries and are trying to retrieve all their data at once. While we're guessing .. I'd say it's even more likely some misguided soul is attempting a full backup or restore during peak hours.

Focus your anger in the right direction. For less than a $10 bill per month, it's hard to complain about the host - or even the odd misguided soul doing a primetime restore. :)