PROBLEM with MYSQL Etc

[mylifestyle]

Hi.

Whenever i post here it always seems to be about a problem. I really wish
that it did'nt have to be that way but there are some very important issues
which I need an answer or to be solved.......

MYSQL

SLOW .. reaction times to the DB's is like waiting for paint to dry. Even trying
to access thru the CPanel is almost impossible.

Please advise if there is any work going on at the moment to solve this ???
Thank you.

CRON JOBS

I had a previous thread abt Cron Jobs not working and requesting assistance
to ensure the commands were correct.

my Cron Jobs have now disappeard....[or] are they linked somehow to the
SQL DB's and unviewable ? [OR] Has someone from admin deleted them ???

I've been working on this site for just over a week now and I hope you can get
this resolved for me BEFORE the weekend which is the highest traffic days.

PLEASE can someone acknowledge and at least let me know these points are
being actioned.....

Thank you
ML

 

[mylifestyle]

More than 24 Hours since original posting above and still no reply.

I can't get into the PHPMyadmin/mysql and Cpanel is sooooo friggin slooooowwwwww.........

Quote:

Over the past 6 years we have honed our efforts and we're proud to offer our users all of the fantastic benefits of cPanel 11, our smart in-house account panel and our unique community support system. x10Hosting uses high-powered servers that allow us to deliver the very best speeds that free hosting has to offer while giving you access to the latest technology and top of the line features.

 

[Jarryd]

Hello,

I've checked into the MySQL server, its a little bit slow, but nothing out of the ordinary. If you're having issues with cPanel loading slow can you please provide a tracert to the server you're on.

As for the cron jobs, the only reason they'd get removed automatically is if you have any cron jobs running more than 1 cron job every 5 minutes.

We have a limit of 1 per 5 mins. All others will get removed.

 

[mylifestyle]

Hi Jarryd..

Thanks your reply. Please advise 'what is tracert' ???

My site is on Chopin and is i-m.exofire.net

as for the Cron Jobs they were for every 20 minutes so I don't understand why they
were deleted and WHO deleted them ?????

Thread : http://x10hosting.com/forums/free-hosting/142481-cron-job-verification.html

ML

 

[Brandon]

Hello,

Our crontab system is viewing " User crontab cleared - 1 cron execution allowed per 5 minute interval."

How many did you have running per 20 minutes?

 

[mylifestyle]

Hi.

I had two crons running........well, I say running.........cos if you look at the thread it did'nt seem to
me as if they were working and was looking for advice abt the command structure err /home/wotsit/thingy etc etc......

 

[masshuu]

IF any 2 crons run within 5 minutes of each other, one will get removed. It doesn't matter how often they run. Also cpanel may be slow when you first load it as it has to query the information, but afterwards it should speed up.

 

[Brandon]

Also to extend on what masshuu is saying,

If you need to run more than one cron within a 5 minute period, our prime membership removes this restriction.

http://x10hosting.com/prime-membership

And on the tracert, are you running Windows?

 

[mylifestyle]

Hi.

Yes I have windows XP

As for the upgraded hosting............well, what can I say. It looks attractive but
5 years??

Also is there cgi support?? That was removed along with access to my
mailing list when some idiot decided cgi was no longer available to us low lifes without
even sending an email in advance warning what was happening........

Is there also a seperate MYSQL server ???

[where is the full list of features?]

 

[Brandon]

Hello,

I think you are getting the Prime membership and Illuminated services mixed up.

Let me go over some things here first.

Prime Membership
- 3 Month Cost: $2.95
- 6 Month Cost: $3.95
- 1 Year Cost: $4.95
- Removes inactivity timer from forums (no login requirements)
- Allows crons every minute (as the problem your having above)
- Doubles your Specs (E-Mails, etc)
- Support Requests are highlighted
- Double Allowed CPU\Memory Resources
- Other fancy things that are listed here.

Now with the above package, x10 Prime Membership, your account will stay on the physical same server. All of the limits will be upped, and everything will continue to run other than those aspects brought above.

What you are looking at, x10 Illuminated, I will list some features below.
Illuminated Membership
- 5 Year cost of $45.
- Includes all features of above.
- You are put on a physical seperate server with less users.
- No remote MySQL server (Like the paid servers, MySQL is on the local server)
- PostgreSQL
- Allows CGI/Perl/Etc
- Higher PHP Memory Limit; less restrictive php in general.

