This is an archived, read-only copy of the United-TI subforum , including posts and topic from May 2003 to April 2012. If you would like to discuss any of the topics in this forum, you can visit Cemetech's
Calculator Programming subforum. Some of these topics may also be directly-linked to active Cemetech topics. If you are a Cemetech member with a linked United-TI account, you can link United-TI topics here with your current Cemetech topics.
General Coding and Design =>
Calculator Programming
Author |
Message |
|
magicdanw pcGuru()
Calc Guru
Joined: 14 Feb 2007 Posts: 1110
|
Posted: 18 Feb 2009 03:08:22 pm Post subject: |
|
|
I'm having some difficulty with a free hosting provider that I'm hosting a few websites on. One of the websites occasionally gives an error that it cannot connect to the MySQL database, and takes up to about ten minutes to start working again. I contacted the hosting provider, and they said that they restart all their MySQL databased every hour to "improve performance." Now, this sounds ridiculous. I don't know much about MySQL databases, but I would imagine they don't need to be restarted every hour. Could someone more knowledgeable let me know if this is true? Also, could anyone recommend a better free host for this site? I need one that doesn't insert advertising, allows me to point a domain name at it, and gives PHP, MySQL, and reasonable space and bandwidth. And, of course, doesn't restart its services every hour |
|
Back to top |
|
|
Galandros
Active Member
Joined: 29 Aug 2008 Posts: 565
|
Posted: 18 Feb 2009 03:23:50 pm Post subject: |
|
|
That's odd.
One php without adds:
http://www.awardspace.com/
other useful but some php doesn' work properly (maybe the php version is outdated)
http://www.phpnet.us/
has adds.
The rest you have to see. Oh, both are free. |
|
Back to top |
|
|
magicdanw pcGuru()
Calc Guru
Joined: 14 Feb 2007 Posts: 1110
|
Posted: 18 Feb 2009 06:35:46 pm Post subject: |
|
|
I forgot one important thing - my website makes use of sendmail(), which most free servers disable to prevent spamming. The host I currently use is an exception. Does anyone know of a free server that does allow sendmail() to be used? If not, maybe I'll just move my database to another server, and keep the php site at the current server. I think that should work, right? |
|
Back to top |
|
|
benryves
Active Member
Joined: 23 Feb 2006 Posts: 564
|
Posted: 19 Feb 2009 08:59:07 pm Post subject: |
|
|
Several cheap hosts don't allow any external access to the database (forcing you to use the atrocious phpMyAdmin). I'd chalk it up as "unlikely". Could you not just pay for hosting? |
|
Back to top |
|
|
pugboy
Active Member
Joined: 11 Apr 2007 Posts: 544
|
Posted: 20 Feb 2009 11:44:33 pm Post subject: |
|
|
I suggest you just pay for hosting, but here are a few alternatives:
http://freehostia.com (I am pretty sure Send Mail is enabled)
http://byethost.com/ (Sendmail is enabled as well as Curl. They also have a free reseller package if you are interested...)
And no, the database server being restarted every hour for performance reasons is complete bogus.
If you want to make it easy on yourself, you can use this external MySQL database service:
http://www.freemysql.net/v2/
Last edited by Guest on 20 Feb 2009 11:46:09 pm; edited 1 time in total |
|
Back to top |
|
|
AlienCC Creative Receptacle!
Know-It-All
Joined: 24 May 2003 Posts: 1927
|
Posted: 21 Feb 2009 04:44:46 am Post subject: |
|
|
pugboy wrote: And no, the database server being restarted every hour for performance reasons is complete bogus.
Yep, we only restart the database server here about as often as we reboot the entire actual server.
Database performance issues can be fixed by adjusting some settings, adding memory, most importantly properly indexing tables, and optimizing slower queries. |
|
Back to top |
|
|
magicdanw pcGuru()
Calc Guru
Joined: 14 Feb 2007 Posts: 1110
|
Posted: 22 Feb 2009 03:05:48 pm Post subject: |
|
|
Thanks, Pugboy. I transferred my database to freemysql.net, and it seems to be working well enough. |
|
Back to top |
|
|
|
Register to Join the Conversation
Have your own thoughts to add to this or any other topic? Want to ask a question, offer a suggestion, share your own programs and projects, upload a file to the file archives, get help with calculator and computer programming, or simply chat with like-minded coders and tech and calculator enthusiasts via the site-wide AJAX SAX widget? Registration for a free Cemetech account only takes a minute.
»
Go to Registration page