And that's a one-time fee of $45, and that offer expires December 1st, were it will then be $60 for 5 years.

Full Feature List: http://x10hosting.com/free-hosting-comparison

I hope this clears up what I said to what you were bringing along to me, let me know if you have any further questions.

 

[mylifestyle]

Hi Brandon.

Thank you for all of that.....

I may just take you up on that offer. first though can u confirm exactly what a cron command should look like [see previous
reply above] and second I'm still have SQL connection probs [SLOW] probably coz it's remote right???? BUT, it never used to
be like that......it just seems to take an ice age before it connects. or does'nt.

You asked previously abt a TRACERT....wots that?? something to do with connection speed?? if so, then sould I be doing that
for the SQL server rather than Chopin....

[ignorance is bliss]

 

[Brandon]

Hello,

Proper Cron would be this.

20 * * * * /usr/bin/php -q /home/mylife/public_html/prizes/lottery.php

0 0,12 * * * /usr/bin/php -q /home/mylife/public_html/cron.ph

I think the fact of the MySQL is more of the fact that we have a lot of users running MySQL, etc, so you'll notice it be slower than on most sites. The illuminated package would fix this; as less people per server average overall.

We have everything setup in the background, so you only need to use localhost to connect to your database.

Finally, click Windows Logo Key + R, a "Run" dialog should come up. Type in "cmd", press enter, you'll get a command prompt. From there type in 'tracert i-m.exofire.net'; from there post the results in this dialog.

 

[mylifestyle]

Thank Brandon

Here are the results.............

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\ADMIN>tracert i-m.exofire.net

Tracing route to i-m.exofire.net [69.175.104.34]
over a maximum of 30 hops:

1 * * * Request timed out.
2 33 ms 33 ms 33 ms host-92-10-0-1.as43234.net [92.10.0.1]
3 57 ms 32 ms 31 ms 92.31.252.42
4 35 ms 34 ms 33 ms xe-11-2-0-scr002.log.as13285.net [78.144.2.131]

5 37 ms 35 ms 36 ms Opal-ge-2.2.0.mpr1.lhr2.above.net [213.161.78.20
9]
6 35 ms 35 ms 35 ms xe-4-2-0.mpr1.lhr1.uk.above.net [64.125.28.125]

7 35 ms 35 ms 35 ms xe-0-3-0.cr1.lhr1.uk.nlayer.net [195.66.224.37]

8 103 ms 103 ms 126 ms xe-2-2-0.cr1.nyc3.us.nlayer.net [69.22.142.9]
9 104 ms 103 ms 103 ms ae2-70g.cr1.ewr1.us.nlayer.net [69.31.95.145]
10 154 ms 129 ms 130 ms xe-3-0-0.cr1.ord1.us.nlayer.net [69.22.142.74]
11 129 ms 129 ms 129 ms ae0-30g.cr2.ord1.us.nlayer.net [69.31.111.154]
12 131 ms 142 ms 149 ms ae2-20g.ar1.ord6.us.nlayer.net [69.31.110.254]
13 146 ms 130 ms 130 ms as32475.xe-1-0-1.ar1.ord6.us.nlayer.net [69.31.1
11.30]
14 130 ms 129 ms 130 ms chopin.x10hosting.com [69.175.104.34]

Trace complete.

 

[Jarryd]

Hey,

That tracert looks quite clean, although its a bit worrying seeing timeouts on hop 1, since hop 1 is your default gateway. Although its not uncommon for some routers/modems to totally block all ping requests to them.

Is there anything else i can help you with?

 

[mylifestyle]

Hi Jarryd....thank you.

Yes pls - default gateway?? whats that?? is that the DNS thingy?? coz previously I changed it to Googles
8888
8844

Just out of interest...if you would'nt mind of course, could you take a few looks at my website over the next
hours and see what sort of response times you get from your end??

For me it's still VERY slow and if there is any way to speed things up then of course that wud be great.

http://i-m.exofire.net

Thx
ML

 

[Jarryd]

Hello,

Default gateway = your router or modem.

I took a look at your website sampled from different times of the day and the response time was within a couple seconds of each other, at most times almost instant.